SeaTable MCP server for AI agents and assistants

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with SeaTable MCP or direct API to manage bases, query rows, update tables, and handle files through natural language.

SeaTable logoSeaTable
Api Key

SeaTable is a collaborative no-code database and spreadsheet platform. Use it to manage structured bases, tables, rows, views, and files with your team.

8 Tools

Try SeaTable now

Type what you want done — sign in and watch it run live in the Tool Router playground.

TOOL ROUTER PLAYGROUND
SeaTable
Try asking
TOOLS

Supported Tools

Every SeaTable action and event your agent gets out of the box.

Append Rows

Append one or more rows to a table in the connected SeaTable base using exact human-readable column names.

Delete Rows

Permanently delete one or more rows by row ID from a named table in the connected SeaTable base.

Get Base Schema

Return the connected base identity and table metadata, including columns and views, without returning authentication tokens.

Get Download Link

Generate a short-lived download URL for an existing file or image attachment in the connected SeaTable base.

Get Row

Get one row by its SeaTable _id from a named table in the connected base.

List Rows

List one page of rows from a table or view in the connected SeaTable base, returning human-readable column names by default.

Query Rows with SQL

Run one strictly read-only SELECT query against the connected SeaTable base for filtering, sorting, grouping, aggregation, or implicit linked-record traversal.

Update Rows

Update one or more existing SeaTable rows by row ID.

SETUP GUIDE

Connect SeaTable MCP Tool with your Agent

1

Install Composio

typescript
npm install @composio/core ai @ai-sdk/mcp @ai-sdk/openai
Install the Composio SDK and your agent framework
2

Create a session with MCP enabled

typescript
import { Composio } from "@composio/core";

const composio = new Composio();
const { mcp } = await composio.create("your-user-id", {
  toolkits: ["seatable"],
  mcp: true,
});
Create a session scoped to SeaTable and read its MCP URL and headers
3

Connect your agent to the MCP server

typescript
import { createMCPClient } from "@ai-sdk/mcp";
import { openai } from "@ai-sdk/openai";
import { generateText, stepCountIs } from "ai";

const client = await createMCPClient({
  transport: { type: "http", url: mcp.url, headers: mcp.headers },
});

const { text } = await generateText({
  model: openai("gpt-5.6-sol"),
  tools: await client.tools(),
  prompt: "List all rows from the Tasks table in my SeaTable base and summarize overdue items.",
  stopWhen: stepCountIs(10),
});

console.log(text);
await client.close();
Pass the session's MCP URL and headers to your agent and run a SeaTable request
SETUP GUIDE

Connect SeaTable API Tool with your Agent

1

Install Composio

typescript
npm install @composio/core @composio/openai openai
Install the Composio SDK, the OpenAI provider, and the OpenAI SDK
2

Create a Composio session

typescript
import OpenAI from "openai";
import { Composio } from "@composio/core";
import { OpenAIResponsesProvider } from "@composio/openai";

const composio = new Composio({ provider: new OpenAIResponsesProvider() });
const client = new OpenAI();

const session = await composio.create("your-user-id", { toolkits: ["seatable"] });
const tools = await session.tools();
Initialize Composio with the OpenAI Responses provider and create a session scoped to SeaTable
3

Run SeaTable tools with your agent

typescript
let response = await client.responses.create({
  model: "gpt-5.6-sol",
  tools,
  input: [{ role: "user", content: "List all rows from the Tasks table in my SeaTable base and summarize overdue items." }],
});

while (response.output.some((o) => o.type === "function_call")) {
  const outputs = await composio.provider.handleToolCalls(session, response.output);
  response = await client.responses.create({
    model: "gpt-5.6-sol",
    tools,
    previous_response_id: response.id,
    input: outputs,
  });
}

console.log(response.output_text);
Send a request, execute the SeaTable tool calls through the session, and print the final answer

Why Use Composio?

AI Native SeaTable Integration

  • Supports both SeaTable MCP and direct API based integrations
  • Structured, LLM-friendly schemas for reliable tool execution
  • Rich coverage for reading, writing, and querying SeaTable bases, tables, rows, views, and files

Managed Auth

  • Store SeaTable API keys securely instead of hard-coding them in your agent code
  • Central place to manage, scope, and revoke SeaTable access
  • Per user and per environment credentials, so your agents use the right SeaTable access every time

Agent Optimized Design

  • SeaTable tools are designed so agents can understand table, row, view, and file operations clearly
  • Tools are tuned using real error and success rates to improve reliability over time
  • Comprehensive execution logs so you always know what ran, when, and on whose behalf

Enterprise Grade Security

  • Fine-grained RBAC so you control which agents and users can access SeaTable
  • Scoped, least privilege access to SeaTable bases and related resources
  • Full audit trail of agent actions to support review and compliance
FAQ

Frequently asked questions

Start with SeaTable.It takes 30 seconds.

Managed auth, hosted MCP servers, and every SeaTable tool your agent needs.Free to start.

Start building