PostgreSQL MCP Server (Enhanced)
BasicPostgreSQL MCP Server (Enhanced) allows LLMs to inspect database schemas, execute queries, modify data, and manage database schema objects. It facilitates both read and write operations on PostgreSQL databases through an API.
000
Overview
PostgreSQL MCP Server (Enhanced) allows LLMs to inspect database schemas, execute queries, modify data, and manage database schema objects. It facilitates both read and write operations on PostgreSQL databases through an API.
Installation
1Install the package
npx
docker run -i --rm mcp/postgres postgresql://host:5432/mydb2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"postgresql-mcp-server-enhanced": {
"command": "npx",
"args": [
"-y",
"docker run -i --rm mcp/postgres postgresql://host:5432/mydb"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from PostgreSQL MCP Server (Enhanced)?"
Prerequisites
- Node.js 18 or higher
- npm or npx available
- Claude Desktop or Claude API access
Configuration
No configuration required. This server works out of the box.
Usage Examples
List Resources
"What resources are available in PostgreSQL MCP Server (Enhanced)?"
Claude will query available resources and return a list of what you can access.
Get Details
"Show me details about [specific item] in PostgreSQL MCP Server (Enhanced)"
Claude will fetch and display detailed information about the requested item.
Create New
"Create a new [item] in PostgreSQL MCP Server (Enhanced) with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
Works with PostgreSQL MCP Server (Enhanced)
See what tools in your stack can connect to AI.
Run free scan
Need help with MCP integration?
We build custom MCP integrations for B2B companies. From simple connections to complex multi-tool setups.