Tools

Comprehensive MySQL Toolset: Extensive Database Capabilities for AI

💎 Enterprise-Grade Value Proposition

• Optimize AI Context Windows: Consolidate complex database workflows using Code Mode to significantly improve token efficiency.
• Streamline Agent Deployments: Integrate AI safely using zero-trust telemetry and strict execution boundaries.
• Enable Autonomous Operations: Provide intelligent agents with granular, schema-enforced database capabilities.
• Scale Reliably: Support high-throughput agent concurrency with robust connection pooling.
• Secure Transactions: Protect your infrastructure with native OAuth 2.1 authentication and sandboxed execution.

---

Browse Core Database

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. aliases for data and conditions

---

Manage Schemas

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_list_constraints	List foreign keys and checks

---

Browse Transactions

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

---

Browse JSON Operations

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

---

Browse 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.

---

Browse 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

---

Browse 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

---

Browse 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

---

Browse 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

---

Browse Performance

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

---

Browse Optimization

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

---

Browse Admin

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. action required, audit default limit fixed
mysql_audit_search	Search and filter system audit logs. requires at least one filter

---

Browse 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. summary mode
mysql_security_sensitive_tables	Scan for sensitive table names
mysql_security_encryption_status	TDE/Encryption-at-rest status

---

Browse Roles

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

---

Browse 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. summary mode
mysql_replication_status	SHOW SLAVE STATUS
mysql_pool_stats	Connection pool statistics
mysql_server_health	Server health check

---

Browse sys Schema

Tool	Description
mysql_sys_user_summary	Resource usage by user. Safe parsing via Standard Schema
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
mysql_sys_memory_summary	Memory usage breakdown

---

Browse Backup

Tool	Description
mysql_export_table	Export table to SQL/CSV. limit parameter (default: 5)
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

---

Browse 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

---

Browse Cluster

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. summary mode
mysql_cluster_instances	List instance details
mysql_cluster_topology	View cluster topology map. offline instance visibility
mysql_cluster_router_status	Connected Routers. summary mode
mysql_cluster_switchover	Validates switchover readiness

---

Browse Partitioning

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

---

Browse Events

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

---

Browse MySQL Router

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. Params: summary, limit, compact
mysql_router_routes	List all configured routes. Params: summary, limit, compact
mysql_router_route_status	Get status of a specific route. Params: routeName, summary, limit, compact
mysql_router_route_health	Check health/liveness of a route. Params: routeName, summary, limit, compact
mysql_router_route_connections	List active connections on route. Params: routeName, summary, limit, compact
mysql_router_route_destinations	List backend MySQL server destinations. Params: routeName, summary, limit, compact
mysql_router_route_blocked_hosts	List blocked IP addresses for a route. Params: routeName, summary, limit, compact
mysql_router_metadata_status	InnoDB Cluster metadata cache status ⚠️ Params: metadataName (typically bootstrap), summary, limit, compact
mysql_router_pool_status	Connection pool statistics ⚠️ Params: poolName, summary, limit, compact

⚠️ = Requires InnoDB Cluster

---

Browse ProxySQL

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

Tool	Description
proxysql_status	Get ProxySQL version, uptime, and runtime stats. summary mode
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-*). limit, like params
proxysql_runtime_status	Get runtime configuration status. summary mode
proxysql_memory_stats	Get memory usage metrics. Added count field
proxysql_commands	Execute LOAD/SAVE admin commands
proxysql_process_list	Get active sessions

---

Browse MySQL Shell

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

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

---

Browse Vector

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

---

Browse Introspection

We provide pre-flight analysis, relationship mapping, and constraint validation tools 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

---

Browse Migration

We built an integrated schema versioning and deployment tracker 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

---

Review Code Mode

Execute JavaScript in a worker-thread sandbox 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. 70-90% token savings

---

Explore Related Topics

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

---

We generate this documentation automatically.