The Data IDE for engineers
who write SQL.
A desktop-native SQL Notebook and AI copilot. Secure local credentials, a responsive workspace, and dialect-correct query authoring — all in one blazing-fast native app.
Free 7-day trial · macOS & Windows · v0.2.2
SELECT c.customer_id, c.name,
COUNT(o.order_id) AS orders,
SUM(o.total) AS revenue
FROM customers c
JOIN orders o ON o.customer_id = c.customer_id
GROUP BY c.customer_id, c.name
ORDER BY revenue DESC
LIMIT 100;| customer_id | name | orders | revenue |
|---|---|---|---|
| 10432 | Aurora Labs | 28 | $48,210 |
| 10087 | Nimbus Co | 19 | $31,440 |
| 10256 | Vega Systems | 15 | $22,980 |
| 10994 | Orbit Data | 12 | $18,750 |
A notebook-style SQL editor for querying data warehouses. Documentation alongside queries. Spreadsheet-grade results. And an AI copilot that actually understands your schema.
- Powerful SQL Editor — Full-featured workspace with custom syntax highlighting, multi-cursor, auto-closing brackets, and query-cancellation controls.
- Semantic Autocomplete — Context-aware autocomplete that parses your SQL, resolves table aliases, and suggests schemas, tables, and columns with intelligent ranking.
- Virtualized Results Grid — Spreadsheet-grade grid with arrow-key navigation, shift-click block selection, and clipboard copy for direct paste into Excel or Google Sheets.
- Drag-and-Drop SQL Generation — Drag columns from the sidebar or grid headers into the editor to generate SELECT, WHERE IN, GROUP BY, ORDER BY, COUNT, and JOIN clauses.
- Rich SQL Notebooks — Markdown and SQL blocks side-by-side. Live markdown preview, SQL prettify, and one-click Run All blocks.
- SAYA AI Copilot — An agentic AI that reads your schema, authors dialect-correct SQL, runs read-only probes, and returns Markdown reports with runnable SQL.
One IDE, every engine. Connect to the warehouses you already use with a consistent experience across all of them.
Full PostgreSQL support with connection pooling, metadata introspection, and intelligent autocomplete across all your schemas.
MySQL connector with proper identifier quoting, dedicated metadata extraction, and full autocomplete support.
Comprehensive Snowflake connector with support for all three authentication methods and efficient large result set handling.
Built-in DuckDB for local analytics — no external server required. Query local files and in-memory databases directly.
SAYA AI is an agentic copilot that reads your schema, runs read-only probes, and returns Markdown reports with runnable SQL. It works with Claude, OpenAI, Gemini, or runs entirely local on Ollama.
Null percentages, distinct counts, min/max, top values, and type validation.
Primary key uniqueness, foreign key integrity, NOT-NULL compliance, and completeness scores.
Numeric outliers, rare categorical values, and unexpected NULL bursts.
Ready to query?
Download DataBook Studio for macOS or Windows. Start a 7-day trial — no account required.