Sign InSign Up

SQL Playground

Full PostgreSQL & SQLite in your browser. Persistent database, 18+ extensions including pgvector, database explorer with pagination. Practice SQL with real databases.

Loading SQLite...

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

PG
Full PostgreSQL

Real PostgreSQL via PGlite. JSON, arrays, window functions, CTEs.

DB
Local Persistence

Data saved to IndexedDB. Your tables survive page refresh.

18+
Extensions

pgvector, pg_trgm, hstore, uuid-ossp, ltree, cube, and more.

EX
Database Explorer

Browse tables, preview data with pagination, view row counts.

IO
Export & Import

pg_dump export, SQL import. Backup and restore databases.

AI
pgvector for AI

Vector similarity search for embeddings. Build AI apps locally.

Sample Databases for Practice

Chinook
Music Store Database

A digital music store with artists, albums, tracks, customers, and invoices. Great for practicing JOINs and aggregations.

Northwind
E-commerce Database

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
SQL Compiler

Run SQL queries online with schema browser and export options

Python Compiler

Learn Python with interactive code execution and visualization