SQL Playground

Run SQLite queries entirely in your browser - no server, no install. Powered by sql.js (WebAssembly).

Initializing…

About this tool

Run SQLite queries directly in your browser - no installation, no server, no account. Powered by sql.js (WebAssembly), the playground gives you a full SQLite database that lives in memory. Write SQL to create tables, insert data, and run complex SELECT queries with JOINs, GROUP BY, and window functions, then see results in a formatted table instantly.

How to Use the SQL Playground

1The editor loads with an example that creates a table, inserts rows, and runs a GROUP BY query.
2Modify the SQL or replace it entirely with your own queries.
3Press 'Run SQL' to execute. Results appear as a formatted table below.
4DDL and DML statements (CREATE, INSERT, UPDATE, DELETE) return no rows - this is expected.
5Click 'Reset example' to restore the starter SQL, or 'Clear DB' to wipe the in-memory database.

Frequently Asked Questions

Is this a real SQL database?+

Yes. It uses SQLite via sql.js compiled to WebAssembly, giving you the full power of SQLite including CREATE, INSERT, UPDATE, DELETE, and complex SELECT statements.

Does my data persist between sessions?+

No. The database lives in browser memory and is cleared when you close or refresh the tab. For persistent data, you'll need a real database server.

Which SQL features are supported?+

All SQLite-supported SQL: CREATE TABLE, INSERT, SELECT with JOINs, GROUP BY, HAVING, ORDER BY, subqueries, CTEs (WITH), and most standard functions.

Can I import data from a CSV or existing database?+

Not directly in this tool. You can paste INSERT statements to load data manually. To import CSV, convert it to INSERT statements first using a CSV-to-SQL tool.

Looking for a deeper guide on this topic? Browse the Searchlight blog.

Visit the blog →

Related tools

View all Code Tools →