Dataset constraint checker

Open Dataset constraint checker on Happytails.ai. This view has the same page content and links, with explicit tool capabilities. Read the processing notes before using a tool.

Tool capabilities

{
  "id": "dataset-constraint-checker",
  "category": "data-tools",
  "built": true,
  "requirements": "Unique rules span the union of the selected tables, including duplicate records in a single source. Range bounds are inclusive decimal strings. skipEmpty is optional and defaults to false. Reports omit source cell values. Up to 1,000,000 characters, 10,000 data records, 100 columns and 100,000 cells across the sources. Files for multi-source tools are limited to 4,000,000 bytes total. Reports retain at most 500 diagnostic findings and state any omitted count. CSV and JSON outputs are limited to 4,000,000 characters.",
  "implementation": {
    "fields": [
      {
        "key": "separator",
        "label": "Input CSV separator",
        "value": ",",
        "type": "select",
        "values": [
          ",",
          ";",
          "\t"
        ]
      },
      {
        "key": "rules",
        "label": "Table constraints (JSON)",
        "value": "[\n  {\n    \"type\": \"unique\",\n    \"tables\": [\n      \"first.csv\",\n      \"second.csv\"\n    ],\n    \"columns\": [\n      \"id\"\n    ]\n  },\n  {\n    \"type\": \"range\",\n    \"tables\": [\n      \"first.csv\",\n      \"second.csv\"\n    ],\n    \"column\": \"amount\",\n    \"min\": \"0\",\n    \"max\": \"10000\"\n  }\n]",
        "type": "textarea",
        "help": "Select tables by their exact uploaded filenames. unique accepts columns (an array); range accepts one column and min and/or max decimal strings. skipEmpty defaults to false."
      }
    ],
    "live": false,
    "presentation": "metrics",
    "note": "Runs locally on your device. CSV requires unique nonempty headers. Up to 1,000,000 characters, 10,000 data records and 100,000 cells across inputs, with 100 columns. Quoted multiline cells are supported. Each JSON settings field is limited to 100,000 characters. Output files are bounded to 4,000,000 characters. Diagnostic reports contain at most 500 findings and disclose the omitted count. Select 1 to 10 distinct UTF-8 CSV files. Up to 4,000,000 bytes total; aggregate CSV limits still apply. Each unique rule checks the union of its selected tables, including duplicates within a source. Range bounds are inclusive. Files are read sequentially and long checks yield so you can cancel.",
    "files": true,
    "multiple": true,
    "input": false,
    "accept": ".csv,.tsv,text/csv",
    "maxFileBytes": 4000000,
    "experience": {
      "automatic": false,
      "single": false,
      "inputMaxLength": 1000000,
      "inputMode": "text",
      "label": "Your text",
      "placeholder": "Type or paste your input…",
      "help": "Up to 1,000,000 characters. Review the settings before running.",
      "helpParts": [
        "Up to 1,000,000 characters.",
        "Review the settings before running."
      ],
      "action": null
    },
    "mode": "explicit",
    "interactive": false
  },
  "execution": "Browser interface",
  "api": null,
  "browser_agent": {
    "supported": true,
    "name": "run_current_tool",
    "discovery": "WebMCP on the human page in a supporting browser",
    "verification": "See audit/API-AUDIT.md; availability is not verification"
  }
}

Page guide