// SCAN REPORT

Mysql

233 tools. 55 can modify or destroy data without limits.

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

Last updated: 12 Jun 2026

55 can modify or destroy data

178 read-only

233 tools total

Community server · catalogue entry verified 12/06/2026

How to control Mysql ↓

TOOL MAP

What Mysql exposes to your agents

Read (178) Write / Execute (37) Destructive / Financial (18)

Running more than one server? Check your whole stack →

MOST DANGEROUS TOOLS

Critical Risk

The most dangerous Mysql tools

Destructive · High drop_event The tool performs irreversible deletion of a scheduled event, which cannot be undone without manual recovery procedures. Destructive · High drop_partition Dropping a partition removes data and structural elements from a table in an irreversible manner. Destructive · High drop_role Dropping a role removes permissions and access controls irreversibly. Destructive · High drop_stored_function Dropping a stored function permanently removes it from the database and cannot be undone without a backup restore.

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

POLICY

How to control Mysql

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

Deny destructive operations

{
  "drop_event": {
    "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

{
  "revoke_role_from_user": {
    "limits": [
      {
        "counter": "revoke_role_from_user_per_hour",
        "window": "hour",
        "max": 30,
        "scope": "grant"
      }
    ]
  }
}

Prevents bulk unintended modifications from agents caught in loops.

Cap read operations

{
  "mysql_comprehensive_performance_summary": {
    "limits": [
      {
        "counter": "mysql_comprehensive_performance_summary_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 Mysql — 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 MYSQL →

Free to start. No card required.

FULL CATALOGUE

All 233 Mysql tools

DESTRUCTIVE 18 tools

EXECUTE 14 tools

Execute mysql_analyze_table Analyze a table to update key distribution statistics. Execute mysql_auto_index_rebuild_scheduler Automatically schedule index rebuilds based on usage patterns. Execute mysql_flush_logs Flush MySQL logs. Execute mysql_flush_privileges Flush MySQL privileges to reload grant tables. Execute mysql_flush_tables Flush MySQL tables. Execute mysql_optimize_table Optimize a table to reclaim unused space and defragment. Execute mysql_repair_table Repair a possibly corrupted table. Execute mysql_use_database Switch to a different database. Execute rebuild_table_indexes Rebuild all indexes for a table. Execute create_event Create a scheduled event. Execute create_stored_procedure Create a stored procedure. Execute mysql_lock_tables Lock tables for the current session. Execute mysql_set_variable Set a MySQL variable. Execute mysql_unlock_tables Unlock all tables for the current session.

WRITE 23 tools

Write revoke_role_from_user Revoke a role from a user (MySQL 8.0+). Write grant_role_to_user Grant a role to a user (MySQL 8.0+). Write mysql_change_user_password Change password for a MySQL user. Write mysql_grant_privileges mysql_grant_privileges Write add_partition Add a partition to a table. Write alter_event Alter a scheduled event. Write create_function create_function Write create_role Create a new role (MySQL 8.0+). Write create_user_with_ssl Create a user with SSL requirements. Write mysql_add_foreign_key mysql_add_foreign_key Write mysql_add_primary_key Add a primary key to a table. Write mysql_alter_table_add_column mysql_alter_table_add_column Write mysql_alter_table_modify_column Modify a column in an existing table. Write mysql_copy_table mysql_copy_table Write mysql_create_database Create a new MySQL database. Write mysql_create_index mysql_create_index Write mysql_create_table mysql_create_table Write mysql_create_user Create a new MySQL user. Write mysql_create_view Create a view in the database. Write mysql_insert_data Insert data into a table. Write mysql_rename_table Rename a table. Write mysql_server_health_dashboard Create a dashboard displaying server health metrics. Write mysql_update_data mysql_update_data

READ 178 tools

Read mysql_comprehensive_performance_summary Generate a comprehensive performance summary combining multiple metrics. Read mysql_diagnostics_info Run comprehensive diagnostics and retrieve aggregated info. Read mysql_multi_tenancy_performance_insights Insights and recommendations for multi-tenant databases. Read mysql_partition_performance_analysis Analyze partition performance and pruning effectiveness. Read mysql_performance_recommendations Generate performance recommendations based on current database state. Read mysql_performance_schema_setup_analysis Analyze Performance Schema configuration and instrumentation setup. Read mysql_trigger_list List triggers for database or specific table. Read analyze_index_usage Analyze index usage statistics. Read describe_table Describe table structure (same as SHOW COLUMNS). Read explain_table Explain table structure (alias for DESCRIBE). Read identify_redundant_indexes Identify potentially redundant indexes. Read list_events List all scheduled events in the database. Read list_mysql_tables List all tables in the current MySQL database. Read list_partitions List partitions for a partitioned table. Read list_stored_procedures List all stored procedures in the current database. Read mysql_adaptive_hash_index_analysis Analyze InnoDB Adaptive Hash Index usage and effectiveness. Read mysql_adaptive_index_fragmentation_analysis Performs an adaptive analysis of index fragmentation and provides recommendations. Read mysql_adaptive_index_improvements Suggest adaptive index improvements based on query patterns. Read mysql_advanced_deadlock_detection Enhanced detection and reporting of deadlock issues. Read mysql_audit_log_summary Summarize and detect anomalies within audit logs. Read mysql_audit_logs Show audit logs if enabled or recent security events. Read mysql_auto_increment_info Show auto-increment information for tables. Read mysql_backup_health_check Perform a health check of backup strategies and configurations. Read mysql_backup_info Get information about database backup status. Read mysql_backup_recovery_status Analyze backup and recovery configuration and status. Read mysql_binary_log_analysis Analyze binary log configuration, usage, and replication impact. Read mysql_binary_logs List binary log files and positions. Read mysql_buffer_pool_cache_diagnostics Detailed diagnostics for buffer pool and cache tuning. Read mysql_buffer_pool_hit_ratio Calculate and analyze InnoDB buffer pool hit ratio and efficiency. Read mysql_buffer_pool_statistics Display buffer pool and cache usage statistics. Read mysql_charset_collation Show available character sets and collations. Read mysql_check_table Check a table for errors. Read mysql_column_stats Get column statistics and data distribution. Read mysql_comprehensive_health_check Perform a comprehensive MySQL server health check and diagnostics. Read mysql_connection_audit_analysis Perform security audit of connections, users, and access patterns. Read mysql_connection_monitor Provide live monitoring of connections and resource usage. Read mysql_connection_statistics Analyze connection patterns and statistics. Read mysql_connection_thread_analysis Analyze connection threads and their resource usage. Read mysql_cross_database_fk_analysis Analyze foreign key issues across databases. Read mysql_databases List all databases accessible to the current user. Read mysql_deadlock_analysis Analyze recent deadlocks and lock contention patterns. Read mysql_deadlock_detection Detect and analyze table deadlocks. Read mysql_deadlock_scenario_reconstruction Reconstructs detailed scenarios of recent deadlocks. Read mysql_diagnostics_summary Provide detailed diagnostics combining multiple status metrics. Read mysql_dynamic_configuration_tuning Analyze and suggest dynamic configuration changes. Read mysql_engine_status Show storage engine status information. Read mysql_event_scheduler Show scheduled events information. Read mysql_event_scheduler_analysis Analyze MySQL Event Scheduler status, events, and execution history. Read mysql_explain_query Analyze query execution plan. Read mysql_foreign_key_dependency_analysis Analyze foreign key dependencies and referential integrity. Read mysql_fragmentation_analysis Show table and index fragmentation analysis. Read mysql_fragmentation_extensive_analysis Provide a detailed analysis and defragmentation recommendations for tables. Read mysql_fulltext_indexes List full-text search indexes. Read mysql_grants_for_entities Show grants assigned to roles and users. Read mysql_historical_slow_query_analysis Analyze and aggregate historical slow query patterns. Read mysql_index_optimization_suggestions Suggest optimal indexing strategies and potential consolidations. Read mysql_index_usage_effectiveness Analyze index usage effectiveness and identify unused indexes. Read mysql_index_usage_statistics Provide index usage statistics and suggestions for optimization. Read mysql_innodb_buffer_pool_analysis Detailed analysis of InnoDB buffer pool performance. Read mysql_innodb_metrics_analysis Deep analysis of InnoDB metrics for performance tuning. Read mysql_innodb_metrics_deep_analysis Analyze InnoDB performance metrics and counters. Read mysql_io_statistics Show I/O statistics for tables and indexes. Read mysql_io_statistics_analysis Analyze MySQL I/O statistics and disk usage patterns. Read mysql_json_validation Validate JSON columns and data. Read mysql_key_cache_status Show key cache status and statistics. Read mysql_list_open_transactions List current open transactions and their states. Read mysql_memory_usage Show memory usage by database objects. Read mysql_memory_usage_breakdown Provide detailed breakdown of MySQL memory usage by component. Read mysql_memory_usage_by_thread Analyze memory usage by thread for performance optimization. Read mysql_optimizer_statistics_analysis Analyze query optimizer statistics and histogram data. Read mysql_partition_info Show table partitioning information. Read mysql_partition_management_analysis Analyze table partitioning configuration and partition statistics. Read mysql_partition_management_recommendations Recommend partition management techniques. Read mysql_plugin_and_components_status Show status of MySQL plugins and components. Read mysql_privileges_security_audit Audit user privileges and recommend policy improvements. Read mysql_process_list Show active MySQL connections and processes. Read mysql_query Execute read-only MySQL queries. Read mysql_query_analysis Comprehensive query analysis including execution plan and recommendations. Read mysql_query_cache_analysis Analyze query cache performance and configuration. Read mysql_query_cache_performance Analyze query cache hit ratio and efficiency metrics. Read mysql_query_cache_stats Show query cache statistics. Read mysql_query_digest_analysis Analyze query digest statistics for performance optimization. Read mysql_query_optimizer_analysis Analyze query execution plan and optimizer decisions. Read mysql_query_pattern_clustering Identifies clustered patterns and anomalies in query executions. Read mysql_real_time_query_perf_metrics Provide real-time metrics on query performance and bottlenecks. Read mysql_replication_binary_log_status Show replication and binary log status details. Read mysql_replication_lag_analysis Analyze replication lag and slave status for monitoring purposes. Read mysql_replication_lag_monitoring Monitor replication lag over a time series. Read mysql_replication_status Show MySQL replication status. Read mysql_resource_consumption_analysis Analyze resource consumption patterns by users, databases, and operations. Read mysql_roles_and_privileges List database roles and their privileges. Read mysql_running_events List all currently running events with schedules and status. Read mysql_schema_unused_indexes Identify unused indexes in the schema. Read mysql_search_tables Search for tables containing specific column names. Read mysql_security_audit Perform basic security audit of MySQL configuration and users. Read mysql_show_check_constraints Show CHECK constraints for a table. Read mysql_show_create_table Show the CREATE TABLE statement for a table. Read mysql_show_engines Show available storage engines. Read mysql_show_engines_status Show detailed status of all storage engines. Read mysql_show_error_log Read the MySQL error log file content. (Requires file access privileges) Read mysql_show_errors Show MySQL errors from the last statement. Read mysql_show_events List all scheduled events. Read mysql_show_foreign_keys Show foreign key constraints for a table. Read mysql_show_function_params Show parameters of a stored function. Read mysql_show_memory_status Show memory usage statistics. Read mysql_show_procedure_params Show parameters of a stored procedure. Read mysql_show_processlist Show the current process list. Read mysql_show_replication_status Show replication status including master and slave. Read mysql_show_schemas Show all available database schemas. Read mysql_show_slow_log Show recent entries from the slow query log. Read mysql_show_status Show MySQL server status variables. Read mysql_show_status_variables Show server status variables, optionally filtered by pattern. Read mysql_show_table_constraints Show constraints for a given table (primary keys, unique, foreign keys). Read mysql_show_table_engines Show available storage engines in the MySQL server. Read mysql_show_table_partitions Show partitioning information for a table if partitioned. Read mysql_show_table_triggers List triggers defined on a table. Read mysql_show_tables_information Show comprehensive information about all tables in current database. Read mysql_show_user_privileges Show privileges for a specific user. Read mysql_show_user_tables Show tables owned by the current MySQL user. Read mysql_show_users Show all MySQL users. Read mysql_show_variables Show server system variables, optionally filtered by pattern. Read mysql_show_variables_status Show all MySQL variables and status in one combined report. Read mysql_show_warnings Show MySQL warnings from the last statement. Read mysql_slow_queries Analyze slow query log entries. Read mysql_slow_query_analysis Analyze queries from the slow query log with summaries. Read mysql_ssl_connection_analysis Analyze SSL/TLS connection configuration and usage. Read mysql_ssl_encryption_status Analyze SSL/TLS encryption status and certificate information. Read mysql_ssl_tls_configuration_audit Audit and improve SSL/TLS security configurations. Read mysql_statistical_anomaly_detection Detect statistical anomalies in column distributions. Read mysql_stored_functions_procedures List all stored functions and procedures with metadata details. Read mysql_stored_procedures List stored procedures and functions. Read mysql_stored_views_info Display information about stored views in the database. Read mysql_table_compression_analysis Analyze table compression ratios and storage efficiency. Read mysql_table_constraints Show foreign key and check constraints for a table. Read mysql_table_data Fetch sample data from a MySQL table. Read mysql_table_dependencies Find foreign key dependencies between tables. Read mysql_table_fragmentation Analyze table fragmentation and suggest optimization. Read mysql_table_indexes Show all indexes for a specific table. Read mysql_table_locks Show current table locks and waiting processes. Read mysql_table_schema Get detailed schema information for a MySQL table. Read mysql_table_size Get storage size information for a table. Read mysql_table_space_analysis Analyze tablespace usage and file system layout. Read mysql_table_statistics Provide info about table statistics like row counts and sizes. Read mysql_table_status Get comprehensive status information for tables. Read mysql_tables_without_primary_keys List tables without primary keys and recommendations. Read mysql_temp_table_analysis Analyze temporary table usage and identify optimization opportunities. Read mysql_temp_table_usage Analyze MySQL thread pool status and performance metrics. Read mysql_triggers_by_event Show triggers grouped by event type or action. Read mysql_unused_duplicate_indexes Identify unused or duplicate indexes that could be dropped. Read mysql_user_activity_patterns Analyzes granular user activity and access patterns. Read mysql_user_privileges Show current user's privileges. Read mysql_user_statistics Show detailed user statistics like query counts and connection duration. Read mysql_variables Show MySQL system variables. Read show_binary_logs Show binary log files. Read show_character_sets Show available character sets. Read show_collations Show available collations. Read show_create_database Show the CREATE DATABASE statement for a database. Read show_create_table Show the CREATE TABLE statement for a table. Read show_events Show scheduled events in the database. Read show_function_status Show status of stored functions. Read show_global_variables Show global variables. Read show_grants_for_user Show grants for a specific user. Read show_master_status Show master status for replication. Read show_open_tables Show open tables in the table cache. Read show_procedure_status Show status of stored procedures. Read show_roles Show all roles in the database (MySQL 8.0+). Read show_session_variables Show session variables. Read show_slave_status Show slave status for replication. Read show_table_indexes Show all indexes for a specific table. Read show_table_status Show status information for tables. Read show_table_types Show available table types (storage engines). Read show_triggers Show triggers for a table or all triggers. Read mysql_charset_collation_analysis Analyze character set and collation usage across databases and tables. Read mysql_innodb_lock_analysis Analyze InnoDB redo log and undo log configuration and usage. Read mysql_innodb_lock_waits Show detailed InnoDB lock wait information. Read mysql_lock_contention Analyze lock contention and waits. Read mysql_lock_wait_analysis Analyzes historical and real-time lock wait scenarios. Read mysql_lock_wait_status Display status of locks and waits in the database.

EXPLORE

Related servers

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

FAQ

Questions about Mysql

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

Yes. The Mysql server exposes 18 destructive tools including drop_event, drop_partition, drop_role. 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 Mysql? +

The Mysql server has 23 write tools including revoke_role_from_user, grant_role_to_user, mysql_change_user_password. 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 Mysql.

How many tools does the Mysql MCP server expose? +

233 tools across 4 categories: Destructive, Execute, Read, Write. 178 are read-only. 55 can modify, create, or delete data.

How do I enforce a policy on Mysql? +

Register the Mysql 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 Mysql tool call.

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

ENFORCE POLICY ON MYSQL →

Free to start. No card required.

233 Mysql tools catalogued and risk-classified — across an index of 43,000+ MCP servers.