Database Studio

Database Studio is a private SQL workspace in your browser: drop in data files or a SQLite database and query them with real SQL engines (DuckDB for analytics, SQLite for .sqlite files). Your data is read from disk and never leaves the page.

Features

Open CSV, TSV, Excel (.xlsx), JSON, NDJSON, Parquet and Arrow files as tables, SQLite .sqlite/.db databases and SQL dumps
Import wizard: delimiter, header, skipped rows, date formats and column types, with a live preview; import into DuckDB or a SQLite database
Table view: filter builder, search across every column, sort, show/hide columns, 1,000-row pages
Edit cells, add, duplicate and delete rows; review the changes as SQL and commit them in one transaction, with undo
Column profile: NULLs, distinct values, min/max/average, top values and a histogram
ER diagrams of any database (foreign keys plus relations inferred from names), or design a schema visually: tables, columns, keys, drag to relate
CREATE TABLE (PostgreSQL, MySQL, SQLite, SQL Server) or DBML → diagram, and diagram → DDL, DBML, Mermaid, PNG or SVG
Migration SQL: ALTER statements from a saved version or the live database to your design, ready to run in a SQL tab
Charts from any result (bar, line, area, scatter, pie, histogram, number) with grouping, exported as PNG or SVG
Explain shows the query plan as a tree (DuckDB Analyze times every step) and suggests SQLite indexes you can create in one click
SQL lint as you type (unknown tables and columns, UPDATE or DELETE without WHERE, = NULL, cross joins), a formatter and snippets
Notebooks with SQL and Markdown cells and {{parameters}}, exported as an HTML report; dashboards of pinned charts
DuckDB for fast analytical SQL on large files; SQLite for real .sqlite databases you can change and download
SQL editor with syntax highlighting, autocomplete of your tables and columns, tabs and query history
Ctrl+Enter runs the statement under the cursor; run a selection or the whole script
Fast results grid for 100,000 rows: sort, resize columns, copy cells or rows
Export results to CSV, JSON, SQL INSERTs or Parquet; save your SQLite database back to its file or download it
Tables and databases are kept in your browser between visits and work offline

How to use it

Drop a CSV, Excel, Parquet, JSON or SQLite file (or try a sample).
Open a table to browse, filter and edit it, or write SQL and press Ctrl+Enter.
Commit your edits, export results, or save the database file.

FAQ

Is my data uploaded?

No. Files are read and queried in your browser with DuckDB and SQLite compiled to WebAssembly. Nothing is sent to a server.

Can I connect to my Postgres or MySQL server?

Not directly: browsers can’t open database connections. Export a table to CSV or Parquet, or a SQL dump, and open that instead.

Can I draw an ER diagram from SQL?

Yes. Paste CREATE TABLE statements (PostgreSQL, MySQL, SQLite or SQL Server) or DBML into an ER diagram, or open the diagram of any database you loaded. Relations come from foreign keys, and columns like user_id are linked to users.id as inferred relations.

Why is my query slow?

Click Explain to see how the database runs it: full table scans, temporary sorts, nested loops and cross products are pointed out. On DuckDB, Analyze runs the query and times every step; on SQLite you get the CREATE INDEX that would help, ready to run.

Can I make charts and dashboards?

Yes. Switch a query result to Chart, pick the chart type and columns, and export it as PNG or SVG, or pin it to a dashboard that re-runs its queries whenever you open it. Notebooks mix SQL, charts and notes and export as an HTML report.

Can I edit data?

Yes. Open a table, double-click a cell (or just type), add or delete rows, then review the generated UPDATE/INSERT/DELETE statements and commit them. A SQLite database can be saved back to the file you opened.

How big can files be?

DuckDB reads files in place, so files of several gigabytes work on a desktop browser; the limit is your device’s memory for what a query needs.

More developer tools

API Studio

Build, test and automate HTTP requests right in your browser.

API Studio: Build, test and automate HTTP requests: collections, environments, tests and a runner.

Diagrams

Draw cloud architectures and watch the data flow.

Architecture Builder: Draw cloud architectures and data flows with AWS, Azure, GCP and 1,000+ components.

CI/CD

See, edit and check your CI/CD pipelines.

Pipeline Studio: See and edit your Bitbucket pipelines as a metro map, with checks for mistakes Bitbucket would reject.

Data

Query, browse and edit data files and SQLite databases.

Database Studio: Query, browse and edit CSV, Excel, Parquet and SQLite files with SQL, right in your browser. Nothing is uploaded.

System Design

Simulate traffic through a system design and find its limits.

System Design Simulator: Design a system, send it traffic and watch where it melts: latency, errors and the bottleneck.

Team Knowledge

Every error your team has hit, and how it was fixed.

Error Memory: Search every error your team has hit and how it was fixed; log new ones with their fix.

Formatters & Beautifiers

Make messy payloads, queries and markup readable.

JSON & Log Formatter: Repair, beautify and deep-decode JSON, Python dicts and log lines.
SQL Formatter: Pretty-print queries for 12 SQL dialects.
XML / HTML Beautifier: Beautify or minify HTML and XML, with validation.
JSON Diff: Compare two payloads side by side or as a change list.
SQL Diff: Compare queries, scripts or schemas as SQL, with schema changes and the migration.
JQ / JSONPath: Filter JSON with jq or JSONPath expressions.

Encoders & Decoders

Look inside tokens, encodings and escaped text.

JWT Debugger: Decode tokens, check expiry and verify HMAC signatures.
Base64 / Hex / Binary: Convert text and files between Base64, hex and binary.
URL / Query Parser: Split, edit and rebuild URLs and query strings.
HTML & Unicode Entities: Encode and decode HTML entities and Unicode escapes.

Generators

IDs, hashes, keys, placeholder text and typed code.

UUID / ULID / Hash: Generate UUIDs and ULIDs; hash text or files.
Lorem Ipsum: Placeholder paragraphs, sentences or words.
RSA / EC Key Pair: RSA and EC key pairs as PEM or JWK, via WebCrypto.
Schema & Code Generator: Turn sample JSON into TypeScript, Zod, Go, Rust, SQL and more.

Converters

Move data between formats, times and color spaces.

Unix Timestamp ↔ Date: Convert Unix timestamps to dates and back.
Color Converter: HEX, RGB, HSL and OKLCH with WCAG contrast checks.
Cron Parser: Explain cron expressions and list upcoming runs.
Format Converter: Convert between JSON, YAML, TOML, XML and CSV.

API & Debugging

Reproduce requests, read errors and sanitise logs.

Log → cURL: Rebuild a runnable cURL from logs, HAR or fetch calls.
HTTP Status Codes: Status codes with causes and fixes.
Payload Redactor: Strip secrets and personal data before you share.
Regex Tester: Test patterns live and explain them token by token.