Free tool
SQL Playground
Write SQL and run it against a real SQLite database, right here in your browser. Two sample tables are already loaded, so you can run a query the moment the page finishes loading. Nothing to install, nothing uploaded.
A real database, running in the browser
This is not a mock or a syntax check. It is SQLite compiled to WebAssembly, running inside the page, executing your queries the same way a local database would. When a query returns rows, those rows came from a genuine SQL engine, not a lookup table of canned answers.
Because the whole engine lives in the tab, there is no round trip to a server and no account to create. You get the immediacy of a scratchpad with the accuracy of the real thing, which makes it a good place to check a query before you run it somewhere that matters.
Two tables, ready to join
The playground loads with a users table and an orders table, linked by user_id. That pairing is enough to practise the parts of SQL people reach for most: a JOIN across the two tables, a GROUP BY to roll orders up per user, and an aggregate like COUNT or SUM to total them. The starter query does exactly that, so you can read it, run it, and change it.
You are not limited to the sample data. Run your own CREATE TABLE and INSERT statements and they persist for the rest of the session, so you can rebuild a schema you are working on and try queries against it. Reloading the page resets everything to the starting point.
Private by default
Since the database runs in your browser, your queries and any data you paste in stay on your machine. Nothing is sent to a server, so you can experiment freely. Close the tab and it is all gone.
The engine is SQLite, which is a fully featured SQL database in its own right. Most of what you write here, from window functions to common table expressions, is standard SQL that carries over to PostgreSQL and MySQL, with the usual differences in a few functions and types.
Frequently asked questions
- What is this SQL playground?
- It is a free online SQL editor with a real SQLite database running inside your browser. You can write queries and run them instantly against sample tables, with no server, no install, and no account. It is a fast way to test an idea or practise SQL.
- Which SQL does it run?
- The engine is SQLite, so the playground supports the SQLite dialect. That covers SELECT, INSERT, UPDATE, DELETE, JOINs, GROUP BY, subqueries, common table expressions, window functions, and the standard SQLite built-in functions.
- What data can I query?
- Two sample tables are loaded for you: a users table and an orders table linked by user_id. That is enough to practise joins and aggregates right away. You can also run CREATE TABLE and INSERT to build your own tables in the same session.
- Can I change the data?
- Yes. The database is yours for the session, so INSERT, UPDATE, DELETE, and CREATE all work. Reload the page to reset back to the original sample tables.
- Is my SQL or data sent to a server?
- No. The database lives entirely in your browser tab through WebAssembly, so your queries and any data you add never leave your machine. Nothing is uploaded or saved once you close the tab.
- Do I need to install anything?
- No. The playground loads in the browser with nothing to download and no sign-up. When you want to connect to your own PostgreSQL, MySQL, or SQLite database, that is where a desktop client like DB Pro comes in.
More free tools
Ready for your own database?
This playground is great for a quick query against sample data. When you want to run SQL against your own database, DB Pro gives you the same editor experience connected to the real thing. It is a desktop client for macOS, Windows, and Linux that works with PostgreSQL, MySQL, SQLite, and more, with autocomplete, a data browser, and saved connections.
Prefer to keep practising? Browse the free tools or work through the SQLite cheat sheet.