SQL Playground

Practice SQL locally in your browser

Run queries with an in-memory database powered by AlaSQL. No backend required—perfect for quick experiments or learning the basics.

Quick start guide

Client-side
1

Create database & use it

You are working in a dedicated in-memory database. Switch with USE if you add more.

CREATE DATABASE sandbox; USE sandbox;
2

Create tables

Define your schema before inserting rows. AlaSQL supports most SQL92 column definitions.

CREATE TABLE todos (id INT PRIMARY KEY, title STRING, done BIT DEFAULT 0);
3

Insert sample data

Populate the tables with rows. Multiple statements are allowed in one run.

INSERT INTO todos VALUES (1, 'ship feature', 0), (2, 'write tests', 1);
4

Query & visualize

Run SELECT, JOIN, GROUP BY, and aggregate functions. Results render instantly below.

SELECT title FROM todos WHERE done = 0 ORDER BY id;

SQL Editor

Runs entirely in the browser with AlaSQL. Press Ctrl+Enter to execute.

Loading...
Loading SQL engine...

Schema

No tables yet. Run a CREATE TABLE statement to see it here.

Query Results

Run a SELECT query to see rows here.