SQL ↔ JSON Schema 转换器

免费在线 SQL CREATE TABLE 与 JSON Schema 双向转换工具：从建表 DDL 自动生成 JSON Schema Draft-07，含字段类型映射 / 必填项 / 默认值 / 注释；也支持 JSON Schema 反向生成 CREATE TABLE。所有处理在浏览器本地完成
NaNToday Remaining
NaNConverted
NaNTotal Helped
Rating(undefined users)
SQL (CREATE TABLE)319 bytes
CREATE TABLE users ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, email VARCHAR(255) NOT NULL UNIQUE, name VARCHAR(100) DEFAULT '', age INT, status TINYINT(1) DEFAULT 1 COMMENT '0:disabled 1:active', bio TEXT, avatar_url VARCHAR(500), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) );
JSON Schema output
Type on the left to see the conversion
User Guide
✨ Features
• Convert CREATE TABLE → JSON Schema Draft-07 with type mapping, required, default, comments, primary keys • Smart type mapping: VARCHAR(N) → string + maxLength; INT UNSIGNED → integer + minimum=0; TIMESTAMP → string + format:date-time; JSON → object • Reverse: JSON Schema → CREATE TABLE — picks the right SQL type from JSON Schema type / format / maxLength • Multi-table SQL automatically grouped under JSON Schema definitions • Live conversion + error feedback; all processing local
📖 How to Use
Step 1
Pick direction: SQL → JSON Schema or JSON Schema → SQL
Step 2
Paste DDL or schema on the left
Step 3
Right pane shows converted output with syntax highlighting
Step 4
Use 'Swap' to send output back to input — useful for round-trip verification
Like it? Rate it!

Feedback List