Use case
Connect Postgres to your AI
Let your assistant inspect a Postgres schema, run queries and explain results — in Claude, Cursor or VS Code — without pasting tables into the chat.
Which MCP server should I use for PostgreSQL?
pg.ddx.io: the PostgreSQL community's memory, PostgreSQL (hardened, read-only) and Devart MCP Server for PostgreSQL (ADO.NET) are the strongest matches in the catalog today, ranked by how directly they address this and how well they are maintained. Create a dedicated read-only role (GRANT SELECT) for the assistant. Never hand it the owner credentials.
Before you pick one
- Create a dedicated read-only role (GRANT SELECT) for the assistant. Never hand it the owner credentials.
- Pass the connection string through an environment variable, not inline in a config file you commit.
- Point it at a replica or staging copy first: schema exploration issues many small queries.
MCP servers (12)
- Databases & Storage
pg.ddx.io: the PostgreSQL community's memory
Every PostgreSQL mailing list since 1991, linked to the commits, code, commitfest and docs.
MCP Registryremote60 toolsio.ddx.pg
- Databases & Storage3
PostgreSQL (hardened, read-only)
Read-only PostgreSQL over MCP. Writes refused at the parsed SQL, plus a READ ONLY transaction.
MCP Registrynpm7 toolsio.github.Eszetael
- Databases & Storage0
Devart MCP Server for PostgreSQL (ADO.NET)
Schema-aware read/write access to PostgreSQL through Devart dotConnect ADO.NET data provider.
MCP Registrynugetcom.devart
- Databases & Storage0
PostgreSQL MCP by InsightfulPipe
Hosted PostgreSQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
MCP Registryremotecom.insightfulpipe
- Databases & Storage65
postgres
Connect to your PostgreSQL database to query data and schemas.
MCP Registryremoteai.waystation
- Databases & Storage2
read-only-local-postgres-mcp-server
MCP server for read-only PostgreSQL database queries in Claude Desktop
MCP Registrynpm3 toolscapital.hove
- Databases & Storage0
Kaiva Postgres MCP
Read-only PostgreSQL MCP server. Drop-in replacement for the archived server-postgres.
MCP Registrynpm3 toolsai.kaiv
- Dev Tools & Git0
Postgres AIops
Governed PostgreSQL DBA ops: slow-query RCA, bloat/vacuum & blocking-lock analysis; 35 MCP tools.
MCP Registrypypiio.github.AIops-tools
- AI & Memory40
Ekwo OS — open source accounting: ledger, invoices and VAT on your own Supabase or Postgres
Double-entry books an agent keeps as the user: invoices, VAT returns, 174 country packs.
MCP Registrynpmai.ekwo
- Dev Tools & Git0
ainative-postgres-mcp
Zero-config Postgres MCP with auto-provisioning — drop-in for server-postgres.
MCP Registrynpm5 toolsio.github.AINative-Studio
- Databases & Storage
rabbitmq-elasticsearch-postgres-stack-generator-mongo
RabbitMQ + Elasticsearch + Postgres Stack Generator (Mongo)
MCP Registryremote2 toolsai.getvda
- Databases & Storage
rabbitmq-postgres-mongodb-stack-generator
RabbitMQ + Postgres + MongoDB Stack Generator
MCP Registryremote2 toolsai.getvda
Related skills (4)
- Data & Analysis42
cloud sql postgresql
Create, connect, and interact with a Cloud SQL for PostgreSQL database and data.
Claude Plugins (Official)by gemini-cli-extensions
- Data & Analysis1
aiven
Easily deploy managed PostgreSQL (pg), Kafka, OpenSearch, Clickhouse and other databases, streaming and apps. Free tier available, up and running in minutes.
Claude Plugins (Official)by aiven
- Data & Analysis24
alloydb
Create, connect, and interact with an AlloyDB for PostgreSQL database and data.
Claude Plugins (Official)by gemini-cli-extensions
- Automation & Workflow5
vsql extension builder
Builds a VillageSQL extension for MySQL end-to-end through a 7-phase persona-driven workflow. Commonly used to port PostgreSQL extensions to MySQL.
Claude Plugins (Official)by villagesql