The mcp-postgres-server allows AI agents to perform CRUD operations on PostgreSQL databases. It exposes SQL query execution, transaction management, and connection pooling. It connects directly to PostgreSQL instances via JDBC. Developers use it to build AI agents that interact with PostgreSQL databases for data retrieval, manipulation, and reporting tasks.
The mcp-postgres-server allows AI agents to perform CRUD operations on PostgreSQL databases. It exposes SQL query execution, transaction management, and connection pooling. It connects directly to PostgreSQL instances via JDBC. Developers use it to build AI agents that interact with PostgreSQL databases for data retrieval, manipulation, and reporting tasks.
npx -y mcp-postgres-serverAdd this configuration to your claude_desktop_config.json:
{
"mcpServers": {
"mcp-postgres-server-npm": {
"command": "npx",
"args": [
"-y",
"npx -y mcp-postgres-server"
]
}
}
}Restart Claude Desktop, then ask:
"What tools do you have available from mcp-postgres-server?"
API Key Required
This server requires an API key from mcp-postgres-server. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| MCP-POSTGRES-SERVER_API_KEY | Yes | Your mcp-postgres-server API key |
"What resources are available in mcp-postgres-server?"
Claude will query available resources and return a list of what you can access.
"Show me details about [specific item] in mcp-postgres-server"
Claude will fetch and display detailed information about the requested item.
"Create a new [item] in mcp-postgres-server with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
We build custom MCP integrations for B2B companies. From simple connections to complex multi-tool setups.