SQL Table Generator
Generate CREATE TABLE SQL statements with types, constraints, and keys.
Columns
Name
Type
Default
Null / PK / AI / UQ
Generated SQL
SQL CREATE TABLE Generator
This tool generates syntactically correct CREATE TABLE statements for MySQL, PostgreSQL, SQLite, and SQL Server. Add and configure columns with data types, nullability, default values, primary key, auto-increment, and unique constraints. Each dialect uses its native syntax: MySQL uses AUTO_INCREMENT, PostgreSQL uses SERIAL, SQLite uses INTEGER PRIMARY KEY AUTOINCREMENT, and SQL Server uses IDENTITY(1,1). Boolean columns map to TINYINT(1) in MySQL and BIT in SQL Server for maximum ORM compatibility. Everything runs in your browser with no data sent to any server.
Private & free — this tool runs entirely in your browser.
Recommended: IndieKit — Ship your Next.js startup in days.affiliate
Related Developer Utilities tools
RegExp Tester
Test regular expressions and inspect matches locally.
Regex Visualizer
Visual regex pattern diagram with live match highlighting and capture group annotations.
Subnet Calculator
Compute CIDR subnets, usable hosts, and network ranges.
Cron Parser
Translate cron syntax into plain English.
URL Parser
Break a URL into protocol, host, path, and query parts.
HTML Previewer
Paste HTML and see it rendered live in a safe, sandboxed preview.
HTTP Status Code Reference
Search and look up every HTTP status code and its meaning.
MIME Type Lookup
Find the MIME type for a file extension, or the extensions for a MIME type.