database
PostgreSQL MCP servers and skills
There are 170 ways to connect PostgreSQL to Claude, ChatGPT, Cursor and other AI assistants; these are the 100 with the highest scores. The most used is Postgres MCP (0 GitHub stars).
Best PostgreSQL MCP servers, compared →Most used
A Model Context Protocol server for PostgreSQL with Prisma-aware schema introspection.
Double-entry books an agent keeps as the user: invoices, VAT returns, 138 country packs.
PostgreSQL MCP server - query, schema introspection, explain, and health checks for AI assistants
Model Context Protocol server for PostgreSQL database operations
Database-agnostic PostgreSQL MCP server with live discovery and bounded per-call selection. Installs one platform package with the .NET runtime bundled; no .NET installation or runtime downloads required.
Postgres storage for OpenBooking: bookings and holds, idempotency, Studio activity and connector records.
MCP servers (75)
- 1Postgres MCP Passionfroot · DatabasesA Model Context Protocol server for PostgreSQL with Prisma-aware schema introspection.85
- 2Ekwo OS — open source accounting: ledger, invoices and VAT on your own Supabase or Postgres Ekwo-ai · DatabasesDouble-entry books an agent keeps as the user: invoices, VAT returns, 138 country packs.84
- 3PostgreSQL MCP Server YawLabs · DatabasesPostgreSQL MCP server - query, schema introspection, explain, and health checks for AI assistants82
- 4MCP Postgres kristofer84 · DatabasesModel Context Protocol server for PostgreSQL database operations82
- 5Postgresql Sharp MCP codegiveness · DatabasesDatabase-agnostic PostgreSQL MCP server with live discovery and bounded per-call selection. Installs one platform package with the .NET runtime bundled; no .NET installation or runtime downloads required.81
- 6Postgres openbooking-sh · DatabasesPostgres storage for OpenBooking: bookings and holds, idempotency, Studio activity and connector records.81
- 7postgres-mcp pgEdge · DatabasesEnterprise PostgreSQL MCP server with NL queries, hybrid search (pgvector+BM25), and web UI80
- 8Postgres MCP microsoft · DatabasesPostgreSQL MCP server for AI assistants over the Model Context Protocol.79
- 9PostgreSQL antonorlov · DatabasesMCP server for PostgreSQL: local, Docker, RDS, Neon, Supabase, or behind an SSH bastion.76
- 10MCP Postgres Readonly vbss-io · DatabasesRead-only multi-org PostgreSQL MCP server for extracting reports and KPIs76
- ADYour product hereThis row is seen by people browsing PostgreSQL tools. Book it from $249 a month.See prices →
- 11Dsh MCP Postgres tudamu · DatabasesMCP Postgres server toolkit for dsh - SQL queries via Model Context Protocol. Name reserved; first release in development.75
- 12ainative-postgres-mcp AINative-Studio · DatabasesZero-config Postgres MCP with auto-provisioning — drop-in for server-postgres.73
- 13Postgres (read-only) contextflo · DatabasesRead-only Postgres: drop-in for the archived server-postgres, with schema context.73
- 14PostgreSQL (hardened, read-only) Eszetael · DatabasesRead-only PostgreSQL over MCP. Writes refused at the parsed SQL, plus a READ ONLY transaction.73
- 15PostgreSQL MCP Server neverinfamous · DatabasesPostgreSQL MCP server with 203 tools, connection pooling, HTTP/SSE, OAuth 2.1, and tool filtering73
- 16Postgres MCP Server HenkDz · DatabasesA Model Context Protocol (MCP) server that provides comprehensive PostgreSQL database management capabilities for AI assistants67
- 17PostgreSQL MCP Server neverinfamous · DatabasesEnterprise PostgreSQL MCP server with 63 tools, 10 resources, 10 prompts for AI-native operations64
- 18Postgresql Ssh MCP Zlash65 · DatabasesPostgreSQL MCP Server with built-in SSH tunneling for secure database access through bastion hosts63
- 19PostgreSQL performance Tuner MCP Server isdaniel · Databasesprovides AI-powered PostgreSQL performance tuning capabilities.62
- 20Postgres Context Server zed-industries · Databasesa model context protocol server for postgres60
- 21Postgresql MCP Server Code-suphub · DatabasesPostgreSQL MCP Server - 统一权限控制58
- 22Postgresql MCP sarmadparvez · DatabasesMCP server for PostgreSQL with full read-write support, transactions, and schema inspection. Works with any PostgreSQL instance — local, Supabase, AWS RDS, or self-hosted. Use with Claude, Cursor, Windsurf, and any MCP-compatible AI client.56
- 23Store Postgres amir-gorji · DatabasesPostgres-backed EventStore and SessionRegistry for mcpose: SSE reconnect replay that survives a restart54
- 24postgres waystation-ai · DatabasesConnect to your PostgreSQL database to query data and schemas.53
- 25DBeast PostgreSQL MCP snss10 · DatabasesPostgreSQL MCP server for schema, query, health, security, and performance analysis.53
- 26MCP Postgres Ssh dinamexoft · DatabasesMCP server for Postgres via SSH53
- 27database-mcp-postgres arifulislamat · DatabasesMCP server for PostgreSQL. Read-only by default, row caps, timeouts, secrets never logged.51
- 28Postgres MCP llm-graph · DatabasesA blazing fast, type-safe MCP Server for AI Agents to interact with multiple PostgreSQL databases51
- 29Postgres Readonly MCP beydemirfurkan · DatabasesMCP server for read-only PostgreSQL database access50
- 30Safe Postgres MCP samuel-cabral · DatabasesSafety-first, read-only PostgreSQL MCP server. Read-only isn't a regex — it's enforced by Postgres itself (READ ONLY transactions, statement timeouts, row caps). One npx command to give AI agents safe access to your database.50
- 31read-only-local-postgres-mcp-server hovecapital · DatabasesMCP server for read-only PostgreSQL database queries in Claude Desktop49
- 32Postgres MCP mmtr-tech · DatabasesModel Context Protocol server for PostgreSQL (single DATABASE_URL or multi-target YAML catalog)49
- 33Postgres MCP Server allensandiego · DatabasesModel Context Protocol (MCP) server for PostgreSQL databases48
- 34Postgres MCP Server Teja-sudo · DatabasesA Model Context Protocol (MCP) server for PostgreSQL database management and analysis48
- 35MCP Postgres Full Access syahiidkamil · DatabasesFull-access PostgreSQL server for Model Context Protocol with read/write capabilities and enhanced schema metadata46
- 36Postgres MCP For Devs devandy1024 · DatabasesPostgres MCP server with full read/write SQL — list tables, describe schema, execute arbitrary queries45
- 37MCP Server Postgres Multi Schema HarjjotSinghh · DatabasesMCP server for interacting with PostgreSQL databases, with support for multiple schemas45
- 38Modelcontextprotocol Server Postgres p29hieu · DatabasesMCP server for interacting with PostgreSQL databases44
- 39Zlash65 Postgresql Ssh MCP Zlash65 · DatabasesPostgreSQL MCP Server with built-in SSH tunneling for secure database access through bastion hosts43
- 40Postgres MCP Server spencerpauly · DatabasesA secure, self-hostable Model Context Protocol server for PostgreSQL.43
- 41Blankbrackets Postgres MCP Server blankbrackets · DatabasesModel Context Protocol server for AI-assisted PostgreSQL database analysis and optimization. Provides read-only access for comprehensive performance analysis, index optimization, and schema recommendations.43
- 42Enhanced Postgres MCP Server garethcottrell · DatabasesEnhanced PostgreSQL MCP server with read and write capabilities. Based on @modelcontextprotocol/server-postgres by Anthropic.42
- 43MCP Postgres Monsoft-Solutions · DatabasesMCP server for postgres database interactions42
- 44User Postgresql MCP wenxue1 · DatabasesA PostgreSQL MCP server built with @modelcontextprotocol/sdk.41
- 45Postgres MCP Server ahmedmustahid · DatabasesMCP server for interacting with PostgreSQL databases41
- 46MCP Server Azure Postgres Ryzeon · DatabasesMCP server for Azure Database for PostgreSQL with automatic Azure AD token refresh41
- 47MCP Server Postgres ahmetkca · DatabasesA comprehensive, read-only, multi-tenant PostgreSQL MCP server with advanced schema introspection and query capabilities40
- 48MCP Postgres Secure pugltd · DatabasesA secure Model Context Protocol server for PostgreSQL with readonly, DML, and full access modes40
- 49Postgres MCP Readonly mahin1995 · DatabasesA secure, read-only PostgreSQL Model Context Protocol (MCP) server for safe database introspection and querying40
- 50Postgres MCP edelciomolina · DatabasesPostgreSQL MCP wrapper with .env credential mapping, tool selection, and safe read-only defaults.39
- 51Sezzlee PostgreSQL sezzlee · DatabasesExplore and query PostgreSQL read-only: catalogue search, schema introspection and bounded queries.39
- 52MCP Postgres Rw snyder2709 · DatabasesMCP server for PostgreSQL with both read and write support (INSERT, UPDATE, DELETE, DDL). Unlike the official server-postgres, this one allows write operations.39
- 53Postgres MCP Server caleb-mabry · DatabasesModel Context Protocol server for PostgreSQL database operations36
- 54Postgres MCP daitasu · DatabasesPostgreSQL Model Context Protocol Server - A read-only PostgreSQL MCP server implementation36
- 55MCP Postgres muhfauziazhar · DatabasesSafe, read-only-by-default Model Context Protocol (MCP) server for PostgreSQL. Let AI agents inspect and query your database without fear of destructive writes.35
- 56postgres marcelo-ochoa · DatabasesMCP server for interacting with PostgreSQL databases34
- 57Postgres MCP cesarvarela · DatabasesPostgreSQL MCP Server - Expose PostgreSQL database operations via Model Context Protocol34
- 58Garethcott Enhanced Postgres MCP Server garethcottrell · DatabasesEnhanced PostgreSQL MCP server with read and write capabilities. Based on @modelcontextprotocol/server-postgres by Anthropic.34
- 59Garethcott Enhanced Postgres MCP Server garethcottrell · DatabasesEnhanced PostgreSQL MCP server with read and write capabilities. Based on @modelcontextprotocol/server-postgres by Anthropic.34
- 60Postgresql MCP Readonly ferrybig · DatabasesA Model Context Protocol server for readonly PostgreSQL database access34
- 61postgres ai-kaiva · DatabasesRead-only PostgreSQL MCP server. Drop-in replacement for the archived server-postgres.33
- 62PostgreSQL MCP Server musaddiq-dev · DatabasesPython MCP server for PostgreSQL database inspection and querying32
- 63Postgres Claude MCP Wrapper adam1571 · DatabasesA simple CLI tool to configure PostgreSQL Model Context Protocol (MCP) server for Claude Desktop using environment variables.32
- 64Postgres MCP ketanexpora · DatabasesMCP server for interacting with PostgreSQL databases32
- 65Postgres AIops AIops-tools · DatabasesGoverned PostgreSQL DBA ops: slow-query RCA, bloat/vacuum & blocking-lock analysis; 35 MCP tools.30
- 66PostgreSQL Performance (read-only) gouranshul · DatabasesRead-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions30
- 67MCP Postgres Full Access Extended kamusis · DatabasesFull-access PostgreSQL server for Model Context Protocol with read/write capabilities and enhanced schema metadata30
- 68Devart MCP Server for PostgreSQL (ADO.NET) devart-ai-connectivity · DatabasesSchema-aware read/write access to PostgreSQL through Devart dotConnect ADO.NET data provider.27
- 69WHOOP MCP cunicopia-dev · DatabasesSync WHOOP recovery, sleep, strain, and workouts into Postgres and query them from any MCP client.27
- 70sw-postgres-mcp jpka · DatabasesSafe-write Postgres MCP server with preview-before-execute writes and rollback safety.27
- 71PostgreSQL CVE & Release Intelligence meob · DatabasesPostgreSQL security for AI agents: CVEs, yanked releases, exploits, and upgrade paths27
- 72postgres ofershap · DatabasesPostgreSQL MCP — query databases, inspect schemas, explain queries.27
- 73MCP Server Postgresql axbalal · DatabasesPostgreSQL MCP Server for LLM coding agents27
- 74Server Postgres hbeckeri · DatabasesMCP server for interacting with PostgreSQL databases27
- 75NexQL Postgres MCP NexQL-OSS · DatabasesStandalone Postgres MCP server — schema-aware, read-only by default, installable everywhere.26
Skills (25)
- 1neon-postgres benjaminasterA · DatabasesExpert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integration Use when: neon database, serverless postgres, database branching, neon postgres, postgres...70
- 2postgres giswater · DatabasesPostgreSQL best practices, query optimization, and performance improvement. Load when working with Postgres databases.66
- 3sql-postgres agent-kit-startup · DatabasesWrite and review Postgres SQL (DDL, DML, indexes, constraints). Use for .sql, schemas, or Postgres mentions.49
- 4healthcheck-dotnet-postgresql hoangnh2412 · DatabasesĐăng ký PostgreSQL readiness qua AddNpgSql() và HealthChecks:Readiness. Dùng khi project .NET cần probe Npgsql trên /health/ready.44
- 5postgres sundial-org · DatabasesPostgreSQL database management. Run queries, manage schemas, and monitor performance.44
- 6postgres-schema-design Dankosik · DatabasesRelational identity, cardinality, invariant, constraint, lifecycle, and migration depth reference.43
- 7pgroll PostgreSQL Zero-Downtime Schema Migration agentskillexchange · Databasespgroll is an open-source CLI tool by Xata that performs zero-downtime, reversible schema migrations for PostgreSQL. It uses the expand-and-contract pattern to keep old and new schema versions running simultaneously with automatic backfilling and instant rollback.42
- 8PostgreSQL Query Plan Analyzer agentskillexchange · DatabasesExecutes EXPLAIN ANALYZE BUFFERS on slow PostgreSQL queries and parses the plan tree for sequential scans, nested loop joins, and sort spills. Integrates with pg_stat_statements for identifying top resource-consuming queries.42
- 9PostgreSQL Query Analyzer agentskillexchange · DatabasesAnalyzes PostgreSQL slow queries using EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) output and pg_stat_statements views. Identifies missing indexes via pg_stat_user_tables sequential scan counters and suggests index creation with HypoPG extension.42
- 10PostgreSQL Slow Query Analyzer agentskillexchange · DatabasesQueries pg_stat_statements and pg_stat_activity to surface the top slow queries by total execution time, mean latency, and call frequency. Runs EXPLAIN ANALYZE on worst offenders and suggests index additions, rewrite candidates, or vacuum triggers. Works on RDS and Supabase.40
- 11neon-postgres omer-metin · DatabasesExpert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integrationUse when "neon database, serverless postgres, database branching, neon postgres, postgres serverless, connection pooling, preview environments, database per preview, neon, postgres, serverless, database, branching, prisma, drizzle, connection-pooling" mentioned.40
- 12postgresql-query bidewio · DatabasesExecute SQL queries, manage schemas, and perform data operations using PostgreSQL at {{POSTGRES_HOST}}:{{POSTGRES_PORT}}.39
- 13postgresql skeletorflet · DatabasesPostgreSQL — advanced SQL, indexing, extensions, partitioning, EXPLAIN ANALYZE.37
- 14oracle-to-postgresql-playbook aws-samples · DatabasesKnowledge base for converting Oracle to PostgreSQL (Aurora PostgreSQL compatible), distilled from the AWS Oracle-to-Aurora-PostgreSQL Migration Playbook into granular per-topic references. Use when converting or assessing a specific Oracle construct — datatypes, SQL/PL-SQL (MERGE, sequences, cursors, packages, dynamic SQL, DBMS_* packages), tables/indexes, partitioning, triggers, views, materialized views, JSON/XML, database links, security/roles, HA/DR, configuration, performance tuning, or monitoring — and you need the PostgreSQL equivalent, the conversion difficulty, and the workaround. The db-migration-inception and db-migration-construction skills consult this to classify and convert objects. This is a reference index/router: load the specific topic file under references/ rather than reading everything.35
- 15neon-postgres claudiodearaujo · DatabasesExpert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integration Use when: neon database, serverless postgres, database branching, neon postgres, postgres serverless.35
- 16postgresql gabrielmoreira · DatabasesPostgreSQL query optimization, indexing, full-text search, JSONB, and advanced features.32
- 17backup-postgres Kvmyk · DatabasesCodzienny backup bazy PostgreSQL (pg_dump) z rotacja 7 dni, wpisem [backup] w DIRECTORY i pilnowaniem swiezosci.30
- 18postgres-sql ivanshamaev · DatabasesWrite PostgreSQL DDL and analytical SQL with explicit types, maintainable naming, and raw-to-analytics conventions.29
- 19prisma-postgres devDivyansh28 · DatabasesDeprecated compatibility name for prisma-postgres-setup. Use only when a user or existing integration explicitly invokes prisma-postgres; otherwise select prisma-postgres-setup.28
- 20postgres-schema-guardian JulioAlejandro-GitHub · DatabasesProteger esquema PostgreSQL actual integridad relacional y persistencia científica sin preflight de versiones.28
- 21postgresql-expert arvnfly · DatabasesPostgreSQL performance optimization, EXPLAIN ANALYZE, vacuuming strategies, connection pooling, and JSONB indexing.26
- 22postgres-analyze-bicep-arm javakishore-veleti · DatabasesAnalyze Bicep or ARM templates for Azure Database for PostgreSQL Flexible Server, including server, databases, networking, identity, HA, backup, CMK, parameters, and monitoring. Use for template review, deployment failures, or drift.26
- 23postgres-analyze-networking javakishore-veleti · DatabasesAnalyze Azure Database for PostgreSQL Flexible Server networking including private access/VNet integration, private endpoints where applicable, public access/firewall, DNS, routing, and application connectivity. Use for connection timeouts or network isolation reviews.26
- 24postgres-db-helper Festus12lo · DatabasesUse this skill when the user asks to connect, configure, or query a PostgreSQL database for the backend.26
- 25postgres-mcp-onboarding hongyime · DatabasesEnable PostgreSQL MCP correctly across providers. USE FOR: local Docker Postgres, Supabase, Railway, Neon, managed Postgres URLs. DO NOT USE FOR: SQL query optimization itself.26
Questions
Is there an official PostgreSQL MCP server?
Check the publisher on each listing: servers published by PostgreSQL itself are the official ones. The most used PostgreSQL server here is Postgres MCP by Passionfroot.
How do I connect PostgreSQL to Claude?
Pick a server below, open its page and copy the install command for Claude Code, or the config block for Claude Desktop. Most PostgreSQL servers need an API key or token from your PostgreSQL account.