MCP Tools Reference
execute_query
Section titled “execute_query”Run a parameterized SQL query.
| Parameter | Type | Required | Description |
|---|---|---|---|
sql | string | ✓ | Parameterized SQL statement |
params | array | Query parameters ($1, $2, …) |
execute_transaction
Section titled “execute_transaction”Run multiple SQL statements as an ACID transaction.
| Parameter | Type | Required | Description |
|---|---|---|---|
statements | array | ✓ | Array of {sql, params} objects |
run_migration
Section titled “run_migration”Apply a schema migration.
| Parameter | Type | Required | Description |
|---|---|---|---|
name | string | ✓ | Migration name (unique) |
sql | string | ✓ | DDL SQL to execute |
get_audit_trail
Section titled “get_audit_trail”Retrieve the audit log for an entity.
| Parameter | Type | Required | Description |
|---|---|---|---|
entityType | string | ✓ | Entity type (e.g. query, migration) |
entityId | string | ✓ | Entity identifier |
limit | number | Max results (default 50) |
health_check
Section titled “health_check”Check Hyperdrive and D1 connectivity. No parameters.