Flatfile

Flatfile

Official
flatfilers

Connects to Flatfile's data migration platform to manage data import/export workflows, spreadsheet processing, and user management directly from your conversation.

Provides direct access to Flatfile's data migration platform for managing spaces, workbooks, sheets, jobs, users, and data operations without leaving your conversation context.

318 viewsLocal (stdio)

What it does

  • Create and manage Flatfile workbooks and sheets
  • Process data migration jobs
  • Manage user access and permissions
  • Execute data transformations and validations
  • Monitor import/export job status
  • Configure data mapping rules

Best for

Data engineers building ETL pipelinesProduct teams handling customer data importsOperations teams managing bulk data migrations
Direct API access without UI switchingFull workflow management capabilities

About Flatfile

Flatfile is an official MCP server published by flatfilers that provides AI assistants with tools and capabilities via the Model Context Protocol. Flatfile is a data server manager enabling seamless project and data base management system tasks, all within your conve It is categorized under analytics data.

How to install

You can install Flatfile in your AI client of choice. Use the install panel on this page to get one-click setup for Cursor, Claude Desktop, VS Code, and other MCP-compatible clients. This server runs locally on your machine via the stdio transport.

License

Flatfile is released under the MIT license. This is a permissive open-source license, meaning you can freely use, modify, and distribute the software.

Flatfile MCP Server

The Flatfile MCP Server enables AI assistants such as Claude Desktop, Claude Code, Cursor, and other to interact directly with your Flatfile data. This MCP Server creates a seamless bridge between AI assistants and Flatfile.

✨ Features

  • Supports 100+ Flatfile API endpoints
  • View and manage Sheets, Workbooks, Spaces, and more
  • Add, edit, and delete Records
  • Ask questions about your data
  • Generate Sheets from natural language
  • Create new Workbooks from scratch
  • And more!

🛠️ Setup

You will need either a Flatfile Personal Access Token or a Flatfile API Key.

API Key

Access your API Key by following these instructions.

Personal Access Token

Create a Flatfile Personal Access Token by following these instructions.

Filtering Tools

Flatfile provides over 100 API endpoints, with a tool to interact with each of them. It is strongly recommended to filter the tools to only include the ones you need. This can be done by passing the --enabled-tools flag to the MCP Server along with a comma-separated list of the tools you want to enable. If the --enabled-tools flag is not passed, all tools will be enabled.

Example:

{
  "mcpServers": {
      // ...
      "mcp-server-flatfile": {
         "command": "npx",
         "args": ["-y", "@flatfile/mcp-server", "--enabled-tools", "getRecords,updateRecords"],
         // ...
      }
      // ...
  }
}

Usage with Claude Desktop

Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "mcp-server-flatfile": {
      "command": "npx",
      "args": ["-y", "@flatfile/mcp-server", "--enabled-tools", "..."], // Replace with the tools you want to enable
      "env": {
        "FLATFILE_BEARER_TOKEN": "pat_your_token_here",
        "FLATFILE_API_URL": "https://platform.flatfile.com/api/v1" // Optional, for non-US regions or self-hosting
      }
    }
  }
}

Usage with Claude Code

Add the following to your .claude/code/config.json:

claude mcp add mcp-server-flatfile -e FLATFILE_API_URL=https://platform.flatfile.com/api/v1 -e FLATFILE_BEARER_TOKEN=pat_your_token_here -- npx -y @flatfile/mcp-server --enabled-tools ... // Replace with the tools you want to enable

Claude Code instructions on how to add a MCP Server.

Usage with Cursor

Add the following to your .cursor/mcp.json:

{
  "mcpServers": {
    "mcp-server-flatfile": {
      "command": "npx",
      "args": ["-y", "@flatfile/mcp-server", "--enabled-tools", "..."], // Replace with the tools you want to enable
      "env": {
        "FLATFILE_BEARER_TOKEN": "pat_your_token_here",
        "FLATFILE_API_URL": "https://platform.flatfile.com/api/v1" // Optional, for non-US regions or self-hosting
      }
    }
  }
}

