marimo-pair vs Metrics SQL by Rill

marimo-pair is an open-source extension for marimo reactive notebooks that lets you drop AI agents directly into live, running notebook sessions. Unlike traditional AI coding assistants that only see static code, these agents can execute cells, inspect in-memory variables, read dataframes, manipulate UI components, and iterate on your actual live state — not a static snapshot. The tool plugs into Claude Code via a marketplace plugin and supports any agent implementing the Agent Skills standard. An agent that can see and run your notebook opens up genuinely new workflows: "explore this dataframe and tell me what's anomalous," "run this hypothesis test on the data already in memory," or "generate a chart for each of these 12 conditions." It's the difference between an assistant that reads your code and one that works alongside you in your actual environment. Marimo itself is already a compelling React-based replacement for Jupyter — every cell tracks its dependencies so the notebook is always consistent. marimo-pair makes that reactive model collaborative with AI, enabling a new style of human-AI pair programming where the agent shares your full computational context.

Metrics SQL is a SQL-based semantic layer from Rill Data that solves a specific and painful problem: AI agents that query your data warehouse tend to hallucinate aggregation logic, producing metrics that look plausible but are mathematically wrong. Metrics SQL lets analysts define business metrics once — revenue, MAU, conversion rate, ROAS — in a governed definition layer, and then exposes those definitions as queryable SQL tables. Every dashboard, notebook, and AI agent resolves from the same source. The technical approach is elegant: rather than inventing a new DSL, Metrics SQL extends SQL itself. An agent that knows SQL can query `SELECT * FROM metrics.weekly_revenue` and get correctly computed numbers without needing to know how revenue is defined, which tables it joins, or how edge cases like refunds are handled. The semantic layer intercepts the query, applies the governed definition, and returns correct results. The implications for AI-native data stacks are significant. Currently, one of the biggest failure modes for AI analysts and BI agents is inconsistent metric computation — different agents or dashboards produce different numbers for 'revenue' because they implement aggregation logic differently. Metrics SQL addresses this at the infrastructure level, not by improving agent prompting.