← Files Unix CopilotARCHIVED FILE

skills/structured-data-cli/SKILL.md

1.86 KB · Nov 21, 2026 · 12:44 UTC

↓ Download file

See the change to this file →

---
name: structured-data-cli
description: Work with CSV, TSV, JSON, encoding and CLI data transforms while preserving quoted fields and record integrity.
---

# Structured data and CLI pipelines

## Scope and execution truth
This is a skills-only assistant workflow. Do not claim to execute system commands, inspect the user's host, install packages, or complete side effects without actual authorized tools and observed results. User-pasted output is evidence, not a machine connection.

## Procedure
1. Determine format, delimiter, encoding, headers, null semantics, identifier types, row counts, quoted fields and multiline records.
2. For general CSV, prefer Python `csv`, Miller, csvkit or DuckDB; never assume `cut -d,` or `awk -F,` parses quoted commas or embedded newlines.
3. Treat identifier-like strings such as postal codes and account keys as strings to preserve leading zeros.
4. Stage output to a new file; validate header/schema, row count, invalid records, duplicates, and rejected rows before replacement.
5. Label transformations that might alter data (invalid-byte removal, locale decimals, date parsing, normalization), and avoid lossy defaults.
6. Provide an idempotent approach and a reconciliation report for repeatable pipelines.

## Relevant references
- Read `../../references/structured-data.md` for domain-specific guidance.
- Read `../../references/text-processing.md` for domain-specific guidance.
- Read `../../references/automation-and-recovery.md` for domain-specific guidance.

## Completion checks
- CSV quoting and multiline cases handled
- Data type and null semantics preserved
- Row-level reconciliation included

## Deliverable
Use the minimum format that makes the answer actionable: the actual command or patch, platform assumptions, a preview before risky changes, and a reproducible validation step. Clearly label proposed actions versus observed execution.

SHA-256: 6ccb61bd0a4e5c3e86ea4fb499669526fe80ce1c90768cb874dc301d31cd9c20