# Flatfile — MCP server on mcp.ai
> Connect your Flatfile account and use 12 tools for developer tools straight from your AI agent. Connect with your own API key. Flatfile is a data exchange platform for collecting, validating, transforming, and managing structured data across collaborative workflows.

By: mcp.ai · official
Page: https://mcp.ai/flatfile

## Connect (MCP protocol)
Remote MCP endpoint (HTTP, streamable): https://api.mcp.ai/p_flatfile?ms=1787293740000
Add it as a custom/remote MCP connector, then authenticate when prompted.

## REST API (no MCP client required)
Every tool is also a REST endpoint, authed with a workspace API key.
Discover: GET https://api.mcp.ai/api/flatfile/_endpoints   # public; lists every endpoint
Call:     POST https://api.mcp.ai/api/flatfile/<endpoint>
  Authorization: Bearer sk_live_…   # create one at https://mcp.ai/settings/api-keys
  Content-Type: application/json
  Body: { …args }   →   { "ok": true, "tool": "<id>", "result": { … } }

## Developer docs
How to use (MCP or REST), markdown: https://mcp.ai/flatfile/skill.md
Postman collection (v2.1): https://mcp.ai/flatfile/postman.json

## Tools
- flatfile_delete_records(sheet_id: string, record_ids: string[]) — Permanently delete one to 100 explicitly identified records from one Flatfile sheet. This action never performs an unfiltered delete. Flatfile hooks are disabled, so these deletions do not trigger hoo
- flatfile_get_job(job_id: string) — Get detailed status, outcome, result, and diagnostic information for one Flatfile asynchronous job.
- flatfile_get_sheet(sheet_id: string) — Get one sheet's field configuration and record counts before reading or writing records.
- flatfile_get_space(space_id: string) — Get safe metadata for one Flatfile space without exposing transient access credentials or token-bearing guest links.
- flatfile_insert_records(records: object[], sheet_id: string) — Insert one or more rows into a Flatfile sheet using simple field-key to value objects. Returns Flatfile's success receipt and commit ID, not created record IDs. Use List Records separately when later 
- flatfile_list_environments(cursor?: string, page_size?: integer) — List Flatfile environments visible to the connected environment secret key and return the IDs needed to find spaces.
- flatfile_list_files(mode?: string, cursor?: string, space_id?: string, page_size?: integer) — Discover import or export files and their processing status, optionally within a Flatfile space.
- flatfile_list_jobs(cursor?: string, source?: string, file_id?: string, space_id?: string, page_size?: integer, workbook_id?: string, parent_job_id?: string, environment_id?: string, sort_direction?: string, exclude_child_jobs?: boolean) — Find asynchronous Flatfile jobs by environment, space, workbook, file, or parent job and inspect progress at a glance.
- flatfile_list_records(query?: string, cursor?: string, fields?: string[], filter?: string, sheet_id: string, page_size?: integer, record_ids?: string[], filter_field?: string, search_field?: string, search_value?: string, include_links?: boolean, include_messages?: boolean) — Read one page of records from a Flatfile sheet, optionally filtering by validity, field, record ID, search value, or FFQL expression.
- flatfile_list_spaces(cursor?: string, search?: string, archived?: boolean, namespace?: string, page_size?: integer, environment_id?: string, is_app_template?: boolean) — Find Flatfile spaces by environment, text, namespace, archive state, or template status.
- flatfile_list_workbooks(name?: string, label?: string, space_id?: string, namespace?: string, include_sheets?: boolean) — List workbooks, optionally within a space, with their nested sheets so an agent can continue to sheet and record tasks.
- flatfile_update_records(records: object[], sheet_id: string) — Update one or more existing Flatfile records by ID using simple field-key to value objects. Flatfile hooks are disabled, so these updates do not trigger hook-driven workflows.

## Example prompts
- "What can I do in Flatfile?"
- "Show me a summary of my Flatfile account"

## Links
Docs: https://mcp.ai/docs/mcps/flatfile
Website: https://mcp.ai/mcps/flatfile