DuckDB is an in-process, columnar analytical database designed for fast OLAP queries. It supports rich SQL, vectorized execution, window functions, and complex aggregations.
Use this playground to test DuckDB analytical SQL, generate_series, CTEs, joins, and aggregations. This page uses the native hosted DuckDB CLI—not DuckDB-Wasm.
This page sends your script to a hosted, network-isolated DuckDB 1.5.5 runtime. Every Run executes the whole editor contents against a fresh database, then discards its database state and files. It does not run the database in your browser and it never connects to your own database.
Available output: HTML result tables, DuckDB text, CSV, and native JSON. The schema panel shows a bounded catalogue captured after successful execution. Large output may be truncated, and package installation, remote network access, persistent storage, and external database connections are not supported.
Build a DuckDB script in the editor with syntax highlighting and editor assistance.
Run the complete script against a fresh isolated database sandbox.
Review rows, messages, errors, and execution time in the results panel.
Your draft stays in this browser, and Share creates a separate snapshot link.
WITH values AS (
SELECT n, n * n AS squared
FROM generate_series(1, 5) AS t(n)
)
SELECT count(*) AS rows, sum(squared) AS total
FROM values;The editor uses Monaco, the engine behind VS Code, with language-aware editing tools and familiar keyboard controls.
Write your query in the editor, then click Run (or press Ctrl/Cmd + Enter) to execute it.
Results appear instantly in the output panel below, along with any errors and how long the query took.
Nothing to install and no account to create — queries run in a hosted, isolated database sandbox.
Smart autocomplete and syntax highlighting for your query language
Real-time error underlines, bracket matching, and code folding
Multi-cursor editing plus find & replace (Ctrl/Cmd + F)
One-click formatting to tidy up long queries
Copy to clipboard and download your script
Built on Monaco — the same editor that powers VS Code
Run the whole editor script and see its native results
Output shows returned rows, messages, errors, and execution time
Start from a clean database every run, so experiments never clash
Switch between light and dark themes
Adjust font size and other editor settings
Toggle side-by-side or top/bottom layouts
Enter distraction-free fullscreen mode
Generate a shareable link to your exact query in one click — no login needed
Your work autosaves to your browser, so you can pick up where you left off
Copy your query to the clipboard or download it as a file
Run query: Ctrl/Cmd + Enter
Find & replace: Ctrl/Cmd + F
Open the full shortcut list from the keyboard icon in the toolbar