AppYonder

Database Studio

Michael Elsner

No ratings yetEducationAges 4+

Get for USD 0.99 on the App StoreOpens Apple's App Store

Screenshots

About this app

Database Studio is a SQLite learning and database workspace designed for students, teachers and anyone practising SQL. Open SQLite database files, browse tables, inspect fields and relationships, run SQL commands, and view results in a clear workspace. Use the built-in sample databases to learn common SQL commands, or upload your own .db, .sqlite or .sqlite3 files. Features include: • Interactive SQL editor with line numbers • Contextual SQL help for common commands • Table browsing with adjustable column widths • Add, edit and delete records • Create tables visually • Add primary keys and foreign keys • View table relationships • Run SELECT, WHERE, JOIN, GROUP BY, INSERT, UPDATE, DELETE and CREATE statements • Import CSV data • Export query results and tables as CSV • Export a database copy • Built-in SQL lessons and practice challenges • SQL injection learning lab • Student and teacher modes • Optional assessment mode for SQL-only classroom tasks Database Studio is built for practical learning: students can see real database structures, write real SQL, make mistakes safely, and understand how tables, keys and relationships work together.

What's new

Version 1.5 · Sep 14, 2026

• Improved Learn SQL lesson order for a clearer progression. • Added a new Linking Tables lesson covering primary keys, foreign keys, references, and referential integrity. • Updated SQL lesson wording for better clarity and grammar. • Moved advanced topics like CREATE VIEW and SQL Injection toward the end of the lesson sequence. • Refined SELECT lessons, including corrected explanation text for the FROM clause. • Verified lesson examples against the bundled practice databases.

More from Michael Elsner

You might also like