Postgres MCP Pro

Postgres MCP Pro is a PostgreSQL database management and optimization MCP server that provides AI agents with comprehensive tools for performance tuning, health monitoring, and safe query execution. Key features of Postgres MCP Pro: - Database health analysis including index health, connection utilization, buffer cache efficiency, vacuum status, sequence limits, and replication lag monitoring - Advanced index tuning using industrial-strength algorithms to explore thousands of potential indexes and identify optimal solutions for specific workloads - Query plan analysis with EXPLAIN plan review and hypothetical index simulation to validate and optimize query performance before making changes - Schema intelligence that enables context-aware SQL generation based on detailed database structure understanding - Safe SQL execution with configurable access controls including read-only mode and safe SQL parsing for secure use in production environments

[](https://opensource.org/licenses/MIT) [](https://pypi.org/project/postgres-mcp/) [](https://discord.gg/4BEHC7ZM) [](https://x.com/auto_dba) [](https://github.com/crystaldba/postgres-mcp/graphs/contributors)

A Postgres MCP server with index tuning, explain plans, health checks, and safe sql execution.

Overview • Demo • Quick Start • Technical Notes • MCP API • Related Projects • FAQ

Overview

Postgres MCP Pro is an open source Model Context Protocol (MCP) server built to support you and your AI agents throughout the entire development process—from initial coding, through testing and deployment, and to production tuning and maintenance.

Postgres MCP Pro does much more than wrap a database connection.

Features include:

Postgres MCP Pro supports both the Standard Input/Output (stdio) and Server-Sent Events (SSE) transports, for flexibility in different environments.

For additional background on why we built Postgres MCP Pro, see our launch blog post.

Demo

*From Unusable to Lightning Fast*

What we did:

See the video below or read the play-by-play.

https://github.com/user-attachments/assets/24e05745-65e9-4998-b877-a368f1eadc13

Quick Start

Prerequisites

Before getting started, ensure you have: 1. Access credentials for your database. 2. Docker *or* Python 3.12 or higher.

#### Access Credentials You can confirm your access credentials are valid by using psql or a GUI tool such as pgAdmin.

#### Docker or Python

The choice to use Docker or Python is yours. We generally recommend Docker because Python users can encounter more environment-specific issues. However, it often makes sense to use whichever method you are most familiar with.

Installation

Choose one of the following methods to install Postgres MCP Pro:

#### Option 1: Using Docker

Pull the Postgres MCP Pro MCP server Docker image. This image contains all necessary dependencies, providing a reliable way to run Postgres MCP Pro in a variety of environments.

docker pull crystaldba/postgres-mcp

#### Option 2: Using Python

If you have pipx installed you can install Postgres MCP Pro with:

pipx install postgres-mcp

Otherwise, install Postgres MCP Pro with uv:

uv pip install postgres-mcp

If you need to install uv, see the uv installation instructions.

Configure Your AI Assistant

We provide full instructions for configuring Postgres MCP Pro with Claude Desktop. Many MCP clients have similar configuration files, you can adapt these steps to work with the client of your choice.

#### Claude Desktop Configuration

You will need to edit the Claude Desktop configuration file to add Postgres MCP Pro. The locatio