Tools

Comprehensive MySQL Toolset: Extensive Database Capabilities for AI

Value Proposition Equip your AI agents with a comprehensive, schema-enforced suite of database tools. From core CRUD operations to complex administrative tasks, our toolset is secured by distributed rate limiting to safely scale your automated workflows. Read the full value proposition. 💡 Global Parameter Note: All tools support token-optimized payloads via optional summary, limit, and compact parameters where applicable.

---

Core Database Operations

Tool	Description
mysql_read_query	Execute SELECT with parameter binding
mysql_write_query	Execute INSERT/UPDATE/DELETE
mysql_list_tables	List tables with metadata
mysql_describe_table	Get column definitions
mysql_create_table	CREATE TABLE with engine/charset
mysql_drop_table	DROP TABLE with IF EXISTS
mysql_create_index	CREATE INDEX (BTREE, HASH, FULLTEXT)
mysql_get_indexes	SHOW INDEX FROM table
mysql_enable_versioning	Enable OCC on a table
mysql_disable_versioning	Disable OCC on a table
mysql_check_version	Get current _version of a row
mysql_conditional_update	Update row conditionally based on version.

Schema Management

Tool	Description
mysql_list_schemas	List databases/schemas
mysql_create_schema	CREATE DATABASE
mysql_drop_schema	DROP DATABASE
mysql_list_views	List views in schema
mysql_create_view	CREATE OR REPLACE VIEW
mysql_drop_view	DROP VIEW
mysql_list_stored_procedures	List stored procedures
mysql_list_functions	List stored functions
mysql_list_triggers	List triggers
mysql_create_trigger	CREATE TRIGGER
mysql_drop_trigger	DROP TRIGGER
mysql_list_constraints	List foreign keys and checks

Transaction Control

Tool	Description
mysql_transaction_begin	START TRANSACTION with isolation level
mysql_transaction_commit	COMMIT
mysql_transaction_rollback	ROLLBACK
mysql_transaction_savepoint	SAVEPOINT name
mysql_transaction_release	RELEASE SAVEPOINT
mysql_transaction_rollback_to	ROLLBACK TO SAVEPOINT
mysql_transaction_execute	Execute statements atomically

JSON & Document Processing

Tool	Description
mysql_json_extract	JSON_EXTRACT with path
mysql_json_set	JSON_SET to modify values
mysql_json_insert	JSON_INSERT (no overwrite)
mysql_json_replace	JSON_REPLACE (only existing)
mysql_json_remove	JSON_REMOVE paths
mysql_json_contains	JSON_CONTAINS for filtering
mysql_json_keys	JSON_KEYS to list object keys
mysql_json_array_append	JSON_ARRAY_APPEND
mysql_json_get	Simple JSON value extraction
mysql_json_update	Update JSON field by path
mysql_json_search	Search JSON for string value
mysql_json_validate	Validate JSON structure
mysql_json_merge	JSON_MERGE_PATCH / PRESERVE
mysql_json_diff	Compare two JSON documents
mysql_json_normalize	Normalize keys and formats
mysql_json_stats	Calculate depth, keys count, size
mysql_json_index_suggest	Suggest generated columns for indexing

Document Store

Treat MySQL like a NoSQL document database (requires Document Store support).

Tool	Description
mysql_doc_list_collections	List JSON collections
mysql_doc_create_collection	Create new collection
mysql_doc_drop_collection	Drop collection
mysql_doc_find	Find documents (NoSQL-style criteria)
mysql_doc_add	Add documents to collection
mysql_doc_modify	Modify documents matching criteria
mysql_doc_remove	Remove documents matching criteria
mysql_doc_create_index	Create index on JSON path
mysql_doc_collection_info	Get collection stats.

Text Processing

Tool	Description
mysql_regexp_match	REGEXP pattern matching
mysql_like_search	LIKE with wildcards
mysql_soundex	SOUNDEX phonetic matching
mysql_substring	SUBSTRING extraction
mysql_concat	String concatenation
mysql_collation_convert	Character set conversion

FULLTEXT Search

