Simon SpätiMar 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.
https://www.rilldata.com/blog/building-an-agent-friendly-local-first-analytics-stack-with-motherduck-and-rill

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ätiMar 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ätiMar 9

In this new essay we look into general data engineering workflows and working with new agent tooling, why you'd use @motherduck.com, and how @rilldata.com can help you in this stack.

We look at #ConversationalBI, turning dashboards into code (and code into agent-readable context).

Show threadSimon SpätiMar 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

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.

Mar 9 at 2:23pmWeb
Show threadSimon SpätiMar 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ätiMar 9

Again, if you like this, read the full article at: https://www.rilldata.com/blog/building-an-agent-friendly-local-first-analytics-stack-with-motherduck-and-rill

What do you think, and which agent-friendly, local-first analytics stack do you prefer these days?

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.