PostgreSQL MCP Server

Enables LLM agents to read database schemas, query tables with safeguards, and analyze relations without dumping raw credentials.

One-line install command

npx -y @modelcontextprotocol/server-postgres "postgresql://user:pass@localhost:5432/db"

Prompt to use it

Use the PostgreSQL MCP Server skill for this task: [describe the task]. Before you start, tell me which steps of the skill apply and anything you need from me. When done, list what you changed and how you checked it.

Paste into your agent after installing the skill. Replace the [brackets].

Quality Score98/100

LicenseMIT

Public Stars38,200

Agents SupportedClaude Desktop, Cursor, Windsurf, Cline

Mission Loadouts Featuring This Skill

Ship a Full-Stack Web SaaS in 24 HoursScaffold, code, and deploy a complete web app with auth, database, and responsive Apple-style UI.Diagnose Slow Database Queries & Query PlansInterpret EXPLAIN ANALYZE, design compound indexes, and eliminate sequential scans.