Auto Schema Detector

Infer a schema (types, nullability, uniqueness) from any sample dataset.

Free · No signup · Runs in your browser

Input formatdetected: csv

Output

Nullability

Input data317bytes·5rows·6cols

JSON Schema1,401bytes

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "type": "array",
  "items": {
    "type": "object",
    "properties": {
      "id": {
        "type": "integer",
        "minimum": 1,
        "maximum": 5,
        "examples": [
          "1",
          "2",
          "3"
        ]
      },
      "name": {
        "type": "string",
        "minLength": 11,
        "maxLength": 17,
        "examples": [
          "Ada Lovelace",
          "Grace Hopper",
          "Katherine Johnson"
        ]
      },
      "email": {
        "type": "string",
        "format": "email",
        "minLength": 15,
        "maxLength": 21,
        "examples": [
          "ada@example.com",
          "grace@example.com",
          "katherine@example.com"
        ]
      },
      "signup_date": {
        "type": "string",
        "format": "date",
        "examples": [
          "2024-01-12",
          "2024-02-05",
          "2023-12-30"
        ]
      },
      "score": {
        "type": "number",
        "minimum": 9.3,
        "maximum": 9.8,
        "examples": [
          "9.7",
          "9.4",
          "9.8"
        ]
      },
      "is_active": {
        "type": "boolean",
        "examples": [
          "true",
          "false"
        ]
      }
    },
    "required": [
      "id",
      "name",
      "email",
      "signup_date",
      "score",
      "is_active"
    ]
  }
}

column	type	conf.	rows	nulls	uniques	samples
id	integer	100%	5	0 · 0%	5	1 · 2 · 3
name	string	100%	5	0 · 0%	5	Ada Lovelace · Grace Hopper · Katherine Johnson
email	email	100%	5	0 · 0%	5	ada@example.com · grace@example.com · katherine@example.com
signup_date	date	100%	5	0 · 0%	5	2024-01-12 · 2024-02-05 · 2023-12-30
score	float	100%	5	0 · 0%	5	9.7 · 9.4 · 9.8
is_active	boolean	100%	5	0 · 0%	2	true · false

Runs entirely in your browser. Nothing is uploaded or stored.