modelcontextprotocol-server-postgres
npxStandardMCP server for interacting with PostgreSQL databases
000
Overview
MCP server for interacting with PostgreSQL databases
Installation
1Install the package
npx
npx -y modelcontextprotocol-server-postgres2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"modelcontextprotocol-server-postgres-npm": {
"command": "npx",
"args": [
"-y",
"npx -y modelcontextprotocol-server-postgres"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from modelcontextprotocol-server-postgres?"
Prerequisites
- Node.js 18 or higher
- npm or npx available
- Claude Desktop or Claude API access
- API key for modelcontextprotocol-server-postgres
Configuration
API Key Required
This server requires an API key from modelcontextprotocol-server-postgres. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| MODELCONTEXTPROTOCOL-SERVER-POSTGRES_API_KEY | Yes | Your modelcontextprotocol-server-postgres API key |
Usage Examples
List Resources
"What resources are available in modelcontextprotocol-server-postgres?"
Claude will query available resources and return a list of what you can access.
Get Details
"Show me details about [specific item] in modelcontextprotocol-server-postgres"
Claude will fetch and display detailed information about the requested item.
Create New
"Create a new [item] in modelcontextprotocol-server-postgres with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
Works with modelcontextprotocol-server-postgres
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.