Rocky vs Sourcegraph Cody Agentic Code Review

“Compile-time type safety for SQL is the feature I've wanted for years — catching type mismatches before the pipeline runs instead of finding out when a dashboard breaks at 9am. The column-level lineage alone justifies the migration cost for any team managing complex pipelines.”

“The primitive here is clear: an agentic review bot that uses Sourcegraph's code graph as context window, not just the diff. That's the actual technical bet, and it's the right one — diff-only review misses cross-repo call chains and dependency implications that cause real bugs. The DX bet puts complexity at the webhook config layer, which is correct; once it's wired in, it fires on every PR without friction. My concern is the moment of truth: if the annotation signal-to-noise ratio is bad in week two, developers start ignoring it, and it becomes a dead checkbox in CI. If Sourcegraph has tuned precision over recall here, this earns a ship. If it floods PRs with obvious lint-level comments, it's a fancy bot you disable.”

“dbt has a massive ecosystem, hundreds of integrations, and years of community knowledge — migrating to Rocky means giving all that up for a Rust tool with a small user base. The AI intent layer sounds cool but 'stores intent as metadata' is vague; in practice this is probably just comments with extra steps.”

“Direct competitors are GitHub Copilot code review, CodeRabbit, and Cursor's review tooling — and most of them share the same limitation: they review diffs, not codebases. Sourcegraph's moat is its code intelligence graph, which has been indexing entire enterprise repos for years before anyone called it agentic. The specific scenario where this breaks is monorepos with heavy abstraction layers — when the agent has to traverse 12 layers of indirection to understand whether a change is safe, latency and hallucination risk compound. What kills this in 12 months isn't a competitor, it's GitHub Copilot getting native enterprise code graph access, which is exactly the capability GitHub has been building toward. If that doesn't ship, Cody owns this space.”

“Data pipelines are the next frontier for AI-assisted maintenance, and Rocky's intent metadata approach is ahead of the curve. When AI can auto-reconcile pipelines after schema changes because it knows what each model was meant to do, that's a qualitative shift in how data infrastructure gets maintained.”

“Rocky is clearly built for engineering-heavy data teams — the VS Code extension, compile-time guarantees, and Dagster integration signal a developer-first product. For data analysts and business intelligence folks who just need their transforms to work, the learning curve is steep.”

“The buyer here is an engineering manager or VP Eng who owns code quality KPIs and is already paying for Sourcegraph's enterprise code intelligence — this is an upsell into an existing budget line, not a greenfield sale. That's a structurally sound GTM position. The moat is the code graph: Sourcegraph has years of enterprise indexing data and cross-repository context that a new entrant can't replicate in a sprint cycle. The stress test is what happens when GitHub ships native agentic review into Copilot Enterprise — at that point, customers already on GitHub Advanced Security have zero reason to add a vendor. Sourcegraph's survival depends on winning accounts where multi-VCS environments and custom code intelligence queries matter enough to justify the line item, which is real but narrower than their TAM claims suggest.”

“The job-to-be-done is 'catch bugs and issues before they merge,' and Cody's full-repo context is a genuine differentiator for that job — but the product isn't complete enough to replace human review, and a tool that supplements rather than replaces requires developers to maintain two workflows. The onboarding path through webhook configuration is a configuration screen, not value delivery — you're at least 20 minutes from seeing a single annotation if you're new to Sourcegraph's infrastructure. The deeper problem is that this feature has no opinion about review severity triage: if every annotation looks equal, developers learn to ignore all of them, which is how CodeClimate died in every org I've seen adopt it. Ship this when there's a demonstrated precision threshold and a credible 'this blocked a real bug' proof point in the docs.”