The AI-driven SQL IDE

Query your database with a companion that knows your schema

SnoutData is a fast, keyboard-driven desktop SQL client for every major SQL database. Its built-in assistant reads your schema, drafts and explains queries, and runs them only when you allow it.

Download for free

Free to start. Windows, macOS, and Linux.

A real database IDE, with a brain

Everything you expect from a pro SQL client, plus an assistant that understands what it is looking at.

Schema-aware AI

The assistant reads your live tables, columns, and foreign keys, so it drafts SQL that fits your database instead of generic guesses.

A real table workbench

Browse millions of rows with server-side paging, edit cells inline, and design tables and indexes with a preview that runs on confirm.

Local-first and private

A native desktop app, not a browser tab. Passwords and SSH keys are encrypted in your OS keychain, never in config files.

Bring your own model API

On Plus and Pro, point the assistant at your own Claude, ChatGPT, or any OpenAI-compatible model. Your key and prompts go straight to the provider and never touch our servers.

MCP access for agents

Let Claude Code, Codex, or any MCP client query your databases through SnoutData. The agent gets read-only access by default, never your passwords or keys, and only the connections you allow.

Safe on production

Production connections are flagged, and destructive statements ask for confirmation before they run. Pro adds an audit log.

The assistant

It reads your schema before it answers

Most tools paste your prompt into a generic model and hope. SnoutData ranks the tables most relevant to your question, follows their foreign keys, and grounds the model in your real columns and types, so the SQL it writes actually runs.

  • Draft a query from a plain-English question
  • Explain, refactor, or optimize a query you already have
  • Ask: quick, one-shot answers to a single question
  • Agentic: extended thinking for deeper, multi-step work
  • It runs only when you approve. Pro keeps an audit log of every action
Try it free
Which products have no orders in the last 90 days?
reading schema: products, orders
select p.name
from products p
left join orders o
  on o.product_id = p.id
  and o.created_at > now() - interval '90 days'
where o.id is null;

See it in action

A real desktop SQL IDE with an assistant that understands your database. Here is what that looks like.

Ask in plain English

Describe the report, get the SQL

The assistant reads your live schema (tables, columns, foreign keys), writes real runnable SQL, and explains its reasoning. One click drops it into the editor or a new tab.

Tab to complete, our own model

Snout Complete finishes the line for you

Start typing and Snout Complete suggests the rest inline. Press Tab to accept. This is our own FIM model (snout-fim-1.0), not the deterministic keyword list, served through our gateway so the suggestion fits your actual schema.

It learns how you work

Sharper the more you use it

Snout Complete adapts to how you build SQL. As you write queries it learns your patterns, your formatting, the columns and filters you reach for, and folds that into its inference, so the suggestions get closer to exactly what you would have typed instead of a generic average.

Agent mode

Let the assistant run the query

Expand the chat to a focused full-window view and let it work as an agent: it runs queries against your database, reads the results, and keeps the thread going. Pick the model and how much freedom it gets.

Stuck on an error

Paste a failing query, get the fix

Hand it the error and the SQL that produced it. It diagnoses the cause against your actual schema, a wrong table name or a missing column, and returns corrected SQL.

Know your data

Every table at a glance

Each table gets a telemetry view: storage and index sizes, schema facts like keys, indexes, engine, and collation, plus the queries that recently touched it.

Connect securely

Your databases, your keychain

MySQL and Aurora, PostgreSQL, and SQL Server, with optional SSH tunneling and AWS Secrets Manager. Credentials are encrypted by your OS keychain, never stored in plain text.

MCP access for agents

Let agents query, keep your secrets

Point Claude Code, Codex, or any MCP client at your databases through SnoutData. Your passwords and keys never leave your OS keychain, and never touch the agent or a repo. Access is read-only by default, and you pick exactly which connections are reachable.

See the answer

Ask for a chart, get a chart

Some questions are easier to read as a picture. Ask for one and the assistant runs the query and renders the chart right in the thread, ready to save. No spreadsheet round-trip.

Light or dark

Themed to match how you work

A polished light theme and a deep dark theme, both tuned for long sessions staring at query results.

Simple, honest pricing

Every tier runs the same app. Your plan only changes what the AI assistant is allowed to do.

Free
$0forever

The full assistant, including its deeper reasoning, every day.

  • Monthly AI credits, on us
  • Multi-tab SQL editor with schema-aware completion
  • Connection explorer and table workbench
  • Results grid, query history, and CSV/JSON export
  • AI extended thinking mode
  • Multi-step query help and explanations
  • Schema design review
  • Works with every major SQL database
Download
Pro
$15per month

The most AI quota and early access to what is next.

  • Everything in Plus
  • Early access to new features
  • The most AI quota
  • Priority on new model rollouts

Paid plans are billed securely through Stripe. Sign in to upgrade, switch, or cancel anytime.

Plus and Pro can bring their own provider key. Your key never touches our servers. Learn more.

Ready to query faster?

Download SnoutData and let the assistant learn your schema in seconds.