SysEmperor📋 Table Editor
Visual table schema designer — define columns and export CREATE TABLE and INSERT SQL.
Schema — 4 columns
| NAME | TYPE | PK | AI | NULL | DEFAULT | |
|---|---|---|---|---|---|---|
CREATE TABLE `users` (
`id` INT AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(255) NOT NULL,
`email` VARCHAR(255) NOT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT NOW()
);
Export to Excel (.xlsx)
About the Table Editor
The Table Editor lets you visually design a database table schema, add sample data rows, and export the result as ready-to-use SQL or CSV — no database connection required. Everything runs in your browser.
How to use this tool
- Set the table name and select your SQL dialect (MySQL or PostgreSQL).
- Click + Column to add columns. Define the name, data type, and constraints (Primary Key, Auto Increment, NOT NULL, DEFAULT value).
- Click + Row to add sample data rows used when exporting INSERT statements.
- Switch between CREATE TABLE, INSERT, and CSV output using the tabs in the output panel.
- Click Copy SQL to copy the output to your clipboard.
Data types reference
INT/BIGINT— whole numbers; use BIGINT for large IDs or counters.VARCHAR(n)— variable-length strings up to n characters.TEXT— unlimited-length string; suitable for descriptions or long content.BOOLEAN— true/false values.DATE/DATETIME/TIMESTAMP— date and time values. TIMESTAMP stores UTC and is ideal forcreated_at/updated_atcolumns.DECIMAL(10,2)— exact fixed-point decimal; preferred for monetary values.UUID/CHAR(36)— universally unique identifiers.JSON— native JSON column type (MySQL 5.7+, PostgreSQL 9.2+).