Is my data uploaded anywhere?

No. The SQL engine is SQLite compiled to WebAssembly and it runs entirely inside your browser tab. Your queries, your results, and any database file you open stay on your device. There is no server to send them to.

Which SQL dialect does this use?

SQLite. Most standard SQL works unchanged, but MySQL and PostgreSQL differ in places, including data types, some functions, and AUTO_INCREMENT versus AUTOINCREMENT. Practise the concepts here and check your target database's documentation for exact syntax.

Can I use my own database file?

Yes. Select Open .db file and choose any SQLite file up to 50 MB. It is read inside your browser and never uploaded.

Are my changes saved?

Yes. After each successful query the database is saved in your browser's storage, so you can close the tab and come back to your work later.

I dropped a table by mistake, how do I undo it?

Use Reset database to restore the current sample database to its original state, or Reset all to restore every sample database at once.

Why was my query stopped after 5 seconds?

A query that runs longer than that is almost always an accidental cross join producing an enormous result. The engine is stopped and restarted so the page stays usable. Add a WHERE clause or a LIMIT and try again.

Why does it only show 1,000 rows?

Displaying more would freeze the page. The true row count is always reported above the table, so SELECT COUNT(*) still gives you the real number.

Does it work offline?

Yes, once the page and the engine have loaded. Nothing it does requires a network connection.

Can I practise INSERT, UPDATE and DELETE?

Yes. Every SQL statement SQLite supports works here, including CREATE, INSERT, UPDATE, DELETE and DROP. That is the point of a sandbox: you can break things safely and reset.

What are the sample databases?

Classroom is three tables (28 columns) for basic queries and a first join. Bookshop is six tables (50 columns) for multi-table joins, grouping and aggregates. Sensors is four tables (38 columns) holding a time series for window functions and date handling. All three mix text, integers, decimals, dates, booleans and NULLs so you can practise realistic filtering.

Yes, and there is no signup. Nothing is stored on a server because there is no server.

Does it work on mobile?

Yes. On a phone the tool shows three tabs, Query, Schema and Results, so the editor is not squeezed. The draggable panel layout is a desktop feature.

SQL Playground - Practice SQL Online in Your Browser

Overview

Practice SQL in Your Browser

The SQL Playground provides a fully functional SQLite environment directly in your browser. Run real SQL queries against sample databases entirely in your browser without uploading anything to a backend server. Your queries, results, and uploaded databases remain completely private on your local machine.

Sleek modern SQL editor interface showing a SELECT query being typed

This tool is ideal for developers, data analysts, and students who want to quickly test queries, analyze data sets, or practice SQL without the hassle of setting up a local database server. Simply write your SQL commands, hit run, and view the results instantly.

It is a practice sandbox using SQLite. MySQL and PostgreSQL differ in some syntax, so check your target database's documentation before depending on a query in production.

Features

From First SELECT to Window Functions

The Classroom database has three tables, students, courses and enrollments, which is enough to learn SELECT, WHERE, ORDER BY and your first JOIN without getting lost. Its columns cover text, integers, decimals, dates, booleans and NULLs.

Database schema visualizer showing table relationships and columns

The Bookshop database adds authors, books, customers, orders, order items and stock, so you can practise multi-table joins, GROUP BY, aggregates such as SUM and COUNT, HAVING, and subqueries against data that behaves like a real shop.

The Sensors database holds a time series of readings from six devices, with temperature, humidity, pressure, battery level and signal strength, perfect for window functions such as LAG and ROW_NUMBER.

Guide

How to Use the SQL Playground

Writing and Executing Queries

Type your SQL in the Query Editor. In Terminal Mode, press Enter to run the statement (Shift+Enter for a new line); in Script Mode, write several statements separated by semicolons and press Ctrl+Enter, or click the "Run" button, to execute them.

Data table showing query results with elegant dark theme UI

Terminal Mode always runs the full statement, and Script Mode always runs the full script — there's no way to select and run just part of the editor's contents. To run only one statement out of several, delete or comment out the others, or switch to Terminal Mode for that one query.

Managing Databases

You start with a default sample database. To work with your own data, use the "Open .db file" button to load an existing SQLite (.sqlite, .db) file — up to 50MB. Your uploaded databases are securely saved in your browser's IndexedDB so they persist across sessions.

Viewing Schema and History

The Schema panel automatically updates to show the tables, columns, and data types in your current database. The History panel keeps a log of all successfully executed queries, making it easy to rerun previous commands.

Still have questions?

If you can't find the answer you're looking for, feel free to contact our support team.

Contact Us

SQL Playground

Are you sure?

Privacy Focused

Instant Results

No Signup

Browser Based

Practice SQL in Your Browser

From First SELECT to Window Functions

How to Use the SQL Playground

Still have questions?