PersonalAI2024

SuperArc

Ask a database a question in English and get a table back. Local LLM text-to-SQL with a schema-aware chain that will only run SELECT.

Problem

Non-SQL users needed answers from a relational database without being handed a SQL console.

Solo.

LangChain SQL chain against a local Ollama (Mistral) model; schema injected without sample rows.
Refuses questions unrelated to the schema and runs only SELECT statements.
Returns the answer, the columns and the generated SQL. MySQL in Docker Compose.

Next.jsFlaskLangChainOllamaMySQL

A guarded text-to-SQL loop that never issues writes and shows the SQL it ran.