SQL DDL to JSON Schema Converter
Turn SQL CREATE TABLE statements into a standard JSON Schema Draft-07 model automatically
This tool parses SQL DDL — the CREATE TABLE statements that define your relational database tables — and maps column types (INT, VARCHAR, TIMESTAMP, and more), nullability, and constraints into a matching JSON Schema Draft-07 document you can drop straight into a RESTful API contract.
도구를 불러오는 중…
🔒 Everything runs 100% in your browser. Your files and input are never uploaded to any server.
How to use
- Paste your SQL CREATE TABLE statement into the editor.
- Optionally toggle "Allow null union types for columns without NOT NULL" to control how nullable columns are typed.
- Copy the generated JSON Schema Draft-07 output or download it as a file and use it in your project.
FAQ
- Which SQL data types are supported?
- Integer types such as INT and BIGINT map to integer, numeric types such as DECIMAL and FLOAT map to number, and character and date/time types such as VARCHAR, TEXT, and DATETIME map to string with the appropriate format. BOOLEAN and JSON columns are converted as well.
- Can I paste multiple CREATE TABLE statements into the input box at once?
- Yes — enter several CREATE TABLE statements separated by semicolons, and the tool generates a separate JSON Schema definition for each table, in order. One thing it doesn't do automatically, though, is carry FOREIGN KEY relationships between tables into the schema — you'll need to add those references yourself if you need them.
- Can I paste multiple CREATE TABLE statements into the input box at once?
- Yes — enter several CREATE TABLE statements separated by semicolons, and the tool generates a separate JSON Schema definition for each table, in order. One thing it doesn't do automatically, though, is carry FOREIGN KEY relationships between tables into the schema — you'll need to add those references yourself if you need them.