# Coda MCP for AI Agents MCP

> Coda MCP lets your AI agent manage structured data across collaborative documents. It handles tables, formulas, and document structure by letting you read rows, update records, and pull live formula values using natural language commands.

## Overview
- **Category:** productivity
- **Price:** Free
- **Tags:** collaborative-docs, table-management, formula-automation, workspace-integration, data-sync, project-tracking

## Description

The Coda platform mixes words, databases, and teams into one place. This MCP connects your AI to that whole system so you don't have to open the application to get answers or make changes. Instead of navigating multiple tabs and copying data manually, you just ask your agent what you need done.

For example, if an operations team needs to check the status of a task listed in a tracker, the AI can read that specific row right from the chat window. If a product manager needs to know the total calculated budget for Q4, it can pull the live formula value instantly. It even lets you add or delete entire rows of data on demand.

By connecting Coda through Vinkius's catalog, your AI client gains deep access to everything—from listing all related documents to automating complex data sync between different parts of your workspace.

## Tools

### delete_rows
Removes one or more specific rows from a Coda table.

### insert_rows
Adds new, empty rows to the end of an existing Coda table.

### get_doc_details
Retrieves key metadata and structural details about a specified Coda document.

### get_formula_value
Pulls the current, calculated value of any named formula in a document for real-time reporting.

### list_columns
Shows you all the column headers present in a chosen Coda table.

### list_docs
Gives a list of all Coda documents available to your agent.

### list_formulas
Retrieves the names of all named formulas within a specific document.

### list_rows
Pulls the data contents of multiple rows from a specified Coda table.

### list_tables
Shows you all the distinct tables located inside one document.

### update_row
Modifies and saves new data into an existing row within a Coda table.

## Prompt Examples

**Prompt:** 
```
What's the overall status and total budget for Q1?
```

**Response:** 
```
**Q1 Status Report**

The project is currently marked as **In Progress**. Here are the key metrics:

*   **Total Budget:** $450,000.00 (Last calculated: 2 minutes ago)
*   **Key Milestones:** All three milestones were hit on time.
*   **Action Items:** We need to update row 14 with the new vendor contact details.
```

**Prompt:** 
```
Show me the most recent documents and list all available tables in 'Project Tracker'.
```

**Response:** 
```
You have 4 recent documents:

1.  **Project Tracker:** (3 Tables)
2.  **Q1 OKRs:** (2 Tables)
3.  **Team Meeting Notes:** (1 Table)

I found the following tables in 'Project Tracker':
*   `Task Statuses` (Columns: Task Name, Owner, Due Date)
*   `Resource Allocation` (Columns: Resource, Hours Used, Cost Center)
```

**Prompt:** 
```
Can you add a new row to the 'Resource Allocation' table for Jane Doe and set her hours used to 15?
```

**Response:** 
```
Done. I inserted a new record into the `Resource Allocation` table.

The new entry is:
*   **Resource:** Jane Doe
*   **Hours Used:** 15
*   **Cost Center:** Marketing

The row ID is `r_92a3b`. Let me know if you need to update any other data points.
```

## Capabilities

### Get document context and structure
The agent lists recent documents or retrieves detailed information about a specific file, including its contained tables and pages.

### List and manage data tables
You can retrieve a list of tables within a document, identify all columns in a table, or pull the full rows from any given table.

### Read, update, create, or delete records
The agent handles structured data changes, allowing you to read specific rows, update existing entries, insert new rows, or remove old ones entirely.

### Access live formula calculations
You can get the current calculated value for any named formula within a document, providing real-time metrics without opening the file.

## Use Cases

### Checking project status for a client call
Instead of digging through 'Sprint Board' to check Q3 Launch status, ask your agent. It runs list_rows and tells you the current task status, assigned owner, and deadline right away.

### Automating quarterly budget reporting
A finance team member needs the total cost across three different departments. The agent calls get_formula_value multiple times to pull the live 'Total Budget' metric from each respective document, compiling one summary.

### Migrating data between teams
When a department changes its tracking system, use list_tables and list_columns to map out all necessary fields before writing scripts that insert new rows into the target location.

## Benefits

- Don't open the document to check data. Use list_rows or list_columns so your agent pulls specific table data directly into the chat.
- Get real-time metrics instantly. The get_formula_value tool lets you pull live numbers from named formulas without needing manual calculations.
- Keep project trackers current. Update status reports and record changes by using update_row, making sure the source of truth is always accurate.
- Handle data cleanup fast. Need to remove old records? Use delete_rows or insert_rows to manage table capacity on demand.
- Know your document structure immediately. Using list_docs helps you quickly find and understand which documents hold the information you need.

## How It Works

The bottom line is you get to manage structured data and documents using only conversation, without needing to interact with Coda’s visual interface.

1. First, add the Coda integration to your AI toolset and connect it via Vinkius.
2. Next, provide the necessary API Token from your Coda Account Settings.
3. Finally, issue a natural language command—like 'What is the total budget in the Q1 OKRs document?'—and the agent executes the action.

## Frequently Asked Questions

**How does the Coda MCP help with project tracking?**
It lets your AI agent read and write directly into structured tables. You can check status updates or modify task assignments without ever leaving your chat window, making project management much faster.

**Can I use the Coda MCP to calculate totals automatically?**
Yes. The MCP lets you pull the live value of named formulas in any document. This means you get real-time financial or metric data without having to manually calculate anything.

**Does the Coda MCP only read information from my documents?**
No, it's bidirectional. You can not only pull data using list_rows but also update records and insert new rows across various tables in your workspace.

**What kinds of roles benefit the most from the Coda MCP for AI Agents?**
Product Managers, Operations Coordinators, and Data Analysts gain the most. This tool handles constant data retrieval and updates that are core to their daily workflow.

**If I change a tracker table, do I need to use the Coda MCP?**
Yes, if your AI agent needs to know about the change. Using our tools ensures the data is read correctly and that any dependent formulas are pulled with the most current values.