pgmcp allows AI agents to query PostgreSQL databases using natural language. It translates queries into SQL, executes them, and returns results. It connects directly to PostgreSQL instances. Use it for data analysis, reporting, or building AI-driven database interfaces.
pgmcp allows AI agents to query PostgreSQL databases using natural language. It translates queries into SQL, executes them, and returns results. It connects directly to PostgreSQL instances. Use it for data analysis, reporting, or building AI-driven database interfaces.
Add this configuration to your claude_desktop_config.json:
{
"mcpServers": {
"subnetmarco-pgmcp-github": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-subnetmarco-pgmcp-github"
]
}
}
}Restart Claude Desktop, then ask:
"What tools do you have available from pgmcp?"
API Key Required
This server requires an API key from pgmcp. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| PGMCP_API_KEY | Yes | Your pgmcp API key |
"What resources are available in pgmcp?"
Claude will query available resources and return a list of what you can access.
"Show me details about [specific item] in pgmcp"
Claude will fetch and display detailed information about the requested item.
"Create a new [item] in pgmcp 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.