Skip to content

Free tool

Online SQL compiler

Write and run SQL against a practice shop database — right here in your browser.

Press Ctrl/⌘ + Enter to run. Tab indents; press Esc then Tab to leave the editor.

Loading SQL engine…

Frequently asked questions

Which SQL dialect does this compiler use?

SQLite, running in your browser via WebAssembly. Standard SELECT, JOIN, GROUP BY, CTEs and window functions all work. Some vendor-specific functions — for example date functions in PostgreSQL or MySQL — have SQLite equivalents such as date() and julianday().

What data is in the practice database?

A small fictional online shop: customers, products, orders, order_items, employees (with managers for self-joins) and web_sessions for funnel questions. Use Reset database to restore it after you modify tables.

Is my query sent to a server?

No. The database and the SQL engine run entirely in your browser tab, so queries are private and fast.