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.
SQL Server Concurrency and Deadlocks Guide in sqlcmd and DbSchema
Learn how to manage SQL Server concurrency, locks, blocking, and deadlocks in sqlcmd and DbSchema.
How to Document SQL Server Schemas Visually
Visualize and document your SQL Server schema with ER diagrams, clickable HTML docs, and change tracking. Perfect for teams, audits, and onboarding.
SQL Server Transactions Guide with COMMIT, ROLLBACK, and SAVEPOINT | DbSchema
Learn how to perform SQL Server transactions in sqlcmd and DbSchema using COMMIT, ROLLBACK, and SAVEPOINT.
SQL Server CREATE VIEW Guide with Examples in sqlcmd and DbSchema | DbSchema
Learn how to create SQL Server views in sqlcmd and DbSchema, including syntax, permissions, examples, and practical usage tips.
SQL Server CREATE DATABASE Guide with sqlcmd and DbSchema | DbSchema
Learn how to create a SQL Server database using sqlcmd and DbSchema, with prerequisites, practical steps, and verification queries.
Exploring Data Across MongoDB Collections
Link MongoDB collections with virtual relations in DbSchema and browse related documents side by side, without writing an aggregation pipeline.
Seeing the Structure of a Schemaless Database
Connect DbSchema to an undocumented MongoDB database and reverse-engineer a diagram of what the documents contain, sampled and inferred, not enforced.
Choosing an ER Notation Your Team Can Read
Compare Chen, crow's foot, Barker, IDEF1X and UML class diagrams and pick the ER notation your readers can read, then render one model in it.
DBeaver Alternative for 2026: Why DbSchema Fits Database Design Better | DbSchema
DbSchema vs DBeaver for schema design, edition by edition, and what Navicat, dbForge, DataGrip, DbVisualizer and Beekeeper Studio offer for the same work.
PostgreSQL JSONB: Operators, GIN Indexes, and Query Examples | DbSchema
Learn PostgreSQL JSONB operators, GIN indexes, path queries, and update patterns. Explore and document JSONB structures visually in DbSchema.