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.
ER Postgres Design with DbSchema: Visual PostgreSQL Schema Workflow | DbSchema
Design PostgreSQL schemas visually with DbSchema. Build ER diagrams, edit tables, sync changes, version schema files with Git, and publish docs.
Reverse Engineering a PostgreSQL Database
Learn how to reverse-engineer an existing PostgreSQL database into an offline ER diagram, extract the pg_catalog schema, and map undeclared relations.
PostgreSQL Schema Version Control: Methods and Tools
Discover how to manage PostgreSQL schema version control using Git workflows. Learn to diff XML models and generate automated migration scripts safely.
How to Document a Postgres Database
Document a Postgres database with SQL COMMENT statements applied via psql -f, then export the comments and diagram as one interactive HTML5 file with DbSchema.
A Visual Query Builder for PostgreSQL
How DbSchema builds PostgreSQL SELECTs and joins from the diagram, where the recursive CTE actually goes, and what it will not do to production.
Improve Performance with Range Partitioning in PostgreSQL
Discover how PostgreSQL range partitioning splits large tables into smaller parts based on values like dates or numbers, making queries faster and maintenance easier.
PostgreSQL CREATE INDEX Guide with psql and DbSchema | DbSchema
Learn how to create indexes in PostgreSQL using psql and DbSchema, including index options, limitations, and practical examples.
PostgreSQL Database Design Tools: Visual Comparison
DbSchema, pgModeler, SqlDBM, dbdiagram.io and ChartDB compared as PostgreSQL design tools: reverse-engineering, offline modelling and current pricing.
How to Handle Large PostgreSQL Schemas with a GUI Tool
Learn how to manage large PostgreSQL schemas with a visual database tool: split diagrams, compare changes, document tables, and handle 10,000+ tables.
PostgreSQL Schema Migration: Deploying Changes Safely
Deploy PostgreSQL schema changes without blocking traffic: lock_timeout, constant defaults, NOT VALID constraints and CREATE INDEX CONCURRENTLY.