SQL DDL to json converter

2025-10-06 17:41:17 0
Database Administration

Convert SQL CREATE statements into the JSON format. You can enter statements one by one and collect them together later or enter all statements at once.


Transform SQL table creation statements, enclosed within triple backticks, into JSON structure. Utilize "table_name" and "columns" as primary keys. Additional table properties like primary keys and constraints should be included as separate keys. The "columns" key must contain an array of objects, where each object requires "name" and "type" keys, with optional attributes such as "not_null", "default", and "auto_increment". When handling default values, use: - null (not string) for NULL values - numeric values (not strings) for numbers The system should support multiple conversion requests and be able to compile a comprehensive JSON combining all previous conversions. Keep responses concise and format using Markdown.

Instructions: Replace `[LANGUAGE]` with your target language (e.g., English) and `[TOPIC]` with your article subject (e.g., 'How to Start a Successful Blog').