Retable MCP for AI Agents

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Retable MCP or direct API to read tables, create and update rows, query records, and upload files through natural language.

Retable logoRetable
Api Key

Retable is a collaborative spreadsheet and database platform for organizing workspaces, tables, and files. Use it to manage projects, structure data, and collaborate with teammates in flexible tables.

11 Tools

Try Retable now

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

TOOL ROUTER PLAYGROUND
Retable
Try asking
TOOLS

Supported Tools

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

Add Columns

Append one or more typed columns to a table and return the complete resulting column list.

Delete Columns

Permanently delete one or more columns and their cell data, then return the complete remaining column list.

Delete Rows

Permanently delete one or more rows from a table; missing row IDs are ignored and count as zero deletions.

Get Rows

Return all rows or up to 50 selected rows using stable column IDs or title-keyed fields.

Get Table

Get one table's metadata, column IDs and types, and views before reading or changing its data.

Insert Rows

Insert one or more rows into a table in one request and return the created rows with their IDs.

List Project Tables

List tables in one Retable project with their IDs, columns, and parent workspace and project IDs.

List Workspace Projects

List projects accessible in one workspace, including project IDs needed to discover tables.

List Workspaces

List workspaces visible to the connected Retable account, including each workspace ID needed to discover projects.

Search Rows

Search a table for a value in a primary column and return matching rows from an optional starting offset.

Update Rows

Update cells in one or more existing rows in one request and return the updated row IDs.

SETUP GUIDE

Connect Retable 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 Retable
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: "List all tables in the 'Marketing' workspace and show the first 10 rows of the 'Campaigns' table."
  }],
  maxSteps: 5,
});

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

Connect Retable 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 Retable 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 all tables in the 'Marketing' workspace and show the first 10 rows of the 'Campaigns' table."
  }],
});
const result = await composio.provider.handleToolCalls(
  'your-user-id',
  response.output
);
console.log(result);
Get tools from Tool Router session and execute Retable actions with your Agent

Why Use Composio?

AI Native Retable Integration

  • Supports both Retable MCP and direct API based integrations
  • Structured, LLM-friendly schemas for reliable tool execution
  • Rich coverage for reading, writing, and querying your Retable data

Managed Auth

  • Built-in OAuth handling with automatic token refresh and rotation
  • Central place to manage, scope, and revoke Retable access
  • Per user and per environment credentials instead of hard-coded keys

Agent Optimized Design

  • Tools are tuned using real error and success rates to improve reliability over time
  • 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 Retable
  • Scoped, least privilege access to Retable resources
  • Full audit trail of agent actions to support review and compliance
FRAMEWORKS

Use Retable with any AI Agent Framework

Choose a Framework you want to connect Retable with

FAQ

Frequently asked questions

Yes, Retable 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 Retable.It takes 30 seconds.

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

Start building