SQL Runner

Execute SQLite queries entirely in your browser using WebAssembly.

Initializing SQL Engine...
No results to display.

SQL Tips & Reference

Create & Insert

CREATE TABLE users (id INTEGER, name TEXT);
INSERT INTO users VALUES (1, 'Alice');

Filtering Data

SELECT * FROM employees
WHERE salary > 75000
AND department = 'Engineering';

Aggregation

SELECT department, COUNT(*) as emp_count
FROM employees
GROUP BY department;

Table Joins

SELECT e.name, d.name
FROM employees e
JOIN departments d ON e.dept_id = d.id;

About the Online SQL Runner

The SQL Runner is an essential tool for developers, data analysts, and students learning SQL. It allows you to create tables, insert data, and run complex SELECT queries instantly, without installing a heavy database engine.

How to Use

Type your valid SQLite queries in the top text editor and click 'Run Query'. If you are just starting out, click 'Load Example DB' to automatically create a sample schema with some data, so you can practice your SELECT joins right away.

Privacy & Security

This tool uses `sql.js`, a WebAssembly port of SQLite. Your entire database lives in memory directly inside your browser. No queries or data are sent to our servers, guaranteeing 100% data privacy.

Read our Blogpost