README - GRID MCP Server by grid-is

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

Clone this repo:

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

Once that's complete, move into the new directory:
```
cd claude-mcp
```
Next, set the project up using npm:
```
npm install
```
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
```

Add your server in the mcpServers key:

{
  "mcpServers": {
    "grid": {
      "command": "node",
      "args": ["/ABSOLUTE/PATH/TO/claude-mcp/dist/index.js"],
      "env": {
        "GRID_API_TOKEN": "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.

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:

Install dependencies:
```
npm install
```
Build the server:
```
npm run build
```
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.