# Mysql Mcp MCP server

Agent View of the PolicyLayer registry record for Mysql Mcp: identity, probed posture, risk grade, and all 223 tools classified. HTML page: https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp

## Facts

- Server id: `oci:docker.io/writenotenow/mysql-mcp:v1.0.0`
- Homepage: https://github.com/neverinfamous/mysql-mcp.git
- Registry record: grade F, identity unverified
- Lifecycle: active
- Rate-limited: no
- Tools: 223
- Tool categories present: Destructive, Execute, Read, Write
- Tags: io github neverinfamous mysql mcp, admin, automation
- Record last modified: 2026-06-28T21:38:45.686Z

## Tools (223)

| Tool | Category | Risk | Record |
| --- | --- | --- | --- |
| `mysql_audit_restore_backup` | Destructive | Critical | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-audit-restore-backup.md |
| `mysql_cascade_simulator` | Destructive | Critical | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-cascade-simulator.md |
| `mysql_doc_drop_collection` | Destructive | Critical | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-doc-drop-collection.md |
| `mysql_doc_remove` | Destructive | Critical | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-doc-remove.md |
| `mysql_drop_partition` | Destructive | Critical | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-drop-partition.md |
| `mysql_drop_schema` | Destructive | Critical | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-drop-schema.md |
| `mysql_drop_table` | Destructive | Critical | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-drop-table.md |
| `mysql_drop_view` | Destructive | Critical | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-drop-view.md |
| `mysql_event_drop` | Destructive | Critical | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-event-drop.md |
| `mysql_force_index` | Destructive | Critical | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-force-index.md |
| `mysql_fulltext_drop` | Destructive | Critical | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-fulltext-drop.md |
| `mysql_json_remove` | Destructive | Critical | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-remove.md |
| `mysql_migration_rollback` | Destructive | Critical | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-migration-rollback.md |
| `mysql_role_drop` | Destructive | Critical | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-role-drop.md |
| `mysql_analyze_table` | Execute | High | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-analyze-table.md |
| `mysql_create_dump` | Execute | High | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-create-dump.md |
| `mysql_event_create` | Execute | High | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-event-create.md |
| `mysql_flush_tables` | Execute | High | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-flush-tables.md |
| `mysql_json_merge` | Execute | High | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-merge.md |
| `mysql_migration_apply` | Execute | High | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-migration-apply.md |
| `mysql_optimize_table` | Execute | High | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-optimize-table.md |
| `mysql_spatial_intersection` | Execute | High | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-spatial-intersection.md |
| `mysql_spatial_transform` | Execute | High | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-spatial-transform.md |
| `mysql_stats_row_number` | Execute | High | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-row-number.md |
| `mysql_transaction_begin` | Execute | High | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-transaction-begin.md |
| `mysql_transaction_execute` | Execute | High | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-transaction-execute.md |
| `mysqlsh_run_script` | Execute | High | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysqlsh-run-script.md |
| `proxysql_commands` | Execute | High | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/proxysql-commands.md |
| `mysql_audit_diff_backup` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-audit-diff-backup.md |
| `mysql_audit_list_backups` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-audit-list-backups.md |
| `mysql_binlog_events` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-binlog-events.md |
| `mysql_buffer_pool_stats` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-buffer-pool-stats.md |
| `mysql_check_table` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-check-table.md |
| `mysql_cluster_instances` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-cluster-instances.md |
| `mysql_cluster_router_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-cluster-router-status.md |
| `mysql_cluster_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-cluster-status.md |
| `mysql_cluster_switchover` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-cluster-switchover.md |
| `mysql_cluster_topology` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-cluster-topology.md |
| `mysql_concat` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-concat.md |
| `mysql_constraint_analysis` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-constraint-analysis.md |
| `mysql_dependency_graph` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-dependency-graph.md |
| `mysql_describe_table` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-describe-table.md |
| `mysql_detect_bloat_risk` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-detect-bloat-risk.md |
| `mysql_detect_connection_spike` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-detect-connection-spike.md |
| `mysql_detect_query_anomalies` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-detect-query-anomalies.md |
| `mysql_doc_collection_info` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-doc-collection-info.md |
| `mysql_doc_find` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-doc-find.md |
| `mysql_doc_list_collections` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-doc-list-collections.md |
| `mysql_event_list` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-event-list.md |
| `mysql_event_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-event-status.md |
| `mysql_explain` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-explain.md |
| `mysql_explain_analyze` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-explain-analyze.md |
| `mysql_export_table` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-export-table.md |
| `mysql_fulltext_boolean` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-fulltext-boolean.md |
| `mysql_fulltext_expand` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-fulltext-expand.md |
| `mysql_fulltext_search` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-fulltext-search.md |
| `mysql_get_indexes` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-get-indexes.md |
| `mysql_gr_flow_control` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-gr-flow-control.md |
| `mysql_gr_members` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-gr-members.md |
| `mysql_gr_primary` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-gr-primary.md |
| `mysql_gr_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-gr-status.md |
| `mysql_gr_transactions` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-gr-transactions.md |
| `mysql_gtid_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-gtid-status.md |
| `mysql_index_recommendation` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-index-recommendation.md |
| `mysql_index_usage` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-index-usage.md |
| `mysql_innodb_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-innodb-status.md |
| `mysql_json_contains` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-contains.md |
| `mysql_json_diff` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-diff.md |
| `mysql_json_extract` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-extract.md |
| `mysql_json_get` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-get.md |
| `mysql_json_index_suggest` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-index-suggest.md |
| `mysql_json_keys` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-keys.md |
| `mysql_json_normalize` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-normalize.md |
| `mysql_json_search` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-search.md |
| `mysql_json_stats` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-stats.md |
| `mysql_json_validate` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-validate.md |
| `mysql_kill_query` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-kill-query.md |
| `mysql_like_search` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-like-search.md |
| `mysql_list_constraints` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-list-constraints.md |
| `mysql_list_events` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-list-events.md |
| `mysql_list_functions` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-list-functions.md |
| `mysql_list_schemas` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-list-schemas.md |
| `mysql_list_stored_procedures` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-list-stored-procedures.md |
| `mysql_list_tables` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-list-tables.md |
| `mysql_list_triggers` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-list-triggers.md |
| `mysql_list_views` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-list-views.md |
| `mysql_master_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-master-status.md |
| `mysql_migration_history` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-migration-history.md |
| `mysql_migration_risks` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-migration-risks.md |
| `mysql_migration_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-migration-status.md |
| `mysql_optimizer_trace` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-optimizer-trace.md |
| `mysql_partition_info` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-partition-info.md |
| `mysql_pool_stats` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-pool-stats.md |
| `mysql_query_rewrite` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-query-rewrite.md |
| `mysql_query_stats` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-query-stats.md |
| `mysql_read_query` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-read-query.md |
| `mysql_regexp_match` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-regexp-match.md |
| `mysql_reorganize_partition` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-reorganize-partition.md |
| `mysql_repair_table` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-repair-table.md |
| `mysql_replication_lag` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-replication-lag.md |
| `mysql_replication_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-replication-status.md |
| `mysql_role_grants` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-role-grants.md |
| `mysql_role_list` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-role-list.md |
| `mysql_router_metadata_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-router-metadata-status.md |
| `mysql_router_pool_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-router-pool-status.md |
| `mysql_router_route_blocked_hosts` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-router-route-blocked-hosts.md |
| `mysql_router_route_connections` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-router-route-connections.md |
| `mysql_router_route_destinations` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-router-route-destinations.md |
| `mysql_router_route_health` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-router-route-health.md |
| `mysql_router_route_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-router-route-status.md |
| `mysql_router_routes` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-router-routes.md |
| `mysql_router_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-router-status.md |
| `mysql_scheduler_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-scheduler-status.md |
| `mysql_schema_snapshot` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-schema-snapshot.md |
| `mysql_security_audit` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-security-audit.md |
| `mysql_security_encryption_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-security-encryption-status.md |
| `mysql_security_firewall_rules` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-security-firewall-rules.md |
| `mysql_security_firewall_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-security-firewall-status.md |
| `mysql_security_mask_data` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-security-mask-data.md |
| `mysql_security_password_validate` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-security-password-validate.md |
| `mysql_security_sensitive_tables` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-security-sensitive-tables.md |
| `mysql_security_ssl_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-security-ssl-status.md |
| `mysql_security_user_privileges` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-security-user-privileges.md |
| `mysql_server_health` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-server-health.md |
| `mysql_show_processlist` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-show-processlist.md |
| `mysql_show_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-show-status.md |
| `mysql_show_variables` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-show-variables.md |
| `mysql_slave_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-slave-status.md |
| `mysql_slow_queries` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-slow-queries.md |
| `mysql_soundex` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-soundex.md |
| `mysql_spatial_contains` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-spatial-contains.md |
| `mysql_spatial_distance` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-spatial-distance.md |
| `mysql_spatial_distance_sphere` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-spatial-distance-sphere.md |
| `mysql_spatial_geojson` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-spatial-geojson.md |
| `mysql_spatial_within` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-spatial-within.md |
| `mysql_stats_correlation` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-correlation.md |
| `mysql_stats_descriptive` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-descriptive.md |
| `mysql_stats_distinct` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-distinct.md |
| `mysql_stats_distribution` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-distribution.md |
| `mysql_stats_frequency` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-frequency.md |
| `mysql_stats_hypothesis` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-hypothesis.md |
| `mysql_stats_lag_lead` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-lag-lead.md |
| `mysql_stats_moving_avg` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-moving-avg.md |
| `mysql_stats_ntile` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-ntile.md |
| `mysql_stats_outliers` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-outliers.md |
| `mysql_stats_percentiles` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-percentiles.md |
| `mysql_stats_rank` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-rank.md |
| `mysql_stats_regression` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-regression.md |
| `mysql_stats_running_total` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-running-total.md |
| `mysql_stats_sampling` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-sampling.md |
| `mysql_stats_summary` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-summary.md |
| `mysql_stats_time_series` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-time-series.md |
| `mysql_stats_top_n` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-top-n.md |
| `mysql_substring` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-substring.md |
| `mysql_sys_host_summary` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-sys-host-summary.md |
| `mysql_sys_innodb_lock_waits` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-sys-innodb-lock-waits.md |
| `mysql_sys_io_summary` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-sys-io-summary.md |
| `mysql_sys_memory_summary` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-sys-memory-summary.md |
| `mysql_sys_schema_stats` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-sys-schema-stats.md |
| `mysql_sys_statement_summary` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-sys-statement-summary.md |
| `mysql_sys_user_summary` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-sys-user-summary.md |
| `mysql_sys_wait_summary` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-sys-wait-summary.md |
| `mysql_table_stats` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-table-stats.md |
| `mysql_thread_stats` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-thread-stats.md |
| `mysql_topological_sort` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-topological-sort.md |
| `mysql_transaction_release` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-transaction-release.md |
| `mysql_transaction_rollback` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-transaction-rollback.md |
| `mysql_transaction_rollback_to` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-transaction-rollback-to.md |
| `mysql_user_roles` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-user-roles.md |
| `mysqlsh_check_upgrade` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysqlsh-check-upgrade.md |
| `mysqlsh_dump_instance` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysqlsh-dump-instance.md |
| `mysqlsh_dump_schemas` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysqlsh-dump-schemas.md |
| `mysqlsh_dump_tables` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysqlsh-dump-tables.md |
| `mysqlsh_export_table` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysqlsh-export-table.md |
| `mysqlsh_version` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysqlsh-version.md |
| `proxysql_connection_pool` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/proxysql-connection-pool.md |
| `proxysql_global_variables` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/proxysql-global-variables.md |
| `proxysql_memory_stats` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/proxysql-memory-stats.md |
| `proxysql_process_list` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/proxysql-process-list.md |
| `proxysql_query_digest` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/proxysql-query-digest.md |
| `proxysql_query_rules` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/proxysql-query-rules.md |
| `proxysql_runtime_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/proxysql-runtime-status.md |
| `proxysql_servers` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/proxysql-servers.md |
| `proxysql_status` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/proxysql-status.md |
| `proxysql_users` | Read | Low | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/proxysql-users.md |
| `mysql_add_partition` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-add-partition.md |
| `mysql_append_insight` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-append-insight.md |
| `mysql_collation_convert` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-collation-convert.md |
| `mysql_create_index` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-create-index.md |
| `mysql_create_schema` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-create-schema.md |
| `mysql_create_table` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-create-table.md |
| `mysql_create_view` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-create-view.md |
| `mysql_doc_add` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-doc-add.md |
| `mysql_doc_create_collection` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-doc-create-collection.md |
| `mysql_doc_create_index` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-doc-create-index.md |
| `mysql_doc_modify` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-doc-modify.md |
| `mysql_event_alter` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-event-alter.md |
| `mysql_fulltext_create` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-fulltext-create.md |
| `mysql_import_data` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-import-data.md |
| `mysql_json_array_append` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-array-append.md |
| `mysql_json_insert` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-insert.md |
| `mysql_json_replace` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-replace.md |
| `mysql_json_set` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-set.md |
| `mysql_json_update` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-json-update.md |
| `mysql_migration_init` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-migration-init.md |
| `mysql_migration_record` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-migration-record.md |
| `mysql_restore_dump` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-restore-dump.md |
| `mysql_role_assign` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-role-assign.md |
| `mysql_role_create` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-role-create.md |
| `mysql_role_grant` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-role-grant.md |
| `mysql_role_revoke` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-role-revoke.md |
| `mysql_spatial_buffer` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-spatial-buffer.md |
| `mysql_spatial_create_column` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-spatial-create-column.md |
| `mysql_spatial_create_index` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-spatial-create-index.md |
| `mysql_spatial_point` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-spatial-point.md |
| `mysql_spatial_polygon` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-spatial-polygon.md |
| `mysql_stats_histogram` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-stats-histogram.md |
| `mysql_transaction_commit` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-transaction-commit.md |
| `mysql_transaction_savepoint` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-transaction-savepoint.md |
| `mysql_write_query` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysql-write-query.md |
| `mysqlsh_import_json` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysqlsh-import-json.md |
| `mysqlsh_import_table` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysqlsh-import-table.md |
| `mysqlsh_load_dump` | Write | Medium | https://policylayer.com/tools/io-github-neverinfamous-mysql-mcp/mysqlsh-load-dump.md |

