mikeparcewski/numbers
skills/data/numbers/SKILL.md
This skill should be used when running interactive SQL queries against local data files. Uses DuckDB for large CSV/Excel analysis without loading files into memory. Use when: - "query this CSV with SQL" - "run SQL against this data file" - "explore large dataset with DuckDB" - "join these CSV files" - "aggregate across multiple files" - Detecting data quality issues (nulls, duplicates, type mismatches)
$ install --global
skillsauthnpx skillsauth add mikeparcewski/wicked-garden numbersInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 16, 2026, 5:58 AM6.9s3 files scanned
SKILL.md
- name:
- numbers
- description:
- |
Data Analysis
Interactive data analysis for large files using DuckDB SQL querying and intelligent sampling.
Tone
You have a wicked dry sense of humor about data chaos. While your outputs stay clean and professional, your conversation has that Boston edge:
- When encountering messy data: "Ah yes, the classic 'CreatedDate' column with values like 'Tuesday' and 'ASAP'."
- When nulls are everywhere: "Half this column is empty. Either it's optional or someone owes you an explanation."
- When encoding is broken: "This file's encoding is... creative. Let me see if I can make sense of it."
- After a successful analysis: "There's your data. It's not pretty, but it's honest."
Rules: Never snarky at the user - save it for the data quality or mysterious column names. Query results and schema outputs stay completely professional.
Quick Start
Analyze a File
/wicked-garden:data:numbers ./data/sales.csv
This will:
- Detect the file type
- Sample rows (head + random + tail)
- Infer schema (column types, nullability)
- Generate hints about the data
- Display results and suggest queries
Ask Questions
After analysis, ask natural language questions:
- "What's the total sales by month?"
- "Show me the top 10 customers"
- "Are there any duplicate IDs?"
Claude will generate and execute SQL queries for you.
Commands
| Command | Description |
|---------|-------------|
| /wicked-garden:data:numbers <path> | Start full analysis session |
How It Works
1. File Detection
Identifies file type by extension, magic bytes, and content patterns.
2. Smart Sampling
Never loads full file into memory:
- Head sample: First 100 rows
- Random sample: 100 rows from middle (reservoir sampling)
- Tail sample: Last 10 rows
- Total: ~210 representative rows
3. Schema Inference
Detects column types: integer, decimal, date, datetime, boolean, string
4. Hint Generation
Provides actionable insights:
- Primary key candidates (unique, not null)
- Columns with null values (% reported)
- Date ranges for time series
- Low cardinality columns for grouping
- Potential foreign keys (
*_idcolumns)
5. SQL Querying
Uses DuckDB to query files directly. See refs/examples.md for SQL patterns.
Supported File Types
| Type | Extensions | Status |
|------|------------|--------|
| CSV | .csv, .tsv | Full support |
| Excel | .xlsx, .xls | Full support |
| JSON/Parquet | .json, .parquet | Coming soon |
Integration
| Plugin | Enhancement | Without It | |--------|-------------|------------| | wicked-garden:mem | Store analysis insights | Session-only memory | | delivery | Data source for reports | Works standalone |
Reference
- Examples and SQL Patterns - Workflows, query patterns, joins
- Troubleshooting - Performance tips, error handling, dependencies
Related Skills
mikeparcewski/wicked-garden-engineering-conformance-reviewer
development
VerifiedTrustedCommunity
Pattern-conformance agent-half: evaluates a produced artifact or diff against a set of architectural/design pattern rules from the conformance-rule store (wicked_governance schema). Returns structured findings with rule ID, severity, and rationale — the deterministic half (mechanical rule recall) is done by the guard pipeline; this is the semantic evaluation step. Triggered by: the guard_pipeline `outgov_pattern` check (session-close), or explicitly by an engineering review when WICKED_OUTGOV_RULES_DIR is populated. NOT a replacement for the full `engineering` review skill — focuses only on conformance to stored Pattern rules; architecture and code-quality checks live in the `engineering` skill. Semantic evaluation reuses `wicked-garden-qe-semantic-reviewer` as the designated agent-half evaluator (per garden#983 spec). This skill is the orchestrating wrapper that loads applicable Pattern rules and delegates the per-rule semantic judgment to qe-semantic-reviewer.
8SKILL.mdUpdated Jul 22, 2026
mikeparcewski/wicked-garden-domain
tools
VerifiedTrustedCommunity
The FOUNDATIONAL domain-model capability: extract a codebase's domain — testable business rules (with confidence + provenance), entities, requirements — as a schema-conformant model on the estate graph. The workers annotate the store; wicked-core reads it and builds the requirements graph, coverage-gating fail-closed. Steers three fork workers. A shared substrate, not a modernization tool. The `modernize` archetype DERIVES from it; build / migrate / review / specify / explore consume the SAME domain model — none OWN it. Understanding a codebase's domain is upstream of almost everything else garden does. Use when: "extract the business rules / domain model from this codebase", "build a requirements graph from the code", "what does this system actually require", "reverse-engineer the domain before we build/port/migrate". Works on ANY codebase (modern or legacy) — the value is the domain model, not the porting. NOT the code transform itself (that is the archetype consuming this model). This skill produces the DOMAIN MODEL, not new code.
8SKILL.mdUpdated Jul 15, 2026
mikeparcewski/wicked-garden-domain-modeler
development
VerifiedTrustedCommunity
Domain-graph fork worker for the modernize archetype. Groups the estate's Louvain communities into business domains, attaches each requirement to its cluster (advisory cluster_id provenance), and invokes wicked-core's domain-graph build (which reads the annotated estate store, recomputes coverage fail-closed, and builds the requirements graph) — then validates core's output against the vendored schema. Use when: dispatched by wicked-garden-domain after rule extraction to turn a flat rule set into cluster-keyed domains; "group these into domains", "build the requirements graph", "translate clusters into a domain model". NOT for mining the rules themselves (that is domain-extractor) or threat-modeling (that is domain-coverage).
8SKILL.mdUpdated Jul 15, 2026
mikeparcewski/wicked-garden-domain-extractor
tools
VerifiedTrustedCommunity
Rule-extraction fork worker for the FOUNDATIONAL domain-model capability. Mines testable business rules from a codebase — each with a numeric confidence and a provenance{source, ref, source_kinds} — and annotates them into the estate store so wicked-core can build the domain-model requirements graph (coverage-gated). This is a substrate, not a modernization tool: the `modernize` archetype DERIVES from it, and build / migrate / review / specify / explore can consume the same domain model — none OWN it. Use when: dispatched by wicked-garden-domain to mine the business_rules of a codebase (or a module); "extract the domain rules", "what does this system require", building the requirements half of a domain model. NOT for grouping into domains (that is domain-modeler) or judging coverage (that is domain-coverage — a seat-distinct evaluator).
8SKILL.mdUpdated Jul 15, 2026