DEV Community

Cover image for Ottoch - ask your database questions in you plain language, self-hosted....
santhosh bhandari
santhosh bhandari

Posted on

Ottoch - ask your database questions in you plain language, self-hosted....

****Built Ottoch over some weekends: a self-hosted tool that turns plain English questions into SQL. Connect a database, bring your own OpenAI/Anthropic/Gemini key (or don't), ask "how many orders this month?", get a real answer back with the actual SQL shown β€” not a black box.

Runs entirely on your own machine. Nothing phones home. UI is available in English, Dutch, German, and Spanish.

Added a demo bundle so you can try it without connecting anything real β€” one command spins up the app plus six pre-seeded databases (Postgres, MySQL, MariaDB, SQL Server, ClickHouse, SQLite), plus a local Ollama model

so it works with zero API key too:

git clone https://github.com/ottochapp/ottoch-demo
cd ottoch-demo
docker compose up -d
Enter fullscreen mode Exit fullscreen mode

Live demo, no signup: ottoch demo

Built with a lot of help from Claude. Weekend project, not a pitch β€” feedback welcome.

Top comments (0)