An assistant that reads your schema, writes the query, runs it read-only and shows you exactly what it did — with no rows leaving your network.
Editor autocomplete finishes the line you are already writing. An assistant answers a question you have not worked out how to ask in SQL yet — which means it has to do three things autocomplete never does: find the right tables in a schema it was not trained on, run the query, and read the result well enough to notice when it is wrong.
Any current model can write syntactically valid SQL. Almost none can write correct SQL against a two-thousand-table warehouse it has never seen, because correctness is a question about your schema and not about SQL. SQLore introspects the database once and caches what it finds — tables, columns, keys, distinct values and statistics — then searches that index locally before a single token of SQL is generated. That is why a filter lands on the column that actually holds the value.
Write. There is no question worth answering that requires an UPDATE, and an assistant with write access is one hallucinated statement away from an incident. SQLore parses generated SQL to an abstract syntax tree and validates it down to a single read-only SELECT before it goes near your database, then executes it on a read-only connection with a statement timeout. That is a parser, not a blocklist of dangerous words — the distinction matters, because a blocklist is a list of the strings someone thought of.
Most assistants in this category are a web app with a form for your connection string, which means your credentials and your schema live on someone else's server. SQLore is a desktop application: the credentials stay on your machine, the query runs from your machine, and with a local model configured, nothing leaves your network at all. Live cloud models are something you switch on for a hard question, not something you have to find and switch off.
More answers on the main FAQ, or ask us directly.
For people who already write SQL
The technique
Local models
Every page in this section covers a different question about the same product. See all solutions.
Start free, upgrade when you are asking enough questions for it to matter.
