How to integrate Retable MCP with Atomic Agent

Connect Atomic Agent to Retable MCP. List all tables in marketing workspace, create a new row in campaigns, and more using natural language, with authentication handled for you.

Get started for free Get a demo

Retable

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

Managed auth

Connect Retable without auth hassles

We manage OAuth, API keys, token refresh, and scopes — you just build.

Book a call

Explore the MCP Gateway

Introduction

Atomic Agent is an open-source AI agent that runs on your machine and supports local models through llama.cpp. Connect it to 1,500+ apps through Composio, including Retable.

This guide uses Atomic Agent's built-in Composio integration. You need Atomic Agent v0.5.6 or later, your own Composio API key, and a Retable account. See the Atomic Agent documentation for installation instructions.

Also integrate Retable with

ChatGPT Claude Cowork Hermes

How Atomic Agent connects to Retable

Atomic Agent connects to Composio's Tool Router over Streamable HTTP MCP. It discovers the tools needed for your request, and Composio handles account authentication.

Execution and account-connection tools follow Atomic Agent's configured approval policy. Review any approval prompt before allowing an action on your connected account.

Connect Retable to Atomic Agent

Sign up or sign in to the Composio dashboard. Copy your API key.
In Atomic Agent, open the Integrations tab and select Composio. Select API key, press e, paste the key, and press Enter. The tools become available immediately, without a restart.
Ask Atomic Agent to do something in Retable. It searches Composio for the right tool.
On first use, open the sign-in link returned in the chat. Connect your Retable account, then return to Atomic Agent to continue.

Headless setup

Add the following line to ~/.atomic-agent/.env, replacing YOUR_COMPOSIO_API_KEY with your key. Start Atomic Agent after saving the file.

bash

COMPOSIO_API_KEY=YOUR_COMPOSIO_API_KEY

What is the Retable MCP server, and what's possible with it?

The Retable MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Retable account. It provides structured and secure access to your workspaces, projects, tables, columns, and rows, so your agent can explore tables, find data, add records, update cells, and remove data on your behalf.

Workspace and project discovery: Have your agent list available workspaces, browse their projects, and find the tables used to organize your work.
Table structure review: Let the agent inspect a table's columns, data types, and views before working with its contents.
Row retrieval and search: Instruct your agent to read table rows or search for records that match a value in the primary column.
Record creation and updates: Direct your agent to add new rows or update cells across one or more existing rows.
Table data maintenance: Have your agent add columns or permanently remove unneeded columns and rows, including their associated cell data.

Use Retable from Atomic Agent

With your account connected, ask Atomic Agent to work with Retable in natural language. You can connect more apps through the same Composio integration as you need them.

Visit the Atomic Agent website or inspect the Atomic Agent source code.

Troubleshooting

Why is my API key rejected?

Copy the key directly from the Composio dashboard. Atomic Agent requires ASCII characters because it sends the key in an HTTP header. Remove any extra characters introduced when copying.

Why are Composio tools unavailable after saving a key?

Check that you use Atomic Agent v0.5.6 or later and that Composio is enabled in your configuration. A "composio": { "enabled": false } setting disables the integration while keeping the saved key on disk.

Does Composio have a free plan?

The Hobby plan includes 100,000 tool calls per month. Composio-managed OAuth apps have a lower included allowance. See Composio pricing for the current limits that apply to your connection.

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.

FRAMEWORKS

How to build Retable MCP Agent with another framework

ChatGPT

Use Retable MCP with ChatGPT

Claude Cowork

Use Retable MCP with Claude Cowork

Hermes

Use Retable MCP with Hermes

MORE TOOLKITS

Explore Other Toolkits

Toolkit marketplace

Google Sheets

Oauth2

Google Sheets is a cloud-based spreadsheet tool for real-time collaboration and data analysis. It lets teams work together from anywhere, updating information instantly.

Notion

Oauth2Api Key

Notion is a collaborative workspace for notes, docs, wikis, and tasks. It streamlines team knowledge, project tracking, and workflow customization in one place.

Airtable

Oauth2Api Key

Airtable combines the flexibility of spreadsheets with the power of a database for easy project and data management. Teams use Airtable to organize, track, and collaborate with custom views and automations.

Asana

Oauth2

Asana is a collaborative work management platform for teams to organize and track projects. It streamlines teamwork, boosts productivity, and keeps everyone aligned on goals.

FAQ

Frequently asked questions

With a standalone Retable MCP server, the agents and LLMs can only access a fixed set of Retable tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from Retable and many other apps based on the task at hand, all through a single MCP endpoint.

Yes, you can. Atomic Agent fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right Retable tools.

Yes, absolutely. You can configure which Retable scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do.

All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your Retable data and credentials are handled as safely as possible.

Start with Retable.It takes 30 seconds.

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

Start building