motherduck-build-cfa-app

What problem does it solve?

This skill helps you design a production-ready customer-facing analytics application on MotherDuck with strong per-customer isolation, safe serving patterns, and a clear implementation plan.

Core Features & Use Cases

• Customer-facing analytics architecture: produces a recommended serving architecture (defaulting to a 3-tier CFA pattern) for embedding analytics into an external product.
• Isolation model and routing strategy: defines how to isolate tenants (e.g., per-customer database namespaces or service-account boundaries) and how backend routing should select the correct connection.
• Query serving requirements: ensures serving queries are validated and aligned with read scaling and consistency expectations, rather than relying on unsafe shared-database shortcuts.
• Implementation orchestration: ties together operational steps across discovery, modeling, ingestion, querying, and connection selection by leveraging other MotherDuck skills.

Quick Start

Use motherduck-build-cfa-app to design your 3-tier embedded analytics backend by first inspecting your live MotherDuck workspace and then producing an isolation model, API contract outline, and rollout plan.