Tools

Curated Essential Showcase

Value Proposition Supercharge your AI agents with a comprehensive, token-optimized suite of core database operations. From complex JSON manipulations to advanced statistical analysis, these meticulously curated tools guarantee secure, context-aware, and highly efficient data interactions. 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).