Skip to content
  1. Home
  2. MCP servers
  3. Postgres MCP Pro

Postgres MCP Pro

Postgres server with health checks, index tuning and EXPLAIN plan analysis

What it is

Goes beyond running queries: it reports on database health (indexes, vacuum, connections, replication), recommends indexes for a workload, reviews EXPLAIN plans with hypothetical indexes, and offers a restricted read-only mode. For developers and DBAs tuning PostgreSQL with an assistant.

Good for

  • Find slow queries and missing indexes
  • Review EXPLAIN plans
  • Run read-only SQL against production

Install or run

pipx install postgres-mcp

Command as given in the project README. Read the repository before you run anything on your machine.

What you need

Python (pipx/uv) or Docker; a PostgreSQL connection URI

Worth knowingREADME examples use unrestricted mode, which allows writes and schema changes; switch to restricted mode for production.

Sources

The summary is ours, written from the README. Spotted an error? See how we work.

More for data & research

See the topic →
  • MCP Toolbox for Databases

    googleapis/mcp-toolbox

    Google's server and framework for connecting agents to SQL databases

    MCP serverGitHub stars: 17k
  • Firecrawl MCP Server

    firecrawl/firecrawl-mcp-server

    Web search, scraping, crawling and page interaction returning clean Markdown

    MCP serverGitHub stars: 7.8k
  • Exa MCP Server

    exa-labs/exa-mcp-server

    Hosted web search, page fetching and research tools from Exa

    MCP serverGitHub stars: 5.2k
  • Flint

    microsoft/flint-chart

    Chart spec language and MCP server for agent-made visualisations

    MCP serverGitHub stars: 4.6k