List all databases on the MySQL server.

Returns database names the current user has access to.

Returns:

• markdown: formatted list

• json: { databases: string[] }

List all tables in a MySQL database.

Args:

• database (string, optional): Database name. Uses MYSQL_DATABASE if omitted.

• response_format ('markdown' | 'json'): Output format (default: 'markdown')

Returns:

• markdown: formatted table list

• json: { database: string, tables: string[], count: number }

Get column definitions for a MySQL table (equivalent to DESCRIBE or SHOW COLUMNS).

Args:

• table (string, required): Table name

• database (string, optional): Database name. Uses MYSQL_DATABASE if omitted.

• response_format ('markdown' | 'json'): Output format (default: 'markdown')

Returns column info: Field, Type, Null, Key, Default, Extra

Get the full CREATE TABLE DDL statement for a table.

Args:

• table (string, required): Table name

• database (string, optional): Database name. Uses MYSQL_DATABASE if omitted.

Returns the complete CREATE TABLE SQL with all indexes, constraints, and engine settings.

Execute a read-only SELECT query against MySQL.

Only SELECT and SHOW/EXPLAIN statements are permitted. Use mysql_execute for write operations.

Args:

• sql (string, required): SQL SELECT statement. Use ? placeholders for params.

• params (array, optional): Bind parameters corresponding to ? placeholders.

• database (string, optional): Database name. Uses MYSQL_DATABASE if omitted.

• limit (number, optional): Max rows to return (default: 100, max: 1000).

• response_format ('markdown' | 'json'): Output format (default: 'json')

Returns:

• json: { rows: object[], count: number, has_more: boolean }

• markdown: formatted table

Examples:

• sql: "SELECT * FROM biz_exhaust_yg WHERE jcrq = ? LIMIT 10", params: ["2026-03"]

• sql: "SELECT COUNT(*) as cnt FROM biz_exhaust_hy"

Execute a write SQL statement (INSERT, UPDATE, DELETE, DDL).

WARNING: This tool modifies data. Use with caution.

Args:

• sql (string, required): SQL statement. Use ? placeholders for parameters.

• params (array, optional): Bind parameters corresponding to ? placeholders.

• database (string, optional): Database name. Uses MYSQL_DATABASE if omitted.

Returns: { affectedRows: number, insertId: number, changedRows: number }

Examples:

• sql: "UPDATE biz_exhaust_hy SET DELETE_FLAG = 'DELETED' WHERE ID = ?", params: [123]

• sql: "INSERT INTO my_table (name) VALUES (?)", params: ["test"]

Get row count and size statistics for tables in a database.

Args:

• database (string, optional): Database name. Uses MYSQL_DATABASE if omitted.

• table (string, optional): Filter to a specific table. If omitted, returns all tables.

• response_format ('markdown' | 'json'): Output format (default: 'markdown')

Returns per table: table_name, row_count, data_size_mb, index_size_mb, engine, create_time