The Great Sleepwalk: Coding Agents Will Revolutionize Knowledge Work

I recently watched my simple Antigravity AI agent take a SQL competency test. It didn’t just pass; it nailed a 9 out of 9 score, deftly handling subqueries, window functions, and WHERE clauses that usually trip up human analysts after their third coffee.

This wasn’t a parlor trick. It was a litmus test for a thesis I’ve been chewing on for months: The capability to solve problems via software engineering is rapidly flowing downstream.

For the last decade, we’ve bifurcated the world into “Developers” (the high priests of syntax) and “Users” (the click-and-hope crowd). Somewhere in the middle sat the “Makers”—the no-code warriors of Coda, Notion, and Airtable who learned just enough logic to be dangerous at times and extremely helpful otherwise. We owe this cohort immense gratitude for the operational clarity, cost savings, and innovation they have delivered.

But as I reviewed the results of that SQL competency test—run in a Coda doc connected to a local SQLite environment via MCP—I realized something profound. The dam has broken. The rigid discipline of software engineering is no longer trapped upstream in the Engineering Department. It is flooding the valley of general knowledge work.

Most enterprise middle managers are sleepwalking into the rising water.

The Upstream/Downstream Dynamic

In a recent discussion on the Coda Maker Community, I noted that enterprise leaders are missing the point of AI agents. They see “chatbots” or “content generators.” They see a faster way to write a mediocre email. Or a lazy path to summarize texts, much of it poorly.

What they should be seeing is the democratization of deterministic reasoning.

Enterprise middle-managers are sleepwalking into a future where it is common to believe and accept that almost any problem/solution can be expressed in software. What they are missing is that this capability is upstream of all knowledge work.” — Bill French

Currently, I’m consulting on a project involving the modernization of COBOL systems—mainframes that have been humming since the days when Star Wars was in theaters. These systems cannot fail. “Hallucination” isn’t a cute quirk here; it’s a lawsuit or an ATM that doesn’t give you your own money. By crafting a formal agentic framework using modern reasoning models, we are seeing two to five nines of competence.

This is the Upstream reality: Formal, agentic frameworks that convert natural language intent into deterministic, flawless code execution. But let’s expand on the term “code execution” to include an agent that opens a Coda document, analyzes the related views, and magically modernizes it to use the new tabbed views feature.

The Downstream reality is what happens when those tools hit the marketing department, HR, or sales operations. The ability to structure a problem, break it into logical steps, and implement it in code (even if you never write a line of Python or CFL yourself) is becoming a baseline requirement for employment.

Vibe Coding and the Death of Syntax

Andrej Karpathy coined the term “Software 2.0” to describe neural networks. But we are arguably entering “Software 3.0,” or what the internet, in its infinite wisdom and irreverence, has dubbed “Vibe Coding.”

Aakash Gupta recently highlighted this shift. We are moving from a world where you need to know the syntax (where to put the semicolon) to a world where you need to know the vibe (what is the user actually trying to achieve?).

A Note About ‘Vibe’
Don’t get hung up on this term. It reflects a general lack of due diligence, yielding imprecise outcomes. Ultimately, we align with AI agents to drive precise, actionable outcomes. Vibing is no different than contexting. The better your vibe, the better the outcomes.

The entire industry is pivoting to this “Agentic Generalist” model on the heels of tools like Claude Code:

  • Google Antigravity: This isn’t just an IDE; it’s a “productivity platform”. While initially pitched as a “Cursor Killer” for devs, it’s finding a massive foothold in Product Management and Marketing. Why? Because it offers an “Agent Manager” surface where a PM can say “Build a campaign timeline,” and the agent autonomously plans, executes, and tests the result. It’s software engineering applied to Gantt charts.
  • Claude Cowork: Anthropic just dropped this “Claude Code for the rest of us”. It doesn’t just chat; it stares at a folder on your desktop and does the work—organizing spreadsheets, renaming files, and executing multi-step workflows that used to require a junior analyst.

This is terrifying for purists. It’s liberating for everyone else.

In the Coda ecosystem, we are seeing this collision in real-time. The “Old Maker” spent hours learning the intricacies of Coda formulas, RunActions, and layout hacks. They took pride in the complexity of their docs.

The “New Maker”—enabled by tools like Coda MCP and mcpOS™—doesn’t care about the formula. They care about the reasoning.

