marimo pair vs Rocky

marimo pair is an open-source agent skill that lets AI agents operate directly inside a live marimo notebook session. Rather than editing files from the outside, agents can execute code incrementally, inspect live variables, and manipulate visualizations — the same interactive environment that data scientists already prefer. The system works through a reactive REPL architecture that eliminates hidden state. Because marimo's reactive design enforces deterministic execution order, agents stay on track and produce replayable Python programs instead of the chaotic half-executed notebooks that plague traditional LLM-notebook integrations. It's installed via a single npx command and activated with a one-liner slash command. The core insight is that research is exploratory, not deterministic — and most agent frameworks optimize for software engineering patterns that don't fit data work. marimo pair bridges this gap, enabling things like multi-agent experiment sweeps, paper-to-notebook generation, and collaborative EDA sessions where a human and an agent share the same canvas.

Rocky is a Rust-based SQL transformation engine that brings software engineering discipline to data pipelines. Where tools like dbt gave data teams a version-controlled workflow, Rocky goes further: type-safe compile-time SQL, column-level lineage visualization, git-style branches for isolated testing, and a built-in AI intent layer that stores your purpose as metadata alongside the code. The branching feature is the standout — you can create a branch, run it against an isolated schema, inspect the results, then drop or promote. The column-level lineage shows the full downstream blast radius before you ship a change, tracing any single column back through every aggregation and join to its source. This is the kind of visibility that prevents the "who broke the revenue dashboard" post-mortems that happen in every data team. The AI intent layer is genuinely novel: it stores what a model is supposed to do as metadata, so AI can later explain models, auto-update them when upstream schemas change, and generate tests based on the original intent. Rocky integrates with Dagster via an official plugin and supports DuckDB for local development with no credentials required. With Hacker News coverage and a Rust-native architecture, it's positioned as the data pipeline tool for engineering-forward teams who are tired of YAML-based transformations.