Practice · Database
Database Practice
Why this is here
Most automation frameworks eventually need to verify state a UI or API won't show you directly — a row written to a database table, a status flag flipped by a background job. This page gives you a real SQL engine, running entirely in your browser via AlaSQL, seeded with two related tables you can query with real SQL.
Pick a preset to load a real query, or write your own, then run it and read the actual result set. Unlike the API testing page, writes here (INSERT/UPDATE/DELETE) really do persist — in this browser tab, until you hit Reset. That's deliberate, and the opposite lesson from that page: test data that isn't reset between runs leaks into your next test.
Schema:
customers(id, name, email, city, signup_date) orders(id, customer_id, product, amount, status, order_date)
Presets
Query
Result
No query run yet.
Initial state.