PostgreSQL Playground
Production SQL — real Postgres in the browser
Run actual PostgreSQL via PGlite WASM — ILIKE, JSONB, SERIAL, RETURNING, and window functions. What you'll use at work, not just SQLite.
What you get when you open PostgreSQL Studio.
Real Postgres dialect
JSONB, ILIKE, and window functions via PGlite
Schema browser
Click a table to seed SELECT * FROM … LIMIT 20
Result grid
Markdown-table results with row counts and run history
⌘/Ctrl+Enter
Run the active query from the editor or the toolbar
Data panel
Local/cloud uploads (CSV; SQLite .db where supported)
Opens in the PostgreSQL Studio workspace.
-- sales.csv is auto-loaded from the Data panel
SELECT region,
COUNT(*) AS orders,
SUM(revenue::numeric) AS total_revenue
FROM sales
GROUP BY region
ORDER BY total_revenue DESC;