mcp-postgres-server
npxStandardThe 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.
930Updated 10 months ago
Overview
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.
Installation
1Install the package
npx
npx -y mcp-postgres-server2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"mcp-postgres-server-npm": {
"command": "npx",
"args": [
"-y",
"npx -y mcp-postgres-server"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from mcp-postgres-server?"
Prerequisites
- Node.js 18 or higher
- npm or npx available
- Claude Desktop or Claude API access
- API key for mcp-postgres-server
Configuration
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 |
Usage Examples
List Resources
"What resources are available in mcp-postgres-server?"
Claude will query available resources and return a list of what you can access.
Get Details
"Show me details about [specific item] in mcp-postgres-server"
Claude will fetch and display detailed information about the requested item.
Create New
"Create a new [item] in mcp-postgres-server with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
Works with mcp-postgres-server
Claude
AI assistant built for thoughtful, nuanced conversation
Anthropic
Safety-focused AI research and Claude model provider
Baserow
The data collaboration platform for teams
GitHub
Code hosting and collaboration platform for developers
NetBox
Open-source network infrastructure documentation and automation
Snipe-IT
Open-source IT asset management made simple
Model ML
AI workspace for financial services
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.