Referential integrity checker

Open Referential integrity 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": "referential-integrity-checker",
  "category": "data-tools",
  "built": true,
  "requirements": "Parent keys must be nonempty and unique. Composite keys compare exact ordered strings without trimming or numeric coercion. An option allows entirely empty child keys; partly empty keys remain violations. 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": "childKeys",
        "label": "Child key columns (JSON)",
        "value": "[\"customer_id\"]",
        "type": "textarea",
        "help": "Ordered child foreign-key columns."
      },
      {
        "key": "parentKeys",
        "label": "Parent key columns (JSON)",
        "value": "[\"id\"]",
        "type": "textarea",
        "help": "Equally many parent primary-key columns, in matching order."
      },
      {
        "key": "comparison",
        "label": "Parent CSV",
        "value": "id\nA\nB\n",
        "type": "textarea",
        "help": "Paste the parent table, including its header."
      },
      {
        "key": "emptyKeys",
        "label": "Empty child keys",
        "value": "Report missing",
        "type": "select",
        "values": [
          "Report missing",
          "Allow entirely empty"
        ]
      }
    ],
    "live": true,
    "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. Paste the child table in the main input. Parent keys must be nonempty and unique. Exact string matching supports composite keys. Partially empty child keys are always violations; entirely empty keys can be permitted explicitly.",
    "experience": {
      "automatic": true,
      "single": false,
      "inputMaxLength": 1000000,
      "inputMode": "text",
      "label": "Child CSV",
      "placeholder": "customer_id\nA\nC",
      "help": "Paste CSV data with unique column headers. Quoted multiline cells are supported. Results update as you type. Up to 1,000,000 characters.",
      "helpParts": [
        "Paste CSV data with unique column headers. Quoted multiline cells are supported.",
        "Results update as you type.",
        "Up to 1,000,000 characters."
      ],
      "action": null
    },
    "mode": "automatic",
    "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