// SCAN REPORT

Mcpg

252 tools. 90 can modify or destroy data without limits.

9 destructive tools with no built-in limits. Policy required.

Last updated: 7 Jul 2026

90 can modify or destroy data

162 read-only

252 tools total

Community server · catalogue entry checked 07/07/2026

How to control Mcpg ↓

TOOL MAP

What Mcpg exposes to your agents

Read (162) Write / Execute (78) Destructive / Financial (9)

Running more than one server? Check your whole stack →

MOST DANGEROUS TOOLS

Critical Risk

The most dangerous Mcpg tools

Destructive · High cancel_migration Cancelling a migration could irreversibly halt a data migration operation, potentially leaving data in an inconsistent or partial state. Destructive · Critical drop_graph The name 'drop_graph' strongly indicates permanent removal of a graph object. Destructive · High drop_property_graph The 'drop' operation in PostgreSQL and most database systems irreversibly deletes objects and their data. Destructive · Critical drop_publication The tool name 'drop_publication' directly indicates deletion of a database publication object.

90 of Mcpg's 252 tools can modify, destroy, or commit something on every call — and an agent calls them with no built-in limits.

POLICY

How to control Mcpg

PolicyLayer is an MCP gateway — it sits between your AI agents and Mcpg, and nothing reaches the server without passing your rules. These are the rules we recommend:

Deny destructive operations

{
  "cancel_migration": {
    "deny_if": [
      {
        "conditions": [],
        "on_deny": "Blocked by default. Requires approval."
      }
    ]
  }
}

Destructive tools should never be available to autonomous agents without human approval.

Rate limit write operations

{
  "add_compression_policy": {
    "limits": [
      {
        "counter": "add_compression_policy_per_hour",
        "window": "hour",
        "max": 30,
        "scope": "grant"
      }
    ]
  }
}

Prevents bulk unintended modifications from agents caught in loops.

Cap read operations

{
  "analyze_distance_metric": {
    "limits": [
      {
        "counter": "analyze_distance_metric_per_minute",
        "window": "minute",
        "max": 60,
        "scope": "grant"
      }
    ]
  }
}

Controls API costs and prevents retry loops from exhausting upstream rate limits.

Create a free account and register Mcpg — nothing to install.
Add these rules — paste them, or build them visually. Tune the limits to your setup.
Point your MCP client (Claude, Cursor, anything) at your gateway URL.

ENFORCE POLICY ON MCPG →

Instant setup, no code required.

FULL CATALOGUE

All 252 Mcpg tools

DESTRUCTIVE 9 tools

Destructive cancel_migration cancel_migration Destructive drop_graph drop_graph Destructive drop_property_graph drop_property_graph Destructive drop_publication drop_publication Destructive drop_subscription drop_subscription Destructive dump_database dump_database Destructive partman_drop_partition partman_drop_partition Destructive prune_audit_events prune_audit_events Destructive restore_database restore_database

EXECUTE 39 tools

Execute cancel_query cancel_query Execute cluster_vectors cluster_vectors Execute complete_migration complete_migration Execute dry_run_ddl dry_run_ddl Execute enable_extension enable_extension Execute enable_logical_replication_on_demand enable_logical_replication_on_demand Execute enable_redis_fdw enable_redis_fdw Execute generate_graph_projection generate_graph_projection Execute generate_test_data generate_test_data Execute hybrid_search hybrid_search Execute maintain_turboquant_index maintain_turboquant_index Execute mmr_search mmr_search Execute open_cursor open_cursor Execute optimize_query optimize_query Execute partman_run_maintenance partman_run_maintenance Execute pg_search_run pg_search_run Execute prepare_migration prepare_migration Execute prewarm_recommended prewarm_recommended Execute prewarm_relation prewarm_relation Execute recommend_redistribute recommend_redistribute Execute reindex_pg_search_index reindex_pg_search_index Execute reindex_turboquant_index reindex_turboquant_index Execute repack_table repack_table Execute run_advisors run_advisors Execute run_cypher run_cypher Execute run_ddl run_ddl Execute run_maintenance run_maintenance Execute run_pgq run_pgq Execute run_select_parallel run_select_parallel Execute run_select_tuned run_select_tuned Execute schedule_autowarm schedule_autowarm Execute schedule_cron_job schedule_cron_job Execute schedule_logical_backup schedule_logical_backup Execute test_rls_for_role test_rls_for_role Execute translate_nl_to_sql translate_nl_to_sql Execute tune_vector_index tune_vector_index Execute validate_migration validate_migration Execute validate_migration_schema validate_migration_schema Execute wait_for_lsn wait_for_lsn

