Simon Späti 🏔️Mar 9
CLI-first is eating development. Email, calendar—they all have CLIs now. Why not your business metrics? For data/analytics engineers building with agents: DuckDB + MotherDuck + Rill give you an #agentfriendly, #localfirst frontend—exact context via SQL and YAML.

Rill | Building an Agent-Frien...
Rill | Building an Agent-Friendly, Local-First Analytics Stack with MotherDuck and Rill

The convergence of embedded analytics engines (DuckDB/MotherDuck), declarative BI-as-code (Rill), and AI agent protocols (MCP) is creating a new architecture for business intelligence, one where dashboards become code, code becomes agent-readable, and analysts shift from clicking to prompting.

Show threadSimon Späti 🏔️Mar 9
These stacks are a joy to work in, and the iteration cycles are super fast from: `ambiguous prompts -> verifiable configs -> shipping visualizations` Increases quality by allowing domain-experts knowing the business best to own more of the stack, while everything is still versioned, automatable.
Show threadSimon Späti 🏔️Mar 9
In this new essay we look into general data engineering workflows and working with new agent tooling, why you'd use @[email protected], and how @[email protected] can help you in this stack. We look at #ConversationalBI, turning dashboards into code (and code into agent-readable context).
Show threadSimon Späti 🏔️Mar 9
We explore more: →We discuss agentic coding—no more dashboards needed? →Natural language interfaces: convenient, but inaccurate? →Does self-serve BI-as-Code provide the #context we need? →How language choice matters—SQL, YAML, chosen for Agent use (not human familiarity).
Show threadSimon Späti 🏔️Mar 9
And we check #limitations the future holds due to the imprecise way of natural language, e.g., "give me the analytics for this week?" Did you mean "from today until last week"? Or how data workloads need to be #deterministic and #reproducible to backfill faulty data, but AI agents aren't that.
Show threadSimon Späti 🏔️Mar 9
We explore three examples: 1. Stack Overflow Developer Survey with zero-pipeline analytics 2. Updated Multi-Cloud Cost Analyzer to add MotherDuck with `DLT_DESTINATION=motherduck` 3. Including a real-world setup from Drio Tech, how he uses Airbyte/dlt + BigQuery/MotherDuck/dbt + Rill.
Show threadSimon Späti 🏔️
Again, if you like this, read the full article at: www.rilldata.com/blog/buildin... What do you think, and which agent-friendly, local-first analytics stack do you prefer these days?

Rill | Building an Agent-Frien...
Rill | Building an Agent-Friendly, Local-First Analytics Stack with MotherDuck and Rill

The convergence of embedded analytics engines (DuckDB/MotherDuck), declarative BI-as-code (Rill), and AI agent protocols (MCP) is creating a new architecture for business intelligence, one where dashboards become code, code becomes agent-readable, and analysts shift from clicking to prompting.

Mar 9 at 2:23pmWeb