Menu
PDF Tools
Image Tools
Converters & Utilities
Seller & Print Tools
Accounting & Business
Calculators
Text & Writing Tools
Developer & Web Tools
Creator & Social Tools
Browser Utilities & Games
Document & Design Makers
Text & Developer Tools
Exam & Form Tools

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.

How to use Online SQL Editor online

  1. Write the SQL. Or choose an example.
  2. Press Run. Or Ctrl+Enter.
  3. Read the result tables. And the schema.
  4. 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?
No. The database and your files stay in your browser.
Why did my tables disappear?
You pressed Stop, a time limit ended the worker, or you reloaded the page. Save the database file to keep them.
Can I use MySQL or PostgreSQL syntax?
This is SQLite, which differs in places. Most basic SQL works the same.
How do I load my CSV?
Drop the file on the page. The first row becomes the column names.
How many rows are shown?
Up to 1000 rows for each result. Add a LIMIT or a filter to see the rest in parts.

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.

More tools in Developer & Web Tools →

Search tools