WRITE 39 tools

Write add_compression_policy add_compression_policy Write add_retention_policy add_retention_policy Write close_cursor close_cursor Write copy_table_between_databases copy_table_between_databases Write create_graph create_graph Write create_hypertable create_hypertable Write create_pg_search_index create_pg_search_index Write create_property_graph create_property_graph Write create_publication create_publication Write create_redis_cache_server create_redis_cache_server Write create_redis_cache_table create_redis_cache_table Write create_redis_user_mapping create_redis_user_mapping Write create_subscription create_subscription Write create_turboquant_index create_turboquant_index Write disable_data_checksums disable_data_checksums Write enable_data_checksums enable_data_checksums Write export_query export_query Write export_table export_table Write generate_drizzle_schema generate_drizzle_schema Write generate_ecto_schemas generate_ecto_schemas Write generate_ent_schemas generate_ent_schemas Write generate_graph_diagram generate_graph_diagram Write generate_jooq_config generate_jooq_config Write generate_prisma_schema generate_prisma_schema Write generate_sqlalchemy_models generate_sqlalchemy_models Write generate_sqlc_schema generate_sqlc_schema Write generate_test_row_for generate_test_row_for Write import_csv import_csv Write import_json import_json Write import_vectors import_vectors Write log_rerank_event log_rerank_event Write merge_partitions merge_partitions Write migrate_vector_to_halfvec migrate_vector_to_halfvec Write partman_create_parent partman_create_parent Write record_efficiency_observation record_efficiency_observation Write run_write run_write Write seed_table_with_sample_data seed_table_with_sample_data Write setup_rag_telemetry setup_rag_telemetry Write terminate_backend terminate_backend

READ 162 tools

