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.
DbSchema Blog
Database design, migrations, SQL and everyday database work — explained with practical examples.
What a Database Migration Tool Does
A database migration tool turns schema changes into SQL that every environment runs once, in order. See a real PostgreSQL 16 migration fail and pass.
Comparing Production and Staging Schemas
Compare production and staging database schemas before a release. See which catalog queries catch which drift on PostgreSQL 16, and where DbSchema fits.
Comparing Two Database Schemas
How to compare two database schemas: a catalog query, a schema-only dump diff and a model compare that writes the migration SQL, tested on PostgreSQL 16.
Putting a Database Schema in Git
Database schema version control with Git: keep the schema as a text model file, review its diffs, merge branches and sync the change into the database.
Rolling Back a Database Schema Change
Can you roll back a database schema change? Which engines undo DDL in a transaction, what data is gone for good, and how to run the reverse script.
Finding Schema Drift Between Database Environments
Confirm schema drift between production and staging: pick a reference, compare it in DbSchema, decide each difference, and schedule the check.
Choosing an ER Notation Your Team Can Read
Compare Chen, crow's foot, Barker, IDEF1X and UML class diagrams, pick the ER diagram notation your readers know, and render one model in it.
Reviewing an AI-Proposed Schema Change
Review an AI-proposed schema change before it runs: what the DbSchema AI Assistant saw, what it missed, and how to test it in the model first.
Exploring Master-Detail Data Across Foreign Keys
Browse master-detail data across foreign keys in PostgreSQL 16. See what ON DELETE CASCADE removes, how to turn a link into a lookup, and the DbSchema way.
Reverse Engineering a PostgreSQL Database
Reverse engineer a PostgreSQL database into an ER diagram: what pg_catalog holds, the psql route, DbSchema over JDBC, virtual foreign keys and a schema check.