ITKokka

SQL Playground

Run SQL queries on a live school database, right in your browser using SQLite3. No setup, no server. Explore tables, try JOINs, INSERT, UPDATE, DELETE and see results instantly.

Setting up database...

Loading SQLite + seeding 6 tables

First load takes a bit, faster on next visit :)

How to Use

  1. 1

    Open the table list to see the sample school database structure.

  2. 2

    Type a SQL query in the editor, for example a SELECT with a WHERE clause.

  3. 3

    Run it and check the result table that appears below.

  4. 4

    Try INSERT, UPDATE, and DELETE too, the database resets any time you reload the page.

What Is SQL?

SQL (Structured Query Language) is the language used to store, retrieve, update, and delete data in a relational database. O/L and A/L ICT database units test SELECT, WHERE, JOIN, INSERT, UPDATE, and DELETE against a sample schema, exactly what this playground gives you a safe space to practice on.

FAQ

What database engine does this playground use?

SQLite3, running fully in your browser, so no server or account is needed and nothing you type leaves your device.

Can I practice JOIN queries here?

Yes, the sample school database has multiple related tables, ideal for practicing INNER JOIN and other multi table queries that show up in O/L and A/L ICT database questions.

Will my changes to the data be saved?

No, INSERT, UPDATE, and DELETE only affect your current session. Reloading the page resets the database to its original state, safe to experiment freely.

Is this SQL playground free to use?

Yes, fully free, no sign up, no installation required.

Related

Python PlaygroundJSON VisualizerAll Free Tools