X (Twitter)LinkedInGitHubDiscordYouTube

Stackby MCP for AI Agents

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Stackby MCP or direct API to list rows, create records, update tables, and query workflow data through natural language.

Get started for freeGet a demo
Stackby logoStackby
Api Key

Stackby is a no-code workspace that blends spreadsheets, databases, and automation. Teams use it to track projects, manage operations, and keep workflow data in sync.

9 Tools

Try Stackby now

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

TOOL ROUTER PLAYGROUND
Stackby
Try asking
TOOLS

Supported Tools

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

Create Rows

Create 1 to 10 rows in a Stackby table in one request.

Delete Rows

Delete 1 to 10 identified rows from a Stackby table.

List Columns

List columns and their types for a Stackby table so row field names can be chosen correctly.

List Rows

List one page of rows from a Stackby table, or retrieve specific rows by ID, with optional filtering, view selection, and single-field sorting.

List Stacks

List accessible Stackby stacks in a known workspace and return IDs needed for table discovery.

List Tables

List tables in a Stackby stack and return their IDs and names.

List Views

Return view IDs and names for a Stackby table for use in view-scoped row queries.

List Workspaces

List accessible Stackby workspaces and return the workspace IDs needed to discover stacks.

Update Rows

Partially update 1 to 10 existing Stackby rows in one request.

SETUP GUIDE

Connect Stackby 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 Stackby
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 new lead named Jane Doe to my Stackby Sales CRM table with email jane@example.com'
  }],
  maxSteps: 5,
});

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

Connect Stackby 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 Stackby 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 the first 10 records from my Stackby Sales CRM table'
  }],
});
const result = await composio.provider.handleToolCalls(
  'your-user-id',
  response.output
);
console.log(result);
Get tools from Tool Router session and execute Stackby actions with your Agent

Why Use Composio?

AI Native Stackby Integration

  • Supports both Stackby MCP and direct API based integrations
  • Structured, LLM-friendly schemas for reliable Stackby table and row actions
  • Rich coverage for reading, writing, and querying your Stackby workflow data

Managed Auth

  • Bring your Stackby API key once, then let Composio store and use it securely
  • Central place to manage, scope, and revoke Stackby access for each user
  • Per user and per environment credentials instead of hard-coded API keys

Agent Optimized Design

  • Tools are tuned for AI agents, so Stackby row, table, and query actions are easier to call correctly
  • Clear schemas help agents avoid messy inputs when updating business data
  • 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 Stackby
  • Scoped, least privilege access to Stackby resources
  • Full audit trail of agent actions to support review and compliance
FAQ

Frequently asked questions

Yes, Stackby requires you to configure your own API key credentials. 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 Stackby.It takes 30 seconds.

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

Start building