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

Описание и применение

Ottoch позволяет безопасно и локально задавать вопросы к базам данных на естественном языке, получая ответы и генерируемый SQL без отправки данных внешним сервисам.

Задача

Users need a way to query databases using natural language without exposing raw SQL or relying on external APIs.

Результат

Ottoch enables secure, local natural language querying of multiple database types, eliminating the need for external API keys and providing transparency by showing the generated SQL.

Рабочий процесс

• Clone the Ottoch demo repo
• Navigate to the project directory
• Run docker compose up -d to start the app and six pre‑seeded databases
• Open the web UI in a browser
• Enter a natural language question (e.g., "How many orders this month?")
• Review the returned answer and the generated SQL query

Доказательства

Runs entirely on your own machine. Nothing phones home.

Источник

Added a demo bundle so you can try it without connecting anything real — one command spins up the app plus six pre‑seeded databases

Источник