SQL Designer

Visual database schema builder with smart import, auto-layout, and phpMyAdmin-level control.

Why SQL Designer?

Stop writing SQL by hand. Design visually, export instantly.

• 🎯 Import existing databases - Paste SQL, get instant visual layout
• 🎨 Drag-and-drop everything - Tables, fields, relationships
• 🚀 Auto-arrange - Smart grid layout for clean schemas
• 💾 Export production SQL - Ready for MySQL/MariaDB
• ⚡ Zero setup - Open HTML file, start designing

Core Features

Smart Import/Export

-- Paste your CREATE TABLE statements-- Get organized visual schema instantly-- Modify visually, export back to SQL

Import: Upload .sql or paste code → Auto-arranged grid layout
Export: Customize options → Production-ready SQL script

Visual Design

• Auto-Arrange: Perfect grid layout with one click
• Drag & Drop: Position tables anywhere on infinite canvas
• Relationships: Visual lines between foreign keys
• Zoom Controls: In, out, reset view
• Dark Theme: Easy on the eyes for long sessions

Complete Database Control

Tables

• InnoDB, MyISAM, Memory, Archive, CSV engines
• utf8mb4, collations, row formats, AUTO_INCREMENT
• Comments and full documentation

Fields (30+ types)

• INT, VARCHAR, TEXT, BLOB, JSON, ENUM, spatial types
• UNSIGNED, ZEROFILL, NULL/NOT NULL
• DEFAULT values, ON UPDATE triggers
• PRIMARY KEY, UNIQUE, INDEX

Advanced

• Foreign keys with CASCADE, RESTRICT, SET NULL
• Composite indexes (FULLTEXT, SPATIAL)
• Multi-field primary keys
• Named constraints

Quick Start

Create new schema:

1. Open sql-designer.html
2. Click "New Table"
3. Add fields, set properties
4. Export SQL

Import existing:

1. Click "Import SQL"
2. Paste CREATE TABLE code
3. Tables auto-arranged in grid
4. Modify and export

Interface

┌─────────────┬──────────────────────┬─────────────────┐
│ Sidebar │ Canvas │ Properties │
│ │ │ │
│ New Table │ [Table] [Table] │ Table Name │
│ │ ↓↓ │ Engine │
│ Tables │ [Table] [Table] │ Fields │
│ • users │ │ • id │
│ • orders │ Auto-Arrange │ • name │
│ │ Zoom In/Out │ │
│ Import SQL │ │ Foreign Keys │
│ Export SQL │ │ Indexes │
└─────────────┴──────────────────────┴─────────────────┘

Perfect For

• Database architects designing complex schemas
• Developers prototyping new projects
• Teams collaborating on database structure
• Students learning SQL relationships
• Anyone who needs visual schema tools

License

MIT - Free for personal and commercial use

---

Built by David Sangouard
Architect of digital solutions