# Postgres MCP Pro Server for Database Analysis and Tuning

> Postgres MCP Pro is an open-source MCP server that provides AI agents with PostgreSQL database health analysis, index tuning recommendations, query plan optimization, schema intelligence, and safe SQL execution with configurable access controls.

- Skill: `agentskillexchange/postgres-mcp-pro-server-for-database-analysis-and-tuning` (Agent Skill)
- Install (CLI): `npx skillmds@latest add agentskillexchange/postgres-mcp-pro-server-for-database-analysis-and-tuning`
- Raw SKILL.md: https://api.skillmd.com/api/skills/agentskillexchange/postgres-mcp-pro-server-for-database-analysis-and-tuning/raw
- Safety review: pending (external: skill-scanner PASS, skillspector CAUTION)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: agentskillexchange (https://skillmd.com/u/agentskillexchange)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/agentskillexchange/postgres-mcp-pro-server-for-database-analysis-and-tuning

---


# Postgres MCP Pro Server for Database Analysis and Tuning

Postgres MCP Pro is an open-source MCP server that provides AI agents with PostgreSQL database health analysis, index tuning recommendations, query plan optimization, schema intelligence, and safe SQL execution with configurable access controls.

## Installation

Use the upstream install or setup path that matches your environment:
- The choice to use Docker or Python is yours.
- docker pull crystaldba/postgres-mcp
- pipx install postgres-mcp
- uv pip install postgres-mcp

Requirements and caveats from upstream:
- Docker *or* Python 3.12 or higher.
- #### Docker or Python
- We generally recommend Docker because Python users can encounter more environment-specific issues.

Basic usage or getting-started notes:
- <a href="#quick-start">Quick Start</a> •
- Before getting started, ensure you have:
- Access credentials for your database.

- Source: https://github.com/crystaldba/postgres-mcp
- Extracted from upstream docs: https://raw.githubusercontent.com/crystaldba/postgres-mcp/HEAD/README.md

## Source

- [Agent Skill Exchange](https://agentskillexchange.com/skills/postgres-mcp-pro-database-analysis-tuning/)