Site Map

Main Pages

• Home Free online MySQL and PostgreSQL schema designer — visual drag-and-drop interface with SQL export.
• ER Diagram Maker Working browser-based ER diagram editor with relationship modeling and SQL export for six database dialects.
• About About SQL Designer and its creator, Dmitriy Snyatkov.
• Features Full list of everything SQL Designer can do: canvas editing, SQL export, foreign keys, constraints, and more.
• Pricing Compare the free and Pro plans and see what's included with each.
• Schema Library Real database schemas shared by the community — browse for inspiration or share your own.
• Site Map Full index of all pages on SQL Designer.
• Privacy Policy How we collect, use, and protect your data.
• Personal Data Processing Consent Consent terms for processing account, subscription, payment, and support data.
• Public Offer Subscription price, recurring charge, cancellation, refund, and price-change terms.
• Terms of Service Rules and conditions for using SQL Designer.
• Refund Policy Refund and cancellation terms for SQL Designer Pro subscriptions.

Blog

• Blog Index All articles on database design, SQL, and schema best practices.
• ERD Tools and Database Diagram Guides Comparisons, workflows, and practical guidance for choosing and using ERD tools.
• Relational Database Design Guides Normalization, cardinality, joins, relationships, and practical schema patterns.
• MySQL and PostgreSQL Schema Guides Data types, foreign keys, indexes, DDL differences, and engine selection.
• DDL Differences: MySQL, PostgreSQL, Oracle, SQL Server, and SQLite Side-by-side comparison of CREATE TABLE syntax, primary keys, data types, constraints, and ALTER TABLE across five major databases.
• Crow's Foot Notation — ER Diagram Cardinality Explained Crow's foot symbols for one-to-one, one-to-many, and many-to-many relationships, and how they map to real foreign key constraints.
• 11 Best Free Online ERD Tools in 2026 — Tested and Compared We tested 11 free ERD tools — SQL Designer, DrawSQL, dbdiagram.io, draw.io, ChartDB, ERDPlus, QuickDBD, Lucidchart, Miro, DB Designer, and DBeaver — with honest strengths, real limits, and use-case guidance.
• How to Create a Database Schema Online — Step-by-Step Guide Create a relational database schema online in 5 steps using a free browser-based SQL designer. Design tables, draw relationships, and export SQL — no install required.
• ER Diagram Tools: SQL-Aware vs. Generic Editors How SQL-aware schema tools differ from generic drawing editors, which capabilities matter, and when to use each approach.
• How to Choose Database Design Software for SQL Teams A practical framework for comparing dialect support, schema import, relationships, collaboration, and export features.
• Database Schema Examples — MySQL & PostgreSQL Templates Five real-world schema templates — e-commerce, blog, SaaS, task tracker, and messaging — with complete CREATE TABLE scripts.
• MySQL Foreign Key — Syntax, Examples, and Best Practices Complete guide to MySQL foreign keys: syntax, ON DELETE/UPDATE options, and common mistakes.
• MySQL Data Types Explained Practical guide to numeric, string, date/time, and JSON types — and which to choose.
• Database Normalization Explained — 1NF, 2NF, and 3NF Learn normalization with clear examples and understand when it's acceptable to denormalize.
• MySQL vs PostgreSQL — Key Differences for Schema Design Comparing data types, constraints, JSON support, and which database to choose for your project.
• PostgreSQL Data Types Explained — Which to Use and When Complete guide to PostgreSQL's 42+ built-in types: numeric, text, boolean, date/time, JSONB, arrays, UUID, and identity columns — with CREATE TABLE examples.
• SQL JOIN Types Explained — INNER, LEFT, RIGHT, and FULL Complete guide to SQL joins: INNER, LEFT, RIGHT, FULL, and CROSS JOIN syntax, NULL handling, join algorithms, and common mistakes.
• MySQL Indexes Explained — B-Tree, Composite, and EXPLAIN How B-tree indexes work, composite indexes and the leftmost prefix rule, reading EXPLAIN output, and common indexing mistakes.
• PostgreSQL Indexes Explained — B-Tree, GIN, BRIN, and GiST PostgreSQL's six index types, composite/partial/covering indexes, when the planner picks a sequential scan, and reading EXPLAIN ANALYZE.