Read analyze_distance_metric analyze_distance_metric Read analyze_hnsw_recall analyze_hnsw_recall Read analyze_lock_hotspots analyze_lock_hotspots Read analyze_mpp_query_plan analyze_mpp_query_plan Read analyze_query_plan analyze_query_plan Read analyze_rerank_ndcg analyze_rerank_ndcg Read analyze_rerank_score_distribution analyze_rerank_score_distribution Read analyze_reranker_lift analyze_reranker_lift Read analyze_session_cost analyze_session_cost Read analyze_table_bloat analyze_table_bloat Read analyze_topk_stability analyze_topk_stability Read analyze_vector_search_efficiency analyze_vector_search_efficiency Read analyze_workload analyze_workload Read audit_database audit_database Read audit_sequences audit_sequences Read audit_settings audit_settings Read check_database_health check_database_health Read check_pitr_readiness check_pitr_readiness Read check_segment_health check_segment_health Read compare_schemas compare_schemas Read cross_table_similarity cross_table_similarity Read describe_ao_table describe_ao_table Read describe_graph describe_graph Read describe_property_graph describe_property_graph Read describe_redis_cache_table describe_redis_cache_table Read describe_self describe_self Read describe_table describe_table Read describe_tool describe_tool Read detect_n_plus_one detect_n_plus_one Read detect_vector_outliers detect_vector_outliers Read explain_query explain_query Read fetch_cursor fetch_cursor Read find_blocking_chains find_blocking_chains Read find_sensitive_columns find_sensitive_columns Read find_unused_objects find_unused_objects Read full_text_search full_text_search Read fuzzy_search fuzzy_search Read generate_diesel_schema generate_diesel_schema Read generate_fk_cascade_graph generate_fk_cascade_graph Read generate_schema_diagram generate_schema_diagram Read generate_schema_docs generate_schema_docs Read geo_search geo_search Read get_aio_status get_aio_status Read get_compact_schema get_compact_schema Read get_current_wal_lsn get_current_wal_lsn Read get_data_checksums_status get_data_checksums_status Read get_database_ddl get_database_ddl Read get_logical_replication_status get_logical_replication_status Read get_metrics_exposition get_metrics_exposition Read get_pg_search_index_metadata get_pg_search_index_metadata Read get_pg19_ddl_status get_pg19_ddl_status Read get_pg19_partitions_status get_pg19_partitions_status Read get_pg19_stats_status get_pg19_stats_status Read get_pgq_status get_pgq_status Read get_prewarm_extension_status get_prewarm_extension_status Read get_redis_cache_stats get_redis_cache_stats Read get_repack_status get_repack_status Read get_role_ddl get_role_ddl Read get_server_info get_server_info Read get_skip_scan_status get_skip_scan_status Read get_tablespace_ddl get_tablespace_ddl Read get_turboquant_heap_stats get_turboquant_heap_stats Read get_turboquant_index_metadata get_turboquant_index_metadata Read get_turboquant_last_scan_stats get_turboquant_last_scan_stats Read get_wait_for_lsn_status get_wait_for_lsn_status Read get_wal_archive_status get_wal_archive_status Read get_warehousepg_status get_warehousepg_status Read hybrid_bm25_vector_search hybrid_bm25_vector_search Read lint_naming_conventions lint_naming_conventions Read list_active_queries list_active_queries Read list_audit_events list_audit_events Read list_autowarm_jobs list_autowarm_jobs Read list_available_extensions list_available_extensions Read list_chunks list_chunks Read list_composite_types list_composite_types Read list_constraints list_constraints Read list_cron_jobs list_cron_jobs Read list_cursors list_cursors Read list_databases list_databases Read list_distribution_policies list_distribution_policies Read list_domains list_domains Read list_enums list_enums Read list_extensions list_extensions Read list_foreign_data_wrappers list_foreign_data_wrappers Read list_foreign_keys list_foreign_keys Read list_foreign_servers list_foreign_servers Read list_foreign_tables list_foreign_tables Read list_functions list_functions Read list_generated_columns list_generated_columns Read list_grants list_grants Read list_graphs list_graphs Read list_hypertables list_hypertables Read list_indexes list_indexes Read list_locks list_locks Read list_notification_subscriptions list_notification_subscriptions Read list_partitions list_partitions Read list_pending_migrations list_pending_migrations Read list_pg_search_indexes list_pg_search_indexes Read list_policies list_policies Read list_prewarmed_relations list_prewarmed_relations Read list_property_graphs list_property_graphs Read list_publications list_publications Read list_redis_foreign_servers list_redis_foreign_servers Read list_replicas list_replicas Read list_resource_groups list_resource_groups Read list_roles list_roles Read list_schemas list_schemas Read list_sequences list_sequences Read list_subscriptions List logical-replication subscriptions; requires superuser to see any rows. Read list_tables list_tables Read list_triggers list_triggers Read list_turboquant_indexes list_turboquant_indexes Read list_unapplied_migration_scripts list_unapplied_migration_scripts Read list_user_mappings list_user_mappings Read list_views list_views Read monitor_embedding_drift monitor_embedding_drift Read monitor_index_build monitor_index_build Read pg_search_more_like_this pg_search_more_like_this Read pg_search_parse_query pg_search_parse_query Read poll_notifications poll_notifications Read read_autovacuum_priority read_autovacuum_priority Read read_migration_history read_migration_history Read read_pg_buffercache_relations read_pg_buffercache_relations Read read_pg_buffercache_summary read_pg_buffercache_summary Read read_pg_stat_io read_pg_stat_io Read read_pg_stat_lock read_pg_stat_lock Read read_pg_stat_recovery read_pg_stat_recovery Read read_pg_wal_records read_pg_wal_records Read read_pg_wal_stats read_pg_wal_stats Read recommend_efficiency_thresholds recommend_efficiency_thresholds Read recommend_headline_tools recommend_headline_tools Read recommend_hnsw_ef_search recommend_hnsw_ef_search Read recommend_index_drops recommend_index_drops Read recommend_indexes recommend_indexes Read recommend_io_method recommend_io_method Read recommend_ivfflat_probes recommend_ivfflat_probes Read recommend_pg_search_maintenance recommend_pg_search_maintenance Read recommend_postgres_conf recommend_postgres_conf Read recommend_prewarm_targets recommend_prewarm_targets Read recommend_read_your_writes recommend_read_your_writes Read recommend_redis_cache_targets recommend_redis_cache_targets Read recommend_rerank_strategy recommend_rerank_strategy Read recommend_skip_scan_indexes recommend_skip_scan_indexes Read recommend_turboquant_maintenance recommend_turboquant_maintenance Read recommend_turboquant_query_knobs recommend_turboquant_query_knobs Read recommend_vector_quantization recommend_vector_quantization Read retrieve_with_context retrieve_with_context Read run_select run_select Read split_partition split_partition Read summarize_table summarize_table Read turboquant_approx_candidates turboquant_approx_candidates Read turboquant_rerank_candidates turboquant_rerank_candidates Read unschedule_autowarm unschedule_autowarm Read unschedule_cron_job unschedule_cron_job Read validate_check_constraint validate_check_constraint Read vector_range_search vector_range_search Read vector_recall_at_k vector_recall_at_k Read vector_search vector_search Read verify_audit_chain verify_audit_chain Read verify_connection_encryption verify_connection_encryption Read walk_blocking_chains walk_blocking_chains Read why_is_this_slow why_is_this_slow

