SeaTable MCP connector

SeaTable is an online collaboration platform that combines a spreadsheet-like interface with database features for team data management. The SeaTable MCP connector allows AI agents to manage table data by creating, reading, updating, and deleting rows, and to modify table structures by adding or removing columns. It also supports retrieving individual records, obtaining upload links for file attachments, and querying table schemas to understand data organization.

Authentication type

• API Key - Requires a static API key to be configured before the agent can connect to the service.

Uses

Use the SeaTable MCP connector to perform the following actions:

• Track project tasks and deadlines across distributed teams in real-time collaboration
• Maintain customer contact information and interaction history in a centralized database
• Monitor inventory levels and automatically flag items below reorder thresholds
• Document sales pipeline stages and forecast revenue by quarter or region
• Capture survey responses and feedback to identify trends and improvement areas
• Organize event attendees, registrations, and follow-up communications efficiently
• Log time entries and resource allocation for accurate project billing and reporting

Example prompts

Use the following example prompts to invoke SeaTable MCP connector tools from your AI assistant or Boomi Connect workflow:

• Show me all tasks assigned to Sarah in SeaTable that are due this week.
• Add these five new customers to our SeaTable contact database with their email addresses.
• Create a new column in SeaTable to track product return reasons.
• List all invoices in SeaTable marked as unpaid and sort them by date.
• Update the status of project three in SeaTable from in progress to completed.
• Delete the duplicate customer record from SeaTable that I accidentally created.
• Get me the full details for the customer record with ID 4521 in SeaTable.
• Generate an upload link in SeaTable so the vendor can send us their quarterly report.
• How many open opportunities do we have in SeaTable for the enterprise segment?
• Remove the obsolete budget category column from our SeaTable financial tracker.

SeaTable MCP connector tools

The SeaTable MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.

Tool	Description
listRows	Retrieves all rows from a table or a filtered subset based on criteria.
createRow	Adds one or more new rows to a table with specified data.
updateRow	Modifies the data in an existing row within a table.
deleteRow	Removes a row from a table permanently.
getRow	Retrieves the complete data for a single specific row.
listColumns	Shows all columns in a table with their properties and types.
createColumn	Adds a new column to a table with a defined data type.
deleteColumn	Removes a column and its data from a table permanently.
getUploadLink	Generates a temporary link for uploading files to a table.