MySQL Execute Code
mysql_execute_codeExecute sandboxed TypeScript/JavaScript code with access to MySQL APIs for CRUD, transactions, JSON, performance, and more.
Instructions
Execute TypeScript/JavaScript code in a sandboxed environment with access to all MySQL tools via the mysql.* API.
Available API groups:
mysql.core: readQuery, writeQuery, listTables, describeTable, createTable, createIndex (8 methods)
mysql.transactions: begin, commit, rollback, savepoint, execute (7 methods)
mysql.json: extract, set, insert, remove, contains, keys, merge, diff, stats (17 methods)
mysql.text: regexpMatch, likeSearch, soundex, substring, concat, collationConvert (6 methods)
mysql.fulltext: fulltextSearch, fulltextCreate, fulltextBoolean, fulltextExpand (5 methods)
mysql.performance: explain, explainAnalyze, slowQueries, bufferPoolStats, tableStats (8 methods)
mysql.optimization: indexRecommendation, queryRewrite, forceIndex, optimizerTrace (4 methods)
mysql.admin: optimizeTable, analyzeTable, checkTable, repairTable, flushTables, killQuery, serverConfig, appendInsight, auditSearch (9 methods)
mysql.monitoring: showProcesslist, showStatus, showVariables, innodbStatus, poolStats (7 methods)
mysql.backup: createDump, exportTable, importData, restoreDump (4 methods)
mysql.replication: masterStatus, slaveStatus, binlogEvents, gtidStatus, replicationLag (5 methods)
mysql.partitioning: partitionInfo, addPartition, dropPartition, reorganizePartition (4 methods)
mysql.schema: listSchemas, createView, listFunctions, listTriggers (10 methods)
mysql.events: eventCreate, eventAlter, eventDrop, eventList, schedulerStatus (6 methods)
mysql.sysschema: sysSchemaStats, sysStatementSummary, sysIoSummary (8 methods)
mysql.stats: descriptive, percentiles, correlation, regression, timeSeries, histogram (8 methods)
mysql.spatial: distance, distanceSphere, point, polygon, buffer (12 methods)
mysql.security: sslStatus, userPrivileges, audit, sensitiveTables (9 methods)
mysql.cluster: clusterStatus, grStatus, grMembers, clusterTopology (10 methods)
mysql.roles: roleCreate, roleGrant, roleAssign, roleList (8 methods)
mysql.docstore: docCreateCollection, docFind, docAdd, docModify (9 methods)
mysql.router: routerStatus, routerRoutes, routerRouteHealth (9 methods)
Example:
const tables = await mysql.core.listTables();
const results = [];
for (const t of tables.tables) {
const count = await mysql.core.readQuery(`SELECT COUNT(*) as n FROM \`${t.name}\``);
results.push({ table: t.name, rows: count.rows[0].n });
}
return results;Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| js | No | Alias for code | |
| sql | No | Alias for code | |
| code | No | TypeScript/JavaScript code to execute. Use mysql.{group}.{method}() for database operations. Note: Pass code, not script, javascript, or query. | |
| eval | No | Alias for code | |
| query | No | Alias for code | |
| script | No | Alias for code | |
| command | No | Alias for code | |
| execute | No | Alias for code | |
| timeout | No | Execution timeout in milliseconds (max 30000, default 30000) | |
| readonly | No | If true, restricts to read-only operations | |
| javascript | No | Alias for code |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| code | No | Error code (e.g. VALIDATION_ERROR, QUERY_ERROR) | |
| hint | No | Helpful tip or additional information | |
| logs | No | Captured console output from execution | |
| error | No | Error message if execution failed | |
| result | No | Return value from the executed code | |
| details | No | Additional error context | |
| metrics | No | Execution performance metrics | |
| success | Yes | Whether the code executed successfully | |
| category | No | Error category (validation, query, connection, internal) | |
| suggestion | No | Suggested fix for the error | |
| recoverable | No | Whether the error is recoverable |