About PostgreSQL Analyzer MCP
PostgreSQL Analyzer MCP is an MCP server published by rameshv29 in the Data category: postgreSQL performance analysis and optimization MCP server.
The repository has 2 stars and 5 forks, with the last commit a year ago. Six months or more without a commit doesn't mean the server is broken, but check the open issues before depending on it in production.
Install
git clone https://github.com/rameshv29/postgreSQL-analyzer-mcpThis server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.
Tools (11)
analyze_database_structureAnalyze database schema and provide optimization recommendations
Parameters not published.
analyze_index_usageAnalyze index usage patterns and identify unused or inefficient indexes
Parameters not published.
analyze_queryAnalyze a SQL query and provide optimization recommendations
Parameters not published.
database_health_dashboardGenerate a comprehensive health dashboard for the database
Parameters not published.
execute_read_only_queryExecute a read-only SQL query and return the results
Parameters not published.
get_slow_queriesIdentify slow-running queries in the database
Parameters not published.
health_checkCheck if the server is running and responsive
Parameters not published.
query_optimization_wizardInteractive wizard to optimize a SQL query step by step
Parameters not published.
recommend_indexesRecommend indexes for a given SQL query
Parameters not published.
show_postgresql_settingsShow PostgreSQL configuration settings with optional filtering
Parameters not published.
suggest_query_rewriteSuggest optimized rewrites for a SQL query
Parameters not published.
Ask AI
Ask AI about PostgreSQL Analyzer MCP
Powered by Claude · Grounded in docs
Security checks
6 checks have not been run yet.