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 Data Compression: ROW vs PAGE vs COLUMNSTORE | DbSchema
Compare SQL Server ROW, PAGE, and COLUMNSTORE compression, estimate savings, and pick the right option for OLTP or analytics in DbSchema.
Deploying SQL Server Schema Changes Safely
Deploy SQL Server schema changes safely. Learn how to manage Sch-M locks, set XACT_ABORT, and generate migration scripts without blocking your application.
Why Not Just Ask ChatGPT to Draw Your Schema
Discover why asking ChatGPT to draw your database schema requires extra steps. Learn how to generate visual ER diagrams and safely review AI SQL scripts.
DbSchema Relational Data Editor Guide
Learn how to explore and edit relational data visually with DbSchema Relational Data Editor, including foreign keys, navigation, and inline editing.
Running the Same Query Against Several Engines
Learn how to run the same query against multiple databases from a single editor, exploring data without opening a second tab.
MySQL DROP DATABASE Guide with Safety Checklist | DbSchema
Learn how to drop a MySQL database safely, verify deletion, and manage the operation visually in DbSchema.
Kerberos Authentication for Database Connections
Learn how to configure Kerberos authentication for database connections, secure your JDBC URL, and troubleshoot common GSSException failures.
DbSchema 10.5.2 Release Notes
Explore the DbSchema v10 release notes, featuring the latest updates, new features, and improvements for database design and management.
Visual Schema Diff or a Code-Only Migration Library
Compare code-only migration libraries with visual schema diff tools. Learn how to version XML models in Git and generate migration scripts automatically.
What a Database Migration Tool Does
Learn how a database migration tool tracks schema changes and generates safe SQL scripts. We compare Flyway, Liquibase, and visual synchronization tools.