Home

Example Queries

🟢 Extension-Independent Tools (Always Available)

get_server_info

• "Show PostgreSQL server version and extension status"

• "Check if pg_stat_statements is installed"

get_active_connections

• "Show all active connections"

• "List current sessions with database and user"

get_postgresql_config

• "Show all PostgreSQL configuration parameters"

• "Find all memory-related configuration settings"

get_database_list

• "List all databases and their sizes"

• "Show database list with owner information"

get_table_list

• "List all tables in the ecommerce database"

• "Show table sizes in the public schema"

get_table_schema_info

📋 Features: Column types, constraints, indexes, foreign keys, table metadata

⚠️ Required: database_name parameter must be specified

• "Show detailed schema information for the customers table in ecommerce database"

• "Get column details and constraints for products table in ecommerce database"

• "Analyze table structure with indexes and foreign keys for orders table in sales schema of ecommerce database"

• "Show schema overview for all tables in public schema of inventory database"

• "Get complete table structure including constraints and indexes for employees table in hr_system database"

• "Display column information with data types and constraints for inventory_items table in inventory database"

get_database_schema_info

📋 Features: Schema owners, permissions, object counts, sizes, contents

⚠️ Required: database_name parameter must be specified

• "Show all schemas in ecommerce database with their contents"

• "Get detailed information about sales schema in ecommerce database"

• "Analyze schema structure and permissions for inventory database"

• "Show schema overview with table counts and sizes for hr_system database"

get_table_relationships

📋 Features: Foreign key relationships (inbound/outbound), cross-schema dependencies, constraint details

⚠️ Required: database_name parameter must be specified

💡 Usage: Leave table_name empty for database-wide relationship analysis

• "Show all relationships for customers table in ecommerce database"

• "Analyze foreign key relationships for orders table in sales schema of ecommerce database"

• "Get database-wide relationship overview for ecommerce database"

• "Find all tables that reference products table in ecommerce database"

• "Show cross-schema relationships in inventory database"

get_user_list

• "List all database users and their roles"

• "Show user permissions for a specific database"

get_index_usage_stats

• "Analyze index usage efficiency"

• "Find unused indexes in the current database"

get_database_size_info

• "Show database capacity analysis"

get_table_size_info

• "Show table and index size analysis"

get_vacuum_analyze_stats

• "Show recent VACUUM and ANALYZE operations"

• "List tables needing VACUUM"

get_lock_monitoring

• "Show all current locks and blocked sessions"

• "Show only blocked sessions with granted=false filter"

• "Monitor locks by specific user with username filter"

• "Check exclusive locks with mode filter"

get_wal_status

• "Show WAL status and archiving information"

• "Monitor WAL generation and current LSN position"

get_replication_status

• "Check replication connections and lag status"

• "Monitor replication slots and WAL receiver status"

get_database_stats

• "Show comprehensive database performance metrics"

• "Analyze transaction commit ratios and I/O statistics"

• "Monitor buffer cache hit ratios and temporary file usage"

get_bgwriter_stats

• "Analyze checkpoint performance and timing"

• "Show me checkpoint performance"

• "Show background writer efficiency statistics"

• "Monitor buffer allocation and fsync patterns"

get_all_tables_stats

• "Show comprehensive statistics for all tables"

• "Include system tables with include_system=true parameter"

• "Analyze table access patterns and maintenance needs"

get_user_functions_stats

⚠️ Requires: track_functions = pl in postgresql.conf

• "Analyze user-defined function performance"

• "Show function call counts and execution times"

• "Identify performance bottlenecks in custom functions"

get_table_io_stats

💡 Enhanced with: track_io_timing = on for accurate timing

• "Analyze table I/O performance and buffer hit ratios"

• "Identify tables with poor buffer cache performance"

• "Monitor TOAST table I/O statistics"

get_index_io_stats

💡 Enhanced with: track_io_timing = on for accurate timing

• "Show index I/O performance and buffer efficiency"

• "Identify indexes causing excessive disk I/O"

• "Monitor index cache-friendliness patterns"

get_database_conflicts_stats

• "Check replication conflicts on standby servers"

• "Analyze conflict types and resolution statistics"

• "Monitor standby server query cancellation patterns"

• "Monitor WAL generation and current LSN position"

get_replication_status

• "Check replication connections and lag status"

• "Monitor replication slots and WAL receiver status"

🚀 Version-Aware Tools (Auto-Adapting)

get_io_stats (New!)

📈 PG16+: Full pg_stat_io with timing, backend types, and contexts

📊 PG12-15: Basic pg_statio_* fallback with buffer hit ratios

• "Show comprehensive I/O statistics" (PostgreSQL 16+ provides detailed breakdown)

• "Analyze I/O statistics"

• "Analyze buffer cache efficiency and I/O timing"

• "Monitor I/O patterns by backend type and context"

get_bgwriter_stats (Enhanced!)

📈 PG15: Separate checkpointer and bgwriter statistics (unique feature)

📊 PG12-14, 16+: Combined bgwriter stats (includes checkpointer data)

• "Show background writer and checkpoint performance"

get_server_info (Enhanced!)

• "Show server version and compatibility features"

• "Check server compatibility"

• "Check what MCP tools are available on this PostgreSQL version"

• "Displays feature availability matrix and upgrade recommendations"

🟡 Extension-Dependent Tools

get_pg_stat_statements_top_queries (Requires pg_stat_statements)

• "Show top 10 slowest queries"

• "Analyze slow queries in the inventory database"

get_pg_stat_monitor_recent_queries (Optional, uses pg_stat_monitor)

• "Show recent queries in real time"

• "Monitor query activity for the last 5 minutes"