Figma Plugin for FMBetterForms
06/12/2025
Talking to Your Data with the FileMaker App Assistant
20/12/2025
Connecting FileMaker to modern AI tooling via the Model Context Protocol (MCP) feels, at first, like opening a door to the future. And it is. But it’s also one of those integrations where everything needs to be just right — or nothing works at all. This article walks through what MCP is, where things commonly go wrong, and why it’s absolutely worth pushing through.
What Is MCP — and Why FileMaker Developers Care?
MCP (Model Context Protocol) is a standardized way for AI models (like Claude) to:
- Discover available tools and schemas
- Query external systems
- Reason over live data instead of static prompts
For FileMaker developers, this is huge:
-
Your FileMaker file becomes queryable context
-
Scripts, tables, and data models can be exposed as AI tools
-
Claude can reason with your business data, not just about it
How to get started?
And then dive in deeper: https://help.claris.com/en/claris-mcp-help/content/getting-started.html
Or sit back and watch: https://www.youtube.com/watch?v=PAUQiULMghk
Where Things might Hurt 😅
On paper, the setup looks straightforward. Just Enable Data API / OData, create a Claris MCP context, add an MCP server config in Claude (or you MCP Client of choice) and Done. In reality, there are a few sharp edges that might catch you if you are not a pro...
"Error: Preflight connection failed: Unable to connect to FileMaker server. Verify account credentials and ensure the account has the appropriate extended privileges enabled (fmodata and fmrest)."
This is the most misleading error. In many cases, your credentials are correct and fmrest and fmodata are enabled. Yet MCP still fails — because the error often isn’t FileMaker at all.
Solution: Node.js version mismatches (the silent killer)
MCP tooling (mcp-remote) depends on modern Node features via undici. If Claude ends up running: Node 18 (or earlier), via nvm or via an inherited PATH you didn’t expect, Clause might throw errors that are not easy to explain.
Errors like "ReferenceError: File is not defined" have nothing to do with FileMaker and might point you in the wrong direction. On macOS, GUI apps (like Claude Desktop) do not inherit your shell environment. So even if node -v looks fine in Terminal, Claude may still be using an older runtime.
If you run into this, you might try this MCP Config >
{
"mcpServers": {
"claris": {
"command": "/usr/local/opt/node@22/bin/node",
"args": [
"/usr/local/opt/node@22/lib/node_modules/npm/bin/npx-cli.js",
"-y",
"mcp-remote@latest",
"https://mcp.connect.claris.com/org/290/ctx/7go8e7jfykoga/sse",
"--header",
"Authorization: static YOUR_REAL_TOKEN_HERE",
"--transport",
"sse-only"
],
"env": {
"PATH": "/usr/local/opt/node@22/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin"
}
}
}
}
Why It’s Worth It (Really)
Once everything clicks into place, something shifts. Suddenly:
-
Claude understands your FileMaker schema
-
You can expose domain-specific tools
-
Queries become contextual, not generic
-
You stop copy-pasting data into prompts
Real benefits for FileMaker solutions
-
AI-assisted reporting directly on live data
-
Natural-language querying of business records
-
Script orchestration via AI reasoning
-
Safer AI usage, because access is structured and scoped
Instead of “AI guessing”, you get AI collaborating.
