AcademyMCP serversData and reporting

pgtuner_mcp: PostgreSQL performance tuning

Database administrators and backend developers who review PostgreSQL performance and index design.

  • Recommendedour rating
  • 29gitHub stars
  • Apache-2.0licence
  • 4 months agolast update
claude mcp add pgtuner-mcp -e DATABASE_URI=postgresql://user:password@localhost:5432/mydb -- python -m pgtuner_mcp
README.md

Loading the file...

What it does

An MCP server for PostgreSQL that helps find and fix performance problems. It reads slow queries from pg_stat_statements, runs EXPLAIN plans, and monitors active and long-running transactions. It recommends indexes, tests hypothetical ones with HypoPG, and finds unused and duplicate indexes.

Use cases

  1. 01Find the slowest queries in a workload
  2. 02Test an index idea with HypoPG before creating it
  3. 03Detect unused or duplicate indexes

Questions about
pgtuner_mcp: PostgreSQL performance tuning.

What is pgtuner_mcp: PostgreSQL performance tuning used for?

Database administrators and backend developers who review PostgreSQL performance and index design. An MCP server for PostgreSQL that helps find and fix performance problems. It reads slow queries from pg_stat_statements, runs EXPLAIN plans, and monitors active and long-running transactions. It recommends indexes, tests hypothetical ones with HypoPG, and finds unused and duplicate indexes.

How do I install pgtuner_mcp: PostgreSQL performance tuning?

Run this in your terminal: claude mcp add pgtuner-mcp -e DATABASE_URI=postgresql://user:password@localhost:5432/mydb -- python -m pgtuner_mcp

Is pgtuner_mcp: PostgreSQL performance tuning open source?

Yes. The code is on GitHub (isdaniel/pgtuner_mcp) under the Apache-2.0 licence.

Is pgtuner_mcp: PostgreSQL performance tuning safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.