Skip to content

pgtuner_mcp

MCP Developer Tools

An MCP server that provides AI‑powered PostgreSQL performance tuning, analyzing slow queries, recommending indexes, and monitoring database health.

Python Latest v0.6.0 · 1d ago Security brief →

Features

  • AI‑driven query analysis with `pg_stat_statements` and EXPLAIN insights
  • Hypothetical index testing using HypoPG without disk usage
  • Comprehensive PostgreSQL health scoring covering connections, cache hits, lock contention, vacuum status, replication lag, and I/O patterns
  • Configuration audit with recommendations for memory, checkpoint, WAL, autovacuum, and connection settings
  • Pre‑defined MCP prompt templates and dynamic resources for streamlined tuning workflows

Recent releases

View all 5 releases →
No immediate action
v0.6.0 Bug fix

Replication rollback fix

Monitor
v0.5.0 New feature

Vacuum monitoring + disk I/O tools

No immediate action
v0.4.0 New feature

User exclusion filter

No immediate action
v0.3.0 New feature

pgstattuple-based bloat detection

No immediate action
v0.2.0 New feature

HypoPG service methods

Weekly OSS security release digest.

The CVE patches and breaking changes that affected production tools this week. One email, every Sunday.

No spam, unsubscribe anytime.

About

Stars
24
Forks
5
Languages
Python Dockerfile Makefile

Install & Platforms

Install via
pip

Beta — feedback welcome: [email protected]