# BRAINIAC CSV/JSON Schema Detector

> BRAINIAC CSV/JSON Schema Detector is a paid API for AI agents from www.brainiac.software, paid per call via x402, $0.03/call, status unknown (last checked 2026-11-17).

Analyzes CSV, JSON, or tabular data to detect column types, data quality issues, nullability, and row/column statistics without modifying the source data.

## Facts

- Endpoint: POST https://www.brainiac.software/api/v1/data-quality/csv-schema-detect?utm_source=zero.xyz
- Price: $0.03/call
- Payment: x402
- Status: unknown
- Last checked: 2026-11-17
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/brainiac-csv-json-schema-detector-84b452fc
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_rnJQOhONQFs47ZvFM-ja3

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability brainiac-csv-json-schema-detector-84b452fc -d '<json body>'
```

Example prompt: I have a CSV file with columns like id, email, amount, status, and joined — can you detect the schema and tell me which columns have mixed types, nulls, or data quality issues?

## When to prefer this

Choose this endpoint when you need fast, accountless schema detection and data profiling on tabular data (CSV, JSON, or records) without modifying source data. Ideal for pre-import validation, pipeline ingestion checks, or any agent workflow that needs to understand data structure before processing. At $0.03 per call with no account required, it suits ephemeral agent workflows. Prefer alternatives if you need full data transformation, database writes, or analysis beyond 2,000 rows / 40 columns.

## Known failure modes

- Input exceeds 200,000 character limit for CSV/JSON strings — request is rejected
- More than 2,000 rows provided — rows beyond the limit are silently omitted and recordsOmitted is incremented
- More than 40 columns in input — extra columns are omitted and columnsOmitted is incremented
- Invalid base64 encoding in file.fileBase64 — parsing error returned
- Unsupported mediaType provided — validation error
- Payment of $0.03 USDC on Base not completed — 402 response with payment instructions
- Empty or malformed CSV/JSON — may return zero columns or parsing error

## How this service works

Pay-per-call APIs for AI agents: OFAC sanctions screening, compliance checks, token security, and Base chain data via x402. No account. Fixed USDC price. MCP-ready.

## Output

Returns a JSON object with per-column metadata (name, detected type, count, index, nullable, distinctCount), overall row count, blank row count, columns/records omitted due to limits, data modification flag, outlier confirmation status, and a list of data quality issues and limitations. The checkedAt timestamp and format field are also included.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "csv": {
   "type": "string",
   "maxLength": 200000
  },
  "file": {
   "type": "object",
   "required": [
    "mediaType",
    "fileBase64"
   ],
   "properties": {
    "filename": {
     "type": "string",
     "maxLength": 180,
     "minLength": 1
    },
    "mediaType": {
     "enum": [
      "text/csv",
      "application/json",
      "text/plain"
     ],
     "type": "string"
    },
    "fileBase64": {
     "type": "string",
     "maxLength": 12000000,
     "minLength": 1
    }
   },
   "additionalProperties": false
  },
  "json": {
   "type": "string",
   "maxLength": 200000
  },
  "records": {
   "type": "array",
   "items": {
    "type": "object",
    "propertyNames": {
     "type": "string",
     "maxLength": 80,
     "minLength": 1
    },
    "additionalProperties": {
     "anyOf": [
      {
       "type": "string",
       "maxLength": 4000
      },
      {
       "type": "number"
      },
      {
       "type": "boolean"
      },
      {
       "type": "null"
      }
     ]
    }
   },
   "maxItems": 5000
  },
  "keyColumns": {
   "type": "array",
   "items": {
    "type": "string",
    "maxLength": 80,
    "minLength": 1
   },
   "maxItems": 20
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "format": "csv",
  "issues": [],
  "status": "detected",
  "columns": [
   {
    "name": "id",
    "type": "integer",
    "count": 12,
    "index": 1,
    "nullable": false,
    "distinctCount": 11
   },
   {
    "name": "email",
    "type": "mixed",
    "count": 12,
    "index": 2,
    "nullable": false,
    "distinctCount": 11
   },
   {
    "name": "amount",
    "type": "integer",
    "count": 12,
    "index": 3,
    "nullable": false,
    "distinctCount": 5
   },
   {
    "name": "status",
    "type": "boolean",
    "count": 11,
    "index": 4,
    "nullable": true,
    "distinctCount": 2
   },
   {
    "name": "joined",
    "type": "mixed",
    "count": 12,
    "index": 5,
    "nullable": false,
    "distinctCount": 11
   }
  ],
  "rowCount": 12,
  "blankRows": 0,
  "checkedAt": "2026-11-03T14:00:00.000Z",
  "columnCount": 5,
  "limitations": [
   "No business system is contacted or updated.",
   "Rows past the 2,000-row limit and columns past the 40-column limit are not read. recordsOmitted and columnsOmitted state how many.",
   "Rows that were read stay in the counts. None of those rows is deleted.",
   "Normalization is a proposal. The original cell is kept beside the proposed value.",
   "A statistical outlier is not a confirmed error.",
   "A date is normalized only when it is already a real YYYY-MM-DD day."
  ],
  "recordsRead": 12,
  "dataModified": false,
  "columnsOmitted": 0,
  "recordsOmitted": 0,
  "recordsDiscarded": false,
  "outliersConfirmed": false
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/brainiac-csv-json-schema-detector-84b452fc/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from www.brainiac.software](https://www.zero.xyz/host/www.brainiac.software/llms.txt)
