DDL
CREATE TABLE t (id INT)
TS
export interface T { id: number; }Developer Tools
CREATE TABLE to TypeScript Interface
Parse MySQL, PostgreSQL, or SQLite CREATE TABLE statements and emit matching TypeScript interfaces. Strips comments and common index clauses with regex-based column extraction.
DeveloperTypeScriptSQL
Favorite this tool
No favorite storage mode has been selected.
Quick actions
Copy this tool URL or open the system share sheet on a supported device.
开发工具
SQL DDL to TypeScript
等待输入
已复制
Use cases
- Start Node services from DBA-provided CREATE TABLE scripts
- Generate client types from schema snippets in chat or docs
How to use
- Paste one or more CREATE TABLE statements separated by semicolons
- Review inferred column types
- Copy the TypeScript interfaces
Example input and output
FAQ
Which databases are supported?
Broad rules cover common MySQL, PostgreSQL, and SQLite column types such as INT, VARCHAR, and DATETIME.
Tools
Related tools
Continue with another translated tool for a nearby task.
JSON to TypeScript Interface
JSON to TypeScript Interface Generator
Infer TypeScript interface definitions from JSON in your browser. Nested objects become separate interfaces, with options for the root name, optional fields, readonly, export, and type aliases.
TypeScript JSON Developer
CSV to JSON
CSV to JSON Table Converter
Convert CSV tables to JSON arrays in your browser. Supports comma, tab, semicolon, or pipe separators and optional header rows. Processing stays local—useful for exports, API samples, and light imports.
CSV JSON Converter