Site Map

Main Pages

• Home Free online MySQL and PostgreSQL schema designer — visual drag-and-drop interface with SQL export.
• 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.
• 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.
• Terms of Service Rules and conditions for using SQL Designer.

Blog

• Blog Index All articles on database design, SQL, and schema best practices.
• 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.
• 10 Best Free ERD Tools in 2026 — Tested and Compared We tested 10 free ERD tools — SQL Designer, DrawSQL, dbdiagram.io, draw.io, ChartDB, ERDPlus, QuickDBD, Lucidchart, DB Designer, and DBeaver — with honest strengths, real limits, and use-case guidance.
• Free Online Database Designer Visual schema builder for MySQL and PostgreSQL — design databases without writing DDL.
• 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.