Tools

Curated Essential Showcase

Value Proposition Drive autonomous workflows with secure, context-aware data operations. These curated tools are designed to minimize token overhead, empowering AI agents to accomplish database tasks with greater speed and reliability. Gain continuous insights with robust metrics and real-time observability. Read the full value proposition.

Note

Global Parameter Note: All tools support token-optimized payloads. They use optional summary, limit, and compact parameters where applicable.

Disclaimer: The tools listed on this page are non-exhaustive examples. To discover the complete tool catalog dynamically, leverage the mysql_tool_index prompt or query the native MCP resources (e.g., mysql://help/{group}).

---

Curated Presets

Leverage context-aware presets to instantly deploy highly specialized, precision toolchains tailored for complex database operations.

View Predefined Bundles in Tool Filtering

---

Core Data Operations

CLI Group: --tool-filter core Execute secure, high-performance data manipulation and schema queries with built-in parameterization and rigorous security controls.

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_index	Create an index on a table
mysql_create_table	Create a new table

---

Transactions

CLI Group: --tool-filter transactions Execute transactions including BEGIN, COMMIT, ROLLBACK, and savepoints.

Tool	Description
mysql_transaction_begin	Start a new transaction (BEGIN)
mysql_transaction_commit	Commit the current transaction
mysql_transaction_rollback	Rollback the current transaction
mysql_transaction_savepoint	Create or rollback to savepoints

---

JSON Operations

CLI Group: --tool-filter json Deeply integrate with MySQL's native JSON capabilities to read, mutate, and analyze documents with minimal overhead.

Tool	Description
mysql_json_extract	Extract data from JSON documents
mysql_json_set	Insert/update data in JSON documents
mysql_json_insert	Insert data into JSON documents
mysql_json_replace	Replace values in JSON documents
mysql_json_merge	Merge JSON documents
mysql_json_diff	Compute diff between JSON documents
mysql_json_stats	Generate statistics for JSON documents

---

Document Store Operations

CLI Group: --tool-filter docstore Deeply integrate with MySQL's native Document Store (X DevAPI) capabilities to manage schemaless JSON collections directly within the database engine.

Tool	Description
mysql_doc_find	Find documents in a collection
mysql_doc_add	Add documents to a collection
mysql_doc_modify	Modify documents in a collection
mysql_doc_remove	Remove documents from a collection
mysql_doc_create_collection	Create a new document collection
mysql_doc_drop_collection	Drop a document collection
mysql_doc_create_index	Create an index on a collection

---

Text Operations

CLI Group: --tool-filter text Perform highly efficient pattern matching and text operations directly within the database engine.

Tool	Description
mysql_regexp_match	Perform regular expression pattern matches
mysql_like_search	Perform LIKE pattern matching
mysql_soundex	Perform SOUNDEX string phonetic matching

---

Code Mode Sandbox

CLI Group: --tool-filter codemode Safely execute JavaScript in an isolated-vm V8 instance for improved token efficiency and security. Read Code Mode for API documentation.

Tool	Description
mysql_execute_code	Execute sandboxed JavaScript with access to all mysql.* APIs for optimized token efficiency.

---

Statistical Analysis

CLI Group: --tool-filter stats Execute robust statistical functions directly in-engine to compute aggregations, percentiles, correlation, and histograms with extreme token efficiency.

Tool	Description
mysql_stats_descriptive	Calculate standard descriptive statistics
mysql_stats_percentiles	Calculate percentiles and median
mysql_stats_correlation	Compute correlation and covariance
mysql_stats_distribution	Evaluate data distribution properties
mysql_stats_time_series	Perform time series analysis
mysql_stats_regression	Perform linear regression
mysql_stats_sampling	Extract statistical samples
mysql_stats_histogram	Generate data histograms
mysql_stats_row_number	Compute row numbers over partitions
mysql_stats_rank	Calculate rank and dense rank
mysql_stats_lag_lead	Access prior and subsequent row values
mysql_stats_running_total	Compute running totals
mysql_stats_moving_avg	Calculate moving averages
mysql_stats_ntile	Distribute rows into ordered groups
mysql_stats_hypothesis	Perform basic hypothesis testing
mysql_stats_outliers	Identify statistical outliers
mysql_stats_top_n	Extract top N records per group
mysql_stats_distinct	Advanced distinct value analysis
mysql_stats_frequency	Compute frequency distributions
mysql_stats_summary	Comprehensive statistical summary

---

Anomaly Detection

CLI Group: --tool-filter performance Automatically detect hidden patterns, bloated tables, and query bottlenecks before they impact performance.

Tool	Description
mysql_detect_query_anomalies	Identify execution plan outliers
mysql_detect_bloat_risk	Detect table fragmentation risks
mysql_detect_connection_spike	Analyze connection patterns

---

Performance Tuning

CLI Group: --tool-filter performance Proactively analyze query execution plans and optimize database performance to resolve bottlenecks faster.

Tool	Description
mysql_explain	Get the execution plan for a SQL statement

---

Query Optimization

CLI Group: --tool-filter optimization Apply index hints, run database-wide audits, and get EXPLAIN recommendations.

Tool	Description
mysql_optimizer_trace	Enable and retrieve optimizer trace data

---

Administrative Operations

CLI Group: --tool-filter admin Execute essential database administration tasks such as OPTIMIZE, ANALYZE, and CHECK to maintain database health.

Tool	Description
mysql_optimize_table	Optimize table storage space
mysql_analyze_table	Analyze and store key distribution
mysql_check_table	Check a table for errors

---

ProxySQL Operations

CLI Group: --tool-filter proxysql Dynamically control ProxySQL routing rules and connection pooling to ensure highly available, read-scaled AI workflows.

Tool	Description
proxysql_status	Retrieve global status variables
proxysql_process_list	Get active sessions
proxysql_query_rules	View configured query routing rules

Note

See the top of this page for dynamic tool discovery instructions.

---

Explore Related Topics

• Tool Filtering - Custom tool filtering
• Configuration - General configuration
• Database Resources - Database telemetry resources (MCP)

💡 Pro Tip: Use the mysql_tool_index prompt. It provides a compact categorization of all available tools, enabling discoverability of the complete toolset. (Note: this outputs a full structured markdown listing, not a query-based search).