CodaMcpServer

CodaMcpServer

3.3

If you are the rightful owner of CodaMcpServer and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A Model Context Protocol (MCP) server implementation for seamless integration with Coda's API, providing various tools for document, table, and data management.

MCP Server - Coda.io

A Model Context Protocol (MCP) server implementation for seamless integration with Coda's API, providing various tools for document, table, and data management.

Features

  • Table Operations
    • Fetch all tables from a document
    • Retrieve specific table data
    • Get table columns information
  • Row Management
    • Fetch rows from tables
    • Upsert (insert/update) rows
    • Delete rows
  • Column Operations
    • Fetch specific column details
    • Get column metadata

Prerequisites

  • Node.js (v20 or higher)
  • A Coda API key
  • TypeScript knowledge (for development)

Environment Setup

  1. Clone or fork this repository in Replit
  2. Create a .env file in the root directory:
    PORT=8000
    CODA_API_KEY=your_coda_api_key_here
    
  3. Replace your_coda_api_key_here with your actual Coda API key

Installation

The project uses npm for dependency management. To install dependencies:

npm install

Building the Project

Compile TypeScript files to JavaScript:

npx tsc

Running the Server

After building, start the server:

node dist/index.js

Or use the combined command:

npm install && npx tsc && node dist/index.js

The server will start on port 8000 by default, with the following endpoints available:

  • GET /sse - SSE connection endpoint
  • POST /messages - Message handling endpoint

Available Tools

  1. fetch-coda-docs

    • Fetches all available Coda documents
    • Optional parameters: isOwner, limit
  2. fetch-coda-tables

    • Fetches all tables from a specified document
    • Required parameter: docId
  3. fetch-coda-table

    • Fetches a specific table from a document
    • Required parameters: docId, tableId
  4. fetch-coda-table-columns

    • Retrieves columns information for a specific table
    • Required parameters: docId, tableId
  5. fetch-coda-rows

    • Fetches rows from a specified table
    • Required parameters: docId, tableId
  6. upsert-coda-rows

    • Inserts or updates rows in a table
    • Required parameters: docId, tableId, rows
  7. delete-coda-rows

    • Deletes specified rows from a table
    • Required parameters: docId, tableId, rowIds

Error Handling

The server implements comprehensive error handling:

  • Environment variable validation
  • API response validation
  • Request parameter validation
  • Proper error messages and logging

Development

The project is structured as follows:

src/
├── tools/           # Individual tool implementations
│   ├── fetch-coda-docs.tool.ts
│   ├── fetch-coda-tables.tool.ts
│   └── ...
└── index.ts        # Main server implementation

Built With

  • Express.js - Web framework
  • @modelcontextprotocol/sdk - MCP implementation
  • Zod - Runtime type checking
  • dotenv - Environment configuration

Known Limitations and Future Improvements

The current implementation of tools requires several improvements:

  • Enhanced JSON response handling and formatting
  • Implementation of pagination for large datasets
  • Better error handling and retry mechanisms
  • Rate limiting implementation
  • Batch processing for large operations
  • Caching mechanisms for frequently accessed data
  • There is more API tools to implement based on the documentation

MCP Client Implementation Example

Here are examples of how to implement this MCP server in Cursor:

  1. Configure the MCP server in Cursor's mcp.json:

  2. Enable and use the available tools in Cursor's settings:

License

This project is licensed under the ISC License.