FileMaker OData MCP

Connect AI assistants to FileMaker databases

⚡ Quick Install

Enter your FileMaker server details to generate a configuration.

Optional: ProofChat Credentials (for clipboard tool, macOS only)

Required only for the fmodata_text_to_clipboard tool that converts FileMaker script text to clipboard objects.

Configuration generated — copy below or check if the app opened
~/.cursor/mcp.json

🛠 Available Tools

Once connected, your AI assistant can use these FileMaker operations:

Database Structure

fmodata_list_tables Get all tables in the database
fmodata_get_metadata Get OData schema metadata

Data Query

fmodata_query_records Query with filters, sorting, pagination
fmodata_get_record Get a single record by key
fmodata_get_record_count Get count of records (optionally filtered)
fmodata_get_field_value Get a specific field value from a record
fmodata_navigate_related Navigate to related records via relationships
fmodata_cross_join Perform cross-join query between tables

Data Modification

fmodata_create_record Create a new record
fmodata_update_record Update an existing record
fmodata_delete_record Delete a record

Schema Operations

fmodata_create_table Create a new table
fmodata_add_fields Add fields to an existing table
fmodata_delete_table Delete a table
fmodata_delete_field Delete a field from a table

Scripts & Batch

fmodata_run_script Execute a FileMaker script
fmodata_batch Execute multiple operations in a batch

Clipboard (macOS only)

fmodata_text_to_clipboard Convert FileMaker script text to clipboard object
Note: The clipboard tool requires ProofChat API credentials (configure above in optional section).
Manual Configuration

For Cursor IDE

Add to ~/.cursor/mcp.json:

{
  "mcpServers": {
    "fmodata": {
      "command": "npx",
      "args": [
        "-y",
        "fmodata-mcp",
        "--host",
        "https://your-server.com",
        "--database",
        "YourDatabase",
        "--ottoApiKey",
        "dk_your-api-key"
      ]
    }
  }
}

For Claude Desktop

Add to your Claude Desktop config:

  • macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
  • Windows: %APPDATA%\Claude\claude_desktop_config.json
Using Basic Auth? Replace --ottoApiKey with --username and --password arguments.
Configuration Reference

Required Arguments

  • --host — FileMaker server URL
  • --database — Database name/filename

Authentication (choose one)

Otto API Key:

  • --ottoApiKey — Your Otto API key (dk_ for OttoFMS, KEY_ for Otto v3)

Basic Auth:

  • --username — FileMaker username
  • --password — FileMaker password
Security: Keep your config files secure and never commit credentials to version control.

🔗 Resources