SQL Runner
Run SQL against a temporary SQLite database and view every result set.
About this sql runner
The SQL runner executes queries against a temporary in-browser SQLite database, so you can practise SQL or test a query without installing a database or connecting to a server. Create tables, insert rows, and run SELECT statements, and it shows each result set.
It is ideal for learning SQL, working through examples, or sketching a query before running it for real. Each run starts from a fresh in-browser database that is pre-loaded with a small sample `products` table, so you can query something immediately and nothing you do here touches a production system.
Common uses
- Practise SQL queries against a temporary database without any setup.
- Test SELECT statements, joins, and filters on the built-in sample table.
- Sketch and check a query before running it against a real database.
Helpful tips
- A sample `products` table is loaded on every run, so you can SELECT from it right away or create your own tables.
- The sandbox uses SQLite syntax, which differs slightly from other database engines.
- Each run executes against a fresh database, so keep your CREATE/INSERT statements in the same run as the query that uses them.
How to use SQL Runner
- Paste or enter a small code, data, text, URL, or configuration sample before using SQL Runner on a larger task.
- Remove secrets, tokens, private URLs, customer data, and production credentials before testing examples online.
- Run the tool and review the generated code or data for syntax, escaping, formatting, and target-environment compatibility.
- Copy the result into a test file, sandbox, API client, or staging environment before using it in production.
- Use related developer tools when you need to format, encode, decode, minify, inspect, or validate another step.
Frequently asked questions
Which SQL dialect does the runner use?
It runs SQLite in the browser, so use SQLite syntax. Functions and types may differ from MySQL, PostgreSQL, or SQL Server.
Is my data saved between runs?
No. Each run starts from a fresh in-browser database with a small sample table, so it is a safe place to experiment and nothing persists between runs or visits.
Is SQL Runner free, and does it work on mobile?
Yes. SQL Runner is free to use on JustBloc with no account or installation, and the page is designed to work on desktop, tablet, and mobile browsers.