mcp server

Postgres MCP Pro

Community Postgres server with restricted and unrestricted modes, query plan tools, and index and health analysis.

crystaldba/postgres-mcplistedunreviewednot running here yet

Use tool

Set up

Runs on your computer. Pick your agent and operating system.

Before you start

uv (`curl -LsSf https://astral.sh/uv/install.sh | sh`)
uv (for uvx)

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "postgres-mcp-pro": {
      "command": "uvx",
      "args": [
        "postgres-mcp"
      ],
      "env": {
        "DATABASE_URI": "<your DATABASE_URI>"
      }
    }
  }
}

same format Cursor, GitHub Copilot CLI, Junie, JetBrains AI Assistant, Augment (Auggie CLI), Factory Droid, Kiro, Devin CLI +12

Values in angle brackets are placeholders. Restart Claude Desktop after editing its config.Claude Desktop docs

Tools provided

As listed by the project. Your agent asks before calling them, depending on its settings.

list_schemasList schemas
list_objectsList tables and other objects
execute_sqlRun SQL (restricted mode is read-only)
explain_queryShow a query plan
get_top_queriesShow slow queries
analyze_db_healthCheck database health

README

synced Oct 13, 2026

Postgres MCP Pro

Community Postgres server with restricted and unrestricted modes, query plan tools, and index and health analysis.

Install

uvx postgres-mcp

Configuration

Variable	Required	Description
`DATABASE_URI`	Yes	Postgres connection string

Tools

list_schemas — List schemas
list_objects — List tables and other objects
execute_sql — Run SQL (restricted mode is read-only)
explain_query — Show a query plan
get_top_queries — Show slow queries
analyze_db_health — Check database health

About this listing

Details were gathered from the project's public pages on 2026-10-13 and have not been reviewed by a person yet. Read the project's own documentation before giving it access to anything sensitive.

Sources:

https://github.com/crystaldba/postgres-mcp