A powerful, AI-integrated PostgreSQL Model Context Protocol (MCP) server for automated database operations, monitoring, security, diagnostics, and optimization. Seamlessly manage PostgreSQL with tools and prompts designed for AI assistants like Claude and ChatGPT.

GitHub Repository: https://github.com/mukul975/postgres-mcp-server.git

• 🔍 Explore, diagnose & optimize PostgreSQL databases with over 200 specialized tools.
• 💬 Interact naturally using AI prompts for SQL generation, health checks, and performance reviews.
• 🛡️ Built-in security, permission validation, and error handling.
• ⚙️ Developer-ready integration for Claude, ChatGPT, and custom agents.

• ✅ Create/list databases & schemas
• ✅ Describe tables, analyze indexes
• ✅ Safe SELECT, UPDATE, DELETE execution

• 📈 Query performance & execution plan insights
• 🔒 Lock analysis, replication lag checks
• 🚀 Index, query, and buffer pool optimization

• 👥 User creation, role auditing
• 🔐 Privilege granting & connection monitoring

• 🧪 Table bloat check, autovacuum insights
• 💽 WAL logs, checkpoints, long transaction alerts

To help you navigate, tools are grouped under the following main categories:

• 🔧 General Database Operations
• 👥 User & Role Management
• 📈 Performance Monitoring & Tuning
• 🔁 Replication & Backup
• 🔒 Lock & Concurrency Management
• ✅ Constraint & Integrity Management
• 📊 Resource and Activity Monitoring
• 🧰 Index and Table Maintenance
• 🔬 Advanced Analysis & Diagnostics

python -m venv venv
source venv/bin/activate   # or venv\Scripts\activate on Windows
pip install -r requirements.txt

cp .env.example .env  # or use copy on Windows
# Update with:
DATABASE_URL=postgresql://username:password@localhost:5432/db

python postgres_server.py

✅ For MCP CLI users:

mcp dev postgres_server.py

{
  "mcpServers": {
    "postgres": {
      "command": "python",
      "args": ["postgres_server.py"],
      "cwd": "C:\\path\\to\\postgres-mcp-server",
      "env": {
        "DATABASE_URL": "postgresql://username:password@localhost:5432/database"
      }
    }
  }
}

{
  "mcpServers": {
    "postgres": {
      "command": "python",
      "args": ["postgres_server.py"],
      "cwd": "/absolute/path/to/postgres-mcp-server",
      "env": {
        "DATABASE_URL": "postgresql://username:password@localhost:5432/database"
      }
    }
  }
}

Quick Tool Finder: Use Ctrl+F (or Cmd+F) to search for specific tools by name, category, or functionality.

"List all indexes in the public schema" "Show detailed structure of the orders table"

"What are the slowest queries?" "Analyze unused indexes"

"VACUUM ANALYZE the products table" "Find bloated tables in the database"

"List all users and their roles" "Show active connections and privilege levels"

• Full PostgreSQL system health check
• Query and index optimization

• AI-based schema exploration
• SQL query building with NLP

• Role auditing, connection analysis
• Secure query validation and permission check

This project is licensed under the MIT License – see the LICENSE file for details.

If you find this useful, please:

• ⭐ Star the repo
• 🍝 Fork it
• 🛠️ Submit issues or PRs

🧠 Let’s build smarter PostgreSQL automation – one prompt at a time.

#PostgreSQL #MCP #AI_Database_Tools #Claude #Query_Optimizer #Database_Health_Check #Python_PostgreSQL #DevOps_AI #Database_Monitoring #OpenSource