SQL Playground (In-Browser SQLite)
Run SQL right in your browser against an in-memory SQLite database. A sample employees and departments dataset is preloaded so you can query immediately, or open your own .sqlite/.db file. Everything stays on your device.
How to run SQL in the browser
- Wait for SQLite to load, then use the preloaded sample database.
- Type a query in the editor and press Run (or Cmd/Ctrl+Enter).
- Read the results table, or click a table name to browse its rows.
- Optionally load your own .sqlite file, then download the database when done.
Examples
Select rows
SELECT * FROM employees LIMIT 3;
Returns the first three rows of the employees table.
Aggregate with a join
SELECT d.name, COUNT(*) FROM employees e JOIN departments d ON d.id = e.department_id GROUP BY d.name;
Headcount per department.
Frequently asked questions
Is my data uploaded anywhere?
No. The database runs entirely in your browser using SQLite compiled to WebAssembly. Your queries and any file you open never leave your device.
What SQL does it support?
It is real SQLite, so standard SELECT, INSERT, UPDATE, DELETE, JOIN, GROUP BY, window functions, CTEs and PRAGMA all work.
Can I load my own database?
Yes. Use the load option to open a .sqlite or .db file. It opens locally, and you can run queries against it or export it back out.
Do my changes persist after I reload the page?
No. The database lives in memory, so a refresh resets it. Download the database first if you want to keep your changes.
Why does the first query take a moment?
The SQLite WebAssembly engine downloads once on first use. After it loads, queries run instantly on your device.
Related tools
JSON to SQL
Convert JSON to SQL INSERT statements online. Paste an array of objects, set a table name, and get ready-to-run INSERTs. Runs in your browser.
CSV to JSON
Convert CSV to JSON online. Turn spreadsheet rows into clean JSON objects or arrays, with smart number and boolean typing. Free tier plus API.
SQLite Viewer
Open a .sqlite or .db file in your browser and browse its tables, schema and rows. Run read-only SQL queries. Your data never leaves your device.
.env to JSON
Convert a .env file to JSON, or JSON back to .env. Parses KEY=value lines, comments, quotes and export. Runs entirely in your browser.
Aspect Ratio Calculator
Calculate aspect ratios fast. Enter a ratio like 16:9 and one dimension to get the other, or enter width and height to simplify the ratio.
Base58 Encoder
Encode and decode Base58 online with the Bitcoin alphabet. Convert text to Base58 or back, UTF-8 safe, no confusing 0 O I l. Runs in your browser.