Skip to main content

AI assistant

SnoutData's AI assistant is a chat panel that understands your schema and proposes SQL. Ask a question in plain language and it replies with an explanation and a query you can drop straight into the editor.

The AI assistant answering in plain language, running a query, and charting the result

Schema grounding​

The assistant is grounded in the connected database's schema. Rather than send the whole schema (which would not fit for a large database), it ranks tables by relevance to your question and expands one hop along foreign keys, so the prompt is spent on the tables that actually matter. The result is SQL that references your real tables and columns.

Using a reply​

When the assistant proposes SQL, you can:

  • Insert it into the current editor tab, or
  • Insert it into a new tab.

Then run it like any other query.

Conversations​

  • Replies render as markdown.
  • A per-conversation token tally shows prompt, completion, and total tokens.
  • Start a new chat or stop an in-flight reply at any time (a partial reply is kept).
  • Conversations are saved, so you can reopen past sessions.

Choosing a model​

The model picker lists the models available to you. Which models you can reach depends on your plan. If you would rather use your own provider account, see Bring Your Own Key.

More​