Tool	Description
mysql_fulltext_create	Create FULLTEXT index
mysql_fulltext_drop	Drop FULLTEXT index
mysql_fulltext_search	MATCH...AGAINST natural language
mysql_fulltext_boolean	Boolean mode search
mysql_fulltext_expand	WITH QUERY EXPANSION

Spatial / GIS

Tool	Description
mysql_spatial_create_column	Add POINT/POLYGON column with SRID
mysql_spatial_create_index	Create SPATIAL index
mysql_spatial_point	Create POINT from coords
mysql_spatial_polygon	Create POLYGON from points
mysql_spatial_distance	ST_Distance (Cartesian)
mysql_spatial_distance_sphere	ST_Distance_Sphere (Earth)
mysql_spatial_contains	ST_Contains check
mysql_spatial_within	ST_Within check
mysql_spatial_intersection	Get geometry intersection
mysql_spatial_buffer	Create buffer around geometry
mysql_spatial_transform	Transform SRID (CS conversion)
mysql_spatial_geojson	Import/Export GeoJSON

Statistics

Tool	Description
mysql_stats_descriptive	Mean, median, stddev, variance
mysql_stats_percentiles	Calculate percentiles (p50, p90, p99)
mysql_stats_correlation	Pearson correlation coefficient
mysql_stats_distribution	Frequency distribution
mysql_stats_time_series	Time-bucketed aggregation
mysql_stats_regression	Simple linear regression
mysql_stats_sampling	Random row sampling
mysql_stats_histogram	Generate histogram buckets
mysql_stats_row_number	ROW_NUMBER() window function
mysql_stats_rank	RANK()/DENSE_RANK() window function
mysql_stats_lag_lead	LAG()/LEAD() window function
mysql_stats_running_total	Running total window function
mysql_stats_moving_avg	Moving average window function
mysql_stats_ntile	NTILE() window function
mysql_stats_hypothesis	T-Test/Chi-Square hypothesis testing
mysql_stats_outliers	Z-Score/IQR outlier detection
mysql_stats_top_n	Top N items per category
mysql_stats_distinct	Count distinct values
mysql_stats_frequency	Value frequency and mode
mysql_stats_summary	Comprehensive numeric summary

Performance Monitoring

Tool	Description
mysql_explain	EXPLAIN query execution plan. JSON/TREE/TRADITIONAL formats
mysql_explain_analyze	EXPLAIN ANALYZE
mysql_slow_queries	Query slow query log
mysql_query_stats	Performance schema stats
mysql_index_usage	Index usage statistics
mysql_table_stats	Table statistics. Fast existence check
mysql_buffer_pool_stats	InnoDB buffer pool info
mysql_thread_stats	Thread activity stats
mysql_detect_query_anomalies	Detect unusual query execution patterns
mysql_detect_bloat_risk	Identify tables with high risk of fragmentation
mysql_detect_connection_spike	Detect connection pool anomalies

Optimization

Tool	Description
mysql_index_recommendation	Suggest missing indexes. queries, includeRedundant, includeUnindexed params. Allows database-wide index audit.
mysql_query_rewrite	Query optimization hints
mysql_force_index	Generate FORCE INDEX hints
mysql_optimizer_trace	View optimizer decisions

Database Administration

Tool	Description
mysql_optimize_table	OPTIMIZE TABLE
mysql_analyze_table	ANALYZE TABLE statistics
mysql_check_table	CHECK TABLE integrity
mysql_repair_table	REPAIR TABLE (MyISAM)
mysql_flush_tables	FLUSH TABLES
mysql_kill_query	KILL connection/query
mysql_append_insight	Append insight to log. Feeds the mysql://insights resource
mysql_server_config	Manage server configs.
mysql_audit_search	Search and filter system audit logs. Requires at least one filter.

Security

Tool	Description
mysql_security_audit	Audit user privileges and settings
mysql_security_firewall_status	Firewall status (Enterprise/MariaDB)
mysql_security_firewall_rules	List firewall rules
mysql_security_mask_data	Mask PII data patterns. Alias validation at MCP boundary.
mysql_security_password_validate	Check password strength policy
mysql_security_ssl_status	SSL/TLS connection status
mysql_security_user_privileges	List privileges for user
mysql_security_sensitive_tables	Scan for sensitive table names
mysql_security_encryption_status	TDE/Encryption-at-rest status

