Tools

Optimize Operational Efficiency and Context Windows with MCP Tools

Value Proposition Empower agentic workflows with a comprehensive MySQL tool suite. Execute secure, context-aware data operations that maximize operational efficiency while minimizing token overhead, ensuring your agents accomplish complex tasks faster and more cost-effectively. 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.

---

Use Curated Presets

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

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

---

Execute 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

Execute JSON Operations

CLI Group: --tool-filter json Deeply integrate with MySQL's native JSON capabilities to read, mutate, and validate documents with zero-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

---

Execute Text Operations

CLI Group: --tool-filter text Perform lightning-fast 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

---

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

---

Analyze Performance Tuning

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

---

Manage ProxySQL Operations

CLI Group: --tool-filter proxysql Dynamically control ProxySQL routing rules and connection pooling to ensure highly available, read-scaled AI workflows.

Note

Disclaimer: The tools listed on this page are non-exhaustive examples. For a complete list of tools and their respective groups, please refer to the Tool Filtering page.

---

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 searches for specific tools, not groups, enabling dynamic discoverability of the complete, up-to-date tools.