DuckDB Online Compiler

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.