Database Studio

Explore SQLite using Database Studio’s sample databases, interactive SQL lessons, editor help, table browsing, editing, CSV import/export, and visual PK and FK tools.

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.