Tools

Optimize Operational Efficiency and Context Windows with MCP Tools

Value Proposition Execute secure, context-aware data operations. These tools minimize token overhead to enable agents to accomplish database tasks more efficiently. 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.

---

Curated Presets

Tool filters can use convenient, context-aware presets to instantly unlock specific groups of capabilities tailored for targeted execution.

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_begin_transaction	Start a new transaction (BEGIN)
mysql_commit	Commit the current transaction
mysql_rollback	Rollback the current transaction
mysql_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 validate 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

---

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 code with access to all mysql.* APIs. Yields token savings.

---

Performance Tuning

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

Tool Name	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 Name	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 Name	Description
proxysql_status	Retrieve global status variables
proxysql_query_rules	View configured query routing rules

Note

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}).

---

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