postgres mcp
pipVerifiedPostgres MCP provides read/write access to PostgreSQL databases. It offers performance analysis tools and connects directly to PostgreSQL instances. Developers use it to manage database operations and optimize query performance.
1,9652040Updated 1 month ago
Overview
Postgres MCP provides read/write access to PostgreSQL databases. It offers performance analysis tools and connects directly to PostgreSQL instances. Developers use it to manage database operations and optimize query performance.
Installation
1Install the package
pip
pip install postgres-mcp2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"crystaldba-postgres-mcp-github": {
"command": "uvx",
"args": [
"pip install postgres-mcp"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from postgres mcp?"
Prerequisites
- Python 3.10 or higher
- pip or uv package manager
- Claude Desktop or Claude API access
- API key for postgres mcp
Configuration
API Key Required
This server requires an API key from postgres mcp. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| POSTGRES_MCP_API_KEY | Yes | Your postgres mcp API key |
Usage Examples
List Resources
"What resources are available in postgres mcp?"
Claude will query available resources and return a list of what you can access.
Get Details
"Show me details about [specific item] in postgres mcp"
Claude will fetch and display detailed information about the requested item.
Create New
"Create a new [item] in postgres mcp with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
Works with postgres mcp
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.