Postgres Playground

How it works

This page loads PostgreSQL itself, compiled to WebAssembly through the PGlite project, and starts it inside your browser tab. When you press Run, your SQL is handed to a genuine Postgres query planner and executor, not a re-implementation. That is why SELECT version() returns a real PostgreSQL 18 build, and why joins, CTEs, window functions, generated columns, JSON operators, and transactions all behave exactly like they do on a server.

Your tables and rows are written to your browser's IndexedDB, so the database is still there when you come back tomorrow. There is no server, no connection string, and no account. You can wipe everything instantly with Reset database.

Why run Postgres in the browser?

It is the fastest way to try an idea. There is nothing to install, no Docker, no brew, no waiting for a cloud instance to spin up. It is ideal for learning SQL, sketching a schema, testing a tricky query before you run it for real, or sharing a reproducible example: paste your setup SQL, copy the share link, and the person who opens it gets the exact same query loaded and ready to run on their own private database.

Things to try

1. Click Load sample dataset for a small store schema, then run the join that is pre-loaded in the editor.
2. Write a window function: SELECT name, price, rank() OVER (ORDER BY price DESC) FROM products;
3. Use a CTE and generate_series to build a numbers table.
4. Create your own tables, insert rows, reload the page, and watch your data still be there.