Does this tool support all SQL types?

Yes. Supports INT, VARCHAR, CHAR, TEXT, DECIMAL, FLOAT, DOUBLE, BOOLEAN, DATE, DATETIME, TIMESTAMP, ENUM, JSON, BLOB, and more. Automatically maps SQL types to correct JSON Schema and Zod types.

Are constraints like NOT NULL and DEFAULT preserved?

Yes. NOT NULL columns are added to the 'required' array in JSON Schema and use non-optional types in Zod. DEFAULT values are captured in both schemas.

Is my SQL data sent to a server?

No. This tool runs 100% client-side in your browser. Your SQL statements never leave your device.

Can I use this for database migration tools?

Yes. The generated JSON Schema and Zod schemas are production-ready and can be used with Prisma, Drizzle, TypeORM, or custom migration scripts.

SQL to JSON Schema

Transform SQL CREATE TABLE statements into production-ready JSON Schema and Zod TypeScript validation. 100% client-side — your SQL never leaves your browser.

SQL Input

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "title": "users",
  "type": "object",
  "properties": {
    "id": {
      "type": "integer",
      "description": "PRIMARY KEY, AUTO_INCREMENT"
    },
    "username": {
      "type": "string",
      "maxLength": 50,
      "description": "UNIQUE"
    },
    "email": {
      "type": "string",
      "maxLength": 255
    },
    "age": {
      "type": "integer"
    },
    "status": {
      "enum": [
        "active",
        "pending",
        "deleted"
      ],
      "default": "active"
    },
    "created_at": {
      "type": "string",
      "default": "CURRENT_TIMESTAMP"
    }
  },
  "required": [
    "username",
    "email"
  ]
}

What Gets Converted?

✓ Column types: INT → number, VARCHAR → string, BOOLEAN → boolean, etc.
✓ VARCHAR length: VARCHAR(50) → maxLength: 50 in JSON Schema, .max(50) in Zod
✓ NOT NULL: Adds column to 'required' array, removes .optional() from Zod
✓ DEFAULT values: Captured in both schemas using .default()
✓ ENUM values: ENUM('a','b') → z.enum(['a','b']) and JSON enum array
✓ Metadata: PRIMARY KEY, UNIQUE, AUTO_INCREMENT preserved in descriptions