Cursor Agent Mode 2.0 vs Rocky

“The primitive here is a plan-execute-observe loop that operates at the repo level — not a file, not a selection, the whole working tree. The DX bet is that developers want to describe intent at a high level and supervise outcomes rather than prompt-per-step, which is exactly the right call for any task larger than a one-liner refactor. The moment of truth is when it runs your tests, reads the failure output, and patches the source without you touching the keyboard — I've had it close 6-file refactors that would have taken me 45 minutes in about 8. The weekend alternative here is genuinely not viable: stitching together a repo-aware context window, shell execution sandbox, and iterative test loop yourself would take a week, not a weekend, and Cursor's tight editor integration means the diff review UX is right where you need it. Ships because the loop actually closes — it doesn't just write code, it verifies it.”

“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.”

“Direct competitor is GitHub Copilot Workspace, which has been promising autonomous multi-file edits for over a year and still feels like a prototype with a press release attached. Cursor's Agent Mode 2.0 actually ships the loop — it runs terminal commands, reads test output, and iterates — and that's meaningfully ahead of what Copilot delivers in practice today. The scenario where this breaks is a mature monorepo with complex build tooling: the agent gets confused by non-standard test runners, custom Makefile targets, or repos where the test suite takes 8 minutes to run, and it either spins or gives up. What kills this in 12 months isn't a competitor — it's OpenAI or Anthropic shipping this natively inside VS Code as a free tier, which both have the distribution and model access to do. I'm shipping it because it works now and 'works now' is worth something, but I'd be actively de-risking my dependence on Cursor as a business if I were betting on it past 2027.”

“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.”

“The thesis Cursor is betting on: within 3 years, the dominant unit of developer work shifts from 'write code' to 'review AI-generated diffs,' and the editor that owns the diff review UX owns the developer workflow. That's a falsifiable claim — it depends on model capability continuing to improve at the task-completion level, not just the token-prediction level, and it depends on developers accepting supervised autonomy before full autonomy. The second-order effect that matters here isn't productivity — it's that as agents handle implementation, the bottleneck moves to specification and review, which means senior engineers get dramatically more leveraged and junior engineers face a steeper path to contribution. Cursor is riding the 'context window as RAM' trend — the jump from 8k to 200k context is what makes repo-level coherence possible — and they're on-time to it, not early. The future state where this is infrastructure: Cursor becomes the IDE layer that enterprise teams use to gate all AI-generated code through human review workflows, the same way GitHub became the layer for human-generated code.”

“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.”

“The job-to-be-done is crisp: complete a multi-step engineering task end-to-end without context-switching out of the editor. That's one job, no 'and.' Onboarding is near-zero friction if you're already a Cursor user — Agent Mode is a mode toggle, and within 90 seconds you can watch it read your repo, write a plan, and start executing diffs. The product is complete enough to replace the current solution (manual prompt-chain-per-file plus switching to terminal plus re-prompting on errors) for a meaningful slice of tasks — not all tasks, but refactors, test-fixing loops, and dependency upgrades are genuinely handled. The opinion baked in is that the agent should ask for clarification rather than guess on ambiguity, which is the right call and prevents the 'it rewrote everything wrong silently' failure mode. The gap is project-scale tasks that require external context — design docs, Jira tickets, Slack threads — the agent doesn't yet bridge the specification layer, only the implementation layer. Ships because the implementation layer alone is already worth the subscription.”

“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.”