{"id":"csv-reconcile","version":"1.0.0","description":"Reconcile two CSV documents by key columns, reporting full population totals and bounded samples for added, removed, changed, invalid-key, and ambiguous rows.","supported_operations":["csv reconcile","reconcile csv","csv reconciliation","compare csv by keys with duplicates","csv diff with duplicate keys","keyed csv reconciliation report","diagnose csv differences"],"unsupported_operations":["fuzzy matching","numeric type coercion","schema migration","import or patch generation","external writes","filesystem access","network access"],"semantics":["left and right must share the same exact set of header names; header order may differ.","keys is a non-empty unique array of at most 16 column names existing in the headers.","Empty string in any key cell makes that row invalid-key; whitespace is literal and non-empty.","Invalid-key rows are strictly excluded from key matching and duplicate groups.","Tuple identity uses collision-safe exact string tuples without trimming or case folding.","Duplicate key (>1 valid-key rows on either side) quarantines all rows of that tuple on both sides under ambiguous_keys.","Unambiguous valid tuples are classified into added (right-only), removed (left-only), changed (non-key diffs), or unchanged.","changed.before and changed.after contain only changed columns, with changed_columns ordered according to left CSV header order.","Full population conservation holds: left = invalid_left + ambiguous_left + removed + changed + unchanged; right = invalid_right + ambiguous_right + added + changed + unchanged.","Samples are bounded per category by sample_limit (default 5, 0..20); limit 0 returns all counts and empty samples.","Row numbers are 1-based data row indices.","Added samples follow right row order; removed and changed follow left row order; invalid samples follow their own side row order; ambiguous keys follow first appearance in left, then unseen keys in right.","Each category truncated flag equals samples.length < total; ambiguity side-row flags compare retained row indices with that side count.","If JSON result exceeds 192 KiB, whole sample entries are deterministically shed by removing the last entry (retaining a first-seen prefix) in fixed category priority order (invalid_right, invalid_left, ambiguous_keys, added, removed, changed) while preserving exact counts."],"limits":{"max_input_bytes":245760,"max_csv_bytes":102400,"max_data_rows":5000,"max_columns":128,"max_header_name_bytes":256,"max_keys":16,"max_sample_limit":20,"max_output_bytes":196608},"pricing":{"status":"unpriced","charge_usd":null},"input_schema":{"type":"object","additionalProperties":false,"required":["left","right","keys"],"properties":{"left":{"type":"string","maxLength":102400},"right":{"type":"string","maxLength":102400},"keys":{"type":"array","minItems":1,"maxItems":16,"uniqueItems":true,"items":{"type":"string","minLength":1}},"sample_limit":{"type":"integer","minimum":0,"maximum":20,"default":5}}},"output_schema":{"type":"object","additionalProperties":false,"required":["totals","added","removed","changed","invalid_left","invalid_right","ambiguous_keys"],"properties":{"totals":{"type":"object","additionalProperties":false,"required":["left_rows","right_rows","invalid_left","invalid_right","ambiguous_left","ambiguous_right","ambiguous_keys","added","removed","changed","unchanged"],"properties":{"left_rows":{"type":"integer"},"right_rows":{"type":"integer"},"invalid_left":{"type":"integer"},"invalid_right":{"type":"integer"},"ambiguous_left":{"type":"integer"},"ambiguous_right":{"type":"integer"},"ambiguous_keys":{"type":"integer"},"added":{"type":"integer"},"removed":{"type":"integer"},"changed":{"type":"integer"},"unchanged":{"type":"integer"}}},"added":{"type":"object","additionalProperties":false,"required":["total","samples","truncated"],"properties":{"total":{"type":"integer"},"truncated":{"type":"boolean"},"samples":{"type":"array","items":{"type":"object","additionalProperties":false,"required":["row","key","values"],"properties":{"row":{"type":"integer"},"key":{"type":"array","items":{"type":"string"}},"values":{"type":"object"}}}}}},"removed":{"type":"object","additionalProperties":false,"required":["total","samples","truncated"],"properties":{"total":{"type":"integer"},"truncated":{"type":"boolean"},"samples":{"type":"array","items":{"type":"object","additionalProperties":false,"required":["row","key","values"],"properties":{"row":{"type":"integer"},"key":{"type":"array","items":{"type":"string"}},"values":{"type":"object"}}}}}},"changed":{"type":"object","additionalProperties":false,"required":["total","samples","truncated"],"properties":{"total":{"type":"integer"},"truncated":{"type":"boolean"},"samples":{"type":"array","items":{"type":"object","additionalProperties":false,"required":["key","left_row","right_row","changed_columns","before","after"],"properties":{"key":{"type":"array","items":{"type":"string"}},"left_row":{"type":"integer"},"right_row":{"type":"integer"},"changed_columns":{"type":"array","items":{"type":"string"}},"before":{"type":"object"},"after":{"type":"object"}}}}}},"invalid_left":{"type":"object","additionalProperties":false,"required":["total","samples","truncated"],"properties":{"total":{"type":"integer"},"truncated":{"type":"boolean"},"samples":{"type":"array","items":{"type":"object","additionalProperties":false,"required":["row","key","values"],"properties":{"row":{"type":"integer"},"key":{"type":"array","items":{"type":"string"}},"values":{"type":"object"}}}}}},"invalid_right":{"type":"object","additionalProperties":false,"required":["total","samples","truncated"],"properties":{"total":{"type":"integer"},"truncated":{"type":"boolean"},"samples":{"type":"array","items":{"type":"object","additionalProperties":false,"required":["row","key","values"],"properties":{"row":{"type":"integer"},"key":{"type":"array","items":{"type":"string"}},"values":{"type":"object"}}}}}},"ambiguous_keys":{"type":"object","additionalProperties":false,"required":["total","samples","truncated"],"properties":{"total":{"type":"integer"},"truncated":{"type":"boolean"},"samples":{"type":"array","items":{"type":"object","additionalProperties":false,"required":["key","tuple","left_count","right_count","left_rows","right_rows","left_truncated","right_truncated"],"properties":{"key":{"type":"array","items":{"type":"string"}},"tuple":{"type":"array","items":{"type":"string"}},"left_count":{"type":"integer"},"right_count":{"type":"integer"},"left_rows":{"type":"array","items":{"type":"integer"}},"right_rows":{"type":"array","items":{"type":"integer"}},"left_truncated":{"type":"boolean"},"right_truncated":{"type":"boolean"}}}}}}}},"examples":[{"input":{"left":"id,name,city\n1,Ada,London\n2,Lin,Paris\n3,Zoe,Berlin\n4,Sam,Bristol\n5,Duplicate,CityA\n5,Duplicate,CityB\n,InvalidKey,NoId\n","right":"city,name,id\nLondon,Ada,1\nRome,Lin,2\nOslo,Bob,6\nBristol,Sam,4\nCityA,Duplicate,5\nCityB,Duplicate,5\nNewCity,ValidKey,\n","keys":["id"]},"output":{"totals":{"left_rows":7,"right_rows":7,"invalid_left":1,"invalid_right":1,"ambiguous_left":2,"ambiguous_right":2,"ambiguous_keys":1,"added":1,"removed":1,"changed":1,"unchanged":2},"added":{"total":1,"samples":[{"row":3,"key":["6"],"values":{"city":"Oslo","name":"Bob","id":"6"}}],"truncated":false},"removed":{"total":1,"samples":[{"row":3,"key":["3"],"values":{"id":"3","name":"Zoe","city":"Berlin"}}],"truncated":false},"changed":{"total":1,"samples":[{"key":["2"],"left_row":2,"right_row":2,"changed_columns":["city"],"before":{"city":"Paris"},"after":{"city":"Rome"}}],"truncated":false},"invalid_left":{"total":1,"samples":[{"row":7,"key":[""],"values":{"id":"","name":"InvalidKey","city":"NoId"}}],"truncated":false},"invalid_right":{"total":1,"samples":[{"row":7,"key":[""],"values":{"city":"NewCity","name":"ValidKey","id":""}}],"truncated":false},"ambiguous_keys":{"total":1,"samples":[{"key":["5"],"tuple":["5"],"left_count":2,"right_count":2,"left_rows":[5,6],"right_rows":[5,6],"left_truncated":false,"right_truncated":false}],"truncated":false}}}],"execute_url":"/v1/tools/csv-reconcile/versions/1.0.0/execute"}