SQL Playground

A full Postgres compiled to WebAssembly, running entirely in this tab. Write anything — create tables, load data, run EXPLAIN, try window functions or jsonb. Your database lives only in this browser session; “reset database” wipes it clean.

sql · live postgres (wasm)nothing leaves this tab

try:

-- A real Postgres, right here in your browser. Nothing leaves this tab.
-- Write anything — DDL, DML, EXPLAIN, CTEs, window functions, jsonb…

CREATE TABLE IF NOT EXISTS play (id serial primary key, name text, score int);
INSERT INTO play (name, score) VALUES ('ada', 90), ('linus', 85), ('grace', 95);

SELECT name, score,
       rank() OVER (ORDER BY score DESC) AS rank
FROM play
ORDER BY rank;

-- A real Postgres, right here in your browser. Nothing leaves this tab.
-- Write anything — DDL, DML, EXPLAIN, CTEs, window functions, jsonb…

CREATE TABLE IF NOT EXISTS play (id serial primary key, name text, score int);
INSERT INTO play (name, score) VALUES ('ada', 90), ('linus', 85), ('grace', 95);

SELECT name, score,
       rank() OVER (ORDER BY score DESC) AS rank
FROM play
ORDER BY rank;

⌘/Ctrl + Enter