Skip to content
Numio

Online SQL Editor (SQLite) — Numio

Write and run SQL online with SQLite. Create tables, insert data and see SELECT results as tables. Free, runs in your browser, no setup.

Runs in your browser · No sign-up

Code (SQL)

Ctrl/⌘ + Enter to run

Output

Code runs locally in your browser; it is not uploaded.

How to use

  1. Write SQL statements separated by semicolons.
  2. Create tables and insert sample data in the same script.
  3. Press Run to see each SELECT result as a table.

Example

-- SQLite example
CREATE TABLE fruits (name TEXT, price REAL);
INSERT INTO fruits VALUES ('Apple', 1.2), ('Banana', 0.5), ('Cherry', 3.0);
SELECT name, price FROM fruits WHERE price > 1 ORDER BY price DESC;

Details and limitations

Powered by SQLite (sql.js). A new in-memory database is created on every run, so nothing is kept between runs.

It uses the SQLite dialect, so some MySQL- or PostgreSQL-specific features are not available. Each result shows up to 1,000 rows.

FAQ

Is my data saved?

No. The database lives in memory and is recreated on each run. Include your CREATE and INSERT statements in the script.

Can I run multiple queries?

Yes. Run several statements at once; each SELECT gets its own result table.

Is this MySQL or PostgreSQL?

Neither. It is SQLite. Standard SQL works, but database-specific syntax may differ.

Format references

Tool page updated: