Tools
Value Proposition Equip your AI agents with a schema-enforced MySQL toolset. Safely manage core CRUD operations and administrative tasks within secure isolation boundaries. Read the full value proposition. [!NOTE] Global Parameter Note: All tools support token-optimized payloads via optional
summary,limit, andcompactparameters where applicable.
Tool filters can use convenient presets to unlock specific groups of tools instantly.
| Preset | Tool Groups Unlocked |
|---|---|
starter |
core, json, text, codemode
|
Safely execute foundational 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_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 |
Execute JavaScript in a native isolated-vm V8 instance with access to MySQL tools. Note: Code Mode operations are securely bound by your outer
--tool-filterrules, meaning it cannot execute tools that have been explicitly filtered out. Read Code Mode for API documentation.
| Tool | Description |
|---|---|
mysql_execute_code |
Execute code with access to all mysql.* APIs. Yields significant token savings. |
- Tool Filtering - Reduce tool count for IDE limits
- Configuration - MCP client configuration
- Database Resources - Monitor and query resources
This documentation is generated automatically.