Blog
Guides and tutorials on MySQL and PostgreSQL schema design, ER diagrams, and database modelling.
Free ERD Maker Online — Create ER Diagrams in Your Browser
What an ERD maker is, how it differs from a generic diagram tool, and how to use SQL Designer to create ER diagrams and export working SQL for free.
SQL to ERD — Generate an ER Diagram from a SQL Script
Import an existing CREATE TABLE script and generate a visual ER diagram automatically — tables, columns, constraints, and foreign key relationships rendered instantly.
Crow’s Foot Notation — ER Diagram Cardinality Explained
Learn the crow's foot symbols for one-to-one, one-to-many, and many-to-many relationships, how optionality works, and how the notation maps to real foreign key constraints.
Best Free ERD Tools in 2026 — Honest Comparison
Honest comparison of 7 ERD tools: SQL Designer, DrawSQL, dbdiagram.io, draw.io, DB Designer, DBeaver, and ChartDB — with real strengths, real weaknesses, and clear use-case guidance.
How to Share a Database Diagram Online — Shareable Links & Embeds
Share your database schema with a live link that always shows the current version, or embed it as an interactive iframe in your docs. Control access with read-only, editable, or approval-based permissions.
Free Online Database Designer — Visual Schema Builder for MySQL & PostgreSQL
What to look for in a free online database designer, how visual schema building compares to writing DDL by hand, and how to go from blank canvas to exported SQL.
Free ERD Tool Online — Visual Entity Relationship Diagram Editor
What makes a genuinely free ERD tool, the difference between SQL-aware and generic diagram editors, and how to use SQL Designer to draw ER diagrams and export SQL for free.
Postgres Designer Online — Free Visual PostgreSQL DB Designer
Design PostgreSQL schemas visually in your browser — with PostgreSQL-specific types, foreign key relationships, and one-click DDL export. Free, no install required.
MySQL Designer Online — Free Visual MySQL DB Designer
Design MySQL databases visually — drag-and-drop tables, define columns with MySQL types, draw foreign key relationships, and export a CREATE TABLE script in one click.
Database Schema Examples — MySQL & PostgreSQL Templates
Five real-world database schema templates — e-commerce, blog, SaaS, task tracker, and messaging — with complete MySQL and PostgreSQL CREATE TABLE scripts you can copy or build visually.
How to Design a MySQL Database Schema — A Step-by-Step Guide
A practical walkthrough covering entity identification, column types, primary keys, foreign key relationships, and normalization — with tips on visualising your schema before writing any SQL.
Free ER Diagram Tool Online for MySQL — No Download Required
What entity-relationship diagrams are, why they matter, and how to create one for your MySQL database entirely in the browser — for free.
MySQL Workbench Alternative Online — Free & No Install Required
MySQL Workbench is powerful but heavy. If you need to design a schema quickly without installing anything, here are your options — including a fully free browser-based tool.
MySQL Foreign Key — Syntax, Examples, and Best Practices
A complete guide to MySQL foreign keys: syntax, ON DELETE and ON UPDATE options, practical examples for e-commerce schemas, and common mistakes to avoid.
MySQL Data Types Explained — Which to Use and When
A practical guide to MySQL data types: numeric, string, date/time, and JSON types — with advice on which to choose for each use case and what to avoid.
Database Normalization Explained — 1NF, 2NF, and 3NF with Examples
Learn database normalization with concrete before-and-after examples. Understand 1NF, 2NF, and 3NF, why they matter, and when it's acceptable to denormalize.
How to Draw an ER Diagram Step by Step
A step-by-step guide to drawing entity-relationship diagrams from a blank page to a complete design — with cardinality notation, common mistakes, and a practical blog platform example.
MySQL vs PostgreSQL — Key Differences for Schema Design
Comparing MySQL and PostgreSQL for database schema design: data types, constraints, auto-increment, JSON support, and which to choose for your next project.