SQL to JSON

Convert SQL CREATE TABLE statements to JSON schema with column types and constraints.

CREATE TABLEType DetectionFree

SQL CREATE TABLE

JSON Schema

{
  "table": "users",
  "columns": [
    {
      "name": "id",
      "type": "INT",
      "primaryKey": true,
      "autoIncrement": true
    },
    {
      "name": "name",
      "type": "VARCHAR(100)",
      "nullable": false
    },
    {
      "name": "email",
      "type": "VARCHAR(255)",
      "nullable": false,
      "unique": true
    },
    {
      "name": "age",
      "type": "INT",
      "default": "0"
    },
    {
      "name": "created_at",
      "type": "TIMESTAMP",
      "default": "CURRENT_TIMESTAMP"
    }
  ]
}

How It Works

Paste SQL

Enter a CREATE TABLE statement.

Parse Schema

Configure options and preferences.

Get Results

Copy output or view results instantly.

Guides

Age Calculator: Calculate Exact Age Online How to Trim Audio Files Online AVIF Format: Next-Gen Image Format Guide

Browse all Developer Tools

Love this tool? Explore 999+ more

Free online tools for images, PDFs, text, code, and more. All running in your browser.

Explore All Tools

SQL to JSON

How It Works

Paste SQL

Parse Schema

Get Results

Explore More

Related Tools

Guides

Love this tool? Explore 999+ more

SQL to JSON

How It Works

Paste SQL

Parse Schema

Get Results

Explore More

Related Tools

Guides

Love this tool? Explore 999+ more