SQL Playground
Full PostgreSQL & SQLite in your browser. Persistent database, 18+ extensions including pgvector, database explorer with pagination. Practice SQL with real databases.
The Most Feature-Rich SQL Playground Online
This isn't just another SQL playground. We run full PostgreSQL in your browser via WebAssembly. Your data persists in IndexedDB, so you can close the tab and come back later. Browse tables with our Database Explorer, export your database with pg_dump, or use advanced extensions like pgvector for AI. All 100% local, no server needed.
What Makes This Playground Special
Real PostgreSQL via PGlite. JSON, arrays, window functions, CTEs.
Data saved to IndexedDB. Your tables survive page refresh.
pgvector, pg_trgm, hstore, uuid-ossp, ltree, cube, and more.
Browse tables, preview data with pagination, view row counts.
pg_dump export, SQL import. Backup and restore databases.
Vector similarity search for embeddings. Build AI apps locally.
Sample Databases for Practice
A digital music store with artists, albums, tracks, customers, and invoices. Great for practicing JOINs and aggregations.
Classic e-commerce database with products, orders, customers, and employees. Perfect for business analytics queries.
SQL Topics You Can Practice
- PostgreSQL syntax: JSON, arrays, window functions, CTEs
- Vector search: Use pgvector for AI embeddings
- Full-text search: pg_trgm, unaccent, fuzzystrmatch
- Data modeling: Create tables, indexes, constraints
- Aggregations: GROUP BY, HAVING, window functions
- JOINs: INNER, LEFT, RIGHT, FULL OUTER, CROSS