Anton V.
Projects and blogs
Software dev
Databases
SQL
SQL Playground

SQL Playground

About the tool

The Structured Query Language (SQL) is a language used to manage data held in relational databases.

This tool allows you to create a relational database and query it entirely in the browser using SQL.

The tool uses the sql.js library (a WASM port of the SQLite database engine) and provides a SQL query editor with syntax highlighting for creating and querying tables.

The database does not persist data between sessions or send it to the server.

Demo

SQL query

DROP TABLE IF EXISTS books;

CREATE TABLE books(id INT, name TEXT, author TEXT, year INT);

INSERT INTO books VALUES (1,'The Lord of the Rings','J.R.R. Tolkien',1954);
INSERT INTO books VALUES (2,'The Hobbit','J.R.R. Tolkien',1937);
INSERT INTO books VALUES (3,'Harry Potter and the Philosopher''s Stone','J.K. Rowling',1997);
INSERT INTO books VALUES (4,'Harry Potter and the Chamber of Secrets','J.K. Rowling',1998);

SELECT * FROM books ORDER BY year;

SELECT * FROM books WHERE author = 'J.R.R. Tolkien';1
DROP TABLE IF EXISTS books;
2

3
CREATE TABLE books(id INT, name TEXT, author TEXT, year INT);
4

5
INSERT INTO books VALUES (1,'The Lord of the Rings','J.R.R. Tolkien',1954);
6
INSERT INTO books VALUES (2,'The Hobbit','J.R.R. Tolkien',1937);
7
INSERT INTO books VALUES (3,'Harry Potter and the Philosopher''s Stone','J.K. Rowling',1997);
8
INSERT INTO books VALUES (4,'Harry Potter and the Chamber of Secrets','J.K. Rowling',1998);
9

10
SELECT * FROM books ORDER BY year;
11

12
SELECT * FROM books WHERE author = 'J.R.R. Tolkien';

The SQL query to execute.

Output

Click Execute to run SQL.

SQL Playground

About the tool

Demo

See also