SeaTable MCP for AI Agents

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 its complete table, column, view, and settings metadata 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/openai @ai-sdk/mcp
Install the Composio SDK for Python or TypeScript
2

Initialize Client and Create Tool Router Session

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

const composio = new Composio({ apiKey: 'your-api-key' });
const session = await composio.create('your-user-id');
console.log(`Tool Router session created: ${session.mcp.url}`);
Import and initialize the Composio client, then create a Tool Router session for SeaTable
3

Connect to AI Agent

typescript
import { openai } from '@ai-sdk/openai';
import { experimental_createMCPClient as createMCPClient } from '@ai-sdk/mcp';
import { generateText } from 'ai';

const client = await createMCPClient({
  transport: {
    type: 'http',
    url: session.mcp.url,
    headers: {
      'x-api-key': 'your-composio-api-key',
    },
  },
});

const tools = await client.tools();
const { text } = await generateText({
  model: openai('gpt-4o'),
  tools,
  messages: [{
    role: 'user',
    content: 'Add a row to the Tasks table in my SeaTable base with title "Prepare Q4 report", owner "Alex", and status "Open".'
  }],
  maxSteps: 5,
});

console.log(`Agent: ${text}`);
Use the MCP server with your AI agent (Anthropic Claude or Mastra)
SETUP GUIDE

Connect SeaTable API Tool with your Agent

1

Install Composio

typescript
npm install @composio/openai
Install the Composio SDK
2

Initialize Composio and Create Tool Router Session

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

const composio = new Composio({
  provider: new OpenAIResponsesProvider(),
});
const openai = new OpenAI({});
const session = await composio.create('your-user-id');
Import and initialize Composio client, then create a Tool Router session
3

Execute SeaTable Tools via Tool Router with Your Agent

typescript
const tools = session.tools;
const response = await openai.responses.create({
  model: 'gpt-4.1',
  tools: tools,
  input: [{
    role: 'user',
    content: 'List all rows from the Tasks table in my SeaTable base and summarize overdue items.'
  }],
});
const result = await composio.provider.handleToolCalls(
  'your-user-id',
  response.output
);
console.log(result);
Get tools from Tool Router session and execute SeaTable actions with your Agent

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

Yes, SeaTable requires you to configure your own API key. Once set up, Composio handles secure credential storage and API request handling for you.

Yes! Composio's Tool Router enables agents to use multiple toolkits. Learn more.

Composio is SOC 2 and ISO 27001 compliant with all data encrypted in transit and at rest. Learn more.

Composio maintains and updates all toolkit integrations automatically, so your agents always work with the latest API versions.

Start with SeaTable.It takes 30 seconds.

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

Start building