Tools
Value Proposition Empower agentic workflows with an enterprise-grade MySQL tool suite. Execute secure, context-aware data operations that maximize operational efficiency while minimizing token overhead. 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.
Tool filters can use convenient presets to unlock specific groups of tools.
| Preset | Tool Groups Unlocked |
|---|---|
starter |
core, json, text, codemode
|
CLI Group:
--tool-filter coreSafely execute foundational data manipulation and schema queries. These feature built-in parameterization and rigorous security controls. The tools below are foundational examples rather than an exhaustive list.
| 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 |
CLI Group:
--tool-filter jsonDeep integration with MySQL's native JSON capabilities. Read, mutate, and validate JSON documents securely. The tools below are foundational examples rather than an exhaustive list.
| 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 |
CLI Group:
--tool-filter textExecute text-based operations and matching strategies directly within the database engine. The tools below are foundational examples rather than an exhaustive list.
| Tool | Description |
|---|---|
mysql_regexp_match |
Perform regular expression pattern matches |
mysql_like_search |
Perform LIKE pattern matching |
mysql_soundex |
Perform SOUNDEX string phonetic matching |
CLI Group:
--tool-filter codemodeExecute JavaScript in a native isolated-vm V8 instance with access to MySQL tools. Note: Code Mode is strictly bound by your--tool-filterrules. It cannot execute explicitly filtered tools. Code Mode is included in thestarterpreset. Read Code Mode for API documentation.
| Tool | Description |
|---|---|
mysql_execute_code |
Execute code with access to all mysql.* APIs. Yields significant token savings. |
CLI Group:
--tool-filter performanceAnalyze and optimize query execution plans and database performance. (Use themysql_tool_indexprompt to view the full list of available performance tools. One example ismysql_explain).
CLI Group:
--tool-filter proxysqlManage ProxySQL configuration, query routing rules, and connection pooling metrics dynamically. (Use themysql_tool_indexprompt to view the full list of available ProxySQL tools).
- Tool Filtering - Custom tool filtering
- Configuration - General configuration
- Database Resources - Database telemetry resources (MCP)
💡 Pro Tip: Use the
mysql_tool_indexprompt. It searches for specific tools, not groups, enabling dynamic discoverability of the complete, up-to-date tools.
This documentation is generated automatically.