Tools

Optimize Operational Efficiency and Context Windows with MCP Tools

Value Proposition Execute secure, highly context-aware data operations. Our specialized tools are engineered to maximize operational efficiency while minimizing token overhead, empowering AI agents to accomplish complex database 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.

---

Accelerate with Curated Presets

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

Shortcut	Scope	Use Case	What's Included
starter	Core Set	Standard Package	core, json, transactions, text, codemode
essential	Minimal	Minimal footprint	core, transactions, codemode
dev-power	Full Suite	Power Developer	core, schema, performance, fulltext, transactions, codemode
dev-analytics	Extensive	Developer Analytics	core, stats, performance, codemode
ai-data-nosql	Extensive	AI Data NoSQL	core, json, docstore, codemode
ai-search	Targeted	AI Search	core, text, fulltext, vector, codemode
ai-spatial	Targeted	AI Spatial Analyst	core, spatial, transactions, codemode
ai-vector	Targeted	AI Vector Analyst	core, vector, fulltext, codemode
dba-monitor	Full Suite	DBA Monitoring	core, monitoring, performance, sysschema, optimization, codemode
dba-manage	Full Suite	DBA Management	core, admin, backup, replication, partitioning, events, codemode
dba-secure	Extensive	DBA Security	core, security, roles, transactions, codemode
dba-schema	Extensive	DBA Schema	core, schema, introspection, migration, codemode
base-relational	Extensive	Base Relational	core, transactions, text, schema, codemode
base-analytics	Targeted	Base Analytics	stats, events, codemode
base-nosql	Targeted	Base NoSQL	docstore, spatial, vector, codemode
ecosystem	Full Suite	External Tools	cluster, proxysql, router, shell, codemode

---

Orchestrate 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

Architect 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

---

Orchestrate 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

---

Master the 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.

---

Master 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

---

Architect 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

---

Orchestrate 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

---

Orchestrate 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. 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 provides a compact categorization of all available tools, enabling dynamic discoverability of the complete, up-to-date toolset.