Flatfile MCP for AI Agents

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.

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 Flatfile.It takes 30 seconds.

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

Start building