多数据库语句转JSON/表单/postman

SQL通用
MySQL
SQLite
Oracle
PostgreSQL
Access
Redis
MongoDB
Memcached
SQL/语句
操作
转换结果

工具说明

1. 支持9种类型：通用SQL、MySQL、SQLite、Oracle、PostgreSQL、Access、Redis、MongoDB、Memcached。

2. Tab切换自动填充对应标准示例语句，一键转换。

3. 转换功能：

  • 转JSON：生成实体空模板，适用于前端、接口定义
  • 转表单：输出原生HTML Input表单代码
  • 转Postman：带默认值JSON请求体，直接复制接口测试

4. 自动兼容多数据库自增主键：过滤AUTO_INCREMENT/AUTOINCREMENT/IDENTITY/SERIAL等id字段。

各数据库标准示例

0. 通用标准SQL（通用Tab）

CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '用户主键ID',
  `username` varchar(255) NOT NULL COMMENT '登录账号',
  `auth_key` varchar(32) NOT NULL COMMENT '身份密钥',
  `password_hash` varchar(255) NOT NULL COMMENT '加密密码',
  `password_reset_token` varchar(255) DEFAULT NULL COMMENT '重置密码令牌',
  `email` varchar(255) NOT NULL COMMENT '邮箱',
  `status` smallint NOT NULL DEFAULT '10' COMMENT '状态 10正常 0禁用',
  `created_at` int NOT NULL COMMENT '创建时间戳',
  `updated_at` int NOT NULL COMMENT '更新时间戳',
  PRIMARY KEY (`id`),
  UNIQUE INDEX uk_username (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

1. MySQL

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `auth_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password_reset_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` smallint(6) NOT NULL DEFAULT '10',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

2. SQLite

CREATE TABLE user (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    username TEXT NOT NULL,
    auth_key TEXT NOT NULL,
    password_hash TEXT NOT NULL,
    password_reset_token TEXT NULL,
    email TEXT NOT NULL,
    status INTEGER NOT NULL DEFAULT 10,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL
);
CREATE UNIQUE INDEX idx_username ON user(username);

3. Oracle

CREATE TABLE "USER" (
    ID NUMBER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    USERNAME VARCHAR2(255) NOT NULL,
    AUTH_KEY VARCHAR2(32) NOT NULL,
    PASSWORD_HASH VARCHAR2(255) NOT NULL,
    PASSWORD_RESET_TOKEN VARCHAR2(255),
    EMAIL VARCHAR2(255) NOT NULL,
    STATUS NUMBER(6) DEFAULT 10 NOT NULL,
    CREATED_AT NUMBER NOT NULL,
    UPDATED_AT NUMBER NOT NULL
);
CREATE UNIQUE INDEX UK_USERNAME ON "USER"(USERNAME);

4. PostgreSQL

CREATE TABLE "user" (
    id SERIAL PRIMARY KEY,
    username VARCHAR(255) NOT NULL,
    auth_key VARCHAR(32) NOT NULL,
    password_hash VARCHAR(255) NOT NULL,
    password_reset_token VARCHAR(255),
    email VARCHAR(255) NOT NULL,
    status SMALLINT NOT NULL DEFAULT 10,
    created_at BIGINT NOT NULL,
    updated_at BIGINT NOT NULL
);
CREATE UNIQUE INDEX idx_username ON "user"(username);

5. Access

CREATE TABLE user (
    id AUTOINCREMENT PRIMARY KEY,
    username TEXT NOT NULL,
    auth_key TEXT NOT NULL,
    password_hash TEXT NOT NULL,
    password_reset_token TEXT,
    email TEXT NOT NULL,
    status SMALLINT NOT NULL DEFAULT 10,
    created_at LONG NOT NULL,
    updated_at LONG NOT NULL
);
CREATE UNIQUE INDEX idx_username ON user(username);

6. Redis（Hash结构示例）

# 用户Hash存储
HSET user:1 username test auth_key abc123 password_hash xxx email test@xx.com status 10 created_at 1740000000 updated_at 1740000000
# 字段列表：username,auth_key,password_hash,password_reset_token,email,status,created_at,updated_at

7. MongoDB（文档示例）

{
  "_id": ObjectId("600000000000000000000000"),
  "username": "",
  "auth_key": "",
  "password_hash": "",
  "password_reset_token": null,
  "email": "",
  "status": 10,
  "created_at": 1740000000,
  "updated_at": 1740000000
}

8. Memcached（键值字段映射）

# key前缀 user_1
# 字段列表：
username,auth_key,password_hash,password_reset_token,email,status,created_at,updated_at
# 存储示例 set user_1:username test 0 3600