GRID MCP Server

A Model Context Protocol server for using GRID API directly from Claude for Desktop.

How to use the server

[!IMPORTANT] To run this server, there are some prerequisites:

• Install Claude for Desktop, Node.js, and Git
• Sign up for GRID, upload a spreadsheet, and save a copy of your API key

1. Clone this repo:

   git clone https://github.com/GRID-is/claude-mcp.git
   

2. Once that's complete, move into the new directory:

   cd claude-mcp
   

3. Next, set the project up using npm:

   npm install
   

4. Now we need to configure Claude for Desktop to use this MCP server.

   To do this, open Claude's app configuration file (or create if it doesn't exist).

   On MacOS:

   ~/Library/Application\ Support/Claude/claude_desktop_config.json
   

   On Windows:

   %APPDATA%\Claude\claude_desktop_config.json
   

5. Add your server in the mcpServers key:

   {
     "mcpServers": {
       "grid": {
         "command": "node",
         "args": ["/ABSOLUTE/PATH/TO/claude-mcp/dist/index.js"],
         "env": {
           "GRID_API_KEY": "YOUR_API_KEY"
         }
       }
     }
   }
   

   Make sure to change /ABSOLUTE/PATH/TO/claude-mcp to the real location of the repo directory, and YOUR_API_KEY to your GRID API key.

6. Quit Claude for Desktop and reopen it. Now you can ask Claude questions about your spreadsheet:

   Using the workbook with id xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, give me the sum of cells A1:C10

Development

If you want to hack on the server code locally:

1. Install dependencies:

   npm install
   

2. Build the server:

   npm run build
   

3. For development with auto-rebuild:

   npm run watch
   

Debugging

Since MCP servers communicate over stdio, debugging can be a challenge. It's recommended to use the MCP Inspector, available as a package script:

npm run inspector

MCP Inspector will provide a URL to access debugging tools in your browser.