// MCP TOOL REFERENCE

POSTGRES TOOLS

239 tools from the Postgres MCP Server, categorised by risk level.

View the Postgres policy →
// ALL 239 POSTGRES TOOLS
READ 223 tools
Read PostgreSQL_statistics_reset_frequency Detect frequent planner statistics resets that might indicate issues. Read PostgreSQL_assess_trigger_performance_impact Assess the performance impact of triggers on table operations. Read PostgreSQL_wait_events_analysis Analyze current wait events and blocking processes. Read analyze_buffer_utilization Analyze shared buffer utilization patterns by relation. Read analyze_foreign_key_locks Analyze foreign key constraints that might cause locking issues. Read analyze_index_effectiveness Analyze index effectiveness and identify unused or redundant indexes. Read analyze_query_complexity Analyze query complexity patterns from pg_stat_statements. Read analyze_query_plans Analyze active query execution plans and their performance characteristics. Read analyze_sequence_usage Analyze sequence usage and predict when sequences might be exhausted. Read analyze_transaction_wraparound Monitor transaction ID wraparound risks across databases. Read analyze_trigger_performance Analyze trigger definitions and potential performance impacts. Read analyze_vacuum_efficiency Analyze vacuum efficiency and recommend vacuum strategies. Read check_constraint_violations Check for potential constraint violations and data integrity issues. Read check_database_encoding_collation Check database encoding, collation settings and potential issues. Read check_function_performance Analyze stored function and procedure performance statistics. Read check_replication_lag_details Detailed analysis of replication lag across all replicas. Read check_table_inheritance Analyze table inheritance hierarchies and partitioning structures. Read monitor_autovacuum_progress Monitor currently running autovacuum operations and their progress. Read monitor_checkpoint_efficiency Monitor checkpoint efficiency and timing patterns. Read monitor_connection_patterns Analyze connection patterns and identify potential connection issues. Read monitor_materialized_views Monitor materialized views status and freshness. Read monitor_wal_generation_rate Monitor WAL generation rate and predict disk space requirements. Read PostgreSQL_active_temp_file_users List active databases with significant temporary file usage indicating memory pressure. Read PostgreSQL_analyze_advanced_buffer_usage Analyze advanced buffer cache utilization patterns and efficiency. Read PostgreSQL_analyze_autovacuum_efficiency Analyze autovacuum efficiency and provide tuning recommendations. Read PostgreSQL_analyze_connection_pool_efficiency Analyze connection pool efficiency and usage patterns. Read PostgreSQL_analyze_index_bloat Identify indexes with significant bloat above a threshold percentage. Read PostgreSQL_analyze_query_complexity Analyze query complexity by examining execution plans and costs. Read PostgreSQL_analyze_table_freeze_stats Analyze XID freeze stats to detect tables nearing transaction wraparound risks. Read PostgreSQL_autovacuum_tuning Analyze autovacuum settings and provide tuning recommendations. Read PostgreSQL_backup_recovery_info Get backup and recovery related information including WAL archiving status. Read PostgreSQL_buffer_cache_hit_ratio Analyze buffer cache hit ratios for all databases and tables. Read PostgreSQL_buffer_cache_relation_analysis Analyze buffer cache distribution per relation with detailed breakdown. Read PostgreSQL_check_blocking_queries Get currently blocking and blocked queries with detailed info. Read PostgreSQL_check_long_running_queries Check for queries that have been running longer than the specified duration. Read PostgreSQL_check_table_bloat Check for table bloat statistics to identify tables that may need maintenance. Read PostgreSQL_checkpoint_activity Get detailed checkpoint activity and WAL statistics. Read PostgreSQL_connection_churn_analysis Analyze connection churn and idle times per user/application. Read PostgreSQL_connection_pool_stats Get PostgreSQL connection pool statistics and backend process information. Read PostgreSQL_constraint_violations Check for constraint violations and data integrity issues. Read PostgreSQL_deadlock_analysis Analyze deadlock history and patterns from logs. Read PostgreSQL_describe_table Get detailed information about a table's columns. Read PostgreSQL_detect_conflicting_queries Detect queries that hold locks conflicting with multiple other queries. Read PostgreSQL_detect_foreign_key_lock_contention Detect potential foreign key lock contention and blocking scenarios. Read PostgreSQL_detect_index_lock_waits Detect locking waits specifically on indexes. Read PostgreSQL_detect_table_bloat_regression Detect table bloat regression patterns over time and predict maintenance needs. Read PostgreSQL_detect_transaction_wraparound_risk Detect transaction ID wraparound risks and provide early warning. Read PostgreSQL_diagnose_logical_replication_lag Diagnose logical replication lag and identify bottlenecks. Read PostgreSQL_disk_usage_forecast Analyze database growth patterns and forecast disk usage. Read PostgreSQL_explain_query Run EXPLAIN on a query to show the execution plan. Read PostgreSQL_extension_usage List installed extensions and their usage statistics. Read PostgreSQL_foreign_key_conflicts Analyze foreign key constraints that could cause lock conflicts. Read PostgreSQL_foreign_key_orphaned_references Find tables with foreign keys that might reference deleted rows (integrity issues). Read PostgreSQL_foreign_keys_referencing_table List tables referencing the specified table via foreign keys. Read PostgreSQL_get_active_connections Get information about currently active database connections. Read PostgreSQL_get_active_transactions Get information about currently active transactions. Read PostgreSQL_get_all_constraints Get all table constraints (CHECK, UNIQUE, PRIMARY KEY, FOREIGN KEY). Read PostgreSQL_get_autovacuum_activity Get statistics on autovacuum operations and activity. Read PostgreSQL_get_autovacuum_settings Get autovacuum settings for all tables. Read PostgreSQL_get_autovacuum_stats_per_table Get autovacuum operation stats per table. Read PostgreSQL_get_backup_details Get last known backup status and WAL archiving info. Read PostgreSQL_get_backup_recovery_readiness Assess backup and recovery readiness of the PostgreSQL instance. Read PostgreSQL_get_backup_status Get the last known backup status and WAL archiving information. Read PostgreSQL_get_bloated_tables Find tables with significant bloat that may need maintenance. Read PostgreSQL_get_blocking_locks Identify blocking and blocked queries with detailed lock information. Read PostgreSQL_get_buffer_cache_contents Analyze what's currently in the PostgreSQL buffer cache (requires pg_buffercache extension). Read PostgreSQL_get_buffer_hit_ratios_detailed Get detailed buffer cache hit ratios by database and table. Read PostgreSQL_get_cache_hit_ratio Get cache hit ratios for tables and indexes. Read PostgreSQL_get_cache_hit_ratios Calculate cache hit ratios for buffer and index performance analysis. Read PostgreSQL_get_checkpoint_analysis Analyze checkpoint frequency and performance metrics. Read PostgreSQL_get_checkpoint_info Get checkpoint timing and performance information. Read PostgreSQL_get_checkpoint_stats Get checkpoint and background writer statistics. Read PostgreSQL_get_column_privileges Get column-level privileges on a specific table. Read PostgreSQL_get_column_statistics Get statistics information for table columns. Read PostgreSQL_get_concurrent_connection_analysis Analyze concurrent connections and their states over time. Read PostgreSQL_get_connection_limits Get information about connection limits and current usage. Read PostgreSQL_get_connection_pool_analysis Analyze connection pool efficiency and usage patterns. Read PostgreSQL_get_connection_pool_stats Get detailed connection and activity statistics. Read PostgreSQL_get_constraint_violation_risks Identify potential constraint violation risks and integrity issues. Read PostgreSQL_get_constraint_violations Check for potential constraint violations and data integrity issues. Read PostgreSQL_get_database_config Get important database configuration parameters. Read PostgreSQL_get_database_growth_trend Analyze database growth patterns over time using pg_stat_database. Read PostgreSQL_get_database_size Get size information for all databases in the cluster. Read PostgreSQL_get_database_size_by_tablespace Get database size breakdown by tablespace. Read PostgreSQL_get_detailed_foreign_tables Get advanced details about foreign tables and their servers. Read PostgreSQL_get_estimated_row_counts Get estimated row counts for all tables using statistics (faster than COUNT(*)). Read PostgreSQL_get_event_triggers Get all event triggers in the database. Read PostgreSQL_get_event_triggers_detailed Get comprehensive details about event triggers. Read PostgreSQL_get_extension_list List all installed PostgreSQL extensions. Read PostgreSQL_get_extension_usage_analysis Analyze installed extensions and their usage patterns. Read PostgreSQL_get_foreign_keys Get all foreign key relationships for a table (both referencing and referenced). Read PostgreSQL_get_foreign_tables Get information about foreign tables and foreign data wrappers. Read PostgreSQL_get_full_text_search_configs List all full-text search configurations available. Read PostgreSQL_get_functions Get all user-defined functions in the database. Read PostgreSQL_get_high_wait_events Get wait events with the highest average wait times. Read PostgreSQL_get_idle_connections Find idle connections and idle-in-transaction sessions. Read PostgreSQL_get_important_settings Get important PostgreSQL configuration parameters and their current values. Read PostgreSQL_get_index_maintenance_status Check index maintenance status and identify problematic indexes. Read PostgreSQL_get_index_usage Get index usage statistics to identify unused indexes. Read PostgreSQL_get_index_usage_stats Get comprehensive index usage statistics to identify unused or underutilized indexes. Read PostgreSQL_get_lock_monitoring Monitor current locks and potential blocking situations. Read PostgreSQL_get_lock_statistics Get detailed statistics of database locks, including wait times. Read PostgreSQL_get_lock_waits Get detailed information about current lock waits and blocking sessions. Read PostgreSQL_get_locks_info Get information about current database locks. Read PostgreSQL_get_logical_replication_stats Get logical replication subscription and worker statistics. Read PostgreSQL_get_long_running_transactions Identify long-running transactions that may be holding locks or bloating tables. Read PostgreSQL_get_materialized_view_stats Get statistics and refresh information for materialized views. Read PostgreSQL_get_materialized_views List all materialized views in a schema. Read PostgreSQL_get_memory_context_analysis Analyze PostgreSQL memory context usage and identify memory-intensive operations. Read PostgreSQL_get_memory_usage_stats Get memory-related statistics and buffer pool information. Read PostgreSQL_get_partition_details Get partitioning details of tables and partition strategies. Read PostgreSQL_get_partition_info_detailed Get detailed information about partitioned tables and their partition strategies. Read PostgreSQL_get_partitioned_tables Get information about partitioned tables and their partitions. Read PostgreSQL_get_performance_regression_indicators Identify potential performance regression indicators in queries and operations. Read PostgreSQL_get_prepared_transactions Get the list and stats of prepared transactions, if any. Read PostgreSQL_get_publication_details Retrieve details of all logical replication publications. Read PostgreSQL_get_publication_subscription_details Get logical replication publication and subscription details. Read PostgreSQL_get_publication_tables Get tables included in logical replication publications. Read PostgreSQL_get_publications Get information about logical replication publications. Read PostgreSQL_get_query_error_analysis Analyze query errors and failure patterns from logs. Read PostgreSQL_get_query_plan_cache_analysis Analyze query plan cache usage and effectiveness. Read PostgreSQL_get_query_plan_cache_stats Get statistics about cached query plans and their effectiveness. Read PostgreSQL_get_query_plans Get query execution plans from pg_stat_statements (if available). Read PostgreSQL_get_query_runtime_distribution Get distribution of query runtime in different time buckets. Read PostgreSQL_get_replication_slot_details Get detailed replication slot information including lag and usage. Read PostgreSQL_get_replication_slot_infos Get detailed replication slot information. Read PostgreSQL_get_replication_slots Get information about replication slots. Read PostgreSQL_get_replication_stats Get replication slot and standby server statistics. Read PostgreSQL_get_replication_status Get information about PostgreSQL replication status. Read PostgreSQL_get_role_attributes Get detailed information about database roles and their attributes. Read PostgreSQL_get_sequence_usage_risks Identify sequences approaching their limits or with risky usage patterns. Read PostgreSQL_get_sequence_usage_stats Analyze sequence usage patterns and potential exhaustion risks. Read PostgreSQL_get_sequence_value Get the next value of a sequence without incrementing it. Read PostgreSQL_get_sequences Get all sequences in the database with their current values. Read PostgreSQL_get_server_version Get PostgreSQL server version and configuration information. Read PostgreSQL_get_slow_queries Get slow queries from pg_stat_statements (if available). Read PostgreSQL_get_slow_query_patterns Analyze patterns in slow queries from pg_stat_statements. Read PostgreSQL_get_slow_query_statements Get slow queries from pg_stat_statements with additional performance metrics. Read PostgreSQL_get_subscription_info Get logical replication subscription information. Read PostgreSQL_get_table_access_patterns Analyze table access patterns - sequential scans vs index usage. Read PostgreSQL_get_table_bloat_estimation Estimate table bloat to identify tables that may need maintenance. Read PostgreSQL_get_table_constraints Get all constraints (primary key, foreign keys, etc.) for a table. Read PostgreSQL_get_table_count Get the row count of a specific table. Read PostgreSQL_get_table_fragmentation_analysis Analyze table fragmentation and bloat estimation. Read PostgreSQL_get_table_inheritance Get table inheritance relationships. Read PostgreSQL_get_table_io_stats Get I/O statistics for tables showing disk vs cache usage patterns. Read PostgreSQL_get_table_permissions Get permissions/grants on a specific table. Read PostgreSQL_get_table_rules Get all rules defined on tables. Read PostgreSQL_get_table_size Get the size information for a table. Read PostgreSQL_get_table_size_summary Get comprehensive table size information including indexes and toast. Read PostgreSQL_get_table_statistics Get comprehensive statistics for all user tables. Read PostgreSQL_get_tablespace_info Get information about all tablespaces. Read PostgreSQL_get_tablespace_usage Get tablespace usage statistics and disk space information. Read PostgreSQL_get_temp_file_stats Get temporary file usage statistics indicating potential memory pressure. Read PostgreSQL_get_temp_files Get information about temporary files usage by queries. Read PostgreSQL_get_text_search_configs Get full-text search configurations available in the database. Read PostgreSQL_get_toast_tables Get information about TOAST tables and their usage. Read PostgreSQL_get_top_heavy_queries Get top queries by total time, calls, and mean time from pg_stat_statements. Read PostgreSQL_get_transaction_age_monitoring Monitor transaction age and identify long-running or problematic transactions. Read PostgreSQL_get_trigger_performance_impact Analyze trigger performance impact on tables. Read PostgreSQL_get_triggers Get all triggers in the database. Read PostgreSQL_get_unused_indexes Find indexes that are rarely or never used. Read PostgreSQL_get_vacuum_analyze_recommendations Get recommendations for tables that may need vacuum or analyze operations. Read PostgreSQL_get_vacuum_inefficiency_tables Detect tables with inefficient vacuuming based on dead tuple ratio. Read PostgreSQL_get_vacuum_progress Monitor currently running VACUUM operations and their progress. Read PostgreSQL_get_wait_events Get current wait events from active sessions. Read PostgreSQL_get_wal_archiving_settings Get comprehensive WAL (Write Ahead Log) archiving configuration and status. Read PostgreSQL_get_wal_stats Get Write-Ahead Log (WAL) statistics and status. Read PostgreSQL_get_write_ahead_log_analysis Analyze Write-Ahead Log (WAL) generation and archiving performance. Read PostgreSQL_high_io_tables Detect tables with high I/O operations based on statistics. Read PostgreSQL_identify_index_redundancy Identify potentially redundant or overlapping indexes. Read PostgreSQL_index_bloat_maintenance_analysis Analyze index bloat and suggest maintenance actions. Read PostgreSQL_index_dead_tuples_analysis Analyze dead tuples per index for vacuum optimization. Read PostgreSQL_index_redundancy_detection Identify potentially redundant or overlapping indexes for tables. Read PostgreSQL_index_scan_efficiency Analyze index usage efficiency and identify unused indexes. Read PostgreSQL_list_databases List all databases in the PostgreSQL cluster. Read PostgreSQL_list_event_triggers_detailed Get detailed information about event triggers including their definitions. Read PostgreSQL_list_extensions List all available PostgreSQL extensions (installed and available). Read PostgreSQL_list_foreign_key_references List all tables that reference the specified table via foreign keys. Read PostgreSQL_list_foreign_tables_detailed Get detailed information about foreign tables and their servers. Read PostgreSQL_list_functions List all functions and their definitions in a schema. Read PostgreSQL_list_indexes List all indexes on a specific table. Read PostgreSQL_list_roles_with_login List all database roles with their login capabilities and attributes. Read PostgreSQL_list_roles_with_superuser List database roles, optionally showing only superusers. Read PostgreSQL_list_schemas List all schemas in the database. Read PostgreSQL_list_sequences List all sequences in a schema. Read PostgreSQL_list_table_rules List all rules defined on tables in the database. Read PostgreSQL_list_tables List all tables in a schema. Read PostgreSQL_list_triggers List all triggers on a specific table. Read PostgreSQL_list_users_and_roles List all database users and roles with their attributes. Read PostgreSQL_list_views List all views in a schema. Read PostgreSQL_logical_replication_slot_lag List logical replication slots with current lag in bytes and status. Read PostgreSQL_long_execution_triggers Detect triggers with long average execution times that may impact performance. Read PostgreSQL_long_running_prepared_transactions List prepared transactions sorted by duration with detailed analysis. Read PostgreSQL_longest_idle_transactions Find transactions idle in transaction state longer than a threshold. Read PostgreSQL_maintenance_window_activity Analyze database activity patterns during typical maintenance windows. Read PostgreSQL_memory_usage_analysis Analyze PostgreSQL memory usage and shared memory statistics. Read PostgreSQL_non_autovacuum_friendly_datatypes Identify tables with data types that may affect autovacuum efficiency. Read PostgreSQL_orphaned_prepared_transactions Detect large numbers of orphaned prepared transactions that need cleanup. Read PostgreSQL_parameter_sniffing_detection Detect potential parameter sniffing issues in prepared statements. Read PostgreSQL_partition_maintenance Analyze partitioned tables and their maintenance status. Read PostgreSQL_predict_sequence_exhaustion Predict sequence exhaustion based on usage patterns and growth trends. Read PostgreSQL_prepared_transaction_retention Analyze prepared transaction retention times and potential issues. Read PostgreSQL_query_cancellation_analysis Detect and analyze frequent query cancellations and their causes. Read PostgreSQL_query_plan_cache Analyze query plan cache statistics from pg_stat_statements if available. Read PostgreSQL_replication_lag_detailed Get detailed replication lag information for streaming replication. Read PostgreSQL_replication_slot_activity_analysis Detailed analysis of logical and physical replication slots with lag statistics. Read PostgreSQL_security_audit Perform basic security audit checks on database configuration. Read PostgreSQL_seqscan_heavy_tables Identify tables with high sequential scans that might need indexes. Read PostgreSQL_table_io_patterns Analyze table I/O patterns for sequential vs index scans. Read PostgreSQL_table_size_growth Analyze table size growth and storage efficiency. Read PostgreSQL_temp_file_usage Monitor temporary file usage which indicates memory pressure. Read PostgreSQL_temporary_objects_usage Analyze temporary table and file usage patterns. Read PostgreSQL_toast_table_excessive_usage Identify tables with excessively large TOAST table sizes relative to main table. Read PostgreSQL_transaction_wraparound_monitoring Monitor transaction ID wraparound status for all databases. Read PostgreSQL_unlogged_tables_analysis Analyze usage of unlogged tables and their implications. Read PostgreSQL_vacuum_analyze_frequency_analysis Compare vacuum/analyze frequency with table modification rates. Read PostgreSQL_vacuum_freeze_age_analysis Identify tables and databases approaching XID wraparound vacuum freeze threshold. Read PostgreSQL_vacuum_progress_monitoring Monitor active vacuum operations and their performance impact. Read PostgreSQL_verify_table_column_compression Verify compression methods applied to table columns (if supported). Read PostgreSQL_wal_segment_recycling_analysis Detect excessive WAL segment recycling that might indicate tuning issues. Read PostgreSQL_plan_invalidation_analysis Analyze common reasons for query plan invalidation and cache misses. Read PostgreSQL_predicate_lock_analysis Analyze predicate locks that may lead to serialization failures or contention.
WRITE 7 tools
Write PostgreSQL_reset_sequence Reset a sequence to a specific value or restart from 1. Write PostgreSQL_revoke_privileges PostgreSQL_revoke_privileges Write PostgreSQL_grant_privileges PostgreSQL_grant_privileges Write PostgreSQL_create_index PostgreSQL_create_index Write PostgreSQL_create_schema Create a new database schema. Write PostgreSQL_create_table Create a new table with specified columns. Write PostgreSQL_create_user PostgreSQL_create_user
DESTRUCTIVE 3 tools
Destructive PostgreSQL_drop_index Drop an index. Destructive PostgreSQL_drop_schema Drop a database schema. Destructive PostgreSQL_drop_user Drop a database user/role.
EXECUTE 6 tools
Execute PostgreSQL_execute_select_query Execute a SELECT query and return results. Execute PostgreSQL_execute_update_query Execute an UPDATE, INSERT, or DELETE query. Execute PostgreSQL_analyze_database Run ANALYZE on the entire database to update statistics. Execute PostgreSQL_kill_connection Terminate a specific database connection by PID. Execute PostgreSQL_refresh_materialized_view Refresh a materialized view. Execute PostgreSQL_vacuum_analyze_table Run VACUUM ANALYZE on a specific table to reclaim space and update statistics.

Route Postgres through PolicyLayer and every one of its 239 tools is checked against your policy before it runs.

CHECK YOUR STACK →

See every tool, the dangerous ones, and the token cost across your stack.

// FAQ
How many tools does the Postgres MCP server have? +

The Postgres MCP server exposes 239 tools across 4 categories: Read, Write, Destructive, Execute.

How do I enforce policies on Postgres tools? +

Route the Postgres server through the PolicyLayer gateway. Define allow, deny, or approval rules per tool in the dashboard; they are enforced on every call before it reaches the server.

What risk categories do Postgres tools fall into? +

Postgres tools are categorised as Read (223), Write (7), Destructive (3), Execute (6). Each category has a recommended default policy.

Enforce policy on every Postgres tool call.

Start from Postgres, add the rest of your stack, and see everything your agents can call. Then put policy on all of it.

CHECK YOUR STACK →

Free to start. No card required.

43,000+ MCP servers and 220,000+ tools scanned and risk-classified.

// GET IN TOUCH

Have a question or want to learn more? Send us a message.

Message sent.

We'll get back to you soon.