MotherDuck Build CFA App

Architects MotherDuck-backed customer-facing analytics apps with per-tenant isolation.

Tested · Works

Test report

Verdict
Tested · Works
Score
9.6/10
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-app Architects 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.