pg
pipStandardThe pg MCP server provides AI agents with direct access to PostgreSQL databases. It exposes SQL query execution, transaction management, and schema inspection. Agents use it to retrieve, manipulate, and analyze data stored in PostgreSQL. The server connects to PostgreSQL instances via standard JDBC connections. Developers use it to build AI applications that require database interaction, such as data analysis tools, automated reporting systems, and database management assistants.
534360Updated 5 months ago
Overview
The pg MCP server provides AI agents with direct access to PostgreSQL databases. It exposes SQL query execution, transaction management, and schema inspection. Agents use it to retrieve, manipulate, and analyze data stored in PostgreSQL. The server connects to PostgreSQL instances via standard JDBC connections. Developers use it to build AI applications that require database interaction, such as data analysis tools, automated reporting systems, and database management assistants.
Installation
1Install the package
pip
pip install pg-mcp-server2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"stuzero-pg-mcp-server-github": {
"command": "uvx",
"args": [
"pip install pg-mcp-server"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from pg?"
Prerequisites
- Python 3.10 or higher
- pip or uv package manager
- Claude Desktop or Claude API access
- API key for pg
Configuration
API Key Required
This server requires an API key from pg. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| PG_API_KEY | Yes | Your pg API key |
Usage Examples
List Resources
"What resources are available in pg?"
Claude will query available resources and return a list of what you can access.
Get Details
"Show me details about [specific item] in pg"
Claude will fetch and display detailed information about the requested item.
Create New
"Create a new [item] in pg with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
Works with pg
Related skills
Browse all skillsNeed help with MCP integration?
We build custom MCP integrations for B2B companies. From simple connections to complex multi-tool setups.