Execute a read-only SQL query (SELECT). Uses prepared statements for safety.

Execute a write SQL query (INSERT, UPDATE, DELETE). Uses prepared statements for safety.

List all tables and views in the database with metadata.

Get detailed information about a table's structure including columns, types, and constraints.

Create a new table with specified columns, engine, and charset.

Drop (delete) a table from the database.

Get all indexes for a table including type, columns, and cardinality.

Create an index on a table. Supports BTREE, HASH, FULLTEXT, and SPATIAL index types.

Enable optimistic concurrency control (OCC) on a table. Adds a _version column and an auto-increment trigger.

Disable optimistic concurrency control (OCC) on a table. Drops the _version column and its trigger.

Read the current _version of a specific row for optimistic concurrency control.

Update a row only if its _version matches expectedVersion. Prevents lost updates in multi-agent environments.

Begin a new transaction with optional isolation level. Returns a transaction ID for subsequent operations.

Commit a transaction, making all changes permanent.

Rollback a transaction, undoing all changes.

Create a savepoint within a transaction for partial rollback.

Release a savepoint, removing it without rolling back.

Rollback to a savepoint, undoing changes after that point.

Execute multiple SQL statements atomically. All statements succeed or all are rolled back.

Extract values from JSON columns using JSON path expressions.

Set or update values in JSON columns at specified paths.

Insert values into JSON columns only if the path does not exist.

Replace values in JSON columns only if the path exists.

Remove values from JSON columns at specified paths.

Find rows where JSON column contains a specified value.

Get the keys of a JSON object at the specified path.

Append a value to a JSON array at the specified path.

Simple JSON value extraction by row ID.

Simple JSON value update by row ID.

Search for a string value in JSON columns and return matching paths.

Validate if a string is valid JSON.

Merge two JSON documents using JSON_MERGE_PATCH or JSON_MERGE_PRESERVE.

Compare two JSON documents and identify differences.

Normalize JSON column structure by extracting all unique keys across documents.

Analyze statistics for a JSON column including depth, size, and key frequency.

Suggest functional indexes for frequently accessed JSON paths.

Find rows where column matches a regular expression pattern.

Find rows using LIKE pattern matching with % and _ wildcards.

Find rows with phonetically similar values using SOUNDEX.

Extract substrings from column values.

Concatenate multiple columns with an optional separator.

Convert column values to a different character set or collation.

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;