How to Run SQLite Online in Your Browser (No Installation)

Sometimes you need to test a SQLite query, inspect a local database file, or reproduce a small SQL example without installing SQLite, opening a desktop client, or connecting to a remote server.

For those cases, you can run SQLite directly in a web browser.

SQLiz provides a free SQLite Playground that runs SQLite locally in your browser. It includes a sample database, lets you execute multiple SQL statements, and can open a local .db, .sqlite, or .sqlite3 file without uploading the database to SQLiz.

Run SQLite online

Open the SQLite Playground and start with the sample query:

SELECT department,
       COUNT(*) AS employee_count,
       ROUND(AVG(salary), 2) AS average_salary
FROM employees
GROUP BY department
ORDER BY average_salary DESC;

Click Run SQL, or press Ctrl+Enter on Windows/Linux or Command+Enter on macOS.

The playground executes the query against a temporary SQLite database and displays the result in a table.

You can edit the query, create tables, insert data, run joins, test common table expressions, use window functions, or execute several statements in one script.

Create your own tables

You do not have to use the included sample schema.

For example:

CREATE TABLE products (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  price REAL
);

INSERT INTO products (name, price)
VALUES
  ('Keyboard', 79.99),
  ('Mouse', 29.99),
  ('Monitor', 249.00);

SELECT *
FROM products
ORDER BY price DESC;

Because this is a real SQLite database running in the browser, normal SQLite DDL and DML statements work as long as they are supported by the embedded SQLite version.

Open a local SQLite database file

If you already have a SQLite database, use Open a local SQLite database file in the playground.

Supported file extensions include:

• .db
• .sqlite
• .sqlite3

The current file limit is 25 MiB.

The selected file is read into browser memory. It is not uploaded to SQLiz.

This is useful when you want to inspect a small local database on a machine where you do not have a SQLite GUI installed.

If the database uses WAL mode, checkpoint and close applications using it before opening the main database file. The playground does not import a separate WAL sidecar file.

Import spreadsheet data

If your data starts in Excel, Google Sheets, CSV, or TSV rather than a SQLite file, use the CSV to SQL Converter.

The converter can generate a SQLite CREATE TABLE statement and batched INSERT statements. You can then send that SQL directly to the SQLite Playground.

For example, this CSV:

id,name,department
1,Ada,Engineering
2,Linus,Platform
3,Grace,Research

can become:

CREATE TABLE employees (
  id INTEGER,
  name TEXT,
  department TEXT
);

INSERT INTO employees (id, name, department)
VALUES
  (1, 'Ada', 'Engineering'),
  (2, 'Linus', 'Platform'),
  (3, 'Grace', 'Research');

Format a query before running it

Long SQL statements are easier to inspect when consistently formatted.

Use the SQL Formatter to format SQLite SQL, then send the formatted query back to the playground.

The formatter changes layout and keyword casing only. It does not validate or execute the query.

Does an online SQLite playground send my database to a server?

The SQLiz playground does not.

SQLite runs through WebAssembly inside your browser. SQL text, local database contents, schemas, and query result values remain in the browser and are not sent to SQLiz.

This is especially useful for quick debugging with local development databases that you do not want to upload to a third-party service.

You should still avoid putting production secrets or sensitive data into any browser tool unless your organization’s policies allow it.

Does the database persist?

No.

The working database is temporary and is cleared when you reload the page.

If you open a database, make changes, and want to keep them, use Download database before leaving the page.

Can I run MySQL or PostgreSQL SQL in the playground?

No.

The playground executes SQLite SQL only. MySQL, PostgreSQL, MariaDB, Oracle, and SQL Server have different syntax and behavior.

You can still use the SQL Formatter for those dialects, but you should run the resulting SQL against the actual target database.

When a browser playground is useful

A browser-based SQLite environment is especially convenient for:

• testing a query from documentation or Stack Overflow
• learning SQL without installing a database
• reproducing a SQLite bug
• opening a small local SQLite database
• checking joins, CTEs, window functions, JSON functions, or date expressions
• converting spreadsheet data to a quick queryable database
• reviewing generated SQL before using it elsewhere

For SQLite function details, see the SQLite function reference.

To start immediately, open the SQLite Playground.