MySQL & MariaDB
Ask your MySQL or MariaDB database questions in plain English
Ottoch connects directly to your MySQL or MariaDB database — self-hosted, read-only safe by default, bring your own AI key. No data warehouse, no vendor sitting between you and your database.
Connect your MySQL or MariaDB database
Under Settings → Connections → Add connection, pick MySQL or MariaDB and fill in host, port (3306 by default for both), database name, and credentials. Ottoch treats the two as separate connection types but the same underlying protocol — pick whichever matches what you're actually running.
Activate the tables you want queryable
Under Manage tables, turn on exactly the tables the AI should be able to see. Ottoch only ever sends the schema (table/column names) of tables you've explicitly activated to your LLM provider — never your whole database schema by default, and never row data unless you turn on the separate "auto-explain" setting.
Ask questions — no SQL required
A few examples people actually ask against a MySQL-backed app database:
If a question needs a table Ottoch can't see yet — most often a join table linking two activated tables — activate that one too and ask again.
Referenz
MySQL / MariaDB connection defaults
| Setting | Standard |
|---|---|
| Port | 3306 |
| SSL Mode | Required (works under any mode for MySQL/MariaDB specifically — switch to Disabled only if a connection test fails) |
| Also supports | PostgreSQL, SQL Server, Redshift, ClickHouse, SQLite, Databricks |
Restricting which machines can reach your database port at all? See the firewall and network setup guide.
Try it on your own MySQL or MariaDB database
One Docker command. Free forever for a single user and connection.