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/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 Flatfile
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: 'Find validation errors in the latest Flatfile workbook'
  }],
  maxSteps: 5,
});

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

Connect Flatfile 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 Flatfile 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 recent Flatfile spaces and summarize failed record validations'
  }],
});
const result = await composio.provider.handleToolCalls(
  'your-user-id',
  response.output
);
console.log(result);
Get tools from Tool Router session and execute Flatfile actions with your Agent

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