🔧 Available Tools

  • ackEvent - Acknowledge an event: Acknowledge an event
  • ackJob - Acknowledge a job: Acknowledge a job and return the job
  • ackOutcomeJob - Acknowledge a job outcome: Acknowledge a job outcome and return the job
  • archiveSpace - Archives a space: Sets archivedAt timestamp on a space
  • assignAgentRole - Assign Role to Agent: Assigns a role to a agent.
  • assignGuestRole - Assign Role to Guest: Assigns a role to a guest.
  • assignUserRole - Assign Role to User: Assigns a role to a user.
  • bulkCreateActions - Create several actions: Create several actions
  • bulkDeleteSpace - Delete spaces: Delete multiple spaces by id
  • cancelJob - Cancel a job: Cancel a job and return the job
  • completeJob - Complete a job: Complete a job and return the job
  • createAction - Create an action: Create an action
  • createAgent - Create an agent: Create an agent
  • createAndInviteUser - Create and Invite User: Creates and invites a new user to your account.
  • createApp - Create an app: Creates an app
  • createAssistant - Create a prompt: Creates a prompt
  • createCanvasArea - Create a canvas area: Creates a new canvas area
  • createConstraintApp - Create constraint: Creates a new constraint for an app
  • createDataRetentionPolicy - Create a data retention policy: Add a new data retention policy to the space
  • createDocument - Create a document: Add a new document to the space
  • createDraftSpace - Create a draft of a space: Creates a draft of a space
  • createEnvironment - Create an environment: Create a new environment
  • createEvent - Create an event: Create an event
  • createGuidanceSpace - Create a new guidance: Creates a new guidance
  • createGuideEnvironment - Create a guide: Creates a guide
  • createIdVersion - createId: createId
  • createJob - Create a job: Create a job
  • createMappingProgram - Create a mapping between two schemas: Creates a list of mapping rules based on two provided schemas
  • createRoutine - Create a routine: Creates a new routine
  • createRulesMapping - Add mapping rules to a program: Add mapping rules to a program
  • createRunbook - Create a runbook: Creates a new runbook
  • createSnapshot - Create a snapshot: Creates a snapshot of a sheet
  • createSpace - Create a space: Creates a new space based on an existing Space Config
  • createView - Create a view: Add a new view to the space
  • createWorkbook - Create a workbook: Creates a workbook and adds it to a space
  • deleteAction - Delete an action: Delete an action
  • deleteAgent - Delete an agent: Deletes a single agent
  • deleteAgentExport - Delete an agent export: Delete an agent export
  • deleteAgentRole - Remove Role from Agent: Removes a role from an agent.
  • deleteAllHistoryForUserMapping - Delete all history for the authenticated user: Deletes all history for the authenticated user
  • deleteApp - Delete an app: Deletes an app
  • deleteAssistant - Delete a prompts: Deletes a prompts
  • deleteCanvasArea - Delete a canvas area: Deletes a specific canvas area
  • deleteConstraintApp - Delete constraint: Deletes a specific constraint
  • deleteDataRetentionPolicy - Delete a data retention policy: Deletes a single data retention policy
  • deleteDocument - Delete a document: Deletes a single document
  • deleteEnvironment - Delete an environment: Deletes a single environment
  • deleteFile - Delete a file: Delete a file
  • deleteGuest - Delete a guest: Deletes a single guest
  • deleteGuestRole - Remove Role from Guest: Removes a role from a guest.
  • deleteGuidanceSpace - Delete a guidance: Deletes a guidance by its id
  • deleteGuideEnvironment - Delete a guide: Deletes a guide
  • deleteJob - Delete a job: Delete a job
  • deleteMappingProgram - Delete a mapping program: Deletes a mapping program
  • deleteMultipleRulesMapping - Delete multiple mapping rules: Deletes multiple mapping rules from a program
  • deleteRecords - Delete records: Deletes records from a workbook sheet
  • deleteRoutine - Delete a routine: Deletes a routine
  • deleteRuleMapping - Delete a mapping rule: Deletes a mapping rule from a program
  • deleteRunbook - Delete a runbook: Deletes a runbook
  • deleteSecret - Delete a secret by it
  • deleteSheet - Delete a sheet: Deletes a specific sheet from a workbook
  • deleteSnapshot - Delete a snapshot: Deletes a snapshot of a sheet
  • deleteSpace - Delete a space: Delete a space
  • deleteUser - Delete a user: Deletes a user
  • deleteUserRole - Remove Role from User: Removes a role from a user.
  • deleteView - Delete a view: Deletes a single view
  • deleteWorkbook - Delete a workbook: Deletes a workbook and all of its record data permanently
  • downloadAgentExport - Download an agent export: Download an agent export
  • downloadFile - Download a file: Download a file
  • duplicateSheet - Duplicate a sheet: Creates a copy of a sheet including all its data within the same workbook
  • executeJob - Execute a job: Execute a job and return the job
  • failJob - Fail a job: Fail a job and return the job
  • getAction - Get an action: Get an action
  • getAgent - Get an agent: Get an agent
  • getAgentExport - Get an agent export: Get an agent export
  • getAgentLog - Get an agent log: Get an agent log
  • getAgentLogs - Get logs for an agent: Get logs for an agent
  • getAllActions - Get all actions for the space: Get all actions for the space
  • getApp - Get an app: Returns an app
  • getAssistant - Get a prompt: Returns a prompt
  • getCalculationsSheet - List calculations: Returns all calculations for a sheet
  • getCanvasArea - Get a canvas area: Returns a specific canvas area by ID
  • getCellValuesSheet - Get record cells by field: Returns record cell values grouped by all fields in the sheet
  • getCommit - Get a commit version: Returns the details of a commit version
  • getConstraintByIdApp - Get constraint by ID: Returns a specific constraint
  • getConstraintsApp - Get constraints: Returns constraints for an app
  • getConstraintVersionApp - Get constraint version: Returns a specified version of a specific constraint
  • getConstraintVersionsApp - Get constraint versions: Returns the versions of a specific constraint
  • getCurrentAccounts - Get the current account: Get the current account
  • getDataRetentionPolicy - Get a data retention policy: Returns a single data retention policy
  • getDocument - Get a document: Returns a single document
  • getEnvironment - Get an environment: Returns a single environment
  • getEnvironmentAgentExecutionsAgents - Get all executions in your environment: Get all executions in your environment
  • getEnvironmentAgentLogsAgents - Get all agent logs in your environment: Get all agent logs in your environment
  • **get

