SQL Alignment & Preview Tool

简体中文 | English

Welcome to SQL Alignment & Preview Tool! This application is designed to help you quickly format and organize SQL code, especially CREATE TABLE statements. With a clean interface and a powerful alignment engine, you can easily transform messy SQL into clear, readable, and professional-looking code, improving both development and maintenance efficiency.

---

Features

✨ Single SQL Alignment

• Live Preview: Paste your SQL in the left editor, and the right preview panel will instantly show the formatted result.
• Side-by-Side Comparison: Original vs. formatted SQL displayed side-by-side for easy review.
• Code Statistics: Automatically count total lines, valid lines, comment lines, and field numbers for quick insights.
• Export Options: Download formatted SQL or a full report with one click.

📂 Batch Processing

• File Upload: Upload multiple .sql or .txt files at once.
• Progress Indicator: Track real-time processing progress with a progress bar and status updates.
• Custom File Prefix: Add a prefix to output filenames for easier batch management.
• Processing Report: Get a summary report including processed results and potential issues.
• ZIP Download: All formatted files are bundled into a ZIP for quick download.

---

Customization

In the left sidebar, you can tweak alignment behavior:

• Comment Wrap Width: Adjust the maximum line width for comment wrapping.
• Line Numbers: Toggle line numbers on or off in previews.
• Case Sensitivity: Choose whether keywords are case-sensitive during alignment.

---

Example

• Original SQL

-- ----------------------------
-- Table structure for demo
-- ----------------------------
DROP TABLE IF EXISTS "public"."demo";
CREATE TABLE "public"."demo" (
  "id" int8 NOT NULL ,
  "tenant_id" int8 NOT NULL DEFAULT 0,
  "name" varchar(255) NOT NULL,
  "age" int4,
  "type" int2 NOT NULL,
  "ip" inet,
  "port" int4,
  "status" bool DEFAULT false,
  "usage" numeric(5,2) NOT NULL DEFAULT 0.00,
  "balance" numeric(18,2) NOT NULL DEFAULT 0.00,
  "meta" jsonb NOT NULL DEFAULT '{}'::jsonb,
  "version" varchar(30),
  "creator" varchar(64),
  "create_time" timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "updater" varchar(64),
  "update_time" timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "deleted" int2 NOT NULL DEFAULT 0,
  "remark" varchar(500)
)
;
COMMENT ON COLUMN "public"."demo"."id" IS '主键';
COMMENT ON COLUMN "public"."demo"."tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."demo"."name" IS '名称';
COMMENT ON COLUMN "public"."demo"."age" IS '年龄（0-150）';
COMMENT ON COLUMN "public"."demo"."type" IS '设备类型：1-直连 2-网关子 3-网关';
COMMENT ON COLUMN "public"."demo"."ip" IS 'IP地址';
COMMENT ON COLUMN "public"."demo"."port" IS '端口（1-65535）';
COMMENT ON COLUMN "public"."demo"."usage" IS '使用率百分比（0-100）';
COMMENT ON COLUMN "public"."demo"."balance" IS '余额（保留2位小数）';
COMMENT ON COLUMN "public"."demo"."meta" IS '扩展JSON';
COMMENT ON COLUMN "public"."demo"."version" IS '版本号（生成列）';
COMMENT ON COLUMN "public"."demo"."creator" IS '创建人';
COMMENT ON COLUMN "public"."demo"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."demo"."updater" IS '更新人';
COMMENT ON COLUMN "public"."demo"."update_time" IS '更新时间';
COMMENT ON COLUMN "public"."demo"."deleted" IS '逻辑删除';
COMMENT ON COLUMN "public"."demo"."remark" IS '描述';
COMMENT ON TABLE "public"."demo" IS '示例表';

• Formatted SQL

-- ----------------------------
-- Table structure for demo
-- ----------------------------
DROP TABLE IF EXISTS "public"."demo";
CREATE TABLE "public"."demo" (
    "id"          int8          NOT NULL,
    "tenant_id"   int8          NOT NULL DEFAULT 0,
    "name"        varchar(255)  NOT NULL,
    "age"         int4,
    "type"        int2          NOT NULL,
    "ip"          inet,
    "port"        int4,
    "status"      bool          DEFAULT false,
    "usage"       numeric(5,2)  NOT NULL DEFAULT 0.00,
    "balance"     numeric(18,2) NOT NULL DEFAULT 0.00,
    "meta"        jsonb         NOT NULL DEFAULT '{}'::jsonb,
    "version"     varchar(30),
    "creator"     varchar(64),
    "create_time" timestamp(6)  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater"     varchar(64),
    "update_time" timestamp(6)  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted"     int2          NOT NULL DEFAULT 0,
    "remark"      varchar(500)
)
;
COMMENT ON COLUMN "public"."demo"."id"          IS '主键';
COMMENT ON COLUMN "public"."demo"."tenant_id"   IS '租户ID';
COMMENT ON COLUMN "public"."demo"."name"        IS '名称';
COMMENT ON COLUMN "public"."demo"."age"         IS '年龄（0-150）';
COMMENT ON COLUMN "public"."demo"."type"        IS '设备类型：1-直连 2-网关子 3-网关';
COMMENT ON COLUMN "public"."demo"."ip"          IS 'IP地址';
COMMENT ON COLUMN "public"."demo"."port"        IS '端口（1-65535）';
COMMENT ON COLUMN "public"."demo"."usage"       IS '使用率百分比（0-100）';
COMMENT ON COLUMN "public"."demo"."balance"     IS '余额（保留2位小数）';
COMMENT ON COLUMN "public"."demo"."meta"        IS '扩展JSON';
COMMENT ON COLUMN "public"."demo"."version"     IS '版本号（生成列）';
COMMENT ON COLUMN "public"."demo"."creator"     IS '创建人';
COMMENT ON COLUMN "public"."demo"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."demo"."updater"     IS '更新人';
COMMENT ON COLUMN "public"."demo"."update_time" IS '更新时间';
COMMENT ON COLUMN "public"."demo"."deleted"     IS '逻辑删除';
COMMENT ON COLUMN "public"."demo"."remark"      IS '描述';
COMMENT ON TABLE "public"."demo"                IS '示例表';