Archon vs Metrics SQL by Rill

Archon is an open-source workflow engine and harness builder for AI coding agents, built by indie developer coleam00. It addresses the non-determinism problem at the heart of LLM-based coding: the same prompt doesn't always produce the same result, making agentic coding pipelines unreliable in production. Archon solves this by defining development processes — planning, implementation, validation, code review, PR creation — as structured YAML workflows that run consistently across projects and environments. Each task gets an isolated git worktree, automatic test execution is baked in, and PR creation is handled as part of the workflow rather than an afterthought. The YAML-first design means workflows are version-controlled, diffable, and reviewable by teams — treating the agent process as code rather than a black box. Archon also positions itself as the first open-source tool for building deterministic AI programming benchmarks, giving researchers a reproducible harness for evaluating coding agents. For solo developers, Archon provides guardrails that make autonomous coding agents safe to run unattended. For teams, the YAML workflows create shared standards for how AI contributes to codebases. The core limitation is that you still need to write the workflows — there's no auto-discovery, and complex multi-repo setups require careful YAML construction. But as a free, open-source foundation for reliable agentic coding, it fills a real gap.

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.