postgreSQL-analyzer-mcp
PostgreSQL Analyzer MCP is an AI-based tool that helps optimize PostgreSQL databases by analyzing query performance and providing actionable recommendations. It operates as a read-only MCP server, enabling remote access and use with various compatible clients.
analyze_database_structure
Analyze the database structure and provide optimization suggestions
get_slow_queries
Identify slow queries in the database
analyze_query
Analyze SQL queries and provide optimization suggestions
Recommend_indexes
Recommended indexes for a given SQL query
suggest_query_rewrite
Provide optimization rewrite suggestions for SQL queries
database_health_dashboard
Generate database health dashboard
query_optimization_wizard
Interactive wizards to gradually optimize SQL query
analyze_index_usage
Analyze index usage patterns and identify unused or inefficient indexes
execute_read_only_query
Execute a read-only SQL query and return the results
show_postgresql_settings
Show PostgreSQL configuration settings
health_check
Check if the server is running and responding