Online SQLite Compiler
Run SQL online with SQLite 3.46. Write a script that creates tables, inserts rows and queries them, press Run, and the results appear beside your code. Each run starts with a new, empty database in memory, so a script has to create everything it uses.
How to run SQLite code online
- This page opens with SQLite selected, so you can start typing straight away.
- Write your code in the editor, or open files from your computer: single files, or a whole project as a .zip.
- Press Run, or Ctrl+Enter. The output appears in the panel beside the editor, and when the program asks for input you type it there and press Enter.
- Share a copy with a link, or save your files to your computer.
SQLite 3.46 on Online IDE
- Your script runs in the sqlite3 shell against a new, empty database that lives in memory, so create your tables in the script itself.
- Nothing is kept between runs. Put the CREATE TABLE and INSERT statements in the script every time.
- End each statement with a semicolon. A mistake shows SQLite's error message with the line number, and the statements after it still run.
- Dot commands such as .headers on and .mode column work, and change how results are printed.
- The script is what SQLite reads, so it cannot ask for input while it runs.
Example: a table and a query
CREATE TABLE scores (name TEXT, points INTEGER);
INSERT INTO scores VALUES ('Ada', 92), ('Linus', 85), ('Grace', 97);
.headers on
.mode column
SELECT name, points FROM scores ORDER BY points DESC;
SELECT AVG(points) AS average FROM scores;Features of this tool
- Simple and fastA clean, lightweight editor that opens instantly.
- Powered by AceThe Ace code editor, with syntax highlighting, autocompletion and bracket matching.
- Interactive programsType input into the terminal while your program runs.
- Several filesWork in tabs, open files or a .zip from your computer, and save the project back to disk.
- Made for learningHelpful for beginners to learn and practice programs.
- Light and dark themesPlus 39 editor themes, a choice of coding fonts, and Vim, Emacs or VS Code keys.
- Keep your outputCopy or download the program output in one click.
- Share by linkSave your code in the cloud and open it anywhere.
Frequently asked questions
Which SQLite version does Online IDE use?
SQLite 3.46, run with the sqlite3 command-line shell on Linux.
Is my data saved between runs?
No. Each run starts with an empty in-memory database, so the script has to create its tables and insert its rows every time.
Can I use MySQL or PostgreSQL syntax?
Only what SQLite supports. It has its own dialect, so features such as stored procedures and some data types differ from MySQL and PostgreSQL.
Why does the script not ask me for input?
The script itself is what SQLite reads, so there is nothing left to type. Put the values you want to try into the INSERT or WHERE clauses.
Contact us
For any feedback, queries or issues, please feel free to contact us or write to . We value your input and are committed to providing the best possible experience for our users.