Online SQL Editor
Write SQL and run it on a real SQLite database inside your browser. Import a CSV as a table, see the results as tables, export them, and stop a query that runs too long.
- Free, no sign-up
- Files stay on your device
- Worldwide
- 20 MB, one file
- .csv .tsv .txt .sqlite .db
How to use Online SQL Editor online
- Write the SQL. Or choose an example.
- Press Run. Or Ctrl+Enter.
- Read the result tables. And the schema.
- Export or save. CSV, JSON or the database file.
Why use this free Online SQL Editor
- Real SQLite
- Import CSV
- Stop button
- No account or sign-up needed
- Works on phone, tablet and computer
SQLite in a browser tab
This page runs SQLite, the database engine built into phones and many programs, compiled to WebAssembly. You write SQL, press Run and see the results as tables. The database lives in your tab: it has no connection to any server, no access to files and no network, so you can try anything without risk to real data.
What you can do
Create tables, insert rows, join, group, use window functions, recursive queries and the JSON functions of SQLite. Several statements can be run together and each result is shown in its own table; a statement that changes rows reports how many it changed. If one statement has an error, the earlier results stay and the page tells you which statement failed.
Import and export
Drop a CSV or tab-separated file on the page and it becomes a table, with the first row as column names and column types guessed from the values. Drop a .sqlite file to open a database. Copy or download any result as CSV or JSON, and save the whole database as a file to keep your work.
Time limit and Stop
A query that never ends can freeze a page, so the database runs in a background worker. Press Stop, or wait for the time limit you chose, and the worker ends. Because the database lives in that worker, a stop starts a fresh empty database, and the tables you made are lost, so save the file first if it matters.
Limits to know
Files of up to 20 MB can be imported or opened, and each result shows up to 1000 rows. The first run downloads about one megabyte of files from this site, which your browser keeps. This is SQLite, so some features of other database systems, such as stored procedures and users, do not exist. A share link holds the SQL text only.
Online SQL Editor: frequently asked questions
Is my data sent to a server?
Why did my tables disappear?
Can I use MySQL or PostgreSQL syntax?
How do I load my CSV?
How many rows are shown?
Related searches for Online SQL Editor
- Online SQL Editor online
- free Online SQL Editor
- Online SQL Editor online free
- Online SQL Editor without watermark
- Online SQL Editor no upload
- Online SQL Editor for mobile
- Online SQL Editor without sign up
- Online SQL Editor – Developer & Web Tools
Online SQL Editor is a free online tool on MAITBOX, in the Developer & Web Tools group. It runs in your browser, so your files stay on your device and are not uploaded. Accepted formats: CSV, TSV, TXT, SQLITE, DB. Limit: 20 MB per file. No watermark is added to the result. It works on Android and iPhone, and on Windows, Mac and Linux, with no download and no account.