mcp-server-filemaker

MCP server that gives AI assistants direct access to FileMaker databases via OData v4 API.

Works with any MCP-compatible client: Claude Code, Claude Desktop, Cursor, Windsurf, Continue.dev, Zed, and others.

Runs on-premise — no cloud proxy, no Claris ID required.

MCP Client  ──stdio──▶  MCP Server (Node.js)  ──OData v4 / HTTPS──▶  FileMaker Server

Features

• 20 tools — CRUD, scripts, schema introspection, batch requests, test & validation
• OData v4 — direct table access (not layout-based like the Data API)
• Data API bridge — set global fields and run scripts with session context
• Tool restrictions — disable dangerous tools per database via FM_DISABLED_TOOLS
• Zero dependencies beyond the MCP SDK and Zod

Prerequisites

1. FileMaker Server with OData access enabled (Admin Console → Connectors → OData)
2. A dedicated API user with Extended Privilege fmodata
3. For Data API tools (fm_set_globals, fm_run_script_with_globals): also fmrest
4. HTTPS with a valid certificate — self-signed certificates are not supported

Installation

git clone https://github.com/JoergKoester/mcp-server-filemaker.git
cd mcp-server-filemaker
npm install
npm run build

Configuration

Add the server to your MCP client config. For Claude Code and Claude Desktop, edit ~/.mcp.json:

{
  "mcpServers": {
    "filemaker": {
      "command": "node",
      "args": ["/absolute/path/to/mcp-server-filemaker/dist/index.js"],
      "env": {
        "FM_HOST": "https://your-filemaker-server.example.com",
        "FM_DATABASE": "YourDatabase",
        "FM_USERNAME": "api_user",
        "FM_PASSWORD": "your_password",
        "FM_ODATA_VERSION": "v4",
        "FM_TIMEOUT_MS": "15000",
        "FM_RETRY_COUNT": "2",
        "FM_DISABLED_TOOLS": "",
        "FM_DEBUG": "false"
      }
    }
  }
}

Environment Variables

| Variable | Required | Description | |----------|----------|-------------| | FM_HOST | Yes | FileMaker Server URL with protocol, e.g. https://fms.example.com | | FM_DATABASE | Yes | Database name | | FM_USERNAME | Yes | API user (needs Extended Privilege fmodata) | | FM_PASSWORD | Yes | Password | | FM_ODATA_VERSION | No | OData version, default v4 | | FM_TIMEOUT_MS | No | HTTP request timeout in milliseconds, default 15000 | | FM_RETRY_COUNT | No | Retry attempts on transient failures (429/503), default 2 (set 0 to disable) | | FM_DISABLED_TOOLS | No | Comma-separated tool names to disable | | FM_DEBUG | No | true to log full tool arguments to stderr (may include record data) |

Multiple Databases

Run one server instance per database:

{
  "mcpServers": {
    "filemaker-app": {
      "command": "node",
      "args": ["/path/to/dist/index.js"],
      "env": {
        "FM_HOST": "https://fms.example.com",
        "FM_DATABASE": "MyApp",
        "FM_USERNAME": "api_user",
        "FM_PASSWORD": "secret",
        "FM_DISABLED_TOOLS": "fm_create_table,fm_add_field"
      }
    },
    "filemaker-data": {
      "command": "node",
      "args": ["/path/to/dist/index.js"],
      "env": {
        "FM_HOST": "https://fms.example.com",
        "FM_DATABASE": "MyData",
        "FM_USERNAME": "api_user",
        "FM_PASSWORD": "secret",
        "FM_DISABLED_TOOLS": "fm_create_table,fm_add_field,fm_delete_record"
      }
    }
  }
}

Tools

Structure & Metadata

| Tool | Description | |------|-------------| | fm_get_service_document | List all tables | | fm_get_metadata | Full EDMX schema (fields, types, relationships) | | fm_introspect | Tables overview or field details with native FM types |

Data Access

| Tool | Description | |------|-------------| | fm_query | Query records with $filter, $select, $top, $orderby, $expand, $count | | fm_get_record | Single record by ROWID | | fm_create_record | Cre

... View full README on GitHub