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.
Scanned 6/8/2026
Install via CLI
openskills install agentskillexchange/skills---
name: "Postgres MCP Pro Server for Database Analysis and Tuning"
slug: "postgres-mcp-pro-database-analysis-tuning"
description: "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."
github_stars: 2464
verification: "security_reviewed"
source: "https://github.com/crystaldba/postgres-mcp"
category: "Developer Tools"
framework: "MCP"
tool_ecosystem:
github_repo: "crystaldba/postgres-mcp"
github_stars: 2464
---
# 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/)
No comments yet. Be the first to comment!
Ultra-compressed communication mode. Cuts token usage ~75% by speaking like caveman while keeping full technical accuracy. Supports intensity levels: lite, full (default), ultra, wenyan-lite, wenyan-full, wenyan-ultra. Use when user says "caveman mode", "talk like caveman", "use caveman", "less tokens", "be brief", or invokes /caveman. Also auto-triggers when token efficiency is requested.