Architecting Data
Decision frameworks for data lake vs warehouse vs lakehouse, table formats, mesh readiness
Test report
- Verdict
- Tested · Works
- Score
- Tested
- Jul 21, 2026
- Environment
- Claude Code 2.x (agent harness)
- Upstream re-checked
- Aug 10, 2026 · 4953514
Fetched SKILL.md at skills/architecting-data/SKILL.md; frontmatter parses with name+description. Spot-checked 3 referenced files raw (references/decision-frameworks.md, references/medallion-pattern.md, examples/dbt-project/stg_customers.sql) — all HTTP 200; no security smells. For the output test I wrote both a baseline and a strictly skill-following answer to one task (120-person SaaS, 4-person data team, mixed BI+ML on Postgres, cost-sensitive, mesh?). Baseline hedged (warehouse-or-lakehouse, mesh "probably premature"); the skill run applied the 6-factor mesh readiness score (~13/30 → "Build foundation first"), landed decisively on Lakehouse+Iceberg via the decision tree and 50-500 org bracket with cost figures, and specified bronze/silver/gold with dimensional-vs-wide modeling.
Scored on four weighted criteria — install, triggering, output vs. baseline, docs. How scoring works
- Installs cleanly 5/5
- Triggers reliably 5/5
- Output vs. baseline 7/10
- Docs & honesty 4/5
What Architecting Data does
Advisory skill that guides data-platform architecture decisions: storage paradigm (lake/warehouse/lakehouse), modeling approach (dimensional/normalized/data vault/wide), open table format (Iceberg/Delta/Hudi), medallion layering, and a 6-factor data-mesh readiness score. Triggers when designing or modernizing a data platform, choosing centralized vs decentralized patterns, or selecting table formats and governance. Pure knowledge plus reference files and a dbt example; no external tools required to use it.
How to install Architecting Data
git clone --depth 1 https://github.com/ancoleman/ai-design-components.git /tmp/architecting-data-src
mkdir -p ~/.claude/skills
cp -R /tmp/architecting-data-src/skills/architecting-data ~/.claude/skills/architecting-data
# No dependencies. Pure-knowledge skill: SKILL.md + references/*.md + examples/dbt-project.
# Repo also ships an interactive ./install.sh (installs all 76 skills) if you want the full set.
Skills live in ~/.claude/skills/ (global) or .claude/skills/
(per-project). Restart Claude Code after installing.
Commands — how to trigger Architecting Data
-
/architecting-dataDecision frameworks for data lake vs warehouse vs lakehouse, table formats, mesh readiness
It also activates on plain-language prompts like these:
-
Should we use a lakehouse or warehouse here -
Design a medallion architecture for this data -
Choose between Iceberg and Delta Lake for us
Frequently asked questions
- Is the Architecting Data skill free?
- Yes. The skill itself is free from ancoleman/ai-design-components. SkillProof publishes the install command and an independent test verdict at no cost.
- Does Architecting Data work with Claude Code?
- We tested it with Claude Code 2.x (agent harness) on Jul 21, 2026. Verdict: Tested · Works. Fetched SKILL.md at skills/architecting-data/SKILL.md; frontmatter parses with name+description. Spot-checked 3 referenced files raw (references/decision-frameworks.md, references/medallion-pattern.md, examples/dbt-project/stg_customers.sql) — all HTTP 200; no security smells. For the output test I wrote both a baseline and a strictly skill-following answer to one task (120-person SaaS, 4-person data team, mixed BI+ML on Postgres, cost-sensitive, mesh?). Baseline hedged (warehouse-or-lakehouse, mesh "probably premature"); the skill run applied the 6-factor mesh readiness score (~13/30 → "Build foundation first"), landed decisively on Lakehouse+Iceberg via the decision tree and 50-500 org bracket with cost figures, and specified bronze/silver/gold with dimensional-vs-wide modeling.
- What is the Architecting Data SkillProof Score?
- 8.4/10 — installs cleanly 5/5, triggers reliably 5/5, output vs. baseline 7/10, docs & honesty 4/5.
- How do I install Architecting Data?
- Copy the install command from this page, run it in your terminal, and restart Claude Code. Skills live in ~/.claude/skills/ (global) or .claude/skills/ inside a project.
- Can I use Architecting Data with Cursor, Copilot, Gemini CLI, Codex or other AI tools?
- The SKILL.md format is native to Claude (Claude Code, Desktop, claude.ai). The instructions inside adapt to other assistants: Cursor rules, GitHub Copilot instructions, Windsurf rules, Custom GPTs, AGENTS.md for OpenAI Codex, and GEMINI.md for Google Gemini CLI — our conversion guides cover each, and the free converter on the tools page does the wrapping for you.