sciver

MCPIndependentCrystal DBA

Postgres MCP Pro

Diagnoses a Postgres database, reads EXPLAIN plans and picks indexes for the workload.

An open-source server for any Postgres database: it checks the health of indexes, vacuum, connections and replication, analyzes query plans, simulates hypothetical indexes and runs SQL. The database URL goes in the DATABASE_URI variable, and “restricted” mode (read-only with a query time limit) is suitable for production databases too.

Installation

Manual install

$uvx postgres-mcp --access-mode=restricted

Details

Works in
Claude Code, Claude, Cursor, VS Code, Windsurf, Codex, Gemini CLI, Zed
Transport
local
License
MIT
Tasks
Data, Code
Rating
Source
github.com/crystaldba/postgres-mcp (opens in a new tab)

Tags

  • postgres
  • postgresql
  • indexes
  • performance
  • explain
  • dba
  • sql

Log in to rate

A pack is your own set of skills and MCP servers. sciver loads it in your AI with one command.

View in the library