# MySQL

Query a MySQL database — run parametrised SQL against a named connection and get back capped, paginated rows. Read your schema by querying information_schema directly.

Run these through `omni-cli` once a human has connected the platform (`omni-cli mysql login`). Full parameter and output schemas come from `omni-cli discovery mysql`.

## discovery

| Command | What it does | Kind |
|---|---|---|
| `omni-cli mysql foreign-key list` | List foreign keys, showing which columns reference which table. | read |
| `omni-cli mysql index list` | List indexes and the columns they cover. | read |
| `omni-cli mysql server info` | Show the database server version and the identity this connection uses. | read |
| `omni-cli mysql table describe` | Show a table's columns with their types, nullability, defaults and primary key. | read |
| `omni-cli mysql table list` | List the tables and views in a schema. | read |

## query

| Command | What it does | Kind |
|---|---|---|
| `omni-cli mysql query explain` | Show how the database would run a statement, without running it. | read |
| `omni-cli mysql query run` | Run a SQL statement against a named connection and return the rows it produces. | write |