Role Management

MySQL Role Management

Tool	Description
mysql_role_list	List defined roles
mysql_role_create	CREATE ROLE
mysql_role_drop	DROP ROLE
mysql_role_grants	SHOW GRANTS FOR role
mysql_role_grant	GRANT privileges TO role
mysql_role_assign	GRANT role TO user
mysql_role_revoke	REVOKE role FROM user
mysql_user_roles	List active roles for user

Monitoring

Tool	Description
mysql_show_processlist	SHOW PROCESSLIST
mysql_show_status	SHOW STATUS variables
mysql_show_variables	SHOW VARIABLES
mysql_innodb_status	SHOW ENGINE INNODB STATUS
mysql_replication_status	SHOW SLAVE STATUS
mysql_pool_stats	Connection pool statistics
mysql_server_health	Server health check

System Schema Diagnostics

Tool	Description
mysql_sys_user_summary	Resource usage by user. Safe parsing via Standard Schema validation
mysql_sys_io_summary	I/O usage by thread/file
mysql_sys_statement_summary	Statement analysis
mysql_sys_wait_summary	Wait events analysis
mysql_sys_innodb_lock_waits	Blocked transactions info
mysql_sys_schema_stats	Table/index sizes and bloat
mysql_sys_host_summary	Metrics by source host. Safe parsing via Standard Schema validation
mysql_sys_memory_summary	Memory usage breakdown

Backup & Restore

Tool	Description
mysql_export_table	Export table to SQL/CSV
mysql_import_data	LOAD DATA INFILE
mysql_create_dump	mysqldump command generation
mysql_restore_dump	Restore from dump
mysql_audit_list_backups	List available snapshots
mysql_audit_restore_backup	Restore a snapshot
mysql_audit_diff_backup	Diff a snapshot

Replication

Tool	Description
mysql_master_status	SHOW MASTER STATUS
mysql_slave_status	SHOW SLAVE STATUS
mysql_binlog_events	SHOW BINLOG EVENTS
mysql_gtid_status	GTID_EXECUTED status
mysql_replication_lag	Calculate replication lag

InnoDB Cluster & Group Replication

Group Replication / InnoDB Cluster

Tool	Description
mysql_gr_status	Group Replication status
mysql_gr_members	List cluster members
mysql_gr_primary	Get/Set primary member
mysql_gr_transactions	Check distributed transactions
mysql_gr_flow_control	Tuning flow control
mysql_cluster_status	InnoDB Cluster overall status
mysql_cluster_instances	List instance details
mysql_cluster_topology	View cluster topology map. Includes offline instance visibility.
mysql_cluster_router_status	Connected Routers
mysql_cluster_switchover	Validates switchover readiness

Partition Management

Tool	Description
mysql_partition_info	Partition information
mysql_add_partition	ADD PARTITION
mysql_drop_partition	DROP PARTITION
mysql_reorganize_partition	REORGANIZE PARTITION

Event Scheduler

MySQL Event Scheduler

Tool	Description
mysql_event_create	CREATE EVENT
mysql_event_alter	ALTER EVENT
mysql_event_drop	DROP EVENT
mysql_event_list	SHOW EVENTS
mysql_event_status	Check event last run/status
mysql_scheduler_status	Check if scheduler is ON/OFF

MySQL Router Integration

Note: Requires MySQL Router with REST API enabled. For InnoDB Cluster deployments, the cluster must be running for REST API authentication. See MySQL-Router.

Tool	Description
mysql_router_status	Get Router process status and version.
mysql_router_routes	List all configured routes.
mysql_router_route_status	Get status of a specific route.
mysql_router_route_health	Check health/liveness of a route.
mysql_router_route_connections	List active connections on route.
mysql_router_route_destinations	List backend MySQL server destinations.
mysql_router_route_blocked_hosts	List blocked IP addresses for a route.
mysql_router_metadata_status	InnoDB Cluster metadata cache status ⚠️
mysql_router_pool_status	Connection pool statistics ⚠️
⚠️ = Requires InnoDB Cluster

