CREATE TABLE Generator
Design a SQL table visually and generate correct CREATE TABLE DDL for MySQL, PostgreSQL, SQLite, and SQL Server. Add columns, types, defaults, primary keys (single/composite), unique, foreign keys with ON DELETE/UPDATE, indexes, CHECK constraints, ENUMs and comments. Includes CSV/JSON column inference, IF NOT EXISTS, matching DROP TABLE, seed INSERT scaffolding, MySQL engine/charset, SQLite WITHOUT ROWID, reserved-word auto-quoting and per-dialect identifier limits. 100% client-side.
About CREATE TABLE Generator
Design a SQL table visually and generate correct CREATE TABLE DDL for MySQL, PostgreSQL, SQLite, and SQL Server. Add columns, types, defaults, primary keys (single/composite), unique, foreign keys with ON DELETE/UPDATE, indexes, CHECK constraints, ENUMs and comments. Includes CSV/JSON column inference, IF NOT EXISTS, matching DROP TABLE, seed INSERT scaffolding, MySQL engine/charset, SQLite WITHOUT ROWID, reserved-word auto-quoting and per-dialect identifier limits. 100% client-side. Everything runs locally in your browser — your data never leaves your device.
How to use
- Enter your input in the tool above.
- Adjust any options to your preference.
- Use the Copy or Download buttons to save the result.
- Everything happens locally — your data never leaves your browser.
FAQ
Which SQL dialects does the CREATE TABLE Generator support?
Four dialects: MySQL / MariaDB, PostgreSQL, SQLite, and SQL Server (T-SQL). Each dialect has its own identifier quoting (backtick / double-quote / square bracket), type list, auto-increment syntax (AUTO_INCREMENT / GENERATED AS IDENTITY / AUTOINCREMENT / IDENTITY), and table options (MySQL ENGINE/CHARSET, SQLite WITHOUT ROWID). Switch dialects at any time and the DDL is regenerated instantly.
Can it generate primary keys, foreign keys, unique constraints and indexes?
Yes. Single and composite primary keys, UNIQUE constraints (single or composite), foreign keys with ON DELETE / ON UPDATE actions (CASCADE, SET NULL, SET DEFAULT, RESTRICT, NO ACTION) referencing composite parent keys in the correct order, CHECK constraints, and INDEX / KEY declarations with optional method hints (BTREE, HASH for dialects that support it).
Can I infer columns from a pasted CSV or JSON sample?
Yes. Paste a CSV header row + a few sample rows (or paste a JSON array of objects) and the inference module scans the values to pick a sensible SQL type per column — INTEGER, BIGINT, DECIMAL, BOOLEAN, DATE, TIMESTAMP, VARCHAR(n) with detected max length. The inferred columns are added to the form for review before generating DDL.
Does the generator emit DROP TABLE and sample INSERT statements?
Yes. Alongside CREATE TABLE it can emit a matching DROP TABLE IF EXISTS (per-dialect syntax) and a configurable number of seed INSERT statements that respect NOT NULL columns, defaults, and enum value lists — useful for bootstrapping a new schema. All three are produced from a single model.
What extras does this tool offer versus other DDL generators?
(1) Four dialects with per-dialect identifier quoting and limits. (2) Single/composite primary keys, unique, FK with ON DELETE/UPDATE. (3) CHECK constraints, ENUM (where supported), column and table comments. (4) Indexes with method hints. (5) CSV/JSON column inference. (6) IF NOT EXISTS toggle. (7) Matching DROP TABLE + seed INSERT scaffolding. (8) MySQL ENGINE/CHARSET, SQLite WITHOUT ROWID. (9) Reserved-word auto-quoting. (10) Default-expression vs literal detection. (11) Three preset schemas. (12) localStorage history (max 20). (13) Shareable URL. (14) Copy / download .sql. (15) Live validation with severity-tagged issues.
Related tools
.bashrc / .zshrc Alias & Config Manager
Build shell aliases, functions, exports, and PATH edits in a visual editor, then export a clean, commented .aliases file sourced from both .bashrc and .zshrc — with shadowing detection against shell builtins and common CLI tools, function suggestions when args are needed, starter packs (git, docker, kubectl, navigation, safety, ls, dev, devops, data science), import of existing rc files, dedupe, history (localStorage), and shareable URL. 100% client-side.
Add / Subtract Date Calculator
Add or subtract years, months, weeks, days, hours, minutes and seconds from a starting date/time. Calendar-day or business-day mode with custom weekend + holiday list. Month-end policy toggle (clamp to last day vs overflow). Repeat/series mode (e.g. every 2 weeks x 10) with CSV export. Shareable URL. 100% client-side.
Age Calculator
Calculate exact age from a birth date in calendar years/months/days (no negative-day bugs) plus totals in months/weeks/days/hours/minutes/seconds. Next-birthday countdown with weekday. Feb-29 birthday policy toggle. Milestones (1,000 days, 10,000 days, 1 billion seconds). Zodiac sign + Chinese zodiac. Age gap comparison. Shareable URL. 100% client-side.