Claude FileMaker MCP Server
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Claude FileMaker MCP Server List all layouts in my FileMaker database."
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Claude FileMaker MCP Server
An MCP server that connects Claude to FileMaker databases via the Data API. Query records, explore layouts, run scripts, and manage data using natural language.
Features
Query, create, update, and delete records
Explore database layouts and field definitions
Run FileMaker scripts with parameters
Multi-database support
Session caching for performance
Self-signed SSL certificate support
Related MCP server: Salesforce MCP Server
Quick Install (Claude Code CLI)
One command to add the FileMaker server to all your Claude Code projects:
claude mcp add -s user \
filemaker \
"npx -y github:ayushshah31/Claude-Filemaker-Mcp" \
-e FM_PROTOCOL=https \
-e FM_API_VERSION=v1 \
-e FM_SSL_VERIFY=false \
-e NODE_TLS_REJECT_UNAUTHORIZED=0 \
-e FM_SERVER_MYDB=your-filemaker-server.com \
-e FM_DATABASE_MYDB=YourDatabase \
-e FM_ACCOUNT_MYDB=your_username \
-e FM_PASSWORD_MYDB=your_passwordReplace the MYDB suffix and values with your own. The suffix is a database identifier -- it can be anything, but must match across all four env vars (FM_SERVER_, FM_DATABASE_, FM_ACCOUNT_, FM_PASSWORD_).
Then restart Claude Code. Run /mcp inside a session to verify the server is connected.
Manual Install (from source)
Prerequisites
Node.js 18 or higher
FileMaker Server with Data API enabled
A FileMaker account with the
fmrestextended privilege enabled
Step 1: Clone and install
git clone https://github.com/ayushshah31/Claude-Filemaker-Mcp.git
cd Claude-Filemaker-Mcp
npm installStep 2: Register the server
Claude Code (CLI) -- works on Linux, macOS, and Windows:
claude mcp add -s user \
filemaker \
"node /absolute/path/to/Claude-Filemaker-Mcp/server.js" \
-e FM_PROTOCOL=https \
-e FM_API_VERSION=v1 \
-e FM_SSL_VERIFY=false \
-e NODE_TLS_REJECT_UNAUTHORIZED=0 \
-e FM_SERVER_MYDB=your-filemaker-server.com \
-e FM_DATABASE_MYDB=YourDatabase \
-e FM_ACCOUNT_MYDB=your_username \
-e FM_PASSWORD_MYDB=your_passwordClaude Desktop:
Go to Settings > Developers > Edit Config to open claude_desktop_config.json and add:
{
"mcpServers": {
"filemaker": {
"command": "node",
"args": ["/absolute/path/to/Claude-Filemaker-Mcp/server.js"],
"env": {
"FM_PROTOCOL": "https",
"FM_API_VERSION": "v1",
"FM_SSL_VERIFY": "false",
"NODE_TLS_REJECT_UNAUTHORIZED": "0",
"FM_SERVER_MYDB": "your-filemaker-server.com",
"FM_DATABASE_MYDB": "YourDatabase",
"FM_ACCOUNT_MYDB": "your_username",
"FM_PASSWORD_MYDB": "your_password"
}
}
}
}Windows users: Use backslashes in the path, e.g.
"C:\\Users\\you\\Claude-Filemaker-Mcp\\server.js"
Step 3: Restart and test
Restart Claude Code or Claude Desktop, then try:
"What layouts are available in my FileMaker database?"
"Show me the first 10 records from PatientList"
"What scripts are available?"
Multiple Databases
Add more databases by using different suffixes in your env vars:
FM_SERVER_PROD=prod-server.com
FM_DATABASE_PROD=Production
FM_ACCOUNT_PROD=api_user
FM_PASSWORD_PROD=prod_password
FM_SERVER_DEV=dev-server.com
FM_DATABASE_DEV=Development
FM_ACCOUNT_DEV=dev_user
FM_PASSWORD_DEV=dev_passwordAvailable Tools
Tool | Description |
| List all configured databases |
| Test connection to a database |
| Get all layouts in a database |
| Get fields and details for a specific layout |
| Query records with filtering, sorting, and pagination |
| Create a new record |
| Update an existing record |
| Delete a record |
| List all available scripts |
| Execute a FileMaker script with optional parameters |
| Clear data, session, or all caches |
SSL Configuration
Setting | Description |
| Accept self-signed certificates (development) |
| Require valid certificates (production) |
Troubleshooting
Tools show up but return empty results
Make sure
NODE_TLS_REJECT_UNAUTHORIZED=0is set if using a self-signed certificateVerify the FileMaker account has the
fmrestextended privilege enabled
"No valid FileMaker database configurations found"
Check that all four env vars (
FM_SERVER_,FM_DATABASE_,FM_ACCOUNT_,FM_PASSWORD_) use the same suffixMake sure the values are not empty
Connection test works but data calls fail
Clear the cache: ask Claude to "clear the FileMaker cache"
Restart Claude Code / Claude Desktop
Server not showing in /mcp
Run
claude mcp listto check registrationVerify the path to
server.jsis absoluteMake sure
npm installcompleted successfullyCheck that Node.js 18+ is installed:
node --version
FileMaker Server Requirements
Your FileMaker Server account needs:
Data API access enabled on the server
An account with the
fmrestextended privilegeAppropriate privilege set for the operations you need (read-only for queries, full access for create/update/delete)
License
MIT
Available Tools
11 toolsfm_clear_cacheC
Clear cached data
Inputs: type (required).
fm_create_recordC
Create a new record
Inputs: layout (required), database (required), fieldData (required).
fm_delete_recordC
Delete a record
Inputs: layout (required), database (required), recordId (required).
fm_get_layout_metadataC
Get detailed metadata for a specific layout
Inputs: layout (required), database (required).
fm_get_metadataB
Get database metadata (layouts/tables)
Inputs: database (required).
fm_get_scriptsC
Get list of available scripts
Inputs: database (required).
fm_list_databasesB
List all configured FileMaker databases
Inputs: no named parameters.
fm_query_recordsB
Query records with advanced filtering and sorting
Inputs: layout (required), database (required), sort, limit, +2 more.
fm_run_scriptD
Execute a FileMaker script
Inputs: layout (required), script (required), database (required), parameter.
fm_test_connectionB
Test connection to a FileMaker database
Inputs: database (required).
fm_update_recordC
Update an existing record
Inputs: layout (required), database (required), recordId (required), fieldData (required).
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 11 tools
Each tool targets a distinct operation: listing databases, testing connections, fetching metadata at database or layout level, querying, creating/updating/deleting records, running scripts, listing scripts, and clearing cache. No two tools have overlapping purposes.
All tools follow a consistent verb_noun pattern with the fm_ prefix, e.g., list_databases, get_metadata, query_records, create_record, run_script. Even compound names like get_layout_metadata fit the pattern.
11 tools is well-scoped for a FileMaker MCP server, covering connection, metadata, CRUD, scripting, and cache management without redundancy or bloat.
The tool surface covers core CRUD, metadata retrieval, script execution, and connection testing. A minor gap is the absence of a dedicated 'get record by ID' but query_records can handle that via filters, so no critical dead ends.
Maintenance
Related MCP Connectors
MCP server unifying ERPs, CRMs, APIs and knowledge base for Claude, ChatGPT and Gemini.
MCP server giving Claude AI access to 22+ NYC public-record databases for real estate due diligence
Cloud-hosted MCP server for secure AI access to enterprise data sources via CData Connect AI.
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Related MCP Servers
- AlicenseAqualityAmaintenanceAn MCP server implementation that integrates Claude with Salesforce, enabling natural language interactions with Salesforce data and metadata for querying, modifying, and managing objects and records.153,410 npm165MIT
- AlicenseAqualityDmaintenanceAn MCP server implementation that integrates Claude with Salesforce, enabling natural language interactions with Salesforce data and metadata.859 npmMIT
- AlicenseNot gradedqualityBmaintenanceMCP server for FileMaker Server OData 4.01 API integration, enabling AI assistants to discover databases, perform CRUD operations, and manage connections.21 npm14MIT
- AlicenseAqualityDmaintenanceMCP server for Claude that connects to MySQL, MariaDB, and SQLite databases. Query your databases using natural language.3MIT