Download
Features

Everything a data engineer needs
in one desktop app.

A notebook-style SQL editor with native speed and a responsive workspace. Spreadsheet-grade results, semantic autocomplete, and drag-and-drop SQL generation.

SQL Editor

SQL Editor

  • Intelligent Autocomplete — Keywords, schemas, tables, and columns drawn from a local metadata cache. Table alias resolution maps FROM table AS t to suggest t.columns. Foreign-key aware JOIN suggestions and ambiguous-column qualification.
  • SQL Prettify — One-click formatting for clean indents and readable SQL.
  • Seamless Scroll Integration — Mouse wheel events bubble to the parent notebook at scroll boundaries — no scroll-hijacking.
  • Drag-and-Drop Query Generation — Drag table names from the Schema Explorer to generate SELECT * queries. Drag selected cells or columns from a result set to generate SELECT, GROUP BY, WHERE, ORDER BY, COUNT, and JOIN clauses using fully-qualified names.
  • Query Cancellation — A Stop button terminates long-running queries on demand.
  • Run All Blocks — Execute all query blocks in the active notebook sequentially from the toolbar.
-- drag a column header from the results grid → generates WHERE IN
-- Drag "customer_id" cells from the grid into the editor:
SELECT name, email
FROM customers
WHERE customer_id IN (10432, 10087, 10256, 10994)
ORDER BY name;
Results Grid

Results Grid

  • Virtual Grid Rendering — Large datasets render instantly — no pagination round-trips.
  • Multi-Column Client-Side Sorting — Shift-click for multi-criteria sort. Ascending → Descending → Unsorted toggle. All sorting happens in-app with no database round-trips.
  • Spreadsheet-style Selection — Arrow-key navigation moves the active cell. Shift-click and shift-drag select blocks of cells.
  • Clipboard Operations — Cmd/Ctrl+C copies the selection as TSV (Excel/Sheets-ready). Copy as CSV, JSON, or HTML table. Export as CSV, JSON, or XML files.
  • Column Filtering — Per-column filter dropdowns with condition and value tabs.
  • Cell Detail + Charts — Inspect large cell values in a detail modal. Visualize results with built-in chart views.
SQL Notebooks

SQL Notebooks

  • Markdown + SQL Blocks — Documentation alongside queries. Markdown editing with live preview, GFM tables, and task lists.
  • Toggle Interaction — Double-click a preview to edit. Cmd/Ctrl+Enter to render and preview.
  • File System Persistence — Notebooks save directly to disk as files. Auto-save runs every minute. Manual save button. Auto-restore after refresh.
  • Flexible Export — Export notebook state as JSON, or concatenate all query blocks into a single downloadable .sql script with metadata headers.
  • Notebook-Specific Connections — Each notebook maintains its own database connection. Switch per-notebook from the toolbar dropdown.
  • Resizable Blocks — Query blocks and results resize on all edges and corners. Double-click a block header to expand results to full view; double-click again to restore.
Workspace Explorer

Workspace Explorer

  • Recursive Directory Crawler — Browse local folder trees on demand — matches VS Code's local folder experience.
  • Background Filesystem Watcher — File changes are detected in the background with automatic cleanup on close — no zombie processes.
  • Workspace Tabs — Multiple folder contexts in tabs with per-tab notebook state and history.
  • File Operations — Create files or folders, rename paths, delete paths, read and write file content — all with secure permission scoping.
Get started

Ready to try it?

Download DataBook Studio and start querying in minutes.

Download →