Blog Category Design
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.
Design • 12-Aug-2026
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.
Design • 12-Aug-2026
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.
Design • 12-Aug-2026
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.
Design • 12-Aug-2026
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.
Design • 12-Aug-2026
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.
Design • 20-May-2026
DbSchema vs Navicat: Full Feature Comparison for Teams in 2026 | DbSchema
DbSchema vs Navicat compared for 2026: pricing, ER diagrams, Git integration, offline design, schema sync, and documentation. Find the right fit for your team.
Design • 15-Apr-2026
Top 7 Logical Database Design Tools in 2026
Discover the best logical database design tools in 2026 for creating database-independent models with entities, relationships, and metadata.
Design • 14-Apr-2026
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.
Design • 17-Mar-2026
Design Better Databases - From Theory to Tools with DbSchema
Explore core database design principles, normalization, and keys - plus how tools like DbSchema support visual modeling, Git collaboration, and documentation.
Design • 13-Mar-2026
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.
Design • 03-Mar-2026
MySQL vs MongoDB - Visual Design with Real Data Models
Learn the key differences between MySQL and MongoDB using visual modeling. Compare tables and collections with real-world examples in DbSchema.
Design • 02-Mar-2026
DbSchema at Magdeburg DevDays | Germany 2025
DbSchema joins Magdeburg DevDays 2025 with team sessions on MongoDB design, Git collaboration, and writing clean, maintainable tests.
Design • 01-Mar-2026
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.
Design • 13-Feb-2026
DbVisualizer Alternative in 2026 - DbSchema for Database Design
Best DbVisualizer alternative in 2025: DbSchema offers visual modeling, diagrams, Git integration, schema sync, and interactive documentation.
Design • 12-Feb-2026
Team Collaboration in Schema Design with Git
Learn how teams can use Git with DbSchema’s schema design projects to track, share, and collaborate on database changes.
Design • 03-Feb-2026
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.
Design • 24-Jan-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.
Design • 21-Jan-2026
Database Design Errors to Avoid & How To Fix Them
Avoid common database design mistakes in 2026, like missing foreign keys, poor indexing, and bad JSON use. Learn simple fixes with practical examples.
Design • 15-Jan-2026
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.
Design • 12-Jan-2026
The All-in-One Database Design & Management Tool | DbSchema 2026
Learn how to simplify your database design and data management in 2026 with DbSchema - a visual database design tool built to make work faster and easier.
Design • 01-Jan-2026
DBeaver Alternative for 2026 – Why DbSchema Fits Database Design Better | DbSchema
Looking for a DBeaver alternative? Compare DbSchema vs DBeaver for ER diagrams, schema sync, Git, HTML docs, and visual database design.
Design • 19-Aug-2025
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.
Design • 13-Apr-2025
Logical Design Documentation for Database Development
In this article, we will explore how DbSchema can help you create powerful logical and physical database documentation, using comments, tags, and advanced features like Conversion Dictionary and Naming Dictionary, and exporting it all to interactive HTML5 documentation.
Design • 21-Oct-2024
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.
Design • 15-Oct-2024
DbSchema at SQLDays Germany 2022
DbSchema presented at SQLDays Germany 2022 with a session on team database design, documentation, and deployment workflows.
Design • 13-Sep-2022
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.
Design • 26-Apr-2022
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.
Design • 11-Nov-2021
Interactive Database Documentation with DbSchema
Learn how to generate interactive HTML5 database documentation with vector diagrams, comments, zoom, and pan in DbSchema.
Design • 10-Nov-2021
DbSchema Tool Presentation and Feature Overview
Get a quick tour of DbSchema features, including schema modeling, synchronization, documentation, and visual query tools.
Design • 21-Apr-2021
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.
Design • 10-Mar-2021
Interview with MacLaurin Group on Database Design | DbSchema
Watch a technical interview with MacLaurin Group about visual database design, communication, and DbSchema workflows.
Design • 20-Jan-2021
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.
Design • 05-May-2020
SQL Server: Return Date Only from GETDATE | DbSchema
Learn two simple SQL Server methods to return only the date from GETDATE using CONVERT.
Design • 13-Apr-2020
DbSchema vs Navicat, DbForge
This article compares the features, price, strengths & weaknesses of 3 database modeling tools: Navicat, DbForge and DbSchema
Design • 10-Apr-2020
DbSchema vs DbVisualizer
In this article, we compare the main features of DbSchema & DbVisualizer.
Design • 09-Apr-2020
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.
Design • 07-Apr-2020
Indexes and Foreign Keys Design Tips | DbSchema
Learn practical tips for using indexes and foreign keys to improve database consistency and query performance.
Design • 31-Mar-2020
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.
Design • 30-Mar-2020
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.
Design • 29-Feb-2020
SQL Interview Questions for Developers and DBAs | DbSchema
Practice SQL interview questions and solutions for developers and database administrators with realistic PostgreSQL exercises.
Design • 15-Apr-2019
SQL Server Insert Multiple Rows in a Single Query | DbSchema
Learn how to insert multiple rows in a single SQL Server query and avoid repetitive INSERT statements.
Design • 12-Apr-2019
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.
Design • 11-Apr-2019