Blog Category Design
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.
Design • 01-Sep-2026
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.
Design • 30-Aug-2026
Database Design Errors to Avoid & How To Fix Them
Six database design mistakes that cost you later — foreign keys, indexes, JSON columns, normalization, naming, documentation — with the fix for each.
Design • 29-Aug-2026
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.
Design • 28-Aug-2026
DBeaver Alternative for 2026 – Why DbSchema Fits Database Design Better | DbSchema
DbSchema vs DBeaver criterion by criterion: visual design, reverse engineering, schema sync, HTML docs, Git, NoSQL, query building and licensing.
Design • 27-Aug-2026
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.
Design • 27-Aug-2026
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.
Design • 27-Aug-2026
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.
Design • 26-Aug-2026
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.
Design • 25-Aug-2026
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.
Design • 25-Aug-2026
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.
Design • 24-Aug-2026
Best Database Design Tools in 2026: 7 Tools Compared | DbSchema
DbSchema, DBeaver, DataGrip, Navicat Data Modeler, Redgate Data Modeler, DbVisualizer and pgAdmin compared on databases supported, offline modelling, schema sync, Git and licence.
Design • 23-Aug-2026
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.
Design • 23-Aug-2026
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 • 21-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 • 21-Aug-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 • 20-Aug-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 • 20-Aug-2026
DbSchema Tool Presentation and Feature Overview
Get a quick tour of DbSchema features, including schema modeling, synchronization, documentation, and visual query tools.
Design • 18-Aug-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 • 18-Aug-2026
Top 7 Logical Database Design Tools in 2026
Seven logical database design tools compared on engines, offline use, versioning, docs and licence, with prices read from each vendor in August 2026.
Design • 17-Aug-2026
DbSchema vs Navicat, DbForge
This article compares the features, price, strengths and weaknesses of 3 database modeling tools: DbSchema, Navicat and DbForge.
Design • 17-Aug-2026
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 • 17-Aug-2026
DbSchema vs DbVisualizer
DbSchema vs DbVisualizer compared side by side in 2026: engine support, diagramming, query tooling, data editing, documentation and current pricing.
Design • 16-Aug-2026
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.
Design • 16-Aug-2026
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
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
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
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
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
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
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
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
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
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
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