OTHER 3 tools

Other setup_efficiency_observations setup_efficiency_observations Other subscribe_channel subscribe_channel Other unsubscribe_channel unsubscribe_channel

EXPLORE

Related servers

Other MCP servers with similar tools — same risk classification, starter policies for each.

FAQ

Questions about Mcpg

Can an AI agent delete data through the Mcpg MCP server? +

Yes. The Mcpg server exposes 9 destructive tools including cancel_migration, drop_graph, drop_property_graph. These permanently remove resources with no undo. PolicyLayer blocks destructive tools by default so they never reach the upstream server.

How do I prevent bulk modifications through Mcpg? +

The Mcpg server has 39 write tools including add_compression_policy, add_retention_policy, close_cursor. Set a rate limit in your policy -- for example, 10 calls per hour prevents an agent from making more than 10 modifications per hour. PolicyLayer enforces this at the gateway, before calls reach Mcpg.

How many tools does the Mcpg MCP server expose? +

252 tools across 4 categories: Destructive, Execute, Read, Write. 162 are read-only. 90 can modify, create, or delete data.

How do I enforce a policy on Mcpg? +

Register the Mcpg MCP server in PolicyLayer, apply the suggested rules above (adjust the limits to your use case), and point your AI client at the PolicyLayer proxy URL instead of the server directly. Your agents keep the same tools; PolicyLayer evaluates every call against policy before it executes. Nothing to install, live in minutes.

Enforce policy on every Mcpg tool call.

Deterministic rules across all 252 Mcpg tools. Per-identity grants. Full audit log. Live in minutes. Nothing to install.

ENFORCE POLICY ON MCPG →

Instant setup, no code required.

252 Mcpg tools catalogued and risk-classified — across an index of 46,500+ MCP servers.

// WHERE THIS COMES FROM

These policies come from Mcpg's registry record.

The record behind this page: verified identity, auth posture, risk grade, every tool classified, recommended policy — re-checked continuously.

Teams ship this data inside their own products. See what a licence covers →