Creating an ER Diagram From an Existing Database
Learn how to connect a tool to a live database, reverse-engineer a schema into an ER diagram, and uncover undeclared foreign keys with DbSchema.
Design
Every post tagged design on the DbSchema blog.
Top 5 Database GUI Clients with Git Integration in 2026
Learn how Git integration in database tools helps teams track changes, prevent conflicts, and collaborate efficiently on database projects.
Top 7 Logical Database Design Tools in 2026
Seven logical database design tools compared on where the shared model lives, what each runs on and the price each vendor publishes, checked in September 2026.
Schema Design in SQL vs NoSQL: A Visual Comparison
Learn how schema design changes between SQL and NoSQL databases. See real visual examples, normalization tips, and when to use each model.
Logical Design Documentation for Database Development
Document a logical and physical database design in DbSchema: comments, tags, the naming and conversion dictionaries, and interactive HTML5 documentation.
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.
Entity Relationship Diagram (ERD): Symbols, Examples, and How to Create One | DbSchema
Learn entity relationship diagram (ERD) symbols, cardinality, and practical examples, then create, validate, and document database models faster with DbSchema.
Normal Forms Without the Theory
Learn to spot repeating groups and dependencies in your database tables. See how to normalize schemas practically using DbSchema Community Edition.
Best Database Documentation Tools in 2026: Compared and Reviewed
Seven database documentation tools compared on output formats, live refresh, comments, offline use and real prices. Only three actually generate documentation.
Free Database Design Tools 2026: Free Tiers Compared | DbSchema
Seven database design tools compared on free tiers only: what each plan includes, where it stops, which engines it covers, and whether it works offline.
Relational Database Schema: Definition and Worked Example
A relational database schema defines tables, columns, keys and constraints. Follow the StreamFlix example from entities through 1NF-3NF to deployable DDL.
Logical Database Design: Keys and Normalization | DbSchema
How logical design differs from conceptual and physical, how entities become tables, the relationship decisions to make early, and normalization.
Best Database Schema Design Tools in 2026: Visual Comparison | DbSchema
Compare the top 10 visual database design tools for 2026: ER diagrams, Git integration, documentation, schema sync, and multi-database support. With screenshots.
Relational Database Schema Design Procedure | DbSchema
The procedure for designing a relational database schema: seven steps, each ending in a decision, from business rules to per-engine types and indexes.
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.
How to Automate Database Tasks with DbSchema
Learn how to automate database tasks in DbSchema using Groovy scripts for schema deployment, documentation generation, and repeatable workflows.
Free CSV Editor for Large Files | DbSchema
Learn how to use DbSchema's free CSV editor for large files, including format detection, filtering, sorting, and inline editing.
Are Visual Query Builders Safe on Production
Discover how visual query builders keep production databases safe. Learn to build SQL offline, explore data safely, and prevent accidental table locks.
Visual DynamoDB Design and Documentation with DbSchema
Reverse engineer existing DynamoDB tables, create new tables, and edit data visually in DbSchema: no JSON or console needed.
SQL Views Explained with Practical Examples | DbSchema
Learn what SQL views are, how to create and update them, and how to manage views visually in DbSchema.
DbSchema vs DbVisualizer
DbSchema vs DbVisualizer compared side by side in 2026: engine support, diagramming, query tooling, data editing, documentation and current pricing.
Database Design Errors to Avoid & How To Fix Them
Six database design mistakes that cost you later: foreign keys, indexes, JSON columns, normalization, naming and documentation, with the fix for each.
Interactive Database Documentation with DbSchema
Learn how to generate interactive HTML5 database documentation with vector diagrams, comments, zoom, and pan in DbSchema.
DbSchema vs Navicat, DbForge
DbSchema, Navicat and dbForge compared on database modeling features, schema documentation, synchronization and price, for a team choosing one tool.
Database Design Best Practices: Principles, Normalization and Keys
Database design best practices in one page: the five design principles, the four-step process, 1NF to 3NF with worked examples, and primary, foreign and secondary keys in SQL.
Building a Query Across Joined Tables Visually
Skip the raw SQL syntax and build queries across joined tables visually in DbSchema. Browse related data across an unlimited number of joined tables.
DbVisualizer Alternative in 2026: DbSchema for Database Design
DbVisualizer alternative in 2026: DbSchema adds visual modeling, editable ER diagrams, Git versioning, schema sync and interactive HTML5 documentation.
Team Collaboration in Schema Design with Git
How a team shares one DbSchema model through Git: commit the .dbs file, branch per change, review the diff, resolve a conflicted table.
DbSchema vs Navicat: Full Feature Comparison for Teams in 2026 | DbSchema
DbSchema 10.5 vs Navicat Premium 17.3.11, compared job by job: ER modelling, offline design, schema sync, Git, NoSQL, documentation and automation.
MySQL vs MongoDB: Key Differences, Decision Table and Data Models
MySQL vs MongoDB compared on schema enforcement, joins vs $lookup, one-to-one and one-to-many modeling, transactions and schema evolution, with a decision table checked against MySQL 9.7 LTS and MongoDB 8.3.
Querying a Database Without Writing SQL
Learn how data analysts can query relational and NoSQL databases without writing SQL by using visual query builders, data explorers, and offline models.
Indexes and Foreign Keys Design Tips | DbSchema
Learn practical tips for using indexes and foreign keys to improve database consistency and query performance.
Best ER Diagram Tools in 2026: Free and Paid Comparison | DbSchema
Compare the best ER diagram tools in 2026 for PostgreSQL, MySQL, SQLite, MongoDB, and multi-database teams. Visual design, reverse engineering, and documentation.
What an AI Assistant Sees of Your Database
Learn what an AI assistant sees of your database, the privacy risks of shadow AI, and how DbSchema keeps your schema secure while automating query design.
Best Database Tools with Git for Team Design in 2026
Discover collaborative database design tools with Git integration. Compare top options for schema versioning, teamwork, and offline modeling.
Window Functions in SQL for Data Analysis | DbSchema
Learn SQL window functions with practical PostgreSQL examples for ranking, cumulative metrics, and feature engineering using DbSchema.
SQL Interview Questions for Developers and DBAs | DbSchema
Practice SQL interview questions and solutions for developers and database administrators with realistic PostgreSQL exercises.
How to Work Better with Foreign Keys and Virtual Keys
Understand foreign keys and learn how to recreate missing relationships using Virtual Foreign Keys in DbSchema for clear, consistent database design.
When Not to Normalise
Discover when denormalization is the right choice for your database, the native alternatives to try first, and how to manage the update costs.
Reviewing an AI-Proposed Schema Change
An ai schema generator accelerates design but requires expert review. Learn how database architects validate and deploy AI-proposed schema changes safely.
Exploring Master-Detail Data Across Foreign Keys
Explore master-detail data across foreign keys. Understand relational database connections and browse multiple child tables visually without writing SQL.
Designing a Schema for a Collaborative Task App
Learn how to design a collaborative task app schema using a Git-based workflow. Discover how backend teams branch, diff, and sync XML models safely.
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.
SQL Server MERGE to Update, Insert, and Delete Rows | DbSchema
Learn how to use SQL Server MERGE to update, insert, and delete rows by matching source and target tables.
How to Enable Remote Connections in SQL Server | DbSchema
Step-by-step guide to enable remote SQL Server connections by configuring TCP/IP, firewall rules, and connection settings.
DbSchema Tool Presentation and Feature Overview
Get a quick tour of DbSchema features, including schema modeling, synchronization, documentation, and visual query tools.
DbSchema Nominated for Best Data Modeling Solution
DbSchema has been nominated for Best Data Modeling Solution in the 2026 DBTA Readers' Choice Awards! Show your support by voting and help us bring this award home.
DbSchema at Magdeburg DevDays | Germany 2025
DbSchema joins Magdeburg DevDays 2025 with team sessions on MongoDB design, Git collaboration, and writing clean, maintainable tests.
DbSchema at SQLDays Germany 2022
DbSchema presented at SQLDays Germany 2022 with a session on team database design, documentation, and deployment workflows.
Interview with MacLaurin Group on Database Design | DbSchema
Watch a technical interview with MacLaurin Group about visual database design, communication, and DbSchema workflows.