## Tool descriptions

- `mysql_audit_restore_backup` — Restore a specific pre-mutation snapshot to the database.
- `mysql_cascade_simulator` — Simulate the impact of DELETE, DROP, or TRUNCATE on a table. Returns affected tables, estimated row counts, cascade paths, and severity assessment.
- `mysql_doc_drop_collection` — Drop a document collection.
- `mysql_doc_remove` — Remove documents from a collection.
- `mysql_drop_partition` — Drop a partition from a partitioned table. Warning: This deletes all data in the partition!
- `mysql_drop_schema` — Drop a database/schema. WARNING: This permanently deletes all data.
- `mysql_drop_table` — Drop (delete) a table from the database.
- `mysql_drop_view` — Drop a view.
- `mysql_event_drop` — Remove a scheduled event.
- `mysql_force_index` — Generate a query with FORCE INDEX hint.
- `mysql_fulltext_drop` — Drop a FULLTEXT index from a table.
- `mysql_json_remove` — Remove values from JSON columns at specified paths.
- `mysql_migration_rollback` — Roll back a specific migration by ID or version.
- `mysql_role_drop` — Drop a role.
- `mysql_analyze_table` — Analyze tables to update index statistics for the query optimizer.
- `mysql_create_dump` — Generate mysqldump command for backing up database.
- `mysql_event_create` — Create a scheduled event (one-time or recurring) to execute SQL at specified times.
- `mysql_flush_tables` — Flush tables to ensure data is written to disk.
- `mysql_json_merge` — Merge two JSON documents using JSON_MERGE_PATCH or JSON_MERGE_PRESERVE.
- `mysql_migration_apply` — Execute migration SQL and record it atomically. Note: MySQL DDL statements cannot be rolled back, they commit the current transaction.
- `mysql_optimize_table` — Optimize tables to reclaim unused space and defragment data.
- `mysql_spatial_intersection` — Calculate the intersection of two geometries.
- `mysql_spatial_transform` — Transform a geometry from one spatial reference system to another.
- `mysql_stats_row_number` — Assign sequential row numbers within an ordered result set. Use partitionBy to restart numbering per group.
- `mysql_transaction_begin` — Begin a new transaction with optional isolation level. Returns a transaction ID for subsequent operations.
- `mysql_transaction_execute` — Execute multiple SQL statements atomically. All statements succeed or all are rolled back.
- `mysqlsh_run_script` — Execute a JavaScript, Python, or SQL script via MySQL Shell. Provides access to X DevAPI, AdminAPI, and all MySQL Shell features.
- `proxysql_commands` — Execute ProxySQL admin commands like LOAD/SAVE for users, servers, query rules, and variables. Also supports FLUSH commands.
- `mysql_audit_diff_backup` — Compare a snapshot
- `mysql_audit_list_backups` — List available pre-mutation snapshots captured before destructive operations.
- `mysql_binlog_events` — View binary log events for point-in-time recovery or replication debugging.
- `mysql_buffer_pool_stats` — Get InnoDB buffer pool statistics.
- `mysql_check_table` — Check tables for errors.
- `mysql_cluster_instances` — List all instances in the InnoDB Cluster.
- `mysql_cluster_router_status` — Get status of MySQL Routers connected to the cluster.
- `mysql_cluster_status` — Get overall InnoDB Cluster status (requires mysql_innodb_cluster_metadata schema).
- `mysql_cluster_switchover` — Analyze cluster state and provide switchover recommendations.
- `mysql_cluster_topology` — Get a visual representation of the cluster topology.
- `mysql_concat` — Concatenate multiple columns with an optional separator.
- `mysql_constraint_analysis` — Analyze all constraints for issues: missing NOT NULL, missing primary keys.
- `mysql_dependency_graph` — Get the full foreign key dependency graph with cascade paths, row counts, circular dependency detection, and severity assessment. Agent-optimized structured output.
- `mysql_describe_table` — Get detailed information about a table
- `mysql_detect_bloat_risk` — Scores tables by bloat/fragmentation risk using information_schema DATA_FREE vs DATA_LENGTH metrics. Returns per-table risk scores (0-100) with recommendations.
- `mysql_detect_connection_spike` — Detects unusual connection patterns by analyzing concentration by user, host, and state. Flags when a single user monopolizes the pool or idle connections accumulate.
- `mysql_detect_query_anomalies` — Detects queries deviating from their historical execution time norms using MAX/AVG variance analysis. Requires performance_schema.
- `mysql_doc_collection_info` — Get collection statistics.
- `mysql_doc_find` — Query documents in a collection.
- `mysql_doc_list_collections` — List JSON document collections in a schema.
- `mysql_event_list` — List all scheduled events with status, schedule, and execution info.
- `mysql_event_status` — Get detailed status and execution history for a specific event.
- `mysql_explain` — Get query execution plan using EXPLAIN.
- `mysql_explain_analyze` — Get query execution plan with actual timing using EXPLAIN ANALYZE (MySQL 8.0+). Only TREE format is supported.
- `mysql_export_table` — Export table data as SQL INSERT statements or CSV format.
- `mysql_fulltext_boolean` — Perform FULLTEXT search in BOOLEAN MODE with operators (+, -, *, etc.).
- `mysql_fulltext_expand` — Perform FULLTEXT search WITH QUERY EXPANSION for finding related terms.
- `mysql_fulltext_search` — Perform FULLTEXT search with relevance ranking.
- `mysql_get_indexes` — Get all indexes for a table including type, columns, and cardinality.
- `mysql_gr_flow_control` — Get Group Replication flow control statistics and throttling info.
- `mysql_gr_members` — List all Group Replication members with detailed state information.
- `mysql_gr_primary` — Identify the current primary member in a single-primary GR cluster.
- `mysql_gr_status` — Get comprehensive Group Replication status including mode and member state.
- `mysql_gr_transactions` — Get Group Replication transaction statistics and pending transactions.
- `mysql_gtid_status` — Get Global Transaction ID (GTID) status for replication.
- `mysql_index_recommendation` — Analyze table and suggest potentially missing indexes based on query patterns.
- `mysql_index_usage` — Get index usage statistics from performance_schema.
- `mysql_innodb_status` — Get detailed InnoDB engine status. Defaults to parsed summary. Use summary=false for raw output.
- `mysql_json_contains` — Find rows where JSON column contains a specified value.
- `mysql_json_diff` — Compare two JSON documents and identify differences.
- `mysql_json_extract` — Extract values from JSON columns using JSON path expressions.
- `mysql_json_get` — Simple JSON value extraction by row ID.
- `mysql_json_index_suggest` — Suggest functional indexes for frequently accessed JSON paths.
- `mysql_json_keys` — Get the keys of a JSON object at the specified path.
- `mysql_json_normalize` — Normalize JSON column structure by extracting all unique keys across documents.
- `mysql_json_search` — Search for a string value in JSON columns and return matching paths.
- `mysql_json_stats` — Analyze statistics for a JSON column including depth, size, and key frequency.
- `mysql_json_validate` — Validate if a string is valid JSON.
- `mysql_kill_query` — Kill a running query or connection.
- `mysql_like_search` — Find rows using LIKE pattern matching with % and _ wildcards.
- `mysql_list_constraints` — List all constraints (primary key, foreign key, unique, check) for a table.
- `mysql_list_events` — List all scheduled events with execution status and schedule info.
- `mysql_list_functions` — List all user-defined functions with return types and metadata.
- `mysql_list_schemas` — List all databases/schemas with metadata including charset and collation.
- `mysql_list_stored_procedures` — List all stored procedures with parameters and metadata.
- `mysql_list_tables` — List all tables and views in the database with metadata.
- `mysql_list_triggers` — List all triggers with event timing, action, and definition.
- `mysql_list_views` — List all views with their definitions, security type, and check option.
- `mysql_master_status` — Get binary log position from master/source server.
- `mysql_migration_history` — Query migration history with optional filtering by status and source system.
- `mysql_migration_risks` — Analyze proposed DDL statements for risks: data loss, lock contention, constraint violations, and breaking changes. Pre-flight check before executing migrations.
- `mysql_migration_status` — Get current migration tracking status: latest version, counts by status,
- `mysql_optimizer_trace` — Get detailed optimizer trace for a query.
- `mysql_partition_info` — Get partition information for a table.
- `mysql_pool_stats` — Get connection pool statistics.
- `mysql_query_rewrite` — Analyze a query and suggest optimizations.
- `mysql_query_stats` — Get query statistics from performance_schema.
- `mysql_read_query` — Execute a read-only SQL query (SELECT). Uses prepared statements for safety.
- `mysql_regexp_match` — Find rows where column matches a regular expression pattern.
- `mysql_reorganize_partition` — Reorganize partitions by splitting or merging them.
- `mysql_repair_table` — Repair corrupted tables (MyISAM only).
- `mysql_replication_lag` — Calculate replication lag in seconds.
- `mysql_replication_status` — Show replication slave/replica status. Use summary=true for key metrics only.
- `mysql_role_grants` — List privileges granted to a role.
- `mysql_role_list` — List all roles defined in MySQL.
- `mysql_router_metadata_status` — Get InnoDB Cluster metadata cache status including refresh statistics and last refresh host.
- `mysql_router_pool_status` — Get MySQL Router connection pool status including idle and stashed server connections.
- `mysql_router_route_blocked_hosts` — List IP addresses that have been blocked for a route due to too many failed connection attempts.
- `mysql_router_route_connections` — List active connections on a route including source/destination addresses, bytes transferred, and connection times.
- `mysql_router_route_destinations` — List backend MySQL server destinations for a route. Shows address and port of each destination server.
- `mysql_router_route_health` — Check if a route is alive and functioning. Returns isAlive boolean indicating route health.
- `mysql_router_route_status` — Get operational status of a specific route including active connections, total connections, and blocked hosts count.
- `mysql_router_routes` — List all configured routes in MySQL Router. Returns route names that can be used with other router tools.
- `mysql_router_status` — Get MySQL Router process status including version, hostname, and uptime. Requires Router REST API access.
- `mysql_scheduler_status` — Get the global Event Scheduler status and event statistics.
- `mysql_schema_snapshot` — Get a complete schema snapshot in a single agent-optimized JSON structure. Includes tables, columns, constraints, indexes, views, routines, and triggers.
- `mysql_security_audit` — Query the MySQL audit log (requires Enterprise Audit or compatible plugin).
- `mysql_security_encryption_status` — Get Transparent Data Encryption (TDE) and keyring status.
- `mysql_security_firewall_rules` — List MySQL Enterprise Firewall allowlist rules.
- `mysql_security_firewall_status` — Get MySQL Enterprise Firewall plugin status.
- `mysql_security_mask_data` — Apply data masking to sensitive values (implementation for Community Edition).
- `mysql_security_password_validate` — Validate password strength using MySQL validate_password component.
- `mysql_security_sensitive_tables` — Identify tables and columns that may contain sensitive data.
- `mysql_security_ssl_status` — Get SSL/TLS connection and certificate status.
- `mysql_security_user_privileges` — Get comprehensive privilege report for users.
- `mysql_server_health` — Get comprehensive server health information.
- `mysql_show_processlist` — Show all running processes and queries.
- `mysql_show_status` — Show server status variables.
- `mysql_show_variables` — Show server configuration variables.
- `mysql_slave_status` — Get detailed replication slave/replica status.
- `mysql_slow_queries` — Get slow queries from performance_schema (if available).
- `mysql_soundex` — Find rows with phonetically similar values using SOUNDEX.
- `mysql_spatial_contains` — Find rows where the geometry is contained within a specified polygon.
- `mysql_spatial_distance` — Find rows within a certain distance from a point (Cartesian distance).
- `mysql_spatial_distance_sphere` — Calculate distance on a sphere (for geographic coordinates). Returns distance in meters.
- `mysql_spatial_geojson` — Convert geometry between WKT and GeoJSON formats.
- `mysql_spatial_within` — Find rows where the geometry is within a specified geometry.
- `mysql_stats_correlation` — Calculate Pearson correlation coefficient between two numeric columns.
- `mysql_stats_descriptive` — Calculate descriptive statistics (mean, median, stddev, min, max, count) for a numeric column.
- `mysql_stats_distinct` — Get distinct values from a column with count. Useful for understanding cardinality and unique value distribution.
- `mysql_stats_distribution` — Analyze the distribution of values in a column with histogram buckets.
- `mysql_stats_frequency` — Get value frequency distribution (count per unique value) ordered by frequency descending. Shows the most common values first.
- `mysql_stats_hypothesis` — Perform one-sample t-test or z-test against a hypothesized mean. For z-test, provide populationStdDev (sigma) for accurate results. Use groupBy to test each group separately.
- `mysql_stats_lag_lead` — Access data from previous (LAG) or next (LEAD) rows in an ordered set. Useful for comparisons, deltas, and change detection.
- `mysql_stats_moving_avg` — Calculate moving average (AVG OVER sliding window) for a numeric column. Specify windowSize for the number of preceding rows to include.
- `mysql_stats_ntile` — Divide ordered rows into N equal buckets (e.g., quartiles with buckets=4). Returns bucket assignment per row.
- `mysql_stats_outliers` — Detect statistical outliers in a numeric column using IQR (interquartile range) or Z-score method. IQR is robust against non-normal distributions.
- `mysql_stats_percentiles` — Calculate percentile values for a numeric column.
- `mysql_stats_rank` — Assign rank within an ordered result set. Supports rank (gaps), dense_rank (no gaps), and percent_rank (0-1). Use partitionBy to rank within groups.
- `mysql_stats_regression` — Perform simple linear regression analysis (y = mx + b) between two columns.
- `mysql_stats_running_total` — Calculate cumulative running total (SUM OVER) for a numeric column. Use partitionBy to reset total per group.
- `mysql_stats_sampling` — Get a random sample of rows from a table.
- `mysql_stats_summary` — Get summary statistics (count, avg, min, max, stddev) for multiple numeric columns. Defaults to all numeric columns if none specified.
- `mysql_stats_time_series` — Aggregate and analyze time series data with specified intervals.
- `mysql_stats_top_n` — Get the top N rows ranked by a column. Auto-excludes long-content columns (text, json, blob) from output unless selectColumns is specified.
- `mysql_substring` — Extract substrings from column values.
- `mysql_sys_host_summary` — Get connection and activity summary by host from sys schema.
- `mysql_sys_innodb_lock_waits` — Get current InnoDB lock contention information from sys schema.
- `mysql_sys_io_summary` — Get I/O usage summary by file, table, or global from sys schema.
- `mysql_sys_memory_summary` — Get memory usage summary by allocation type from sys schema.
- `mysql_sys_schema_stats` — Get aggregated statistics for a schema including tables, indexes, and auto-increment status.
- `mysql_sys_statement_summary` — Get statement execution statistics including latency and row counts from sys schema.
- `mysql_sys_user_summary` — Get user activity summary including statements, connections, and latency from sys schema.
- `mysql_sys_wait_summary` — Get wait event summary for performance analysis from sys schema.
- `mysql_table_stats` — Get detailed table statistics including size, rows, and engine info.
- `mysql_thread_stats` — Get thread activity statistics.
- `mysql_topological_sort` — Get tables in safe DDL execution order.
- `mysql_transaction_release` — Release a savepoint, removing it without rolling back.
- `mysql_transaction_rollback` — Rollback a transaction, undoing all changes.
- `mysql_transaction_rollback_to` — Rollback to a savepoint, undoing changes after that point.
- `mysql_user_roles` — List roles assigned to a user.
- `mysqlsh_check_upgrade` — Check MySQL server upgrade compatibility using util.checkForServerUpgrade(). Identifies potential issues before upgrading to a newer MySQL version.
- `mysqlsh_dump_instance` — Dump entire MySQL instance using util.dumpInstance(). Creates a compressed, parallel dump of all schemas (excluding system schemas). Ideal for full backups and migrations.
- `mysqlsh_dump_schemas` — Dump selected schemas using util.dumpSchemas(). Creates a compressed, parallel dump of specified schemas. Use for partial backups.
- `mysqlsh_dump_tables` — Dump specific tables using util.dumpTables(). Creates a compressed, parallel dump of specified tables from a schema.
- `mysqlsh_export_table` — Export a MySQL table to a file using util.exportTable(). Supports CSV and TSV formats with WHERE clause filtering.
- `mysqlsh_version` — Get MySQL Shell version and installation status. Useful for verifying MySQL Shell is available before running other shell tools.
- `proxysql_connection_pool` — Get connection pool statistics per backend server. Shows connections used/free, errors, queries, bytes transferred, and latency.
- `proxysql_global_variables` — Get ProxySQL global variables. Filter by prefix: mysql (MySQL proxy settings), admin (admin interface settings), or all. Use like parameter for pattern matching.
- `proxysql_memory_stats` — Get ProxySQL memory usage metrics from stats_memory_metrics. Shows memory for SQLite, auth, query digests, and more.
- `proxysql_process_list` — Get active client sessions similar to MySQL SHOW PROCESSLIST. Shows session ID, user, database, client/server hosts, and current command.
- `proxysql_query_digest` — Get query digest statistics showing top queries by execution count. Useful for identifying queries for routing, rewriting, or caching.
- `proxysql_query_rules` — List query routing rules from mysql_query_rules table. Shows rule IDs, match patterns, destination hostgroups, and cache settings.
- `proxysql_runtime_status` — Get ProxySQL runtime configuration status including version info and admin variables. Use summary: true for condensed key variables only.
- `proxysql_servers` — List configured backend MySQL servers from mysql_servers table. Shows hostgroup, hostname, port, status, and weights.
- `proxysql_status` — Get ProxySQL version, uptime, and runtime statistics. Returns global status variables from stats_mysql_global. Use summary: true for condensed key metrics.
- `proxysql_users` — List configured MySQL users from mysql_users table. Shows username, active status, default hostgroup, and connection limits. Passwords are redacted.
- `mysql_add_partition` — Add a new partition to a partitioned table.
- `mysql_append_insight` — Append a business insight to the in-memory insights memo. Insights are accessible via the mysql://insights resource. Use to record key findings during database analysis.
- `mysql_collation_convert` — Convert column values to a different character set or collation.
- `mysql_create_index` — Create an index on a table. Supports BTREE, HASH, FULLTEXT, and SPATIAL index types.
- `mysql_create_schema` — Create a new database/schema with specified charset and collation.
- `mysql_create_table` — Create a new table with specified columns, engine, and charset.
- `mysql_create_view` — Create or replace a view with specified algorithm and check option.
- `mysql_doc_add` — Add documents to a collection.
- `mysql_doc_create_collection` — Create a new JSON document collection.
- `mysql_doc_create_index` — Create an index on document fields.
- `mysql_doc_modify` — Update documents in a collection.
- `mysql_event_alter` — Modify an existing scheduled event schedule, body, or status.
- `mysql_fulltext_create` — Create a FULLTEXT index on specified columns for fast text search.
- `mysql_import_data` — Import data into a table from an array of row objects.
- `mysql_json_array_append` — Append a value to a JSON array at the specified path.
- `mysql_json_insert` — Insert values into JSON columns only if the path does not exist.
- `mysql_json_replace` — Replace values in JSON columns only if the path exists.
- `mysql_json_set` — Set or update values in JSON columns at specified paths.
- `mysql_json_update` — Simple JSON value update by row ID.
- `mysql_migration_init` — Initialize or verify the schema version tracking table (_mcp_schema_versions).
- `mysql_migration_record` — Record a migration in the schema version tracking table with status
- `mysql_restore_dump` — Generate command for restoring from mysqldump backup.
- `mysql_role_assign` — Assign a role to a user.
- `mysql_role_create` — Create a new role.
- `mysql_role_grant` — Grant privileges to a role.
- `mysql_role_revoke` — Revoke a role from a user, or privileges from a role.
- `mysql_spatial_buffer` — Create a buffer (expanded area) around a geometry.
- `mysql_spatial_create_column` — Add a geometry/spatial column to an existing table.
- `mysql_spatial_create_index` — Create a SPATIAL index on a geometry column for faster queries.
- `mysql_spatial_point` — Create a POINT geometry from longitude/latitude coordinates.
- `mysql_spatial_polygon` — Create a POLYGON geometry from coordinates.
- `mysql_stats_histogram` — View or update column histogram statistics (MySQL 8.0+).
- `mysql_transaction_commit` — Commit a transaction, making all changes permanent.
- `mysql_transaction_savepoint` — Create a savepoint within a transaction for partial rollback.
- `mysql_write_query` — Execute a write SQL query (INSERT, UPDATE, DELETE). Uses prepared statements for safety.
- `mysqlsh_import_json` — Import JSON documents from a file using util.importJson(). Supports NDJSON (one JSON object per line) and multi-line JSON objects (not JSON arrays). REQUIRES X Protocol (port 33060).
- `mysqlsh_import_table` — Parallel table import using util.importTable(). For CSV files, explicitly set fieldsTerminatedBy to
- `mysqlsh_load_dump` — Load a MySQL Shell dump using util.loadDump(). Restores data from a dump created by dumpInstance, dumpSchemas, or dumpTables. Supports parallel loading.

## Related servers

- UnClick (1658 tools) — https://policylayer.com/tools/io-github-malamutemayhem-unclick-mcp-server.md
- Nodebench (824 tools) — https://policylayer.com/tools/io-github-homenshum-nodebench.md
- Yaver (812 tools) — https://policylayer.com/tools/io-github-kivanccakmak-yaver.md
- Binance MCP Server (734 tools) — https://policylayer.com/tools/nirholas-binance-mcp.md
- Crow (587 tools) — https://policylayer.com/tools/kh0pper-crow.md
- Fortimanager (584 tools) — https://policylayer.com/tools/jmpijll-fortimanager-mcp.md
- TinyFn (572 tools) — https://policylayer.com/tools/io-tinyfn-tinyfn.md
- Mcp (571 tools) — https://policylayer.com/tools/io-github-2s-io-mcp.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=io-github-neverinfamous-mysql-mcp · API: https://policylayer.com/registry/api · Recommended policies for every tool: https://policylayer.com/policies/io-github-neverinfamous-mysql-mcp