Learn SQL in your browser
A free SQL tutorial in short lessons on one shop database. Every example runs on real PostgreSQL in your browser, and the page checks your answers.
Database design, migrations, SQL and everyday database work — explained with practical examples.
A free SQL tutorial in short lessons on one shop database. Every example runs on real PostgreSQL in your browser, and the page checks your answers.
When a database schema change goes wrong, decide quickly if it can be reversed. Learn how PostgreSQL, SQL Server, and MySQL handle DDL rollbacks.
Learn how to create a MySQL database from the command line, verify it, and manage it visually in DbSchema.
Looking for a DataGrip alternative? Compare top visual database schema design tools, including DbSchema, Oracle Data Modeler, and Aqua Data Studio.
One row per group in PostgreSQL with DISTINCT ON: the ORDER BY it requires, the tie that picks a random row, and when ROW_NUMBER or LEFT JOIN LATERAL is the better tool.
Write the rules your schema must follow, run them against the DbSchema model, and get a list of every table, column, index, or foreign key that breaks one, before anything reaches the database.
Get a quick tour of DbSchema features, including schema modeling, synchronization, documentation, and visual query tools.
DbSchema has been nominated for Best Data Modeling Solution in the 2026 DBTA Readers' Choice Awards! Show your support by voting and help us bring this award home.
DbSchema joins Magdeburg DevDays 2025 with team sessions on MongoDB design, Git collaboration, and writing clean, maintainable tests.
Explore the DbSchema release notes, featuring the latest updates, new features, and improvements for database design and management.
DbSchema presented at SQLDays Germany 2022 with a session on team database design, documentation, and deployment workflows.