mcpOS™ (my own framework for integrating agentic reasoning into Coda) is proof of this. It allows a Coda doc to stop being a static repository of text and start being a dynamic operating system that can:

  • Read its own schema.
  • Query external databases.
  • Test its own hypotheses.
  • Reason about the data it holds.
  • Validate its work.

The 10x Productivity Lie (It’s Actually higher)

We love to throw around “10x engineer” as a mythical creature. But with extreme context engineering—feeding agents the precise schema, rules, and constraints of a system—we aren’t just making engineers faster. We are making non-engineers capable of engineering feats. Or Makers capable of compressing time while expanding opportunities to enrich enterprise workers.

  • If I can instruct a Coda MCP agent to “analyze the sales data from the last quarter, identify outliers based on standard deviation, and draft a report explaining why the Midwest region is underperforming,” and it executes the SQL, runs the Python analysis, and writes the prose—what am I?

  • If I can refactor twenty Coda systems to utilize the latest advanced features, test the changes, and document the changelog for three hundred users—what am I?

I am no longer a “Manager.” I am the architect of a software system that performs management tasks. I am the orchestrator of a team of agents that transforms me into a Superhuman Maker.

This is the “profound impact” I mentioned in the Community thread. The distinction between “managing people” and “managing code” is blurring as tools that require code-like instructions proliferate, and code is becoming sophisticated enough to act like people.

The Determinism Defense: A Case Study in Reasoning

“But Bill,” I hear the skeptics whine, “AI hallucinates! It lies! It makes things up!”

Yes, if you use it like a drunk intern. But if you use it as an engineer would, it works with decisive intention guided by your vibe (i.e., your instructions, a constitution, a context).

Take a look at the Competence Report generated by my SQL agent. This is the smoking gun for why mcpOS™ and tools like Antigravity are revolutionary.


Look at the “Failures and Corrections” section:

  • The Failure: In a “Nested Subqueries” puzzle, the agent initially failed because it forgot that SQLite performs integer division (e.g., 88 / 95 becomes 0, not 0.92).
  • The Correction: It didn’t just give up. It analyzed the error, applied a fix by casting the denominator to a float (score / (max_val * 1.0)), and re-ran the query.
  • The Result: Success.

This is reasoning. It is the scientific method applied at the speed of silicon. A standard LLM chatbot would have just hallucinated a number, and when corrected, it would tell you, “You’re absolutely right!”. An agent running on mcpOS™ engineered a solution because it includes as part of its constitution this:

### 3. Verification & Testing

#### Automated Tests (Browser Subagent)
We will use the Browser Subagent to perform visual verification:
- **Test Case 1**: Verify Tab Existence
  - Check for DOM elements corresponding to the tab headers: "Table", "Timeline", "Kanban".
- **Test Case 2**: Verify View Switching
  - Click "Timeline" tab -> Verify Timeline view acts active.
  - Click "Kanban" tab -> Verify Board view acts active.

Explicit contexts (vibes) like this are how we are modernizing 40-year-old COBOL systems without melting the financial sector. And it is how a Marketing Director using Google Antigravity will eventually run their entire campaign attribution model without asking the data science guru for a favor.

The Coda Maker Identity Crisis

So, where does this leave the Coda community?

If you identify as a “Maker” because you know how to write complex formulas, you are in trouble. That skill is becoming a commodity. The AI can write the formula faster and with fewer syntax errors. I demonstrated this capability here.

However, if you identify as a “Maker” because you know how to model a problem, you are about to become a god.

The future Coda Maker is not a formula-writer. They are a Context Engineer.

  1. They define the schema (the nouns and verbs of the business).
  2. They define the tools (what APIs the agent can touch via MCP).
  3. They define the success criteria (what “good” looks like).
  4. They force the agent to set goals and create a plan.

Then, they let the agent do the “vibe coding”.

The Downstream Flood

In 2030, we won’t talk about “tech companies” versus “normal companies.” We won’t talk about “software engineers” versus “knowledge workers.”

We will talk about System Architects and System Users.

The “System Architects” will understand that every business problem—from supply chain logistics to writing a press release—is a software problem. They will use tools like mcpOS™, Claude Cowork, and Google Antigravity to spin up agents that solve these problems deterministically.

The “System Users” will be… well, they’ll be the ones complaining that the AI “didn’t get the vibe.”

