Flatfile MCP server for AI agents and assistants

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Flatfile MCP or direct API to validate imported records, transform files, manage spaces, and review jobs through natural language.

Flatfile logoFlatfile
Api Key

Flatfile is a data exchange platform for collecting, validating, and transforming structured data. Use it to run cleaner imports and collaborative data onboarding workflows.

12 Tools

Try Flatfile now

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

TOOL ROUTER PLAYGROUND
Flatfile
Try asking
TOOLS

Supported Tools

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

Delete Records

Permanently delete one to 100 explicitly identified records from one Flatfile sheet.

Get Job

Get detailed status, outcome, result, and diagnostic information for one Flatfile asynchronous job.

Get Sheet

Get one sheet's field configuration and record counts before reading or writing records.

Get Space

Get safe metadata for one Flatfile space without exposing transient access credentials or token-bearing guest links.

Insert Records

Insert one or more rows into a Flatfile sheet using simple field-key to value objects.

List Environments

List Flatfile environments visible to the connected environment secret key and return the IDs needed to find spaces.

List Files

Discover import or export files and their processing status, optionally within a Flatfile space.

List Jobs

Find asynchronous Flatfile jobs by environment, space, workbook, file, or parent job and inspect progress at a glance.

List Records

Read one page of records from a Flatfile sheet, optionally filtering by validity, field, record ID, search value, or FFQL expression.

List Spaces

Find Flatfile spaces by environment, text, namespace, archive state, or template status.

List Workbooks

List workbooks, optionally within a space, with their nested sheets so an agent can continue to sheet and record tasks.

Update Records

Update one or more existing Flatfile records by ID using simple field-key to value objects.

SETUP GUIDE

Connect Flatfile 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: ["flatfile"],
  mcp: true,
});
Create a session scoped to Flatfile 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 recent Flatfile spaces and summarize failed record validations",
  stopWhen: stepCountIs(10),
});

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

Connect Flatfile 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: ["flatfile"] });
const tools = await session.tools();
Initialize Composio with the OpenAI Responses provider and create a session scoped to Flatfile
3

Run Flatfile tools with your agent

typescript
let response = await client.responses.create({
  model: "gpt-5.6-sol",
  tools,
  input: [{ role: "user", content: "List recent Flatfile spaces and summarize failed record validations" }],
});

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 Flatfile tool calls through the session, and print the final answer

Why Use Composio?

AI Native Flatfile Integration

  • Supports both Flatfile MCP and direct API based integrations
  • Structured, LLM-friendly schemas for reliable Flatfile tool execution
  • Rich coverage for spaces, workbooks, sheets, records, jobs, and collaborative data workflows

Secure API Key Auth

  • Flatfile uses API key auth, and Composio keeps those credentials out of your agent code
  • Use auth_configs.create() and connected_accounts.link() when you want lower-level control over Flatfile credential setup
  • Per user and per environment credentials instead of hard-coded keys in prompts, scripts, or repos

Agent Optimized Design

  • Tools are shaped so agents can understand Flatfile concepts like spaces, workbooks, sheets, records, and jobs
  • Comprehensive execution logs so you can see which Flatfile action ran, when it ran, and on whose behalf
  • Use mcp.create() for custom MCP flows when you need more control around agent access

Enterprise Grade Security

  • Fine-grained RBAC so you control which agents and users can access Flatfile workflows
  • Scoped, least privilege access to Flatfile resources and data exchange operations
  • Full audit trail of agent actions to support review, compliance, and debugging
FAQ

Frequently asked questions

Yes, Flatfile 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 Flatfile 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 Flatfile account settings, then paste it once on Composio's connection page. Composio stores it encrypted and uses it only for the Flatfile actions your agent runs. Nobody else in your workspace can read it, and you can revoke it inside Flatfile at any time.

When you connect a Flatfile account through Composio, every action runs under that account, so anything the agent creates, sends, or changes shows up in Flatfile 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 Flatfile. If Flatfile 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 Flatfile 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 Flatfile 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 Flatfile rejects the old key. Create a new key in Flatfile and reconnect the account from the Composio dashboard or by asking your agent to reconnect Flatfile. Nothing else changes.

Composio's free Hobby plan includes 100,000 tool calls per month with no credit card, which covers most personal Flatfile use. Paid plans add higher limits and team features. Your Flatfile 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 Flatfile accounts).

With Composio, you connect Flatfile 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 Flatfile.It takes 30 seconds.

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

Start building