DCT (Data Check Tool) - Skill Router
DCT is a Swiss army knife CLI tool for working with flat data files. This skill routes to appropriate sub-skills based on user intent.
Quick Command Reference
| User Intent |
Route To |
Command Pattern |
| Preview/inspect data |
dct-peek |
dct peek <file> |
| Generate SQL schema |
dct-infer |
dct infer <file> |
| Compare two datasets |
dct-diff |
dct diff <keys> <file1> <file2> |
| Generate synthetic data |
dct-generate |
dct gen <schema> |
| Flatten nested JSON |
dct-flattify |
dct flattify <json> |
| Analyze data quality |
dct-profile |
dct prof <file> |
| JSON Schema to SQL |
dct-js2sql |
dct js2sql <schema> |
| Visualize data |
dct-chart |
dct chart <file> <col> |
Routing Logic
Analyze the user's request and route to the appropriate sub-skill:
Route to dct-peek when:
- User wants to preview data files
- Keywords: "peek", "preview", "show me", "look at", "first rows", "sample"
- Example: "Show me the first 10 rows of data.csv"
Route to dct-infer when:
- User wants to generate SQL schemas
- Keywords: "infer", "schema", "create table", "sql from data", "ddl"
- Example: "Generate a CREATE TABLE statement from this CSV"
Route to dct-diff when:
- User wants to compare two files
- Keywords: "diff", "compare", "differences", "match", "reconcile", "validate"
- Example: "Compare these two CSV files by the ID column"
Route to dct-generate when:
- User wants to create synthetic test data
- Keywords: "generate", "synthetic", "mock", "fake data", "test data"
- Example: "Generate 1000 fake user records"
Route to dct-flattify when:
- User wants to flatten nested JSON
- Keywords: "flatten", "unnest", "nested json", "make flat"
- Example: "Flatten this nested JSON from the API response"
Route to dct-profile when:
- User wants to analyze data quality
- Keywords: "profile", "analyze", "data quality", "statistics", "distribution"
- Example: "Profile this data file for quality issues"
Route to dct-js2sql when:
- User wants to convert JSON Schema to SQL
- Keywords: "json schema", "convert schema", "schema to sql"
- Example: "Convert this JSON Schema to a CREATE TABLE statement"
Route to dct-chart when:
- User wants to visualize data
- Keywords: "chart", "visualize", "histogram", "plot", "graph"
- Example: "Create a chart of the sales column"
Common Patterns
Data Validation Workflow
dct-peek: Preview to understand structure
dct-profile: Check data quality
dct-infer: Generate schema for downstream use
Data Comparison Workflow
dct-peek: Preview both files
dct-diff: Compare with appropriate keys
Test Data Generation Workflow
dct-generate: Create synthetic data
dct-peek: Verify generated data
dct-diff: Compare with production sample
Installation
All sub-skills require DCT to be installed:
which dct || go build -o dct && chmod +x ./dct
Supported File Formats
All DCT sub-skills support:
- CSV (.csv)
- JSON (.json)
- NDJSON (.ndjson) - newline-delimited JSON
- Parquet (.parquet)
Error Handling
If a sub-skill encounters errors:
- Verify the file exists and is readable
- Check file extension matches content format
- Ensure DCT binary is built and executable
Converted and distributed by TomeVault — claim your Tome and manage your conversions.
1---2name: dct3description: Router skill for DCT (Data Check Tool). Use this skill whenever the user wants to work with flat data files (CSV, JSON, NDJSON, Parquet) for inspection, comparison, transformation, or generation. The main dct skill analyzes user intent and routes to appropriate sub-skills. Triggers include any mention of data files, previewing data, comparing datasets, generating test data, flattening JSON, creating SQL schemas, profiling data, or visualizing distributions. Use when this capability is needed.4---56# DCT (Data Check Tool) - Skill Router78DCT is a Swiss army knife CLI tool for working with flat data files. This skill routes to appropriate sub-skills based on user intent.910## Quick Command Reference1112| User Intent | Route To | Command Pattern |13|-------------|----------|-----------------|14| Preview/inspect data | `dct-peek` | `dct peek <file>` |15| Generate SQL schema | `dct-infer` | `dct infer <file>` |16| Compare two datasets | `dct-diff` | `dct diff <keys> <file1> <file2>` |17| Generate synthetic data | `dct-generate` | `dct gen <schema>` |18| Flatten nested JSON | `dct-flattify` | `dct flattify <json>` |19| Analyze data quality | `dct-profile` | `dct prof <file>` |20| JSON Schema to SQL | `dct-js2sql` | `dct js2sql <schema>` |21| Visualize data | `dct-chart` | `dct chart <file> <col>` |2223## Routing Logic2425Analyze the user's request and route to the appropriate sub-skill:2627### Route to `dct-peek` when:28- User wants to preview data files29- Keywords: "peek", "preview", "show me", "look at", "first rows", "sample"30- Example: "Show me the first 10 rows of data.csv"3132### Route to `dct-infer` when:33- User wants to generate SQL schemas34- Keywords: "infer", "schema", "create table", "sql from data", "ddl"35- Example: "Generate a CREATE TABLE statement from this CSV"3637### Route to `dct-diff` when:38- User wants to compare two files39- Keywords: "diff", "compare", "differences", "match", "reconcile", "validate"40- Example: "Compare these two CSV files by the ID column"4142### Route to `dct-generate` when:43- User wants to create synthetic test data44- Keywords: "generate", "synthetic", "mock", "fake data", "test data"45- Example: "Generate 1000 fake user records"4647### Route to `dct-flattify` when:48- User wants to flatten nested JSON49- Keywords: "flatten", "unnest", "nested json", "make flat"50- Example: "Flatten this nested JSON from the API response"5152### Route to `dct-profile` when:53- User wants to analyze data quality54- Keywords: "profile", "analyze", "data quality", "statistics", "distribution"55- Example: "Profile this data file for quality issues"5657### Route to `dct-js2sql` when:58- User wants to convert JSON Schema to SQL59- Keywords: "json schema", "convert schema", "schema to sql"60- Example: "Convert this JSON Schema to a CREATE TABLE statement"6162### Route to `dct-chart` when:63- User wants to visualize data64- Keywords: "chart", "visualize", "histogram", "plot", "graph"65- Example: "Create a chart of the sales column"6667## Common Patterns6869### Data Validation Workflow701. `dct-peek`: Preview to understand structure712. `dct-profile`: Check data quality723. `dct-infer`: Generate schema for downstream use7374### Data Comparison Workflow751. `dct-peek`: Preview both files762. `dct-diff`: Compare with appropriate keys7778### Test Data Generation Workflow791. `dct-generate`: Create synthetic data802. `dct-peek`: Verify generated data813. `dct-diff`: Compare with production sample8283## Installation8485All sub-skills require DCT to be installed:8687```bash88which dct || go build -o dct && chmod +x ./dct89```9091## Supported File Formats9293All DCT sub-skills support:94- CSV (.csv)95- JSON (.json)96- NDJSON (.ndjson) - newline-delimited JSON97- Parquet (.parquet)9899## Error Handling100101If a sub-skill encounters errors:102- Verify the file exists and is readable103- Check file extension matches content format104- Ensure DCT binary is built and executable105106---107> Converted and distributed by [TomeVault](https://tomevault.io/claim/andrew-a-hale) — claim your Tome and manage your conversions.108<!-- tomevault:4.0:skill_md:2026-04-14 -->