get_pg_stat_statements_top_queries

MCP tool from MCP PostgreSQL Ops by call518

pgstatstatements

How to use it

get_pg_stat_statements_top_queries is exposed by the MCP PostgreSQL Ops MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the get_pg_stat_statements_top_queries tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install MCP PostgreSQL Ops

$uvx --python 3.12 mcp-postgresql-ops

FULL MCP POSTGRESQL OPS LISTING

Other tools in MCP PostgreSQL Ops (36)

get_active_connections

❌ None

get_all_tables_stats

❌ None

get_async_io_status

❌ None

get_autovacuum_activity

❌ None

get_autovacuum_status

❌ None

get_bgwriter_stats

❌ None

get_current_database_info

❌ None

get_database_bloat_overview

❌ None

get_database_conflicts_stats

❌ None

get_database_list

❌ None

get_database_schema_info

❌ None

get_database_size_info

❌ None

get_database_stats

❌ None

get_index_io_stats

❌ None

get_index_usage_stats

❌ None

❌ None

get_lock_monitoring

❌ None

get_per_backend_io_stats

❌ None

get_pg_stat_monitor_recent_queries

pgstatmonitor

get_postgresql_config

❌ None

get_replication_status

❌ None

get_running_vacuum_operations

❌ None

get_server_info

❌ None

get_table_bloat_analysis

❌ None

get_table_io_stats

❌ None

❌ None

get_table_relationships

❌ None

get_table_schema_info

❌ None

get_table_size_info

❌ None

get_user_functions_stats

⚙️ Config Required

❌ None

get_vacuum_analyze_stats

❌ None

get_vacuum_effectiveness_analysis

❌ None

get_wait_events

❌ None

❌ None

get_wal_summarizer_status

❌ None