pgtuner_mcp
by Various
provides AI-powered PostgreSQL performance tuning capabilities.
MCP
pgtuner_mcp
Added 1 June 2026
Overview
pgtuner_mcp is a Python-based MCP server that analyzes PostgreSQL query plans and configuration to suggest performance improvements. It connects to a PostgreSQL database, retrieves slow queries and configuration settings, and returns tuning recommendations.
Best for
Best for
Developers and DBAs who want automated PostgreSQL tuning suggestions via MCP
Use cases
- Identify and optimize slow PostgreSQL queries
- Get configuration tuning suggestions for PostgreSQL
- Automate performance review in CI/CD pipelines
Notes
pgtuner_mcp is a Python-based MCP server that analyzes PostgreSQL query plans and configuration to suggest performance improvements. It connects to a PostgreSQL database, retrieves slow queries and configuration settings, and returns tuning recommendations.
24 stars on GitHub. Last updated 2026-05-31. Licensed Apache-2.0.
Use cases
- Identify and optimize slow PostgreSQL queries
- Get configuration tuning suggestions for PostgreSQL
- Automate performance review in CI/CD pipelines
Pros
- Directly integrates with PostgreSQL for real-time analysis
- Lightweight Python implementation with MCP protocol
- Open source with active community contributions
Cons
- Limited to PostgreSQL databases only
- Requires database credentials and network access
- Small user base may mean fewer tested scenarios
Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.
Pros
- Directly integrates with PostgreSQL for real-time analysis
- Lightweight Python implementation with MCP protocol
- Open source with active community contributions
Cons
- Limited to PostgreSQL databases only
- Requires database credentials and network access
- Small user base may mean fewer tested scenarios
Pairs with
Other entries in the index that connect to this one. Click through to see the chain.
Cursor
Anysphere
The AI-first code editor. Tab to autocomplete, Composer to multi-file refactor, Agents for the long-running stuff.
Cline
Cline
Open-source autonomous coding agent that lives inside VS Code. BYO model key, watch it work.
Continue
Continue.dev
Open-source AI code assistant for VS Code and JetBrains. Customisable, BYO model, built for enterprise.