# Postgres MCP server

Agent View of the PolicyLayer registry record for Postgres: identity, probed posture, risk grade, and all 239 tools classified. HTML page: https://policylayer.com/tools/mukul975-postgres-mcp-server

## Facts

- Server id: `mukul975/postgres-mcp-server`
- Homepage: https://github.com/mukul975/postgres-mcp-server
- Registry record: grade F, identity unverified
- Lifecycle: active
- Rate-limited: no
- Tools: 239
- Tool categories present: Destructive, Execute, Read, Write
- Tags: mukul975 postgres mcp server, admin, automation
- Record last modified: 2026-08-12T11:12:19.927Z

## Tools (239)

| Tool | Category | Risk | Record |
| --- | --- | --- | --- |
| `PostgreSQL_drop_index` | Destructive | Critical | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-drop-index.md |
| `PostgreSQL_drop_schema` | Destructive | Critical | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-drop-schema.md |
| `PostgreSQL_drop_user` | Destructive | Critical | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-drop-user.md |
| `PostgreSQL_analyze_database` | Execute | High | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-analyze-database.md |
| `PostgreSQL_execute_select_query` | Execute | High | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-execute-select-query.md |
| `PostgreSQL_execute_update_query` | Execute | High | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-execute-update-query.md |
| `PostgreSQL_kill_connection` | Execute | High | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-kill-connection.md |
| `PostgreSQL_refresh_materialized_view` | Execute | High | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-refresh-materialized-view.md |
| `PostgreSQL_vacuum_analyze_table` | Execute | High | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-vacuum-analyze-table.md |
| `analyze_buffer_utilization` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/analyze-buffer-utilization.md |
| `analyze_foreign_key_locks` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/analyze-foreign-key-locks.md |
| `analyze_index_effectiveness` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/analyze-index-effectiveness.md |
| `analyze_query_complexity` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/analyze-query-complexity.md |
| `analyze_query_plans` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/analyze-query-plans.md |
| `analyze_sequence_usage` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/analyze-sequence-usage.md |
| `analyze_transaction_wraparound` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/analyze-transaction-wraparound.md |
| `analyze_trigger_performance` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/analyze-trigger-performance.md |
| `analyze_vacuum_efficiency` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/analyze-vacuum-efficiency.md |
| `check_constraint_violations` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/check-constraint-violations.md |
| `check_database_encoding_collation` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/check-database-encoding-collation.md |
| `check_function_performance` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/check-function-performance.md |
| `check_replication_lag_details` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/check-replication-lag-details.md |
| `check_table_inheritance` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/check-table-inheritance.md |
| `monitor_autovacuum_progress` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/monitor-autovacuum-progress.md |
| `monitor_checkpoint_efficiency` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/monitor-checkpoint-efficiency.md |
| `monitor_connection_patterns` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/monitor-connection-patterns.md |
| `monitor_materialized_views` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/monitor-materialized-views.md |
| `monitor_wal_generation_rate` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/monitor-wal-generation-rate.md |
| `PostgreSQL_active_temp_file_users` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-active-temp-file-users.md |
| `PostgreSQL_analyze_advanced_buffer_usage` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-analyze-advanced-buffer-usage.md |
| `PostgreSQL_analyze_autovacuum_efficiency` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-analyze-autovacuum-efficiency.md |
| `PostgreSQL_analyze_connection_pool_efficiency` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-analyze-connection-pool-efficiency.md |
| `PostgreSQL_analyze_index_bloat` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-analyze-index-bloat.md |
| `PostgreSQL_analyze_query_complexity` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-analyze-query-complexity.md |
| `PostgreSQL_analyze_table_freeze_stats` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-analyze-table-freeze-stats.md |
| `PostgreSQL_assess_trigger_performance_impact` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-assess-trigger-performance-impact.md |
| `PostgreSQL_autovacuum_tuning` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-autovacuum-tuning.md |
| `PostgreSQL_backup_recovery_info` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-backup-recovery-info.md |
| `PostgreSQL_buffer_cache_hit_ratio` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-buffer-cache-hit-ratio.md |
| `PostgreSQL_buffer_cache_relation_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-buffer-cache-relation-analysis.md |
| `PostgreSQL_check_blocking_queries` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-check-blocking-queries.md |
| `PostgreSQL_check_long_running_queries` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-check-long-running-queries.md |
| `PostgreSQL_check_table_bloat` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-check-table-bloat.md |
| `PostgreSQL_checkpoint_activity` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-checkpoint-activity.md |
| `PostgreSQL_connection_churn_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-connection-churn-analysis.md |
| `PostgreSQL_connection_pool_stats` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-connection-pool-stats.md |
| `PostgreSQL_constraint_violations` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-constraint-violations.md |
| `PostgreSQL_deadlock_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-deadlock-analysis.md |
| `PostgreSQL_describe_table` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-describe-table.md |
| `PostgreSQL_detect_conflicting_queries` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-detect-conflicting-queries.md |
| `PostgreSQL_detect_foreign_key_lock_contention` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-detect-foreign-key-lock-contention.md |
| `PostgreSQL_detect_index_lock_waits` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-detect-index-lock-waits.md |
| `PostgreSQL_detect_table_bloat_regression` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-detect-table-bloat-regression.md |
| `PostgreSQL_detect_transaction_wraparound_risk` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-detect-transaction-wraparound-risk.md |
| `PostgreSQL_diagnose_logical_replication_lag` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-diagnose-logical-replication-lag.md |
| `PostgreSQL_disk_usage_forecast` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-disk-usage-forecast.md |
| `PostgreSQL_explain_query` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-explain-query.md |
| `PostgreSQL_extension_usage` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-extension-usage.md |
| `PostgreSQL_foreign_key_conflicts` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-foreign-key-conflicts.md |
| `PostgreSQL_foreign_key_orphaned_references` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-foreign-key-orphaned-references.md |
| `PostgreSQL_foreign_keys_referencing_table` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-foreign-keys-referencing-table.md |
| `PostgreSQL_get_active_connections` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-active-connections.md |
| `PostgreSQL_get_active_transactions` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-active-transactions.md |
| `PostgreSQL_get_all_constraints` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-all-constraints.md |
| `PostgreSQL_get_autovacuum_activity` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-autovacuum-activity.md |
| `PostgreSQL_get_autovacuum_settings` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-autovacuum-settings.md |
| `PostgreSQL_get_autovacuum_stats_per_table` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-autovacuum-stats-per-table.md |
| `PostgreSQL_get_backup_details` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-backup-details.md |
| `PostgreSQL_get_backup_recovery_readiness` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-backup-recovery-readiness.md |
| `PostgreSQL_get_backup_status` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-backup-status.md |
| `PostgreSQL_get_bloated_tables` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-bloated-tables.md |
| `PostgreSQL_get_blocking_locks` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-blocking-locks.md |
| `PostgreSQL_get_buffer_cache_contents` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-buffer-cache-contents.md |
| `PostgreSQL_get_buffer_hit_ratios_detailed` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-buffer-hit-ratios-detailed.md |
| `PostgreSQL_get_cache_hit_ratio` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-cache-hit-ratio.md |
| `PostgreSQL_get_cache_hit_ratios` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-cache-hit-ratios.md |
| `PostgreSQL_get_checkpoint_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-checkpoint-analysis.md |
| `PostgreSQL_get_checkpoint_info` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-checkpoint-info.md |
| `PostgreSQL_get_checkpoint_stats` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-checkpoint-stats.md |
| `PostgreSQL_get_column_privileges` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-column-privileges.md |
| `PostgreSQL_get_column_statistics` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-column-statistics.md |
| `PostgreSQL_get_concurrent_connection_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-concurrent-connection-analysis.md |
| `PostgreSQL_get_connection_limits` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-connection-limits.md |
| `PostgreSQL_get_connection_pool_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-connection-pool-analysis.md |
| `PostgreSQL_get_connection_pool_stats` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-connection-pool-stats.md |
| `PostgreSQL_get_constraint_violation_risks` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-constraint-violation-risks.md |
| `PostgreSQL_get_constraint_violations` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-constraint-violations.md |
| `PostgreSQL_get_database_config` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-database-config.md |
| `PostgreSQL_get_database_growth_trend` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-database-growth-trend.md |
| `PostgreSQL_get_database_size` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-database-size.md |
| `PostgreSQL_get_database_size_by_tablespace` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-database-size-by-tablespace.md |
| `PostgreSQL_get_detailed_foreign_tables` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-detailed-foreign-tables.md |
| `PostgreSQL_get_estimated_row_counts` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-estimated-row-counts.md |
| `PostgreSQL_get_event_triggers` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-event-triggers.md |
| `PostgreSQL_get_event_triggers_detailed` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-event-triggers-detailed.md |
| `PostgreSQL_get_extension_list` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-extension-list.md |
| `PostgreSQL_get_extension_usage_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-extension-usage-analysis.md |
| `PostgreSQL_get_foreign_keys` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-foreign-keys.md |
| `PostgreSQL_get_foreign_tables` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-foreign-tables.md |
| `PostgreSQL_get_full_text_search_configs` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-full-text-search-configs.md |
| `PostgreSQL_get_functions` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-functions.md |
| `PostgreSQL_get_high_wait_events` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-high-wait-events.md |
| `PostgreSQL_get_idle_connections` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-idle-connections.md |
| `PostgreSQL_get_important_settings` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-important-settings.md |
| `PostgreSQL_get_index_maintenance_status` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-index-maintenance-status.md |
| `PostgreSQL_get_index_usage` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-index-usage.md |
| `PostgreSQL_get_index_usage_stats` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-index-usage-stats.md |
| `PostgreSQL_get_lock_monitoring` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-lock-monitoring.md |
| `PostgreSQL_get_lock_statistics` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-lock-statistics.md |
| `PostgreSQL_get_lock_waits` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-lock-waits.md |
| `PostgreSQL_get_locks_info` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-locks-info.md |
| `PostgreSQL_get_logical_replication_stats` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-logical-replication-stats.md |
| `PostgreSQL_get_long_running_transactions` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-long-running-transactions.md |
| `PostgreSQL_get_materialized_view_stats` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-materialized-view-stats.md |
| `PostgreSQL_get_materialized_views` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-materialized-views.md |
| `PostgreSQL_get_memory_context_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-memory-context-analysis.md |
| `PostgreSQL_get_memory_usage_stats` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-memory-usage-stats.md |
| `PostgreSQL_get_partition_details` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-partition-details.md |
| `PostgreSQL_get_partition_info_detailed` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-partition-info-detailed.md |
| `PostgreSQL_get_partitioned_tables` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-partitioned-tables.md |
| `PostgreSQL_get_performance_regression_indicators` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-performance-regression-indicators.md |
| `PostgreSQL_get_prepared_transactions` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-prepared-transactions.md |
| `PostgreSQL_get_publication_details` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-publication-details.md |
| `PostgreSQL_get_publication_subscription_details` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-publication-subscription-details.md |
| `PostgreSQL_get_publication_tables` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-publication-tables.md |
| `PostgreSQL_get_publications` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-publications.md |
| `PostgreSQL_get_query_error_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-query-error-analysis.md |
| `PostgreSQL_get_query_plan_cache_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-query-plan-cache-analysis.md |
| `PostgreSQL_get_query_plan_cache_stats` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-query-plan-cache-stats.md |
| `PostgreSQL_get_query_plans` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-query-plans.md |
| `PostgreSQL_get_query_runtime_distribution` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-query-runtime-distribution.md |
| `PostgreSQL_get_replication_slot_details` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-replication-slot-details.md |
| `PostgreSQL_get_replication_slot_infos` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-replication-slot-infos.md |
| `PostgreSQL_get_replication_slots` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-replication-slots.md |
| `PostgreSQL_get_replication_stats` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-replication-stats.md |
| `PostgreSQL_get_replication_status` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-replication-status.md |
| `PostgreSQL_get_role_attributes` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-role-attributes.md |
| `PostgreSQL_get_sequence_usage_risks` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-sequence-usage-risks.md |
| `PostgreSQL_get_sequence_usage_stats` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-sequence-usage-stats.md |
| `PostgreSQL_get_sequence_value` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-sequence-value.md |
| `PostgreSQL_get_sequences` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-sequences.md |
| `PostgreSQL_get_server_version` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-server-version.md |
| `PostgreSQL_get_slow_queries` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-slow-queries.md |
| `PostgreSQL_get_slow_query_patterns` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-slow-query-patterns.md |
| `PostgreSQL_get_slow_query_statements` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-slow-query-statements.md |
| `PostgreSQL_get_subscription_info` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-subscription-info.md |
| `PostgreSQL_get_table_access_patterns` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-table-access-patterns.md |
| `PostgreSQL_get_table_bloat_estimation` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-table-bloat-estimation.md |
| `PostgreSQL_get_table_constraints` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-table-constraints.md |
| `PostgreSQL_get_table_count` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-table-count.md |
| `PostgreSQL_get_table_fragmentation_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-table-fragmentation-analysis.md |
| `PostgreSQL_get_table_inheritance` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-table-inheritance.md |
| `PostgreSQL_get_table_io_stats` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-table-io-stats.md |
| `PostgreSQL_get_table_permissions` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-table-permissions.md |
| `PostgreSQL_get_table_rules` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-table-rules.md |
| `PostgreSQL_get_table_size` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-table-size.md |
| `PostgreSQL_get_table_size_summary` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-table-size-summary.md |
| `PostgreSQL_get_table_statistics` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-table-statistics.md |
| `PostgreSQL_get_tablespace_info` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-tablespace-info.md |
| `PostgreSQL_get_tablespace_usage` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-tablespace-usage.md |
| `PostgreSQL_get_temp_file_stats` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-temp-file-stats.md |
| `PostgreSQL_get_temp_files` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-temp-files.md |
| `PostgreSQL_get_text_search_configs` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-text-search-configs.md |
| `PostgreSQL_get_toast_tables` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-toast-tables.md |
| `PostgreSQL_get_top_heavy_queries` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-top-heavy-queries.md |
| `PostgreSQL_get_transaction_age_monitoring` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-transaction-age-monitoring.md |
| `PostgreSQL_get_trigger_performance_impact` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-trigger-performance-impact.md |
| `PostgreSQL_get_triggers` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-triggers.md |
| `PostgreSQL_get_unused_indexes` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-unused-indexes.md |
| `PostgreSQL_get_vacuum_analyze_recommendations` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-vacuum-analyze-recommendations.md |
| `PostgreSQL_get_vacuum_inefficiency_tables` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-vacuum-inefficiency-tables.md |
| `PostgreSQL_get_vacuum_progress` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-vacuum-progress.md |
| `PostgreSQL_get_wait_events` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-wait-events.md |
| `PostgreSQL_get_wal_archiving_settings` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-wal-archiving-settings.md |
| `PostgreSQL_get_wal_stats` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-wal-stats.md |
| `PostgreSQL_get_write_ahead_log_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-get-write-ahead-log-analysis.md |
| `PostgreSQL_high_io_tables` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-high-io-tables.md |
| `PostgreSQL_identify_index_redundancy` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-identify-index-redundancy.md |
| `PostgreSQL_index_bloat_maintenance_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-index-bloat-maintenance-analysis.md |
| `PostgreSQL_index_dead_tuples_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-index-dead-tuples-analysis.md |
| `PostgreSQL_index_redundancy_detection` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-index-redundancy-detection.md |
| `PostgreSQL_index_scan_efficiency` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-index-scan-efficiency.md |
| `PostgreSQL_list_databases` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-databases.md |
| `PostgreSQL_list_event_triggers_detailed` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-event-triggers-detailed.md |
| `PostgreSQL_list_extensions` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-extensions.md |
| `PostgreSQL_list_foreign_key_references` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-foreign-key-references.md |
| `PostgreSQL_list_foreign_tables_detailed` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-foreign-tables-detailed.md |
| `PostgreSQL_list_functions` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-functions.md |
| `PostgreSQL_list_indexes` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-indexes.md |
| `PostgreSQL_list_roles_with_login` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-roles-with-login.md |
| `PostgreSQL_list_roles_with_superuser` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-roles-with-superuser.md |
| `PostgreSQL_list_schemas` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-schemas.md |
| `PostgreSQL_list_sequences` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-sequences.md |
| `PostgreSQL_list_table_rules` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-table-rules.md |
| `PostgreSQL_list_tables` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-tables.md |
| `PostgreSQL_list_triggers` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-triggers.md |
| `PostgreSQL_list_users_and_roles` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-users-and-roles.md |
| `PostgreSQL_list_views` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-list-views.md |
| `PostgreSQL_logical_replication_slot_lag` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-logical-replication-slot-lag.md |
| `PostgreSQL_long_execution_triggers` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-long-execution-triggers.md |
| `PostgreSQL_long_running_prepared_transactions` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-long-running-prepared-transactions.md |
| `PostgreSQL_longest_idle_transactions` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-longest-idle-transactions.md |
| `PostgreSQL_maintenance_window_activity` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-maintenance-window-activity.md |
| `PostgreSQL_memory_usage_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-memory-usage-analysis.md |
| `PostgreSQL_non_autovacuum_friendly_datatypes` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-non-autovacuum-friendly-datatypes.md |
| `PostgreSQL_orphaned_prepared_transactions` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-orphaned-prepared-transactions.md |
| `PostgreSQL_parameter_sniffing_detection` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-parameter-sniffing-detection.md |
| `PostgreSQL_partition_maintenance` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-partition-maintenance.md |
| `PostgreSQL_plan_invalidation_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-plan-invalidation-analysis.md |
| `PostgreSQL_predicate_lock_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-predicate-lock-analysis.md |
| `PostgreSQL_predict_sequence_exhaustion` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-predict-sequence-exhaustion.md |
| `PostgreSQL_prepared_transaction_retention` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-prepared-transaction-retention.md |
| `PostgreSQL_query_cancellation_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-query-cancellation-analysis.md |
| `PostgreSQL_query_plan_cache` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-query-plan-cache.md |
| `PostgreSQL_replication_lag_detailed` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-replication-lag-detailed.md |
| `PostgreSQL_replication_slot_activity_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-replication-slot-activity-analysis.md |
| `PostgreSQL_security_audit` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-security-audit.md |
| `PostgreSQL_seqscan_heavy_tables` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-seqscan-heavy-tables.md |
| `PostgreSQL_statistics_reset_frequency` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-statistics-reset-frequency.md |
| `PostgreSQL_table_io_patterns` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-table-io-patterns.md |
| `PostgreSQL_table_size_growth` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-table-size-growth.md |
| `PostgreSQL_temp_file_usage` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-temp-file-usage.md |
| `PostgreSQL_temporary_objects_usage` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-temporary-objects-usage.md |
| `PostgreSQL_toast_table_excessive_usage` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-toast-table-excessive-usage.md |
| `PostgreSQL_transaction_wraparound_monitoring` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-transaction-wraparound-monitoring.md |
| `PostgreSQL_unlogged_tables_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-unlogged-tables-analysis.md |
| `PostgreSQL_vacuum_analyze_frequency_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-vacuum-analyze-frequency-analysis.md |
| `PostgreSQL_vacuum_freeze_age_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-vacuum-freeze-age-analysis.md |
| `PostgreSQL_vacuum_progress_monitoring` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-vacuum-progress-monitoring.md |
| `PostgreSQL_verify_table_column_compression` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-verify-table-column-compression.md |
| `PostgreSQL_wait_events_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-wait-events-analysis.md |
| `PostgreSQL_wal_segment_recycling_analysis` | Read | Low | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-wal-segment-recycling-analysis.md |
| `PostgreSQL_create_index` | Write | Medium | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-create-index.md |
| `PostgreSQL_create_schema` | Write | Medium | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-create-schema.md |
| `PostgreSQL_create_table` | Write | Medium | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-create-table.md |
| `PostgreSQL_create_user` | Write | Medium | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-create-user.md |
| `PostgreSQL_grant_privileges` | Write | Medium | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-grant-privileges.md |
| `PostgreSQL_reset_sequence` | Write | Medium | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-reset-sequence.md |
| `PostgreSQL_revoke_privileges` | Write | Medium | https://policylayer.com/tools/mukul975-postgres-mcp-server/postgresql-revoke-privileges.md |

## Tool descriptions

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

## Related servers

- UnClick (1662 tools) — https://policylayer.com/tools/io-github-malamutemayhem-unclick-mcp-server.md
- Delx Protocol — Agent Recovery & Continuity (1076 tools) — https://policylayer.com/tools/io-github-davidmosiah-delx-protocol.md
- Delx Mcp A2a (1068 tools) — https://policylayer.com/tools/io-github-davidmosiah-delx-mcp-a2a.md
- Nodebench (824 tools) — https://policylayer.com/tools/io-github-homenshum-nodebench.md
- MCP Framework Personal (811 tools) — https://policylayer.com/tools/inggerman-mcps.md
- Delx MCP Server (740 tools) — https://policylayer.com/tools/io-github-davidmosiah-delx-mcp-server.md
- Binance MCP Server (734 tools) — https://policylayer.com/tools/nirholas-binance-mcp.md
- Eda Agent (726 tools) — https://policylayer.com/tools/eda-agent.md

## For agents

This record is a snapshot. Live verdicts and the full registry:

- Check every server in your MCP config at once: `npx -y policylayer stack`
- Vet a server before you add it: install the mcp-precheck skill — `npx skills add https://policylayer.com` (skill text: https://policylayer.com/skill.md)
- Query the registry over MCP: endpoint `https://api.policylayer.com/mcp` — tools `check_mcp_server`, `check_mcp_stack`, `check_tool`, `search_registry`, `get_change_events`

---

Source: the PolicyLayer MCP registry — one continuously verified record per MCP server. Full record: https://policylayer.com/registry?q=mukul975-postgres-mcp-server · API: https://policylayer.com/registry/api · Recommended policies for every tool: https://policylayer.com/policies/mukul975-postgres-mcp-server