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.
SQLite Database Design Tools Compared in 2026
DbSchema, DB Browser for SQLite and Letos compared as SQLite database design tools: what each one does, where it fits, and what it costs.
SQLite Expressions Explained with Examples
A taxonomy of SQLite expression types with runnable examples, where SQLite allows one, and how to write one in sqlite3 or DbSchema's SQL Editor.
A Visual Query Builder for MySQL: The Data Analyst Guide
Learn how a visual query builder for MySQL helps data analysts explore unlimited tables, build complex queries, and analyze data without writing raw SQL.
Reverse Engineering a MySQL Database: A Developer's Guide
Learn how to reverse-engineer a MySQL database to extract its structure, handle missing MyISAM foreign keys, and build an interactive ER diagram offline.
How to Document a MySQL Database Schema in 2026
Learn how to document your MySQL database schema in 2026 using modern tools for diagrams, data dictionaries, and interactive HTML documentation.
How to Import CSV into MySQL with SQL and DbSchema | DbSchema
Learn how to import CSV files into MySQL using LOAD DATA and the DbSchema Data Importer, with practical steps and verification tips.
MySQL Schema Version Control: Git Workflows and Diffs
Learn how to implement MySQL schema version control by saving your design model as an XML file in Git, reviewing diffs, and generating migration scripts.
Documenting a MySQL Database
Learn how to generate interactive MySQL database documentation. Compare top tools, explore the four documentation types, and export HTML5 docs.
SQL Server Window Functions Guide with Examples | DbSchema
Learn SQL Server window functions with practical examples in sqlcmd and DbSchema, including ranking, aggregates, value functions, and common limitations.
SQL Server Schema Comparison Tools
Compare SQL Server schema comparison tools: DbSchema, Redgate SQL Compare, dbForge and xSQL, with the price each vendor lists today and what each compares.