As I said earlier, enterprise middle managers are sleepwalking. They believe their value lies in their ability to coordinate, attend meetings, and “sync.” They are overlooking the fact that the upstream capabilities of software engineering are flowing down to their desks.

Those who wake up and learn to swim in this new current—using Coda MCP, mcpOS™, context engineering, and reasoning agents—will find they have superpowers. They will do the work of ten people with the effort of one. They will be superhuman.

Those who don’t? They’ll just be wondering why the water is getting so high.

5 Likes

I wholeheartedly agree with this part of your article. In fact, I would expand it further to include a few other skills that are about to become extremely valuable:

  1. Business acumen and knowledge about how your business runs - SOP expertise
  2. Business modeling, data modeling, business logic, spreadsheet expertise (Coda stuff!)
  3. Knowledge curation - managing the key documents about policies, procedures, & how-to
  4. AI Agentic tools - building AI “experts” that do business processing better than people

And these skills are mostly vested in middle-layer (middle-aged?) managers who don’t know how valuable these skills are about to become.

My exec-coaching business has been swamped with new opportunities this month!
Business managers are afraid for their jobs, their careers, their teams, and their line of business.

They see the incoming “AI Tsunami” sweeping away all the safety, certainty, and stability they have been living with throughout their careers. All the media hype and hoopla do not help.

Corporations are issuing “AI First” mandates that require employees to improve productivity through AI or face poor reviews (or worse), but without a lot of guidance about how to do this. (And admitting your ignorance, uncertainty, and fears is not encouraged, alas).

But my biggest clients are facing a huge explosion in their IT departments’ “Technical Debt” because the amount of code being produced has exploded, with almost no control over formal testing, certification, deployment safety, etc. A ‘shadow IT’ plague (as they see it).

Placing vibe-coding tools in the hands of ‘citizen developers’ who cannot understand the code being generated, are not trained in the art of writing clear requirement specifications, regression testing, or source code management, is like handing out crates of hand grenades and bottles of tequila at the xmas party!

Managers who use AI to improve their personal productivity are doing well. Those who naively use AI to produce complex applications in python or js to solve business problems - not so much!

So my own stance is that vibe-coding (for the masses) is not yet ready. But vibe-(no)coding (‘vibe-making’?) using nocode or spreadsheet tools is far more reliable and safe. Especially since the resulting workflows are understandable by the users who make them.

Expressing the “problem model” clearly as a pile of big hairy english prompts is not as good as using more formal process and algorithm analysis tools.

Getting your AI response as a great heap of procedural code you cannot understand is not as good as getting an AI response in the form of a Notion, Coda, Excel, or N8N solution, which is far more useful (and safer for the business).

Coda MCP has the potential to be a significant part of that approach. But for now, it is not ready for prime time yet:

  1. it is only available to a limited set of beta testers
  2. it is undergoing rapid evolution in response to that testing
  3. it is only available to users of copilot, antigravity, kaggle etc
    - ie: people who know how to marshal and deploy the resulting agents
    - not people who rely on Coda to build their business workflows

I applaud you, @Bill_French, for your work on mcpOS, which addresses many of my concerns above.

Your recent articles have given me much to think about, and I will respond here with a more considered and detailed reaction over the weekend.

Respect
:red_circle:➤𝖒𝖆𝖝

5 Likes

Max! Excellent follow-on article! Your evals :wink: are so spot on, I want you instantiated as an eval agent. Could you build that for me?

I haven’t seen any evidence of a new update to the MCP service or any changelogs to that effect. Have you seen something?

100% This is how I approach my use of Coda MCP to remain grounded in the “Maker Vibe”. But I will note that even dancing through a lot of Coda maker-like processes from an agentic platform involves code that the agent perceives as needed when backed into a corner. Typically, these occurrences do invoke code generation to accommodate a process such as parsing data from a Coda UI where a browser subagent has been invoked to overcome the lack of an MCP or even API capability.

3 Likes

I applaud you both, @Bill_French and @Agile_Dynamics!

The perspectives you shared, shaped by both of your experiences in the real world, are absolutely fascinating to use as basis for one’s own evolution of existing thought patterns.

The way you present them (understandable, structured and with witty puns) make them a joy to follow.

Thank you for sharing your expertise and your humor with us in the community!

To me, these two quotes resonated especially strong:

5 Likes