PostgreSQL
OFFICIAL · Model Context ProtocolAUTH REQUIREDMITInspect schema structures, list tables, and execute read-only queries against your PostgreSQL databases from your AI assistant.
Requires a PostgreSQL connection URI string, configured in the setup arguments.
Setup Guide
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-postgres",
"postgresql://user:pass@localhost:5432/dbname"
]
}
}
}Tools
query
Run custom SELECT read-only queries.
list_tables
Retrieve a list of all tables present in the database.
describe_table
Get detailed information about table columns, database types, and keys.
Compatibility
About
Overview
The PostgreSQL Model Context Protocol (MCP) server allows your AI agent to query database schemas, list table names, inspect column types, and execute safe queries recursively.
Having a database connection inside your conversation loop is a game changer for writing SQL commands, checking field names, debugging query errors, and building migrations without switching between your IDE and terminal database clients.
Install and Troubleshooting Intent Coverage
Developer-install and troubleshooting intent for community MCP server listings.
install mcp server / mcp server setup guide
mcp json config example / vscode mcp setup
mcp server not working / mcp tools not showing
mcp server compatibility matrix / cursor vs vscode mcp compatibility
mcp server monetization options / convert community mcp server to paid listing
Related Setup, Debug, and Learning Links
Database MCP troubleshooting
Connection and env-path failures are common in DB tools.
Authentication guide
Most database listings require secure credential flow.
CLI installation guide
Install baseline for all IDEs before listing-specific setup.
Using servers guide
Covers runtime usage patterns and auth flow.
Cursor setup walkthrough
High-intent setup path for developer troubleshooting journeys.
Troubleshooting: tools not showing
Covers discovery/listing failures across major IDEs.
Registry listing: filesystem
Maps this community reference to install-ready hosted listing.
Related explore entry: Notion
Keeps same-intent users on matched category and tool shape.
Related explore entry: Redis
Keeps same-intent users on matched category and tool shape.
Related explore entry: SQLite
Keeps same-intent users on matched category and tool shape.
Related explore entry: Supabase
Keeps same-intent users on matched category and tool shape.
Install this server with the AgenticMarket CLI — you'll be prompted for your API credentials or OAuth tokens during setup. No manual JSON editing.
$npx agenticmarket install postgresNotion
Connect your AI agent to Notion workspaces to read pages, create documents, update databases, search content, and manage your team's knowledge system.
Redis
Connect your AI agent to Redis for real-time key-value storage, caching, pub/sub messaging, and data structure management.
SQLite
Give your AI agent direct read and write access to SQLite databases — query tables, run analysis, insert records, and explore schemas conversationally.
Supabase
Connect your AI coding assistant to Supabase. Query databases, run migrations, deploy Edge Functions, and manage projects — all through natural language in VS Code, Cursor, Claude Desktop, and more.
AgenticMarket