From the workbench
Feature deep-dives, announcements, and notes on building a database IDE where deterministic signals beat model vibes.
Run more than one query at a timeA long-running query used to freeze the whole app. Now SnoutData runs your queries concurrently: fire off the slow one, open a new tab, and keep working, with a tunable connection pool and background tasks that never block your query.Read post →
- Your query looks fine. It still scans 116 million rows.SnoutData asks the database's own query planner before running, and warns you before a query full-scans a huge table because an indexed column was wrapped in a function. Deterministic, instant, no model.
- Live database dashboards, built into the IDEWatch your database move in real time: named dashboards of SQL-backed widgets that poll on an interval and plot the trend, right next to the editor that wrote the query.
- Charts from a question, with the SQL in viewAsk for a chart in plain language: SnoutData writes the query against your real schema, runs it, and draws the chart, with the SQL always shown and export to PNG, SVG, or CSV.
- See exactly what changed: schema diff and syncA two-pane diff between any two schemas with a generated migration preview, so you know what a change does before you run it.
- Bring your own key: your provider, your billOn Plus and Pro, point the assistant straight at your own OpenAI, OpenRouter, or Anthropic key. Requests go directly to that provider, your key stays in the OS keychain, and nothing touches our gateway.
- Let your agent query the database through the app, not a .envSnoutData ships a local MCP server so an external agent can read your databases through the app, with credentials staying in the OS keychain and never landing in a repo or a .env file.
- Ask which indexes your table is missingSnoutData reads a table's real structure and existing indexes, then recommends what is missing and why, with the CREATE INDEX statements ready to run and the trade-offs spelled out.
- Ask questions about a CSV, PDF, or spreadsheetAttach a file to the chat and ask about it. SnoutData reads the contents and answers alongside the database it is already connected to, so a document and your live schema sit in one conversation.
- AI: fix the last error, with your schema in contextA query failed? Run "AI: Fix Last Error." SnoutData hands the assistant the failed SQL, the exact error, and your real schema, and gets a corrected, runnable query back.