---

ProxySQL Integration

Note: Requires access to ProxySQL admin interface. See ProxySQL.

Tool	Description
proxysql_status	Get ProxySQL version, uptime, and runtime stats
proxysql_servers	List configured backend MySQL servers
proxysql_query_rules	List query routing rules
proxysql_query_digest	Get query digest statistics (top queries)
proxysql_connection_pool	Get connection pool statistics per server
proxysql_users	List configured MySQL users
proxysql_global_variables	Get global variables (mysql-* and admin-*). like param
proxysql_runtime_status	Get runtime configuration status
proxysql_memory_stats	Get memory usage metrics.
proxysql_commands	Execute LOAD/SAVE admin commands
proxysql_process_list	Get active sessions

MySQL Shell Integration

Note: Requires MySQL Shell installed. See MySQL-Shell.

Tool	Description
mysqlsh_version	Get MySQL Shell version and installation status.
mysqlsh_check_upgrade	Check server upgrade compatibility.
mysqlsh_export_table	Export table to file (CSV, TSV).
mysqlsh_import_table	Parallel table import. updateServerSettings auto-enables local_infile.
mysqlsh_import_json	Import JSON documents to collection or table.
mysqlsh_dump_instance	Dump entire MySQL instance.
mysqlsh_dump_schemas	Dump selected schemas. ddlOnly dumps only DDL.
mysqlsh_dump_tables	Dump specific tables. all controls trigger inclusion.
mysqlsh_load_dump	Load MySQL Shell dump. updateServerSettings auto-enables local_infile.
mysqlsh_run_script	Execute JS/Python/SQL script via MySQL Shell.

---

Vector Search & Embeddings

Vector embeddings, KNN search, and hybrid search

Tool	Description
mysql_vector_store	Store a single vector embedding
mysql_vector_batch_store	Bulk insert vector embeddings
mysql_vector_delete	Delete a vector by primary key
mysql_vector_get	Retrieve a vector by primary key
mysql_vector_search	Top-k nearest neighbors (KNN) search
mysql_vector_range_search	Find all vectors within a distance threshold
mysql_vector_hybrid_search	Combine vector distance with FULLTEXT relevance using Reciprocal Rank Fusion. metric, rrfK, select, filter parameters
mysql_vector_info	View table vector columns and dimensions
mysql_vector_create_index	Create HNSW vector index
mysql_vector_optimize	Optimize vector index statistics
mysql_vector_stats	Get vector dimension, count, and distance statistics

Schema Introspection

Pre-flight analysis, relationship mapping, and constraint validation tools are provided to ensure safe schema modifications.

Tool	Description
mysql_dependency_graph	Generate a deep relationship graph of tables based on foreign keys
mysql_topological_sort	Determine exact creation/deletion order for foreign key constraints
mysql_cascade_simulator	Simulate cascading deletes/updates without actual data modification
mysql_schema_snapshot	Capture the state of the schema definition at a given point in time
mysql_constraint_analysis	Detect circular dependencies, missing indexes, and overlapping constraints
mysql_migration_risks	Run pre-flight checks on DDL to identify downtime or locking risks

Schema Migration

An integrated schema versioning and deployment tracker is built directly into the MCP server.

Tool	Description
mysql_migration_init	Set up migration tracking tables in the database
mysql_migration_record	Manually record an out-of-band migration to the history
mysql_migration_apply	Apply a single forward migration step
mysql_migration_rollback	Revert a recently applied migration
mysql_migration_history	View applied migrations history
mysql_migration_status	Check the current state of applied vs. pending migrations

Code Mode Sandbox

Execute JavaScript in a native isolated-vm V8 instance with access to all MySQL tools. Read Code-Mode for API documentation.

Tool	Description
mysql_execute_code	Execute code with access to all mysql.* APIs. Yields significant token savings.

Explore Related Topics

• Tool-Filtering - Reduce tool count for IDE limits
• Configuration - MCP client configuration

---

This documentation is generated automatically.