How to use Online SQL Compiler
- Type or paste your program into the editor, or pick one from the Examples list.
- Press Run (or Ctrl+Enter). The output appears under the editor, together with the run time.
- Use Stop if a program never ends. Use Copy code or Download to keep your work.
What is it good for?
Run SQL online with a real SQLite database in your browser. Create tables, insert rows, JOIN, GROUP BY and see results as a table. Free.
Nothing has to be installed or configured. The language runs inside your browser, so it is a quick way to test an idea, finish homework or practise for an interview on any device. People most often reach for it when teaching a class where students cannot install software, trying a snippet before putting it into a project and learning a new language from a phone or a borrowed computer.
See it in action
Here is a small program and what it prints.
About SQL
SQL is the standard language for databases. Learning SELECT, JOIN and GROUP BY is one of the most useful skills for analysts, developers and testers.
This online SQL compiler runs SQLite compiled to WebAssembly. Write several statements separated by semicolons, press Run, and every SELECT shows as a neat table with a row count.
Each run starts from a fresh empty database, so a script should create its own tables and data. Nothing is uploaded or saved on a server. SQLite syntax is close to standard SQL, with small differences from MySQL or PostgreSQL such as AUTOINCREMENT and flexible column types.
What works and what does not
- Runs in your browser, with no sign-up and no limit on runs.
- Your code and input stay on your device.
- No network access and no files outside the program itself.
- Press Stop to end a program that loops forever.
More example programs
JOIN and GROUP BY
Date and text functions
Other online compilers
Online C Compiler, Online C99 Compiler, Online C11 Compiler, Online C17 Compiler, Online C23 Compiler, Online C++ Compiler, Online C++11 Compiler, Online C++14 Compiler, Online C++17 Compiler, Online C++20 Compiler, Online C++23 Compiler, Online Python Compiler.
Using it day to day
If something does not look right, reload the page and try again with a simple example. That tells you quickly whether the issue is the input or the setup.
Use the copy and download buttons where they appear. They save you from selecting text by hand, which is easy to get wrong on a phone.
Privacy
Your program is compiled and run inside your browser. The code and its input are never uploaded to a server.
Frequently asked questions
Is Online SQL Compiler free to use?
Yes, completely free. There is no sign-up, no watermark and no limit on how many times you use it.
Is my data safe when I use Online SQL Compiler?
Your program is compiled and run inside your browser. The code and its input are never uploaded to a server.
Does Online SQL Compiler need to be installed?
No. It runs entirely in your browser using WebAssembly or JavaScript. The first run of some languages downloads the engine once and your browser keeps it for next time.
Can I give input to my program?
This language does not read keyboard input here, so put your data directly in the program.
Why does it not support Java, Go or Rust?
Those compilers are too large or too dependent on a server to run inside a web page without sending your code elsewhere. This page only lists languages that can run fully in your browser, so your code stays private.
Does Online SQL Compiler work on my phone?
Yes, but a keyboard makes coding easier. C and C++ need about 100 MB of free memory the first time the compiler loads, so older phones may be slow.
Any tips for using Online SQL Compiler?
A new empty in-memory SQLite database is created on every run, so include CREATE TABLE and INSERT statements in your script.