Online compiler

SQL online compiler

Write SQL (SQLite 3) code below and run it, with input, in a sandbox on our servers. No sign-in, no ads. The same compiler is an API and an embeddable editor, for running SQL in your own app, course or docs.

By the OnlineCompiler.io team. Updated .

What runs your code

VersionSQL SQLite 3
Compiled withNo separate step: the run command compiles or interprets it
Run withsqlite3 -batch -bail < code.sql
Limits30 seconds, 512 MB of memory, 2 CPUs, 64 KB of output per stream, no network

Good to know

  • Each run starts with an empty in-memory SQLite 3.46 database: create your tables, fill them and query them in one program. A run stops at the first error.
  • Results print in SQLite's list mode, columns separated by |. Dot commands work, so .mode box or .headers on change the format.
  • The Input tab isn't read as SQL, but readfile('input') returns it.

Run SQL from your own code

Send the code and its input to the sync endpoint with an API key, and the output comes back in the response. The API docs cover the async endpoint with callbacks and every response field.

Terminal
curl -X POST https://api.onlinecompiler.io/api/run-code-sync/ \
  -H "Authorization: YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "compiler": "sqlite-3",
    "code": "SELECT '\''Hello, '\'' || rtrim(readfile('\''input'\''), char(10)) || '\''!'\'';",
    "input": "Ada"
  }'

The response has output ("Hello, Ada!\n" here), error, exit_code, time and memory.

Put a runnable SQL example on your site

The editor above is the embeddable widget. Add the script and a div with your widget key, and your readers can edit and run the code without an account:

example.html
<script src="https://onlinecompiler.io/widget.js"></script>

<div class="runcode" data-key="YOUR_WIDGET_KEY" data-lang="sqlite-3">
  <script type="text/plain">
    SELECT 'Hello, ' || rtrim(readfile('input'), char(10)) || '!';
  </script>
</div>

On a platform that takes an iframe but not a script, such as many course sites, use the iframe embed. For Docusaurus, MkDocs, Sphinx and Mintlify, see runnable code examples in docs.

Other languages

Python, C, C++, Java, C#, F#, Go, Rust, PHP, Ruby, Haskell, TypeScript, JavaScript, Bash, Fortran, Visual Basic, Kotlin, R.

Frequently asked questions

Is this SQL online compiler free?

Yes. Running SQL on this page needs no account and shows no ads. To run SQL from your own app or site, the API and the widget are free up to 100,000 runs a month, commercial use included.

Can my SQL program read input?

Yes. Type it in the Input tab before you run, and the program reads it with readfile('input'), since standard input carries the SQL itself. The whole input is sent when you press Run, so a program can't ask for more while it runs.

Can I use SQL libraries?

SQLite's built-in functions, including the JSON and maths functions. There is no MySQL or PostgreSQL, and programs have no network access.

How long can a program run?

Up to 30 seconds, with 512 MB of memory and 2 CPUs. A program still running at 30 seconds is stopped with exit code 124, and output over 64 KB per stream is cut.

Where does my code run?

On our servers, in a fresh gVisor sandbox with no network access that is deleted when the run ends. Each run is kept in execution history with its output; the security page says what is stored.