About the DuckDB compiler
In-process analytical SQL database. Runs in your browser via WASM. Run DuckDB code in your browser with no install and no signup — the editor, the input and the output share one screen. DuckDB compiles and runs on your own device through WebAssembly, so once the page has loaded it keeps working without a network connection.
Press Run to execute the program, edit it and press Run again, or paste your own code over it. Everything you type stays in the page; the editor caches your work locally so a reload does not lose it.
A DuckDB example
This is the program the DuckDB editor opens with — run it as it is, then change it.
-- DuckDB: Analytical SQL Database
-- Runs entirely in your browser via WebAssembly
-- Create a table and insert data
CREATE TABLE students (
id INTEGER PRIMARY KEY,
name VARCHAR,
score INTEGER,
grade VARCHAR
);
INSERT INTO students VALUES
(1, 'Alice', 95, 'A'),
(2, 'Bob', 87, 'B'),
(3, 'Charlie', 92, 'A'),
(4, 'Diana', 78, 'C'),
(5, 'Eve', 88, 'B');
-- Query with aggregation
SELECT
grade,
COUNT(*) as count,
AVG(score) as avg_score,
MIN(score) as min_score,
MAX(score) as max_score
FROM students
GROUP BY grade
The editor opens with the full program.
More Databases compilers
Browse all 109 languages — the same editor runs each of them, in the browser or on a shared runner.