MotherDuck Build CFA App
Architects MotherDuck-backed customer-facing analytics apps with per-tenant isolation.
Test report
- Verdict
- Tested · Works
- Score
- Tested
- Jul 14, 2026
- Environment
- Claude Code 2.x (agent harness)
- Upstream re-checked
- Aug 10, 2026 · 44c08d6
Explicitly steers away from the 'shared tenant_id filter' pattern most generic advice defaults to, naming it a fallback rather than a recommendation, and ships a working customer_routing_example.py/.ts pair (both fetched and confirmed present) demonstrating per-customer database routing.
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 9/10
- Docs & honesty 5/5
What MotherDuck Build CFA App does
Designs the serving architecture for embedding analytics into a product for external customers on MotherDuck: picks between a 3-tier app, embedded Dives, or DuckDB-Wasm, defines per-customer isolation and service-account boundaries, and ships runnable Python/TypeScript routing examples. Triggers on multi-tenant SaaS reporting, embedded analytics, or per-customer database isolation questions.
How to install MotherDuck Build CFA App
git clone https://github.com/motherduckdb/agent-skills
cd agent-skills
mkdir -p ~/.claude/skills
cp -r plugins/motherduck-skills-claude/skills/motherduck-build-cfa-app ~/.claude/skills/motherduck-build-cfa-app
Skills live in ~/.claude/skills/ (global) or .claude/skills/
(per-project). Restart Claude Code after installing.
Commands — how to trigger MotherDuck Build CFA App
-
/motherduck-build-cfa-appArchitects MotherDuck-backed customer-facing analytics apps with per-tenant isolation.
It also activates on plain-language prompts like these:
-
Design a per-tenant analytics app on MotherDuck for our customers -
Should I use embedded Dives or DuckDB-Wasm for this customer app? -
Architect isolation boundaries for our multi-tenant reporting SaaS
Frequently asked questions
- Is the MotherDuck Build CFA App skill free?
- Yes. The skill itself is free from motherduckdb/agent-skills. SkillProof publishes the install command and an independent test verdict at no cost.
- Does MotherDuck Build CFA App work with Claude Code?
- We tested it with Claude Code 2.x (agent harness) on Jul 14, 2026. Verdict: Tested · Works. Explicitly steers away from the 'shared tenant_id filter' pattern most generic advice defaults to, naming it a fallback rather than a recommendation, and ships a working customer_routing_example.py/.ts pair (both fetched and confirmed present) demonstrating per-customer database routing.
- What is the MotherDuck Build CFA App SkillProof Score?
- 9.6/10 — installs cleanly 5/5, triggers reliably 5/5, output vs. baseline 9/10, docs & honesty 5/5.
- How do I install MotherDuck Build CFA App?
- 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 MotherDuck Build CFA App 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.