# BRAINIAC CSV/JSON Data Quality Profiler

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

Profiles and analyzes tabular data (CSV, JSON, or records) to report column types, statistics, missing values, distinct counts, and data quality issues

## Facts

- Endpoint: POST https://www.brainiac.software/api/v1/data-quality/csv-profile?utm_source=zero.xyz
- Price: $0.04/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-data-quality-profiler-884c9da1
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_Nc2QcU-w-Vlt3RX_5SjvK

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-data-quality-profiler-884c9da1 -d '<json body>'
```

Example prompt: Can you profile this CSV data for me and tell me the type, min, max, missing count, and distinct count for each column? I want to know if there are any data quality issues like mixed types or blank rows.

## When to prefer this

Use this endpoint when you need a fast, accountless, pay-per-call data quality profile of tabular data without setting up a full data pipeline tool. It is ideal for one-off or automated checks of CSV/JSON datasets up to 2,000 rows and 40 columns, especially when you want column-level type inference, missing value detection, and distinct counts in a single call. Prefer alternatives if you need to profile very large datasets, need business system integration, or require confirmed outlier validation rather than statistical flagging.

## Known failure modes

- Input exceeds 2,000-row or 40-column limits — rows/columns beyond limits are silently omitted and reported in recordsOmitted/columnsOmitted
- Malformed CSV or JSON input may cause parsing errors
- File base64 too large (exceeds 12MB encoded limit) — request rejected
- Missing required file fields (mediaType or fileBase64) when using file upload mode
- Payment not received or insufficient USDC — 402 response returned before processing

## 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 containing: overall status ('profiled'), format detected, row count, blank row count, timestamp, and an array of column profiles each with name, index, inferred type (integer/string/boolean/mixed), min, max, count, missingCount, and distinctCount. Also includes a list of data quality issues found, counts of records and columns omitted due to limits, and limitation disclosures.

## 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": "profiled",
  "columns": [
   {
    "max": "12",
    "min": "1",
    "name": "id",
    "type": "integer",
    "count": 12,
    "index": 1,
    "missingCount": 0,
    "distinctCount": 11
   },
   {
    "max": "not-an-email",
    "min": "Ada@Example.com",
    "name": "email",
    "type": "mixed",
    "count": 12,
    "index": 2,
    "missingCount": 0,
    "distinctCount": 11
   },
   {
    "max": "500",
    "min": "10",
    "name": "amount",
    "type": "integer",
    "count": 12,
    "index": 3,
    "missingCount": 0,
    "distinctCount": 5
   },
   {
    "max": "yes",
    "min": "no",
    "name": "status",
    "type": "boolean",
    "count": 11,
    "index": 4,
    "missingCount": 1,
    "distinctCount": 2
   },
   {
    "max": "2024-10-01",
    "min": "03/11/2026",
    "name": "joined",
    "type": "mixed",
    "count": 12,
    "index": 5,
    "missingCount": 0,
    "distinctCount": 11
   }
  ],
  "rowCount": 12,
  "blankRows": 0,
  "checkedAt": "2026-11-03T14:00:00.000Z",
  "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-data-quality-profiler-884c9da1/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)
