SeaTable

SeaTable MCP Connector for Claude

A+

Build collaborative databases with spreadsheet simplicity and relational power for project management, CRM, and asset tracking.

11 tools Official Updated Jun 28, 2026 Official Vinkius Partner

Connect your SeaTable account to any AI agent and take full control of your database orchestration and collaborative workflows through natural conversation. SeaTable combines the power of a professional database with the ease of use of a spreadsheet, and this integration allows you to retrieve row metadata, append new records, and perform complex SQL queries directly from your chat interface.

What you can do

  • Database & Row Orchestration — List, create, and update rows programmatically to keep your collaborative data always synchronized.
  • SQL Query Intelligence — Perform advanced data filtering and aggregation using standard SQL syntax directly from the AI interface.
  • Table & Metadata Control — Access base metadata and list tables to maintain a clear overview of your digital workspace via natural language.
  • Automation & Token Oversight — The integration automatically handles the complex exchange of permanent API tokens for short-lived access tokens to ensure secure data operations.
  • Operational Monitoring — Track system activity and manage database records using simple AI commands to streamline your business workflows.

How it works

  1. Subscribe to this server
  2. Enter your SeaTable API Token and Server URL (optional) from your base settings
  3. Start managing your collaborative databases from Claude, Cursor, or any MCP-compatible client

No more manual copy-pasting or complex filter building. Your AI acts as a dedicated database administrator or operations coordinator.

Who is this for?

  • Project Managers — quickly retrieve task statuses and update project timelines without switching browser tabs.
  • Operations Teams — automate the ingestion of new data records and perform aggregate queries via natural conversation.
  • Data Engineers — streamline the retrieval of base metadata and monitor database structures directly within the chat.
seatabledatabase-apicollaborative-datasql-queryspreadsheet-databaseno-code-automationdata-orchestrationmcp

11 tools expose this connector's capabilities to your AI agent.

create_row

Pass row data as a JSON string. Add a new row to a table

create_table

Create a new table

delete_row

Delete a row from a table

get_base_metadata

Get metadata for the current base

get_row

Get a specific row from a table

list_columns

List all columns in a table

list_rows

List all rows in a table

list_tables

List all tables and columns

list_views

List all views for a table

query_sql

Query data using SQL

update_row

Update an existing row

See how to talk to your AI agent using SeaTable.

List all rows from the 'Inventory' table in SeaTable.

I've retrieved the records. You have 15 items in the 'Inventory' table, including 'Laptop Pro' (Stock: 5) and 'Office Chair' (Stock: 12). Would you like me to filter for low stock?

Show me all tables in the project database and pull the data from the Tasks table with filters.

Project database has 6 tables. "Tasks" (234 rows): 45 open, 123 in progress, 66 completed. "Team Members" (18 rows). "Milestones" (12 rows, 3 overdue). "Budget" (45 rows, total $234K). "Documents" (89 attachments). "Time Logs" (456 entries, 1,234 hours). Tasks filtered by status=open: 45 tasks. Top priority: "API redesign" (due tomorrow, assigned to Sarah). 8 tasks are blocked. Average completion time: 4.2 days. Overdue: 12 tasks.

Create a new table called Sprint Backlog with columns for story points, assignee, and sprint number.

Table "Sprint Backlog" created successfully. Columns configured: "Task Name" (text, primary), "Description" (long text), "Story Points" (number, range 1-13), "Assignee" (collaborator), "Sprint Number" (single select: Sprint 1-10), "Status" (single select: To Do, In Progress, Review, Done), "Priority" (single select: Critical, High, Medium, Low), "Created Date" (date, auto-fill). Default view: grouped by Sprint Number. 3 additional views created: Kanban by Status, Calendar view, and My Tasks filter.

Yes! Use the `query_sql` tool. Provide a standard SQL string (e.g., 'SELECT * FROM Tasks WHERE Status = "Done"'), and your agent will return the aggregate or filtered results instantly.

Related Connectors