Stackby MCP connector

Stackby is a collaborative database platform that combines spreadsheet interfaces with relational database features for managing structured data in stacks and tables. The Stackby MCP connector allows AI agents to list, create, and delete records across stacks, enabling automated data management and synchronization workflows. It also supports querying and modifying table data to maintain up-to-date information across collaborative workspaces.

Authentication type

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

Uses

Use the Stackby MCP connector to perform the following actions:

• Track customer inquiries and support tickets in a collaborative spreadsheet database
• Maintain project timelines by creating and updating task records across team members
• Consolidate sales leads from multiple sources into a single Stackby database
• Archive completed work orders and delete obsolete records to keep databases clean
• Monitor inventory levels by querying current stock records in real time
• Build audit trails by logging all changes to critical business data in Stackby
• Distribute survey responses automatically into organized Stackby stacks for analysis

Example prompts

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

• Show me all open support tickets from Stackby created in the last week.
• Add these three new customer contacts to our Stackby leads database.
• How many project tasks in Stackby are marked as overdue?
• Delete all archived invoices from 2022 in Stackby.
• Create a new record in Stackby for each applicant who passed our screening.
• List all products in Stackby with inventory below 10 units.
• Remove duplicate entries from our Stackby customer database.
• Pull all active contracts from Stackby that expire within 30 days.
• Add these survey responses as individual records to our Stackby feedback stack.

Stackby MCP connector tools

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

Tool	Description
listRecords	Retrieves all records from a specified table or view in Stackby.
createRecords	Adds new records to a Stackby table with the provided data.
deleteRecords	Removes specified records from a Stackby table.