List all configured MySQL/MariaDB connections (names only, no URIs).

Ping a MySQL/MariaDB connection (SELECT 1).

Server version, vendor, capabilities, and host metadata.

Add or replace a runtime connection by URI. Use a unique name.

List databases on the server (respects allowed_databases).

List tables and views in a database.

Column definitions for a table (information_schema + SHOW FULL COLUMNS).

Return CREATE TABLE DDL.

List indexes for a table.

List foreign key constraints for a table.

Table size and row estimates from information_schema.

List views in a database.

List triggers in a database.

List scheduled events in a database.

Run a parameterized SELECT query. Use ? placeholders for params.

Run a SELECT and return the first row only.

EXPLAIN a SELECT query (JSON format when supported).

COUNT rows in a table with optional WHERE clause.

Sample rows from a table.

Distinct values for a column (capped).

Run a SELECT and return truncated JSON for large results.

Execute a single DML statement (INSERT/UPDATE/DELETE) with ? placeholders.

Execute multiple DML statements in a single transaction.

Bulk insert rows from a JSON array of objects (column keys must match).

DELETE rows with a required WHERE clause.

TRUNCATE a table (requires confirmed=true).

List stored procedures in a database.

List stored functions in a database.

Parameter list and metadata for a stored procedure.

Return CREATE PROCEDURE DDL.

Return CREATE FUNCTION DDL.

Call a stored procedure with JSON params; captures result sets and OUT parameters.

Call a stored function with positional params.

Test a stored procedure in a sandbox transaction (ROLLBACK by default).

Deploy a stored procedure from SQL (CREATE PROCEDURE body).

Drop a stored procedure.

List all procedures and functions with parameter summaries.

Parse a SQL script into individual statements (DELIMITER-aware). Does not execute.

Parse and classify script statements without executing.

Execute a multi-statement SQL script. Use confirmed=true to commit writes.

Execute a script inside a sandbox transaction (ROLLBACK by default).

Read a SQL file from disk and optionally execute it (sandbox by default).

Prepend SET @var statements then run a script.

Execute a DDL statement (CREATE/ALTER/DROP). Requires confirmed=true.

Create a database.

Drop a database. Requires confirmed=true.

Create an index on a table.

Drop an index from a table.

Show grants for the current user.

SHOW FULL PROCESSLIST — active connections and queries.

Key global status variables.

Server system variables.

SHOW ENGINE INNODB STATUS (InnoDB only).

Replication status (SHOW REPLICA/SLAVE STATUS).

Kill a query by connection id.

Composite health: ping, version, engine, replication snippet.

Composite: columns, indexes, foreign keys, stats, and sample rows.

Composite: all tables with row estimates, engine, and sizes.

Composite: EXPLAIN with human-readable summary.

Compare column definitions between two tables (same or different connections).

List indexes with cardinality and flag possible duplicates.