Learn how to build a local-first, agent-friendly analytics stack using MotherDuck (serverless DuckDB) and Rill (BI-as-Code). Covers the architecture behind declarative dashboards, the metrics layer, MCP integration, and three real-world examples — from Stack Overflow survey analysis to multi-cloud cost tracking.