PostgreSQL
Ask your PostgreSQL database questions in plain English
Ottoch connects directly to your PostgreSQL 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 Postgres database
Under Settings → Connections → Add connection, pick PostgreSQL and fill in host, port (5432 by default), database name, and credentials. Ottoch connects outbound from your own server to your database — your database is never exposed to Ottoch's infrastructure, because there isn't any.
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 Postgres-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.
Referentie
PostgreSQL connection defaults
| Setting | Standaard |
|---|---|
| Port | 5432 |
| SSL Mode | Required (change to Disabled for local/private-network databases without TLS) |
| Also supports | MariaDB, MySQL, SQL Server, Redshift, ClickHouse, SQLite, Databricks |
Restricting which machines can reach your Postgres port at all? See the firewall and network setup guide.
Try it on your own Postgres database
One Docker command. Free forever for a single user and connection.