🗄️ SQL ✅ 100% Free ⚡ 4 Dialects

SQL Table Builder

Visually design your database tables — add columns, set data types & constraints, define indexes and foreign keys, and instantly generate CREATE TABLE SQL for MySQL, PostgreSQL, SQLite or SQL Server.

Dialect:

🗄️ Table Designer 0 columns

Table Name

Schema / DB

Engine (MySQL)

Charset (MySQL)

IF NOT EXISTS

⠿ Column Name Data Type PK NN UQ AI

Quick:

📇 Indexes

🔗 Foreign Keys

ColumnRef TableRef ColumnON DELETEON UPDATE

Generated SQL

Constraint Legend

PKPrimary Key

NNNOT NULL

UQUNIQUE

AIAUTO_INCREMENT

FKForeign Key

DFHas Default

Visual SQL Table Builder

The SQL Table Builder lets you design database tables visually without writing SQL from scratch. Add and reorder columns with drag-and-drop, toggle constraints with one click, and get perfectly formatted CREATE TABLE statements instantly.

Supported Dialects

MySQL: Full type set including ENUM, SET, JSON, TEXT variants — with ENGINE and CHARSET options
PostgreSQL: SERIAL/BIGSERIAL, UUID, JSONB, TIMESTAMPTZ, ARRAY and more
SQLite: INTEGER, REAL, TEXT, BLOB and NUMERIC with SQLite-native affinity
SQL Server: NVARCHAR, IDENTITY, UNIQUEIDENTIFIER, DATETIME2, XML and more

Features

Drag-and-drop column reordering
One-click PK, NOT NULL, UNIQUE, AUTO_INCREMENT toggles per column
Default values and column comments per column
Index builder: INDEX, UNIQUE INDEX, FULLTEXT, SPATIAL, PRIMARY KEY
Foreign key builder with ON DELETE / ON UPDATE action selectors
Quick-insert presets: id, uuid, created_at, updated_at, deleted_at, status
Three ready-made templates: Users, Blog Posts, Orders
Syntax-highlighted SQL output and visual schema preview
Copy to clipboard and download as .sql file