Seatable Mcp

Name: Seatable Mcp
Author: brianmoney

@brianmoney

About Seatable Mcp

A comprehensive Model Context Protocol (MCP) server for SeaTable that exposes end‑to‑end database capabilities (schema introspection, CRUD, querying, linking, select option management, and file attachment stubs) through 18+ rigorously defined tools. You can run it:

#mcp #seatable #database

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "seatable": {
      "command": "npx",
      "args": [
        "-y",
        "@aspereo/mcp-seatable"
      ],
      "env": {
        "SEATABLE_SERVER_URL": "https://your-seatable-server.com",
        "SEATABLE_API_TOKEN": "your-api-token",
        "SEATABLE_BASE_UUID": "your-base-uuid"
      }
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Seatable Mcp?

Seatable Mcp is a Model Context Protocol (MCP) server that provides end‑to‑end database capabilities for SeaTable, including schema introspection, CRUD operations, querying, linking, select option management, and file attachment stubs via 18+ rigorously defined tools. It can be deployed as a local CLI (stdio) server, a local HTTP SSE server, or a globally distributed Cloudflare Worker with dual transport support.

How to use Seatable Mcp?

Install and run with npx -y @aspereo/mcp-seatable, then configure environment variables (SEATABLE_SERVER_URL, SEATABLE_API_TOKEN, SEATABLE_BASE_UUID). Integrate with MCP clients (Claude Desktop, Cursor, VS Code) by adding the server configuration to their settings. For local SSE development, set PORT=3001 and use the --sse flag. For Cloudflare Workers, clone the repo, run npm install and npx wrangler deploy.

Key features of Seatable Mcp

Complete CRUD operations for rows and tables
Advanced querying with DSL and raw SQL support
Schema management (create, modify, delete tables/columns)
Safe SQL execution with parameterized queries
Real‑time health monitoring with connection status and latency
Mock mode for offline testing without a live SeaTable

Use cases of Seatable Mcp

Use with Claude Desktop for natural‑language database management
Integrate with Cursor or VS Code alongside GitHub Copilot
Run as a Cloudflare Worker for production, multi‑user web applications
Develop and test locally using the SSE server and MCP Inspector

FAQ from Seatable Mcp

What environment variables are required?

You must set SEATABLE_SERVER_URL, SEATABLE_API_TOKEN, and SEATABLE_BASE_UUID. Optionally, SEATABLE_TABLE_NAME for a default table and SEATABLE_MOCK=true for offline mock mode.

How do I run in mock mode?

Set SEATABLE_MOCK=true in your environment. The server will use in‑memory mock data, useful for testing and demos without a live SeaTable.

How do I deploy to Cloudflare Workers?

Clone the repository, run npm install, then deploy with npx wrangler deploy. The Worker supports both SSE (/sse) and Streamable HTTP (/mcp) transports with persistent sessions via Durable Objects.

Is authentication required for the Cloudflare Worker?

As of v1.0.3, all tools are exposed without authentication. Do not deploy to a public URL containing sensitive data until OAuth and scoped permissions (planned) are enabled. Mitigate risk by keeping the Worker URL private or restricting access via Cloudflare Access.

What transports does Seatable Mcp support?

It supports three transports: stdio (for traditional CLI MCP clients), SSE (for local or remote development), and both SSE and Streamable HTTP (for Cloudflare Worker deployments). The Worker also provides a health endpoint at /health.