Tools

Comprehensive MySQL Toolset

Value Proposition Equip AI agents with a comprehensive MySQL toolset. Execute secure and scalable data operations. Safely run workflows within strict isolation boundaries. Read the full value proposition.

Note

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

---

Curated Presets

Tool filters can use convenient presets to unlock specific groups of tools instantly.

Preset	Tool Groups Unlocked
starter	core, json, text, codemode

---

Core Database Operations (CLI Group: --tool-filter core)

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

---

JSON Operations (CLI Group: --tool-filter json)

Deep integration with MySQL's native JSON capabilities. Read, mutate, and validate JSON documents securely.

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_remove	Remove data from JSON documents
mysql_json_contains	Check if JSON document contains data
mysql_json_keys	Return keys from JSON documents
mysql_json_array_append	Append values to JSON array
mysql_json_get	Get value from JSON document
mysql_json_update	Update JSON document
mysql_json_search	Search for values within JSON document
mysql_json_validate	Validate JSON document against schema
mysql_json_merge	Merge multiple JSON documents
mysql_json_diff	Compare two JSON documents
mysql_json_normalize	Normalize JSON document
mysql_json_stats	Get statistics about JSON document
mysql_json_index_suggest	Suggest indexes for JSON document

---

Text Operations (CLI Group: --tool-filter text)

Execute text-based operations and matching strategies 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
mysql_substring	Extract substrings
mysql_concat	Concatenate strings
mysql_collation_convert	Convert string collation

---

Code Mode Sandbox (CLI Group: --tool-filter codemode)

Execute JavaScript in a native isolated-vm V8 instance with access to MySQL tools. Note: Code Mode is bound by --tool-filter rules. It cannot execute explicitly filtered tools. Read Code Mode for API documentation.

Tool	Description
mysql_execute_code	Execute code with access to all mysql.* APIs. Yields significant token savings.

---

ProxySQL Operations (CLI Group: --tool-filter proxysql)

Manage ProxySQL configuration, query routing rules, and connection pooling metrics dynamically. (Use the mysql_tool_index prompt to view the full list of available ProxySQL tools).

---

Explore Related Topics

• Tool Filtering - Reduce tool count for IDE limits
• Configuration - MCP client configuration
• Database Resources - Monitor and query resources

💡 Pro Tip: Use the mysql_tool_index prompt for dynamic discoverability of the complete, up-to-date tools and schemas.

---

This documentation is generated automatically.