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.
PostgreSQL Database Design Tools: Visual Comparison
DbSchema, pgModeler, Navicat Data Modeler, pgAdmin, SqlDBM, ChartDB and dbdiagram.io, grouped by where the design lives and whether it compares with PostgreSQL. Checked 29 October 2026.
SQL Server Stored Procedure Tutorial with sqlcmd and DbSchema | DbSchema
Create a stored procedure in SQL Server: the CREATE PROCEDURE syntax, parameters with defaults, OUTPUT parameters and return codes, ALTER and DROP, run from sqlcmd and from DbSchema.
SQL UNION Operator: UNION vs UNION ALL with Examples | DbSchema
SQL UNION and UNION ALL on two small tables: the column rules, which rows count as duplicates, ORDER BY and LIMIT, totals, and the errors PostgreSQL, MySQL and SQLite give.
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.