# SeaTable MCP server

> Lets AI agents interact with SeaTable bases by reading, writing, searching, linking, and querying rows.

- Repository: https://github.com/seatable/seatable-mcp
- Page: https://hostedmcp.org/servers/seatable/seatable-mcp
- Transport: stdio
- Stars: 10
- Latest version: 1.9.6

## Install

### Claude Code

```sh
claude mcp add seatable-mcp -- npx -y @seatable/mcp-seatable
```

### Cursor (`~/.cursor/mcp.json`)

```json
{
  "mcpServers": {
    "seatable-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@seatable/mcp-seatable"
      ]
    }
  }
}
```

### VS Code (`.vscode/mcp.json`)

```json
{
  "servers": {
    "seatable-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@seatable/mcp-seatable"
      ]
    }
  }
}
```

### VS Code CLI

```sh
code --add-mcp '{"name":"seatable-mcp","type":"stdio","command":"npx","args":["-y","@seatable/mcp-seatable"]}'
```

### Claude Desktop (`claude_desktop_config.json`)

```json
{
  "mcpServers": {
    "seatable-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@seatable/mcp-seatable"
      ]
    }
  }
}
```

### Codex

```sh
codex mcp add seatable-mcp -- npx -y @seatable/mcp-seatable
```

### Codex config.toml (`~/.codex/config.toml`)

```toml
[mcp_servers.seatable-mcp]
command = "npx"
args = ["-y", "@seatable/mcp-seatable"]
```

### Gemini CLI

```sh
gemini mcp add -s user seatable-mcp npx -- -y @seatable/mcp-seatable
```

### Gemini settings.json (`~/.gemini/settings.json`)

```json
{
  "mcpServers": {
    "seatable-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@seatable/mcp-seatable"
      ]
    }
  }
}
```

## Environment variables

| Name | Required | Secret | Description |
|---|---|---|---|
| `SEATABLE_API_TOKEN` | no | no | API token for a single SeaTable base |
| `SEATABLE_BASES` | no | no |  |
| `SEATABLE_MOCK` | no | no |  |
| `SEATABLE_MODE` | no | no |  |
| `SEATABLE_SERVER_URL` | no | no | URL of your SeaTable server (e.g. https://cloud.seatable.io) |
| `SEATABLE_TOKEN_SECRET` | no | no |  |

## Tools (23)

- `list_tables`
- `get_schema`
- `list_bases`
- `list_collaborators`
- `list_rows`
- `get_row`
- `find_rows`
- `search_rows`
- `query_sql`
- `add_row`
- `append_rows`
- `update_rows`
- `upsert_rows`
- `delete_rows`
- `execute_sql`
- `upload_file`
- `download_file`
- `link_rows`
- `unlink_rows`
- `get_row_activities`
- `create_snapshot`
- `add_select_options`
- `ping_seatable`

## FAQ

### Can the MCP server manage my SeaTable schema?

No, the server is intentionally focused on data operations like reading and writing rows rather than schema management such as creating or deleting tables.

### How do I use SeaTable MCP with Claude Desktop?

You can configure Claude Desktop by adding the SeaTable server to your `claude_desktop_config.json` using either the hosted HTTP endpoint or a local `npx` command for self-hosted instances.

### Is there a hosted version of the SeaTable MCP server?

Yes, if you use SeaTable Cloud, you can use the hosted MCP server at `mcp.seatable.com` without needing to install anything.

### Does the server handle rate limiting?

Yes, the server automatically retries with exponential backoff when SeaTable returns a 429 error, and in managed mode, it applies its own limits to protect the server process.
