Reading data
SELECT choose columns and expressions FROM choose where data comes from WHERE keep only matching rows ORDER BY sort the result LIMIT limit how many rows are shown DISTINCT return unique values SQL Online
SQL SQL Online
Loading SQLite
SQLite
Online Store.sqlite
Queries and data stay in your browser.
SQL query
This tool uses SQLite. Queries from MySQL, PostgreSQL, and other databases may need small changes.
SQL
Results
SQLite is loading. When it is ready, click Run and the result will appear here.
⛁
Structure
Tables and columns from the active database will appear here after the schema loads.
↻
History
History is empty. Queries you run will be saved here in this browser.
Ready-made examples
Click an example to put the query into the editor.
SQLite cheatsheet
A short guide to common SQLite keywords. Other databases may use different syntax.
Joins and totals
JOIN connect tables LEFT JOIN keep all rows from the left table GROUP BY group rows together HAVING filter grouped rows COUNT, SUM count rows and add values AVG, MIN, MAX average, minimum, and maximum Changing data
INSERT add rows UPDATE change existing rows DELETE delete rows CREATE TABLE create a table ALTER TABLE change table structure DROP TABLE delete a table More SQL
WITH create a temporary result for one query CASE add conditional logic COALESCE pick the first non-empty value UNION combine result sets EXISTS / IN check against another query BEGIN / COMMIT start and save a transaction FAQ
Short answers about features, limits, and privacy.
It is a SQL editor that runs in your browser. It is useful for learning, quick checks, and working with separate SQLite databases.
No. SQLite runs directly on the page. The example database is created automatically, and you can create or import your own databases.
This tool uses SQLite. Its syntax differs from MySQL, PostgreSQL, SQL Server, and Oracle.
Yes. Use Import to open .sqlite, .sqlite3, .db, .sql, and .csv files.
No. Queries, databases, and results stay in your browser.
Different databases use different functions, data types, and service commands. You may need to adapt that query for SQLite.
Click Download database to save the current SQLite database as a file. Important data should be downloaded manually.
Databases are saved in the browser with IndexedDB. Private mode or clearing browser data can remove them, so download important databases as files.
Place the cursor inside the statement you want and click Run. To run the whole editor content, click Full script.
Yes. The example database, ready-made queries, schema, and cheatsheet help you practice SELECT, JOIN, GROUP BY, inserts, updates, and transactions.
About SQL Online
SQL Online is a SQL editor that runs in your browser. It helps you quickly check a query, walk through a course example, or practice JOIN, GROUP BY, subqueries, and CTEs without installing a database. The tool currently uses SQLite, a lightweight SQL engine that works well for learning, local experiments, and small files.
The workflow is simple: choose a database, write a query, and click Run. If you select part of the text, only the selection runs. If nothing is selected, the statement under the cursor runs. Full script runs everything in the editor. Results appear as a table, execution messages have their own tab, and the database schema stays visible on the left.
What you can do
You can read data with SELECT, filter rows with WHERE, sort with ORDER BY, limit output with LIMIT, connect tables with JOIN, and group data with GROUP BY. You can also try INSERT, UPDATE, and DELETE, create tables with CREATE TABLE, change structure with ALTER TABLE, and test transactions with BEGIN, COMMIT, and ROLLBACK.
Why SQLite
SQLite can run directly in the browser without a separate server. That makes the tool quick to open: the example database is ready, and the result appears next to the query. SQLite is still its own SQL dialect, so a query that works here may need changes for MySQL, PostgreSQL, SQL Server, or Oracle.
Your databases and imports
You can open your own SQLite file with a .sqlite, .sqlite3, or .db extension. SQL scripts are imported when they are compatible with SQLite, and CSV files can be loaded as tables. Before importing CSV, check the delimiter, column headers, and data types. Download important databases after editing them because browser storage can be cleared.
Common mistakes
Most errors come from typos in table or column names, missing JOIN conditions, unsupported functions, or very broad queries without filters. MySQL dumps with AUTO_INCREMENT and ENGINE usually need to be adapted for SQLite. Before DELETE, UPDATE, or DROP, download a copy of the database and inspect the data with SELECT first.
Privacy
Queries, databases, and CSV files are processed in your browser. A share link can include a small query text, but not the database itself or the execution result. This is useful for learning and demos, but it is not a secure data vault: avoid uploading secrets or confidential data without separate protection.