BRAINIAC Data Quality Intelligence is an MCP server published by software.brainiac, hosted at www.brainiac.software. When last checked on 2026-11-21 it was working: it answers and lists its tools. It declares 8 tools, including data-quality_csv-schema-detect, data-quality_csv-profile, data-quality_csv-column-type-detect, data-quality_csv-missing-value-audit, data-quality_csv-duplicate-row-detect.
Paid Data Quality Intelligence API via x402. Unpaid tool calls return 402.
1,073 connections through 4 shared values. Tap any node.
Squares are this server's values; dots are other servers sharing them. A shared address or publisher is a lead, not proof of a common operator.
Inferred from the host name and headers: what a server runs on, not who runs it.
Infer a column type from the supplied CSV or JSON values before you load or rely on a dataset. A column with more than one non-numeric type stays mixed. No value is rewritten. Call with optional records, csv, json, file, keyColumns. Returns checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, rowCount. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Detect a CSV schema.
| Parameter | Type | Description |
|---|---|---|
| csv | string | csv, string, length 0 to 200000. Optional. |
| file | object | file, object. Optional. |
| json | string | json, string, length 0 to 200000. Optional. |
| records | array | records, array. Optional. |
| keyColumns | array | keyColumns, array. Optional. |
{
"name": "data-quality_csv-schema-detect",
"title": "Detect a CSV schema",
"description": "Infer a column type from the supplied CSV or JSON values before you load or rely on a dataset. A column with more than one non-numeric type stays mixed. No value is rewritten. Call with optional records, csv, json, file, keyColumns. Returns checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, rowCount. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Detect a CSV schema.",
"inputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"csv": {
"type": "string",
"maxLength": 200000,
"description": "csv, string, length 0 to 200000. Optional."
},
"file": {
"type": "object",
"required": [
"mediaType",
"fileBase64"
],
"properties": {
"filename": {
"type": "string",
"maxLength": 180,
"minLength": 1,
"description": "filename, string, length 1 to 180. Optional."
},
"mediaType": {
"enum": [
"text/csv",
"application/json",
"text/plain"
],
"type": "string",
"description": "mediaType, string, one of text/csv, application/json, text/plain. Required."
},
"fileBase64": {
"type": "string",
"maxLength": 12000000,
"minLength": 1,
"description": "fileBase64, string, length 1 to 12000000. Required."
}
},
"description": "file, object. Optional."
},
"json": {
"type": "string",
"maxLength": 200000,
"description": "json, string, length 0 to 200000. Optional."
},
"records": {
"type": "array",
"items": {
"type": "object",
"description": "item, object. Required.",
"propertyNames": {
"type": "string",
"maxLength": 80,
"minLength": 1
},
"additionalProperties": {
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
]
}
},
"description": "records, array. Optional."
},
"keyColumns": {
"type": "array",
"items": {
"type": "string",
"maxLength": 80,
"minLength": 1,
"description": "item, string, length 1 to 80. Required."
},
"description": "keyColumns, array. Optional."
}
}
},
"outputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"format": {
"type": "string",
"description": "format. String."
},
"issues": {
"type": "array",
"items": {
"type": "string",
"description": "Item. String."
},
"description": "issues. Array."
},
"status": {
"type": "string",
"description": "status. String."
},
"columns": {
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string",
"description": "name. String."
},
"type": {
"type": "string",
"description": "type. String."
},
"count": {
"type": "number",
"description": "count. Number."
},
"index": {
"type": "number",
"description": "index. Number."
},
"nullable": {
"type": "boolean",
"description": "nullable. Boolean."
},
"distinctCount": {
"type": "number",
"description": "distinctCount. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "columns. Array."
},
"rowCount": {
"type": "number",
"description": "rowCount. Number."
},
"blankRows": {
"type": "number",
"description": "blankRows. Number."
},
"checkedAt": {
"type": "string",
"description": "checkedAt. String."
},
"columnCount": {
"type": "number",
"description": "columnCount. Number."
},
"limitations": {
"type": "array",
"items": {
"type": "string",
"description": "Item. String."
},
"description": "limitations. Array."
},
"recordsRead": {
"type": "number",
"description": "recordsRead. Number."
},
"dataModified": {
"type": "boolean",
"description": "dataModified. Boolean."
},
"columnsOmitted": {
"type": "number",
"description": "columnsOmitted. Number."
},
"recordsOmitted": {
"type": "number",
"description": "recordsOmitted. Number."
},
"recordsDiscarded": {
"type": "boolean",
"description": "recordsDiscarded. Boolean."
},
"outliersConfirmed": {
"type": "boolean",
"description": "outliersConfirmed. Boolean."
}
},
"additionalProperties": {}
},
"annotations": {
"title": "Detect a CSV schema",
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true,
"destructiveHint": false
}
}Count present, missing, and distinct values for each column and report the minimum and maximum of the supplied values before you load or rely on a dataset. Call with optional records, csv, json, file, keyColumns. Returns checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, rowCount, columns. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Profile CSV columns.
| Parameter | Type | Description |
|---|---|---|
| csv | string | csv, string, length 0 to 200000. Optional. |
| file | object | file, object. Optional. |
| json | string | json, string, length 0 to 200000. Optional. |
| records | array | records, array. Optional. |
| keyColumns | array | keyColumns, array. Optional. |
{
"name": "data-quality_csv-profile",
"title": "Profile CSV columns",
"description": "Count present, missing, and distinct values for each column and report the minimum and maximum of the supplied values before you load or rely on a dataset. Call with optional records, csv, json, file, keyColumns. Returns checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, rowCount, columns. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Profile CSV columns.",
"inputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"csv": {
"type": "string",
"maxLength": 200000,
"description": "csv, string, length 0 to 200000. Optional."
},
"file": {
"type": "object",
"required": [
"mediaType",
"fileBase64"
],
"properties": {
"filename": {
"type": "string",
"maxLength": 180,
"minLength": 1,
"description": "filename, string, length 1 to 180. Optional."
},
"mediaType": {
"enum": [
"text/csv",
"application/json",
"text/plain"
],
"type": "string",
"description": "mediaType, string, one of text/csv, application/json, text/plain. Required."
},
"fileBase64": {
"type": "string",
"maxLength": 12000000,
"minLength": 1,
"description": "fileBase64, string, length 1 to 12000000. Required."
}
},
"description": "file, object. Optional."
},
"json": {
"type": "string",
"maxLength": 200000,
"description": "json, string, length 0 to 200000. Optional."
},
"records": {
"type": "array",
"items": {
"type": "object",
"description": "item, object. Required.",
"propertyNames": {
"type": "string",
"maxLength": 80,
"minLength": 1
},
"additionalProperties": {
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
]
}
},
"description": "records, array. Optional."
},
"keyColumns": {
"type": "array",
"items": {
"type": "string",
"maxLength": 80,
"minLength": 1,
"description": "item, string, length 1 to 80. Required."
},
"description": "keyColumns, array. Optional."
}
}
},
"outputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"format": {
"type": "string",
"description": "format. String."
},
"issues": {
"type": "array",
"items": {
"type": "string",
"description": "Item. String."
},
"description": "issues. Array."
},
"status": {
"type": "string",
"description": "status. String."
},
"columns": {
"type": "array",
"items": {
"type": "object",
"properties": {
"max": {
"type": "string",
"description": "max. String."
},
"min": {
"type": "string",
"description": "min. String."
},
"name": {
"type": "string",
"description": "name. String."
},
"type": {
"type": "string",
"description": "type. String."
},
"count": {
"type": "number",
"description": "count. Number."
},
"index": {
"type": "number",
"description": "index. Number."
},
"missingCount": {
"type": "number",
"description": "missingCount. Number."
},
"distinctCount": {
"type": "number",
"description": "distinctCount. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "columns. Array."
},
"rowCount": {
"type": "number",
"description": "rowCount. Number."
},
"blankRows": {
"type": "number",
"description": "blankRows. Number."
},
"checkedAt": {
"type": "string",
"description": "checkedAt. String."
},
"limitations": {
"type": "array",
"items": {
"type": "string",
"description": "Item. String."
},
"description": "limitations. Array."
},
"recordsRead": {
"type": "number",
"description": "recordsRead. Number."
},
"dataModified": {
"type": "boolean",
"description": "dataModified. Boolean."
},
"columnsOmitted": {
"type": "number",
"description": "columnsOmitted. Number."
},
"recordsOmitted": {
"type": "number",
"description": "recordsOmitted. Number."
},
"recordsDiscarded": {
"type": "boolean",
"description": "recordsDiscarded. Boolean."
},
"outliersConfirmed": {
"type": "boolean",
"description": "outliersConfirmed. Boolean."
}
},
"additionalProperties": {}
},
"annotations": {
"title": "Profile CSV columns",
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true,
"destructiveHint": false
}
}List the observed types in each column before you load or rely on a dataset. A value that differs from the most common type is referenced by row and column and is not changed. A tie is not blamed on a row. Call with optional records, csv, json, file, keyColumns. Returns checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Detect CSV column types.
| Parameter | Type | Description |
|---|---|---|
| csv | string | csv, string, length 0 to 200000. Optional. |
| file | object | file, object. Optional. |
| json | string | json, string, length 0 to 200000. Optional. |
| records | array | records, array. Optional. |
| keyColumns | array | keyColumns, array. Optional. |
{
"name": "data-quality_csv-column-type-detect",
"title": "Detect CSV column types",
"description": "List the observed types in each column before you load or rely on a dataset. A value that differs from the most common type is referenced by row and column and is not changed. A tie is not blamed on a row. Call with optional records, csv, json, file, keyColumns. Returns checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Detect CSV column types.",
"inputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"csv": {
"type": "string",
"maxLength": 200000,
"description": "csv, string, length 0 to 200000. Optional."
},
"file": {
"type": "object",
"required": [
"mediaType",
"fileBase64"
],
"properties": {
"filename": {
"type": "string",
"maxLength": 180,
"minLength": 1,
"description": "filename, string, length 1 to 180. Optional."
},
"mediaType": {
"enum": [
"text/csv",
"application/json",
"text/plain"
],
"type": "string",
"description": "mediaType, string, one of text/csv, application/json, text/plain. Required."
},
"fileBase64": {
"type": "string",
"maxLength": 12000000,
"minLength": 1,
"description": "fileBase64, string, length 1 to 12000000. Required."
}
},
"description": "file, object. Optional."
},
"json": {
"type": "string",
"maxLength": 200000,
"description": "json, string, length 0 to 200000. Optional."
},
"records": {
"type": "array",
"items": {
"type": "object",
"description": "item, object. Required.",
"propertyNames": {
"type": "string",
"maxLength": 80,
"minLength": 1
},
"additionalProperties": {
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
]
}
},
"description": "records, array. Optional."
},
"keyColumns": {
"type": "array",
"items": {
"type": "string",
"maxLength": 80,
"minLength": 1,
"description": "item, string, length 1 to 80. Required."
},
"description": "keyColumns, array. Optional."
}
}
},
"outputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"format": {
"type": "string",
"description": "format. String."
},
"issues": {
"type": "array",
"items": {
"type": "object",
"properties": {
"row": {
"type": "number",
"description": "row. Number."
},
"code": {
"type": "string",
"description": "code. String."
},
"kind": {
"type": "string",
"description": "kind. String."
},
"value": {
"type": "string",
"description": "value. String."
},
"column": {
"type": "string",
"description": "column. String."
},
"detail": {
"type": "string",
"description": "detail. String."
},
"sourceRow": {
"type": "number",
"description": "sourceRow. Number."
},
"columnIndex": {
"type": "number",
"description": "columnIndex. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "issues. Array."
},
"status": {
"type": "string",
"description": "status. String."
},
"columns": {
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string",
"description": "name. String."
},
"type": {
"type": "string",
"description": "type. String."
},
"index": {
"type": "number",
"description": "index. Number."
},
"observed": {
"type": "array",
"items": {
"type": "object",
"properties": {
"type": {
"type": "string",
"description": "type. String."
},
"count": {
"type": "number",
"description": "count. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "observed. Array."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "columns. Array."
},
"blankRows": {
"type": "number",
"description": "blankRows. Number."
},
"checkedAt": {
"type": "string",
"description": "checkedAt. String."
},
"limitations": {
"type": "array",
"items": {
"type": "string",
"description": "Item. String."
},
"description": "limitations. Array."
},
"recordsRead": {
"type": "number",
"description": "recordsRead. Number."
},
"dataModified": {
"type": "boolean",
"description": "dataModified. Boolean."
},
"columnsOmitted": {
"type": "number",
"description": "columnsOmitted. Number."
},
"recordsOmitted": {
"type": "number",
"description": "recordsOmitted. Number."
},
"recordsDiscarded": {
"type": "boolean",
"description": "recordsDiscarded. Boolean."
},
"outliersConfirmed": {
"type": "boolean",
"description": "outliersConfirmed. Boolean."
}
},
"additionalProperties": {}
},
"annotations": {
"title": "Detect CSV column types",
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true,
"destructiveHint": false
}
}Find empty or whitespace-only cells and give each one a row and column reference before you load or rely on a dataset. The row stays in the table. Call with optional records, csv, json, file, keyColumns. Returns checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, missingCount, columns. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Audit missing CSV values.
| Parameter | Type | Description |
|---|---|---|
| csv | string | csv, string, length 0 to 200000. Optional. |
| file | object | file, object. Optional. |
| json | string | json, string, length 0 to 200000. Optional. |
| records | array | records, array. Optional. |
| keyColumns | array | keyColumns, array. Optional. |
{
"name": "data-quality_csv-missing-value-audit",
"title": "Audit missing CSV values",
"description": "Find empty or whitespace-only cells and give each one a row and column reference before you load or rely on a dataset. The row stays in the table. Call with optional records, csv, json, file, keyColumns. Returns checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, missingCount, columns. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Audit missing CSV values.",
"inputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"csv": {
"type": "string",
"maxLength": 200000,
"description": "csv, string, length 0 to 200000. Optional."
},
"file": {
"type": "object",
"required": [
"mediaType",
"fileBase64"
],
"properties": {
"filename": {
"type": "string",
"maxLength": 180,
"minLength": 1,
"description": "filename, string, length 1 to 180. Optional."
},
"mediaType": {
"enum": [
"text/csv",
"application/json",
"text/plain"
],
"type": "string",
"description": "mediaType, string, one of text/csv, application/json, text/plain. Required."
},
"fileBase64": {
"type": "string",
"maxLength": 12000000,
"minLength": 1,
"description": "fileBase64, string, length 1 to 12000000. Required."
}
},
"description": "file, object. Optional."
},
"json": {
"type": "string",
"maxLength": 200000,
"description": "json, string, length 0 to 200000. Optional."
},
"records": {
"type": "array",
"items": {
"type": "object",
"description": "item, object. Required.",
"propertyNames": {
"type": "string",
"maxLength": 80,
"minLength": 1
},
"additionalProperties": {
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
]
}
},
"description": "records, array. Optional."
},
"keyColumns": {
"type": "array",
"items": {
"type": "string",
"maxLength": 80,
"minLength": 1,
"description": "item, string, length 1 to 80. Required."
},
"description": "keyColumns, array. Optional."
}
}
},
"outputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"format": {
"type": "string",
"description": "format. String."
},
"issues": {
"type": "array",
"items": {
"type": "object",
"properties": {
"row": {
"type": "number",
"description": "row. Number."
},
"code": {
"type": "string",
"description": "code. String."
},
"kind": {
"type": "string",
"description": "kind. String."
},
"value": {
"type": "string",
"description": "value. String."
},
"column": {
"type": "string",
"description": "column. String."
},
"detail": {
"type": "string",
"description": "detail. String."
},
"sourceRow": {
"type": "number",
"description": "sourceRow. Number."
},
"columnIndex": {
"type": "number",
"description": "columnIndex. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "issues. Array."
},
"status": {
"type": "string",
"description": "status. String."
},
"columns": {
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string",
"description": "name. String."
},
"index": {
"type": "number",
"description": "index. Number."
},
"missingRate": {
"type": "number",
"description": "missingRate. Number."
},
"missingCount": {
"type": "number",
"description": "missingCount. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "columns. Array."
},
"blankRows": {
"type": "number",
"description": "blankRows. Number."
},
"checkedAt": {
"type": "string",
"description": "checkedAt. String."
},
"limitations": {
"type": "array",
"items": {
"type": "string",
"description": "Item. String."
},
"description": "limitations. Array."
},
"recordsRead": {
"type": "number",
"description": "recordsRead. Number."
},
"dataModified": {
"type": "boolean",
"description": "dataModified. Boolean."
},
"missingCount": {
"type": "number",
"description": "missingCount. Number."
},
"columnsOmitted": {
"type": "number",
"description": "columnsOmitted. Number."
},
"recordsOmitted": {
"type": "number",
"description": "recordsOmitted. Number."
},
"recordsDiscarded": {
"type": "boolean",
"description": "recordsDiscarded. Boolean."
},
"outliersConfirmed": {
"type": "boolean",
"description": "outliersConfirmed. Boolean."
}
},
"additionalProperties": {}
},
"annotations": {
"title": "Audit missing CSV values",
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true,
"destructiveHint": false
}
}Group records that match after trimming each compared cell before you load or rely on a dataset. When key columns are supplied, only those columns are compared. No record is removed. Call with optional records, csv, json, file, keyColumns. Returns checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Detect duplicate CSV rows.
| Parameter | Type | Description |
|---|---|---|
| csv | string | csv, string, length 0 to 200000. Optional. |
| file | object | file, object. Optional. |
| json | string | json, string, length 0 to 200000. Optional. |
| records | array | records, array. Optional. |
| keyColumns | array | keyColumns, array. Optional. |
{
"name": "data-quality_csv-duplicate-row-detect",
"title": "Detect duplicate CSV rows",
"description": "Group records that match after trimming each compared cell before you load or rely on a dataset. When key columns are supplied, only those columns are compared. No record is removed. Call with optional records, csv, json, file, keyColumns. Returns checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Detect duplicate CSV rows.",
"inputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"csv": {
"type": "string",
"maxLength": 200000,
"description": "csv, string, length 0 to 200000. Optional."
},
"file": {
"type": "object",
"required": [
"mediaType",
"fileBase64"
],
"properties": {
"filename": {
"type": "string",
"maxLength": 180,
"minLength": 1,
"description": "filename, string, length 1 to 180. Optional."
},
"mediaType": {
"enum": [
"text/csv",
"application/json",
"text/plain"
],
"type": "string",
"description": "mediaType, string, one of text/csv, application/json, text/plain. Required."
},
"fileBase64": {
"type": "string",
"maxLength": 12000000,
"minLength": 1,
"description": "fileBase64, string, length 1 to 12000000. Required."
}
},
"description": "file, object. Optional."
},
"json": {
"type": "string",
"maxLength": 200000,
"description": "json, string, length 0 to 200000. Optional."
},
"records": {
"type": "array",
"items": {
"type": "object",
"description": "item, object. Required.",
"propertyNames": {
"type": "string",
"maxLength": 80,
"minLength": 1
},
"additionalProperties": {
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
]
}
},
"description": "records, array. Optional."
},
"keyColumns": {
"type": "array",
"items": {
"type": "string",
"maxLength": 80,
"minLength": 1,
"description": "item, string, length 1 to 80. Required."
},
"description": "keyColumns, array. Optional."
}
}
},
"outputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"format": {
"type": "string",
"description": "format. String."
},
"groups": {
"type": "array",
"items": {
"type": "object",
"properties": {
"rows": {
"type": "array",
"items": {
"type": "object",
"properties": {
"row": {
"type": "number",
"description": "row. Number."
},
"sourceRow": {
"type": "number",
"description": "sourceRow. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "rows. Array."
},
"count": {
"type": "number",
"description": "count. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "groups. Array."
},
"issues": {
"type": "array",
"items": {
"type": "object",
"properties": {
"row": {
"type": "number",
"description": "row. Number."
},
"code": {
"type": "string",
"description": "code. String."
},
"kind": {
"type": "string",
"description": "kind. String."
},
"value": {
"type": "string",
"description": "value. String."
},
"column": {
"type": "string",
"description": "column. String."
},
"detail": {
"type": "string",
"description": "detail. String."
},
"sourceRow": {
"type": "number",
"description": "sourceRow. Number."
},
"columnIndex": {
"type": "number",
"description": "columnIndex. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "issues. Array."
},
"status": {
"type": "string",
"description": "status. String."
},
"blankRows": {
"type": "number",
"description": "blankRows. Number."
},
"checkedAt": {
"type": "string",
"description": "checkedAt. String."
},
"groupCount": {
"type": "number",
"description": "groupCount. Number."
},
"limitations": {
"type": "array",
"items": {
"type": "string",
"description": "Item. String."
},
"description": "limitations. Array."
},
"recordsRead": {
"type": "number",
"description": "recordsRead. Number."
},
"dataModified": {
"type": "boolean",
"description": "dataModified. Boolean."
},
"columnsOmitted": {
"type": "number",
"description": "columnsOmitted. Number."
},
"recordsOmitted": {
"type": "number",
"description": "recordsOmitted. Number."
},
"recordsDiscarded": {
"type": "boolean",
"description": "recordsDiscarded. Boolean."
},
"outliersConfirmed": {
"type": "boolean",
"description": "outliersConfirmed. Boolean."
}
},
"additionalProperties": {}
},
"annotations": {
"title": "Detect duplicate CSV rows",
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true,
"destructiveHint": false
}
}Flag numeric values outside a Tukey fence of 1.5 times the interquartile range when a column has at least eight numbers before you load or rely on a dataset. Each flag is a possible outlier, not a confirmed error. Call with optional records, csv, json, file, keyColumns. Returns checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Detect statistical outliers.
| Parameter | Type | Description |
|---|---|---|
| csv | string | csv, string, length 0 to 200000. Optional. |
| file | object | file, object. Optional. |
| json | string | json, string, length 0 to 200000. Optional. |
| records | array | records, array. Optional. |
| keyColumns | array | keyColumns, array. Optional. |
{
"name": "data-quality_csv-outlier-detect",
"title": "Detect statistical outliers",
"description": "Flag numeric values outside a Tukey fence of 1.5 times the interquartile range when a column has at least eight numbers before you load or rely on a dataset. Each flag is a possible outlier, not a confirmed error. Call with optional records, csv, json, file, keyColumns. Returns checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Detect statistical outliers.",
"inputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"csv": {
"type": "string",
"maxLength": 200000,
"description": "csv, string, length 0 to 200000. Optional."
},
"file": {
"type": "object",
"required": [
"mediaType",
"fileBase64"
],
"properties": {
"filename": {
"type": "string",
"maxLength": 180,
"minLength": 1,
"description": "filename, string, length 1 to 180. Optional."
},
"mediaType": {
"enum": [
"text/csv",
"application/json",
"text/plain"
],
"type": "string",
"description": "mediaType, string, one of text/csv, application/json, text/plain. Required."
},
"fileBase64": {
"type": "string",
"maxLength": 12000000,
"minLength": 1,
"description": "fileBase64, string, length 1 to 12000000. Required."
}
},
"description": "file, object. Optional."
},
"json": {
"type": "string",
"maxLength": 200000,
"description": "json, string, length 0 to 200000. Optional."
},
"records": {
"type": "array",
"items": {
"type": "object",
"description": "item, object. Required.",
"propertyNames": {
"type": "string",
"maxLength": 80,
"minLength": 1
},
"additionalProperties": {
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
]
}
},
"description": "records, array. Optional."
},
"keyColumns": {
"type": "array",
"items": {
"type": "string",
"maxLength": 80,
"minLength": 1,
"description": "item, string, length 1 to 80. Required."
},
"description": "keyColumns, array. Optional."
}
}
},
"outputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"format": {
"type": "string",
"description": "format. String."
},
"issues": {
"type": "array",
"items": {
"type": "string",
"description": "Item. String."
},
"description": "issues. Array."
},
"status": {
"type": "string",
"description": "status. String."
},
"columns": {
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string",
"description": "name. String."
},
"count": {
"type": "number",
"description": "count. Number."
},
"index": {
"type": "number",
"description": "index. Number."
},
"lower": {
"type": "string",
"description": "lower. String."
},
"upper": {
"type": "string",
"description": "upper. String."
},
"status": {
"type": "string",
"description": "status. String."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "columns. Array."
},
"outliers": {
"type": "array",
"items": {
"type": "object",
"properties": {
"row": {
"type": "number",
"description": "row. Number."
},
"rule": {
"type": "string",
"description": "rule. String."
},
"value": {
"type": "string",
"description": "value. String."
},
"column": {
"type": "string",
"description": "column. String."
},
"detail": {
"type": "string",
"description": "detail. String."
},
"confirmed": {
"type": "boolean",
"description": "confirmed. Boolean."
},
"sourceRow": {
"type": "number",
"description": "sourceRow. Number."
},
"columnIndex": {
"type": "number",
"description": "columnIndex. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "outliers. Array."
},
"blankRows": {
"type": "number",
"description": "blankRows. Number."
},
"checkedAt": {
"type": "string",
"description": "checkedAt. String."
},
"limitations": {
"type": "array",
"items": {
"type": "string",
"description": "Item. String."
},
"description": "limitations. Array."
},
"recordsRead": {
"type": "number",
"description": "recordsRead. Number."
},
"dataModified": {
"type": "boolean",
"description": "dataModified. Boolean."
},
"outlierCount": {
"type": "number",
"description": "outlierCount. Number."
},
"columnsOmitted": {
"type": "number",
"description": "columnsOmitted. Number."
},
"recordsOmitted": {
"type": "number",
"description": "recordsOmitted. Number."
},
"recordsDiscarded": {
"type": "boolean",
"description": "recordsDiscarded. Boolean."
},
"outliersConfirmed": {
"type": "boolean",
"description": "outliersConfirmed. Boolean."
}
},
"additionalProperties": {}
},
"annotations": {
"title": "Detect statistical outliers",
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true,
"destructiveHint": false
}
}Propose trim, email lowercase, boolean tokens, and unambiguous thousands separators before you load or rely on a dataset. Each change names its rule and keeps the original cell. Dates that are not already YYYY-MM-DD are not rewritten. Call with optional records, csv, json, file, keyColumns. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Propose CSV normalization.
| Parameter | Type | Description |
|---|---|---|
| csv | string | csv, string, length 0 to 200000. Optional. |
| file | object | file, object. Optional. |
| json | string | json, string, length 0 to 200000. Optional. |
| records | array | records, array. Optional. |
| keyColumns | array | keyColumns, array. Optional. |
{
"name": "data-quality_csv-normalize",
"title": "Propose CSV normalization",
"description": "Propose trim, email lowercase, boolean tokens, and unambiguous thousands separators before you load or rely on a dataset. Each change names its rule and keeps the original cell. Dates that are not already YYYY-MM-DD are not rewritten. Call with optional records, csv, json, file, keyColumns. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Propose CSV normalization.",
"inputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"csv": {
"type": "string",
"maxLength": 200000,
"description": "csv, string, length 0 to 200000. Optional."
},
"file": {
"type": "object",
"required": [
"mediaType",
"fileBase64"
],
"properties": {
"filename": {
"type": "string",
"maxLength": 180,
"minLength": 1,
"description": "filename, string, length 1 to 180. Optional."
},
"mediaType": {
"enum": [
"text/csv",
"application/json",
"text/plain"
],
"type": "string",
"description": "mediaType, string, one of text/csv, application/json, text/plain. Required."
},
"fileBase64": {
"type": "string",
"maxLength": 12000000,
"minLength": 1,
"description": "fileBase64, string, length 1 to 12000000. Required."
}
},
"description": "file, object. Optional."
},
"json": {
"type": "string",
"maxLength": 200000,
"description": "json, string, length 0 to 200000. Optional."
},
"records": {
"type": "array",
"items": {
"type": "object",
"description": "item, object. Required.",
"propertyNames": {
"type": "string",
"maxLength": 80,
"minLength": 1
},
"additionalProperties": {
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
]
}
},
"description": "records, array. Optional."
},
"keyColumns": {
"type": "array",
"items": {
"type": "string",
"maxLength": 80,
"minLength": 1,
"description": "item, string, length 1 to 80. Required."
},
"description": "keyColumns, array. Optional."
}
}
},
"outputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"format": {
"type": "string",
"description": "format. String."
},
"issues": {
"type": "array",
"items": {
"type": "string",
"description": "Item. String."
},
"description": "issues. Array."
},
"status": {
"type": "string",
"description": "status. String."
},
"changes": {
"type": "array",
"items": {
"type": "object",
"properties": {
"row": {
"type": "number",
"description": "row. Number."
},
"rule": {
"type": "string",
"description": "rule. String."
},
"column": {
"type": "string",
"description": "column. String."
},
"original": {
"type": "string",
"description": "original. String."
},
"sourceRow": {
"type": "number",
"description": "sourceRow. Number."
},
"normalized": {
"type": "string",
"description": "normalized. String."
},
"columnIndex": {
"type": "number",
"description": "columnIndex. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "changes. Array."
},
"rowCount": {
"type": "number",
"description": "rowCount. Number."
},
"blankRows": {
"type": "number",
"description": "blankRows. Number."
},
"checkedAt": {
"type": "string",
"description": "checkedAt. String."
},
"limitations": {
"type": "array",
"items": {
"type": "string",
"description": "Item. String."
},
"description": "limitations. Array."
},
"recordsRead": {
"type": "number",
"description": "recordsRead. Number."
},
"changedCount": {
"type": "number",
"description": "changedCount. Number."
},
"dataModified": {
"type": "boolean",
"description": "dataModified. Boolean."
},
"columnsOmitted": {
"type": "number",
"description": "columnsOmitted. Number."
},
"recordsOmitted": {
"type": "number",
"description": "recordsOmitted. Number."
},
"unchangedCount": {
"type": "number",
"description": "unchangedCount. Number."
},
"recordsDiscarded": {
"type": "boolean",
"description": "recordsDiscarded. Boolean."
},
"outliersConfirmed": {
"type": "boolean",
"description": "outliersConfirmed. Boolean."
}
},
"additionalProperties": {}
},
"annotations": {
"title": "Propose CSV normalization",
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true,
"destructiveHint": false
}
}Combine the schema, profile, missing cells, duplicate groups, possible outliers, and proposed normalization for one supplied table before you load or rely on a dataset. No record is removed and no outlier is confirmed. Call with optional records, csv, json, file, keyColumns. Returns checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Report CSV quality.
| Parameter | Type | Description |
|---|---|---|
| csv | string | csv, string, length 0 to 200000. Optional. |
| file | object | file, object. Optional. |
| json | string | json, string, length 0 to 200000. Optional. |
| records | array | records, array. Optional. |
| keyColumns | array | keyColumns, array. Optional. |
{
"name": "data-quality_csv-report",
"title": "Report CSV quality",
"description": "Combine the schema, profile, missing cells, duplicate groups, possible outliers, and proposed normalization for one supplied table before you load or rely on a dataset. No record is removed and no outlier is confirmed. Call with optional records, csv, json, file, keyColumns. Returns checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead. HTTP 200 with status complete, partial, or failed is charged at the full listed price. HTTP 4xx/5xx are not charged. Keywords: before you load or rely on a dataset, records, csv, file, keyColumns, checkedAt, recordsDiscarded, dataModified, outliersConfirmed, format, recordsRead, recordsOmitted, columnsOmitted, blankRows, Report CSV quality.",
"inputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"csv": {
"type": "string",
"maxLength": 200000,
"description": "csv, string, length 0 to 200000. Optional."
},
"file": {
"type": "object",
"required": [
"mediaType",
"fileBase64"
],
"properties": {
"filename": {
"type": "string",
"maxLength": 180,
"minLength": 1,
"description": "filename, string, length 1 to 180. Optional."
},
"mediaType": {
"enum": [
"text/csv",
"application/json",
"text/plain"
],
"type": "string",
"description": "mediaType, string, one of text/csv, application/json, text/plain. Required."
},
"fileBase64": {
"type": "string",
"maxLength": 12000000,
"minLength": 1,
"description": "fileBase64, string, length 1 to 12000000. Required."
}
},
"description": "file, object. Optional."
},
"json": {
"type": "string",
"maxLength": 200000,
"description": "json, string, length 0 to 200000. Optional."
},
"records": {
"type": "array",
"items": {
"type": "object",
"description": "item, object. Required.",
"propertyNames": {
"type": "string",
"maxLength": 80,
"minLength": 1
},
"additionalProperties": {
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
]
}
},
"description": "records, array. Optional."
},
"keyColumns": {
"type": "array",
"items": {
"type": "string",
"maxLength": 80,
"minLength": 1,
"description": "item, string, length 1 to 80. Required."
},
"description": "keyColumns, array. Optional."
}
}
},
"outputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"format": {
"type": "string",
"description": "format. String."
},
"groups": {
"type": "array",
"items": {
"type": "object",
"properties": {
"rows": {
"type": "array",
"items": {
"type": "object",
"properties": {
"row": {
"type": "number",
"description": "row. Number."
},
"sourceRow": {
"type": "number",
"description": "sourceRow. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "rows. Array."
},
"count": {
"type": "number",
"description": "count. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "groups. Array."
},
"issues": {
"type": "array",
"items": {
"type": "object",
"properties": {
"row": {
"type": "number",
"description": "row. Number."
},
"code": {
"type": "string",
"description": "code. String."
},
"kind": {
"type": "string",
"description": "kind. String."
},
"value": {
"type": "string",
"description": "value. String."
},
"column": {
"type": "string",
"description": "column. String."
},
"detail": {
"type": "string",
"description": "detail. String."
},
"sourceRow": {
"type": "number",
"description": "sourceRow. Number."
},
"columnIndex": {
"type": "number",
"description": "columnIndex. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "issues. Array."
},
"status": {
"type": "string",
"description": "status. String."
},
"changes": {
"type": "array",
"items": {
"type": "object",
"properties": {
"row": {
"type": "number",
"description": "row. Number."
},
"rule": {
"type": "string",
"description": "rule. String."
},
"column": {
"type": "string",
"description": "column. String."
},
"original": {
"type": "string",
"description": "original. String."
},
"sourceRow": {
"type": "number",
"description": "sourceRow. Number."
},
"normalized": {
"type": "string",
"description": "normalized. String."
},
"columnIndex": {
"type": "number",
"description": "columnIndex. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "changes. Array."
},
"columns": {
"type": "array",
"items": {
"type": "object",
"properties": {
"max": {
"type": "string",
"description": "max. String."
},
"min": {
"type": "string",
"description": "min. String."
},
"name": {
"type": "string",
"description": "name. String."
},
"type": {
"type": "string",
"description": "type. String."
},
"count": {
"type": "number",
"description": "count. Number."
},
"index": {
"type": "number",
"description": "index. Number."
},
"nullable": {
"type": "boolean",
"description": "nullable. Boolean."
},
"missingCount": {
"type": "number",
"description": "missingCount. Number."
},
"distinctCount": {
"type": "number",
"description": "distinctCount. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "columns. Array."
},
"outliers": {
"type": "array",
"items": {
"type": "object",
"properties": {
"row": {
"type": "number",
"description": "row. Number."
},
"rule": {
"type": "string",
"description": "rule. String."
},
"value": {
"type": "string",
"description": "value. String."
},
"column": {
"type": "string",
"description": "column. String."
},
"detail": {
"type": "string",
"description": "detail. String."
},
"confirmed": {
"type": "boolean",
"description": "confirmed. Boolean."
},
"sourceRow": {
"type": "number",
"description": "sourceRow. Number."
},
"columnIndex": {
"type": "number",
"description": "columnIndex. Number."
}
},
"description": "item. Object.",
"additionalProperties": {}
},
"description": "outliers. Array."
},
"rowCount": {
"type": "number",
"description": "rowCount. Number."
},
"blankRows": {
"type": "number",
"description": "blankRows. Number."
},
"checkedAt": {
"type": "string",
"description": "checkedAt. String."
},
"columnCount": {
"type": "number",
"description": "columnCount. Number."
},
"limitations": {
"type": "array",
"items": {
"type": "string",
"description": "Item. String."
},
"description": "limitations. Array."
},
"recordsRead": {
"type": "number",
"description": "recordsRead. Number."
},
"dataModified": {
"type": "boolean",
"description": "dataModified. Boolean."
},
"outlierCount": {
"type": "number",
"description": "outlierCount. Number."
},
"columnsOmitted": {
"type": "number",
"description": "columnsOmitted. Number."
},
"recordsOmitted": {
"type": "number",
"description": "recordsOmitted. Number."
},
"recordsDiscarded": {
"type": "boolean",
"description": "recordsDiscarded. Boolean."
},
"outliersConfirmed": {
"type": "boolean",
"description": "outliersConfirmed. Boolean."
}
},
"additionalProperties": {}
},
"annotations": {
"title": "Report CSV quality",
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true,
"destructiveHint": false
}
}Tool calls wrap the existing POST APIs and stay pay-per-call. initialize and tools/list are free. An unpaid tool call returns the x402 payment terms in the tool result and does not run. Retry with the payment in params._meta["x402/payment"], or send payment-signature. Payment settles only after a successful result.
Names, descriptions and schemas were written by the server and are shown as data.
Pattern matches on what the server declares. They show what it says it can do, not what it does.
None yet. Changes appear after a server's second daily check.