SIGN UPLOG IN
X (Twitter)LinkedInGitHubDiscordYouTube

Stackby MCP server for AI agents and assistants

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/mcp @ai-sdk/openai
Install the Composio SDK and your agent framework
2

Create a session with MCP enabled

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

const composio = new Composio();
const { mcp } = await composio.create("your-user-id", {
  toolkits: ["stackby"],
  mcp: true,
});
Create a session scoped to Stackby and read its MCP URL and headers
3

Connect your agent to the MCP server

typescript
import { createMCPClient } from "@ai-sdk/mcp";
import { openai } from "@ai-sdk/openai";
import { generateText, stepCountIs } from "ai";

const client = await createMCPClient({
  transport: { type: "http", url: mcp.url, headers: mcp.headers },
});

const { text } = await generateText({
  model: openai("gpt-5.6-sol"),
  tools: await client.tools(),
  prompt: "List the first 10 records from my Stackby Sales CRM table",
  stopWhen: stepCountIs(10),
});

console.log(text);
await client.close();
Pass the session's MCP URL and headers to your agent and run a Stackby request
SETUP GUIDE

Connect Stackby API Tool with your Agent

1

Install Composio

typescript
npm install @composio/core @composio/openai openai
Install the Composio SDK, the OpenAI provider, and the OpenAI SDK
2

Create a Composio session

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

const composio = new Composio({ provider: new OpenAIResponsesProvider() });
const client = new OpenAI();

const session = await composio.create("your-user-id", { toolkits: ["stackby"] });
const tools = await session.tools();
Initialize Composio with the OpenAI Responses provider and create a session scoped to Stackby
3

Run Stackby tools with your agent

typescript
let response = await client.responses.create({
  model: "gpt-5.6-sol",
  tools,
  input: [{ role: "user", content: "List the first 10 records from my Stackby Sales CRM table" }],
});

while (response.output.some((o) => o.type === "function_call")) {
  const outputs = await composio.provider.handleToolCalls(session, response.output);
  response = await client.responses.create({
    model: "gpt-5.6-sol",
    tools,
    previous_response_id: response.id,
    input: outputs,
  });
}

console.log(response.output_text);
Send a request, execute the Stackby tool calls through the session, and print the final answer

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.

Yes. Composio is SOC 2 Type II compliant and is built to keep your Stackby connection and credentials secure. OAuth tokens and API keys are encrypted, and sensitive customer data is protected at rest and in transit.

Composio also undergoes independent security testing and continuously monitors its systems for security threats. You can review the latest reports and policies in the Composio Trust Center.

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

Create the key in your Stackby account settings, then paste it once on Composio's connection page. Composio stores it encrypted and uses it only for the Stackby actions your agent runs. Nobody else in your workspace can read it, and you can revoke it inside Stackby at any time.

When you connect a Stackby account through Composio, every action runs under that account, so anything the agent creates, sends, or changes shows up in Stackby as done by you. Keep an approval step in your prompt for actions with side effects, such as sending or deleting, and have the agent draft first.

Whatever the credentials you connect allow inside Stackby. If Stackby lets you scope a key to specific permissions, create a scoped one so the agent can only do what you intend. You can revoke the key inside Stackby at any time.

Yes. Composio supports multiple connected accounts for the same app, and that works in Claude, ChatGPT, or any other assistant you connect through Composio. Give each Stackby connection a name such as work or personal, and the assistant uses the one you mention in the request. Each account keeps its own credentials and nothing is merged.

The connection stops working the moment Stackby rejects the old key. Create a new key in Stackby and reconnect the account from the Composio dashboard or by asking your agent to reconnect Stackby. Nothing else changes.

Composio's free Hobby plan includes 100,000 tool calls per month with no credit card, which covers most personal Stackby use. Paid plans add higher limits and team features. Your Stackby plan and its API limits still apply as usual.

Built-in connectors usually give one AI access to a limited set of apps. Many people use Composio because it lets their AI connect to more apps than it normally supports, or connect to multiple accounts for the same app (e.g. connect Claude to multiple Stackby accounts).

With Composio, you connect Stackby once and then use it across different AI assistants without setting it up separately in each one. Connect your apps to Composio once, then connect Composio to whichever AI you use, whether that's Claude, ChatGPT, Hermes, or your own custom assistant.

Start with Stackby.It takes 30 seconds.

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

Start building