README truncated. View full README on GitHub.

Alternatives

Related Skills

Browse all skills
data-storytelling

Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive presentations.

27
content-trend-researcher

Advanced content and topic research skill that analyzes trends across Google Analytics, Google Trends, Substack, Medium, Reddit, LinkedIn, X, blogs, podcasts, and YouTube to generate data-driven article outlines based on user intent analysis

23
data-scientist

Expert data scientist for advanced analytics, machine learning, and statistical modeling. Handles complex data analysis, predictive modeling, and business intelligence. Use PROACTIVELY for data analysis tasks, ML modeling, statistical analysis, and data-driven insights.

13
google-analytics

Analyze Google Analytics data, review website performance metrics, identify traffic patterns, and suggest data-driven improvements. Use when the user asks about analytics, website metrics, traffic analysis, conversion rates, user behavior, or performance optimization.

13
senior-data-scientist

World-class data science skill for statistical modeling, experimentation, causal inference, and advanced analytics. Expertise in Python (NumPy, Pandas, Scikit-learn), R, SQL, statistical methods, A/B testing, time series, and business intelligence. Includes experiment design, feature engineering, model evaluation, and stakeholder communication. Use when designing experiments, building predictive models, performing causal analysis, or driving data-driven decisions.

8
backend-dev-guidelines

Comprehensive backend development guide for Langfuse's Next.js 14/tRPC/Express/TypeScript monorepo. Use when creating tRPC routers, public API endpoints, BullMQ queue processors, services, or working with tRPC procedures, Next.js API routes, Prisma database access, ClickHouse analytics queries, Redis queues, OpenTelemetry instrumentation, Zod v4 validation, env.mjs configuration, tenant isolation patterns, or async patterns. Covers layered architecture (tRPC procedures → services, queue processors → services), dual database system (PostgreSQL + ClickHouse), projectId filtering for multi-tenant isolation, traceException error handling, observability patterns, and testing strategies (Jest for web, vitest for worker).

7