mcp-server-filemaker
Provides tools for managing FileMaker databases via OData v4 API, including CRUD operations, script execution, schema introspection, batch requests, and test/validation tools.
Click on "Install 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., "@mcp-server-filemakerList customers from New York"
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.
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 ServerFeatures
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_TOOLSZero dependencies beyond the MCP SDK and Zod
Related MCP server: filemaker-odata-mcp
Prerequisites
FileMaker Server with OData access enabled (Admin Console → Connectors → OData)
A dedicated API user with Extended Privilege
fmodataFor Data API tools (
fm_set_globals,fm_run_script_with_globals): alsofmrestHTTPS 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 buildConfiguration
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 |
| Yes | FileMaker Server URL with protocol, e.g. |
| Yes | Database name |
| Yes | API user (needs Extended Privilege |
| Yes | Password |
| No | OData version, default |
| No | HTTP request timeout in milliseconds, default |
| No | Retry attempts on transient failures (429/503), default |
| No | Comma-separated tool names to disable |
| No |
|
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 |
| List all tables |
| Full EDMX schema (fields, types, relationships) |
| Tables overview or field details with native FM types |
Data Access
Tool | Description |
| Query records with |
| Single record by ROWID |
| Create a new record |
| Update record (PATCH) |
| Delete record by ROWID |
Scripts & Schema
Tool | Description |
| Execute a FileMaker script |
| Create a new table |
| Add a field (SQL-style types: |
| Batch multiple OData requests in one HTTP call |
Data API (Session Context)
Tool | Description |
| Set global fields (Login → PATCH /globals → Logout) |
| Set globals + run script in one session |
Test & Validation
Tool | Description |
| Create a tagged test record |
| Delete all records matching a test tag |
| Validate field values (PASS/FAIL with diff) |
| Assert record count for a query |
| Run script and check result code |
Tool Restrictions
Disable tools per database instance via FM_DISABLED_TOOLS:
FM_DISABLED_TOOLS=fm_create_table,fm_add_field,fm_delete_recordDisabled tools are hidden from the tool list and blocked at execution (double protection)
Server startup shows
Tools: 17/20and lists disabled toolsRecommended: always disable
fm_create_tableandfm_add_fieldon production databases
Architecture
4 files in src/:
File | Responsibility |
| Entry point, env config, STDIO transport, tool routing |
| HTTP client for all OData v4 requests (CRUD, scripts, schema, batch) |
| HTTP client for FileMaker Data API (globals, session-scoped scripts) |
| MCP tool definitions (Zod schemas), handler logic, test tools |
The server is a thin proxy — no caching. Each OData request uses Basic Auth; Data API tools manage their own session (login → action → logout). The OData client retries transient failures (HTTP 429/503) with exponential backoff; the Data API client currently does not retry.
Security Notes
stdio transport has no authentication of its own — anyone who can start the process has full access to the configured FileMaker database with the rights of the API user. Credentials live in your MCP client config (e.g.
~/.mcp.json) and are protected by filesystem permissions only. In multi-user environments, secure the server process and config file accordingly.Startup logs to stderr include the configured host, database, and username (no password, no API keys). Redirect stderr appropriately if that is sensitive.
FM_DEBUG=truelogs the full arguments of every tool call to stderr, which may contain record data from your FileMaker database. Keep this off in production.OData
$filtervalues passed tofm_queryare placed verbatim into the query string. Escape single quotes ('→'') in string literals yourself, and be aware that values containing URL-reserved characters (#,+,%) can corrupt the request.
Development
npm run dev # Run with tsx (no build needed)
npm run watch # Watch mode
npm run build # Compile TypeScript → dist/
npm start # Run compiled versionOData API Reference
Operation | Method | Endpoint |
Service Document | GET |
|
Metadata (EDMX) | GET |
|
Read records | GET |
|
Create record | POST |
|
Update record | PATCH |
|
Delete record | DELETE |
|
Run script | POST |
|
Create table | POST |
|
Add field | PATCH |
|
Batch | POST |
|
AI-generated experimental project
This MCP server was generated almost entirely with the assistance of a generative AI system and has only undergone limited human review so far. It is provided as is, without any guarantees of correctness, security, or fitness for a particular purpose. Use it at your own risk and always review and test the code thoroughly before using it in production.
The code in this repository is licensed under the MIT License. By using it, you agree that the authors and copyright holders are not liable for any claim, damages, or other liability arising from its use, as stated in the license.
License
MIT
Available Tools
19 toolsfm_add_fieldC
Add a new field to an existing FileMaker table. SQL-style field types: VARCHAR(n), INT, NUMERIC, DATE, TIME, TIMESTAMP, BLOB.
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| fieldName | Yes | ||
| fieldType | Yes | SQL-style field type: VARCHAR(n), INT, NUMERIC, DATE, TIME, TIMESTAMP, BLOB | |
| fieldRepetition | No | Number of repetitions (optional) |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, and the description only mentions input types. It does not disclose behavioral traits such as side effects, error conditions, or prerequisites (e.g., table must exist).
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
Single sentence, no redundancy, front-loaded with purpose. Every word earns its place.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
With no annotations, no output schema, and incomplete parameter descriptions, the description fails to provide sufficient context for an AI agent to use the tool reliably. Missing error handling, return values, and prerequisites.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema coverage is 50%, but the description does not add meaningful detail for the undocumented parameters. It only repeats the field type information already in the schema for fieldType, and omits clarification for 'table' and 'fieldName'.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states 'Add a new field to an existing FileMaker table', using a specific verb and resource. It distinguishes from sibling tools like fm_create_table (create table) and fm_update_record (update records).
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance on when to use this tool versus alternatives, no prerequisites or context for usage. The description is purely declarative.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_assert_countB
Checks whether a query returns the expected number of records. Useful for validating script results.
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| filter | No | ||
| expected | Yes | Expected record count |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, so the description carries the full burden. It does not disclose error handling (e.g., invalid filter syntax, table not found), potential side effects, or return format. As a validation tool, it is likely safe, but this is not explicitly stated.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is two short sentences, front-loaded with the core purpose. Every word is meaningful, with no unnecessary details.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given three parameters and no output schema or annotations, the description lacks critical context such as filter syntax, behavior on count mismatch, and return value structure. It is insufficient for an agent to fully understand tool usage.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is only 33% (only 'expected' has a description). The description does not elaborate on 'table' or 'filter' parameters, failing to compensate for the low coverage. It adds little meaning beyond what the schema provides.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool checks whether a query returns the expected number of records, with a clear verb and resource. It distinguishes from siblings like fm_assert_record (asserts existence) and fm_query (returns records) implicitly, but does not explicitly differentiate.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description mentions 'useful for validating script results', giving some context on when to use it. However, it does not provide explicit when-not-to-use guidance, prerequisites, or alternatives.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_assert_recordA
Validates that a FileMaker record contains the expected field values. Returns PASS/FAIL with diff.
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| rowId | Yes | ||
| expected | Yes | Expected field values |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
Without annotations, the description carries full burden. It discloses the return format (PASS/FAIL with diff) but does not mention side effects, permissions, or whether the tool is read-only. The behavior is partially transparent.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is extremely concise, consisting of two short sentences that convey the essential information without any redundant or irrelevant content.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
For a simple validation tool with no output schema, the description is adequate but lacking in usage context, comparison to siblings, and error handling details. It meets minimum viability but has clear gaps.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema coverage is 33% (only 'expected' has a description). The tool description does not elaborate on parameters beyond what the schema already provides, failing to compensate for the low coverage.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool validates a FileMaker record's field values and returns PASS/FAIL with diff. It uses a specific verb 'validates' and resource 'FileMaker record', distinguishing it from sibling tools like fm_assert_count.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description implies the tool is for checking field values, but provides no explicit guidance on when to use it versus alternatives (e.g., fm_assert_count for counting records). No exclusion criteria or context are given.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_batchA
Execute multiple OData GET requests in a single HTTP call (batch). Use individual tools for write operations.
| Name | Required | Description | Default |
|---|---|---|---|
| requests | Yes | List of OData GET requests. Use individual tools for write operations. |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
Discloses batching behavior and that only GET is supported, but lacks details on partial failure handling or response structure. No annotations exist, so description carries full burden; acceptable but not exhaustive.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
Two sentences with no wasted words. Key information is front-loaded, making it efficient for an agent to parse.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
For a simple tool with one parameter, the description covers essential context. Lacks output specification, but acceptable given no output schema and straightforward behavior.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema coverage is 100% with descriptions. The description reinforces that method is limited to GET and advises using separate tools for writes, adding value beyond schema.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states it executes multiple OData GET requests in a single batch call, distinguishing it from sibling tools that handle individual operations or writes.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
Explicitly says 'Use individual tools for write operations,' providing clear guidance on when not to use this tool. Could further specify batch size limits, but overall clear.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_cleanup_test_dataB
Deletes all test records marked with a specific tag. tagField must be an existing text field in the FM table.
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| tag | No | __MCP_TEST__ | |
| tagField | Yes | Field name for the test marker (must exist as a text field in the FM table) |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations provided, so the description must disclose behavioral traits. It mentions deletion but does not state that it is irreversible, the scope of deletion, or any permission requirements. The requirement for tagField is noted, but other behavioral aspects are missing.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is extremely concise, consisting of one clear sentence and a note. It is front-loaded with the action and provides essential information without fluff.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
With 3 parameters, no output schema, and no annotations, the description is too minimal. It lacks details on return values, error behavior, and how the deletion is performed (e.g., whether it's a batch operation). More context is needed for a destructive tool.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is only 33% (only tagField described). The description adds that tagField 'must be an existing text field', but does not explain the 'table' or 'tag' parameters beyond their names. No default or pattern explanation is given beyond the schema.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the action (deletes), the resource (test records), and the identification method (marked with a specific tag). It distinguishes from sibling tools like fm_delete_record which target individual records.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description implies usage for cleanup of test data via a tag, but does not explicitly state when to use this tool versus alternatives like fm_delete_record or fm_batch. It gives a condition (tagField must exist) but lacks when-not guidance.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_create_recordC
Create a new record in a FileMaker table.
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| fields | Yes | Field data as a key/value object |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations, the description must disclose behavioral traits. It only states 'Create a new record' without mentioning any side effects, permissions, return values, or error conditions. This is insufficient.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, clear sentence with no unnecessary words. It is appropriately concise.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the complexity (2 required params, nested object, no output schema, no annotations), the description is too minimal. It does not explain what the tool returns, how conflicts are handled, or any side effects. A more complete description would aid correct invocation.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 50% (fields has description, table does not). The description adds no additional meaning beyond the schema. For a tool with two required parameters, the description should clarify the expected format or constraints, especially for the 'table' parameter.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the action ('Create') and the resource ('a new record in a FileMaker table'). It is specific and distinguishes from sibling tools like fm_update_record or fm_delete_record.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance is provided on when to use this tool versus alternatives, nor any prerequisites or exclusions. The description lacks context for appropriate usage.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_create_tableB
Create a new table in the FileMaker database (schema modification via OData).
| Name | Required | Description | Default |
|---|---|---|---|
| tableName | Yes | Name of the new table |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
Without annotations, the description partially discloses behavior by noting 'schema modification via OData,' but fails to specify side effects, error conditions, or required permissions.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single sentence that efficiently conveys the tool's purpose and method, with no extraneous information.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
The description is minimal and lacks details on error handling, return value, and edge cases (e.g., duplicate table names). While the tool is simple, more context would be beneficial for safe usage.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The parameter schema fully describes the parameter (name type, description). The tool description adds no additional semantic detail about the parameter, so score at baseline 3.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the action (create) and resource (table) with added context of schema modification via OData, distinguishing it from siblings like fm_add_field and fm_create_record.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives, no prerequisites, and no exclusions. The agent must infer from the name and description.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_create_test_recordA
Creates a test record with a test tag. tagField must be an existing text field in the FM table. Returns ROWID for later validation and cleanup.
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| fields | Yes | ||
| tag | No | Marker text for later cleanup, e.g. '__TEST__' | |
| tagField | Yes | Field name for the test marker (must exist as a text field in the FM table) |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, so the description carries full burden. It discloses the return value (ROWID) and mentions cleanup, but does not detail side effects (e.g., it is a write operation), permissions, or failure modes. The constraint on tagField is a precondition, not a behavioral trait.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
Two sentences with no fluff: first sentence states purpose, second adds a constraint and return value. Every word earns its place, and the description is well front-loaded.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
For a tool with 4 parameters, no output schema, and no annotations, the description is partial. It explains the test tag mechanism and return value, but omits details about the 'fields' parameter, optional nature of 'tag', error conditions, and what a ROWID exactly represents. Adequate but not complete.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 50% (tag and tagField have descriptions). The description adds context that tagField must be an existing text field, but does not explain the 'fields' object or 'table' parameter beyond the schema. It adds marginal value but does not fully compensate for the undocumented parameters.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states 'Creates a test record with a test tag' which distinguishes it from the general create sibling (fm_create_record). It specifies the unique test-related purpose and return value (ROWID) for cleanup.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description implies usage for testing due to the test tag and cleanup reference, but provides no explicit guidance on when to use this tool versus fm_create_record or other siblings. No alternative tools or when-not-to-use are mentioned.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_delete_recordC
Delete a FileMaker record by ROWID.
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| rowId | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations, the description must disclose behavioral traits. It merely states 'Delete', implying a destructive action, but does not mention whether deletion is permanent, cascading effects, permission requirements, or error handling (e.g., record not found).
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, concise sentence with no extra words. It is well-structured and front-loaded, though it could be expanded slightly without losing conciseness.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool is a delete operation with no annotations, output schema, or parameter descriptions, the description is far from complete. It does not explain return values, side effects, error responses, or any conditions under which deletion might fail.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema coverage is 0%, so the description should add meaning beyond the schema. It only mentions deleting 'by ROWID', giving slight context to the rowId parameter, but does not explain the table parameter or the expected format of rowId. The schema provides basic names and types, but the description does not clarify how to use them.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the verb 'Delete', the resource 'FileMaker record', and the method 'by ROWID'. It effectively distinguishes this tool from sibling tools like fm_create_record, fm_update_record, and fm_query.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives. It does not mention prerequisites (e.g., needing a valid ROWID), when not to use it, or any context about record ownership or access control.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_get_metadataB
Reads the full OData $metadata document of the FileMaker database (EDMX/XML). Contains all tables, fields, types, and relationships.
| Name | Required | Description | Default |
|---|---|---|---|
No parameters | |||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, so the description must fully disclose behavioral traits. It states the tool 'Reads' implying read-only, but does not disclose potential large response size, caching behavior, or any side effects. Additional context like 'use sparingly due to payload size' would improve transparency.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
Two concise sentences, front-loaded with the action and resource. Every word adds value. No unnecessary elaboration.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given zero parameters and no output schema, the description adequately describes what the tool returns (full metadata document). It mentions the format (EDMX/XML) and contents. However, it could mention that the response might be large, which would help the agent set expectations. Still, it is complete enough for the tool's simplicity.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
There are zero parameters and schema description coverage is 100% (vacuous). The description does not need to add parameter details. The baseline for zero-param tools is 4, and the description meets that without adding unnecessary information.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool reads the full OData $metadata document and lists contents (tables, fields, types, relationships). Uses specific verb 'reads' and resource 'OData $metadata document'. However, it does not differentiate from siblings like fm_get_service_document or fm_introspect, so a 4 is appropriate.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool over alternatives (e.g., fm_introspect, fm_get_service_document). There is no mention of prerequisites, context, or exclusion criteria. This leaves the agent without decision support.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_get_recordB
Read a single FileMaker record by ROWID.
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| rowId | Yes | ROWID of the record |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
Minimal behavior description. With no annotations, description fully carries burden but omits error conditions (e.g., record not found) or return format. Only indicates read operation.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
Extremely concise, one sentence with no fluff. Front-loaded with key action and resource.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given no output schema and no annotations, description covers basic purpose but lacks details on error handling or return behavior. Adequate for simple read, but could be more complete.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema coverage is 50% (only rowId described). Description adds 'by ROWID' confirming rowId's role, but does not elaborate on 'table' parameter. Baseline 3 with partial coverage.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
Clear verb 'Read' and specific resource 'single FileMaker record' with method 'by ROWID'. Distinguishes from sibling tools like fm_query (multiple records) and fm_create_record.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance on when to use this tool versus alternatives. Does not mention prerequisites like needing the ROWID or alternatives for non-ROWID queries.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_get_service_documentA
Lists all available EntitySets (tables/layouts) of the FileMaker database.
| Name | Required | Description | Default |
|---|---|---|---|
No parameters | |||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
Without annotations, the description carries the burden. It discloses that the tool lists EntitySets (tables/layouts), implying a read-only operation. It does not mention any destructive effects or permissions, but the verb 'lists' sufficiently conveys safety.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, front-loaded sentence with no unnecessary words. It directly communicates the tool's purpose.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given no output schema, the description explains the tool returns a list of EntitySets. It could be more explicit about the format (e.g., names only), but for a simple listing tool, it is reasonably complete.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
There are no parameters, so the description does not need to add parameter semantics. The schema coverage is 100% (no parameters), so baseline 4 applies.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states it lists all available EntitySets, with parenthetical clarification that EntitySets are tables/layouts. This is a specific verb+resource, and it distinguishes from sibling tools like fm_create_record or fm_query, which deal with record-level operations.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
There is no guidance on when to use this tool versus alternatives. For example, it does not mention that it is useful for discovering available tables before querying, nor does it contrast with similar sibling tools like fm_introspect.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_introspectA
Analyzes the database structure: lists tables or shows all fields of a table with native FM field types from $metadata.
| Name | Required | Description | Default |
|---|---|---|---|
| table | No | If empty: list all tables. If set: show fields with types from $metadata. |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
Since no annotations are provided, the description carries the full burden of behavioral disclosure. It accurately describes a read-only analysis of the database structure using $metadata, implying no side effects. It is mostly transparent but could explicitly state it does not modify data.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, well-structured sentence that immediately conveys the tool's purpose and the conditional behavior. Every part is necessary, and there is no verbosity or redundancy.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's simplicity (single optional parameter, no output schema), the description is largely complete. It covers the two operational modes and mentions the source ($metadata). It could briefly hint at the output format (e.g., list or array) but is sufficient for an agent to understand usage.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The input schema already has a 100% description coverage for the single parameter, explaining the behavior for empty vs. set values. The tool description does not add additional semantic value beyond what is in the schema, so the baseline score of 3 is appropriate.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states 'Analyzes the database structure' and specifies two distinct modes: listing tables or showing fields with types. This provides a specific verb and resource, and the tool's function is well differentiated from siblings like fm_query or fm_get_metadata.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description explicitly explains the two modes based on whether the 'table' parameter is empty or set, which serves as clear usage guidance. However, it does not explicitly state when not to use this tool or suggest alternatives like fm_get_metadata, missing a bit of comparative context.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_queryA
Query records from a FileMaker table. Supports OData $filter, $select, $top, $skip, $orderby, $expand, $count. Default limit: 100 records (override with $top).
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | FileMaker table name (exact name from FM) | |
| filter | No | OData $filter expression, e.g. "Name eq 'Max'". Escape single quotes in string literals: ' → '' | |
| select | No | Comma-separated field names, e.g. "ID,Name,Date" | |
| top | No | Max number of records | |
| skip | No | Records to skip (pagination) | |
| orderby | No | Sort order, e.g. "Name asc" | |
| expand | No | Include related portals, e.g. "LineItems" | |
| count | No | Return total record count |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations, the description carries full burden. It discloses the default limit and OData support, but omits details on read-only behavior, error handling, performance implications, or what happens with no results. Could be more transparent.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
Two sentences, front-loaded with primary purpose. Every sentence adds value without redundancy. Highly concise.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Despite good parameter descriptions and default limit info, the description lacks details about return format, pagination beyond $skip, and error handling. Given no output schema, more completeness would be beneficial.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema coverage is 100%, so description adds moderate value by stating the default limit and clarifying $top override. It enriches understanding beyond raw schema fields.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
Description clearly states it queries records from a FileMaker table using OData, distinguishing it from sibling tools like fm_create_record or fm_delete_record. The verb 'query' and resource 'table' are specific and unambiguous.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides context about default limit and override via $top, aiding efficient usage. It implicitly differentiates from sibling tools based on operation type, but lacks explicit 'when to use vs. alternatives' guidance.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_run_scriptC
Run a FileMaker script. Returns scriptResult with code and resultParameter.
| Name | Required | Description | Default |
|---|---|---|---|
| scriptName | Yes | Exact script name as defined in FileMaker. Spaces and special characters are allowed (URL-encoded). | |
| scriptParam | No | Script parameter (JSON string recommended) |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, and the description does not disclose behavioral traits such as side effects (e.g., data modification, script execution impacts). It only mentions the return format, which is minimal transparency.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
Extremely concise: two short sentences that cover purpose and return value without extraneous information. Every word is essential.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given no output schema, the description does mention the return structure, but it omits critical context like potential side effects of running a script. With many sibling tools, more context would help the agent select appropriately.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Both parameters are fully described in the input schema (100% coverage), so the description adds no further meaning. The baseline score of 3 is appropriate.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
Clearly states the tool runs a FileMaker script and returns scriptResult with code and resultParameter. However, it does not distinguish itself from similar sibling tools like fm_run_script_and_assert or fm_run_script_with_globals.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance on when to use this tool versus alternatives like fm_run_script_and_assert. The description lacks context about prerequisites or scenarios where this tool is appropriate.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_run_script_and_assertB
Runs a FileMaker script and checks whether the result code matches the expected value.
| Name | Required | Description | Default |
|---|---|---|---|
| scriptName | Yes | ||
| scriptParam | No | ||
| expectedResultCode | No | 0 |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries full burden. It discloses the core behavior (run script and check result) but omits critical details such as error handling, side effects, permission requirements, or what happens on mismatch.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single sentence with no filler. It front-loads the action and resource, making it efficient and easy to parse.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool has 3 parameters, no output schema, and no annotations, the description is insufficient. It does not explain the return value, behavior on failure, or any prerequisites, leaving significant gaps for an agent to use correctly.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 0%, so the description must compensate. It implicitly references 'scriptName' and 'expectedResultCode' ('checks whether the result code matches the expected value') but does not explain the 'scriptParam' parameter or the default value of 'expectedResultCode'.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the verb 'Runs' and 'checks' with the resource 'FileMaker script' and 'result code'. It effectively distinguishes from siblings like 'fm_run_script' which lacks the assertion step.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description implies the tool is for running scripts with result checking, but provides no guidance on when to use it versus siblings like 'fm_run_script' or 'fm_run_script_with_globals'. No when-not or alternative contexts are given.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_run_script_with_globalsA
Sets global fields and runs a script in the SAME Data API session. This makes scripts that depend on global fields for context work (e.g. SESSIONS::UUID_g). Flow: Login → Set Globals → Run Script → Logout.
| Name | Required | Description | Default |
|---|---|---|---|
| globals | Yes | Global fields as key/value. Keys: 'Table::FieldName_g' | |
| layout | Yes | Layout name for Data API script execution (must be based on the correct table) | |
| scriptName | Yes | Exact script name | |
| scriptParam | No | Script parameter (JSON string recommended) |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations provided, so description bears burden. It describes the session flow and global setting, but lacks details on side effects, error handling, permissions, or destructiveness. Adequate but not comprehensive.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is concise: two sentences plus a flow arrow. No wasted words, front-loaded with the main action.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given no output schema and no annotations, the description covers the core idea but omits details like error behavior, required permissions, or what happens if login fails. Adequate for a simple tool.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema covers all 4 parameters. The description adds value by explaining the globals key format ('Table::FieldName_g') and the purpose of setting globals in the same session, going beyond schema.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's action: sets global fields and runs a script in the same Data API session, distinguishing from sibling 'fm_run_script' which likely does not set globals. Example and flow provided.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description explains when to use (scripts depending on global fields) and provides a flow. However, it does not explicitly state when not to use or list alternatives; the context of sibling tools implies it.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_set_globalsA
Sets global fields via FileMaker Data API (not OData). Opens a Data API session, sets the globals, then closes the session. Keys must be fully qualified: 'Table::FieldName_g'.
| Name | Required | Description | Default |
|---|---|---|---|
| globals | Yes | Global fields as key/value. Keys must be fully qualified: 'Table::FieldName_g' |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations provided, so description bears full burden. It discloses session management and key format, but does not mention idempotency, error handling, or side effects. Basic transparency but could be more detailed.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
Two efficient sentences: first states purpose and scope, second adds process detail. No unnecessary words, front-loaded with key information.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given simplicity (1 param, no output schema), the description covers purpose, key format, and process. It lacks mention of return value or success indication, but overall sufficiently complete for a setter tool.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema coverage is 100% and includes description for the 'globals' parameter. The tool description repeats the key format requirement, adding no new semantic value beyond the schema.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states it sets global fields via FileMaker Data API (not OData), and explains the process of opening and closing a session. It distinguishes from OData, providing specific verb and resource.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description notes it is not OData, and gives key qualification requirements, but does not explicitly state when to use this tool versus siblings like fm_run_script_with_globals. Usage context is implied but not direct.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
fm_update_recordC
Update an existing FileMaker record by ROWID (PATCH).
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| rowId | Yes | ||
| fields | Yes | Fields to update |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations, the description must fully disclose behavior. It mentions PATCH (partial update) but omits error handling, record existence checks, access requirements, or side effects.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
Very concise, one sentence with key info front-loaded. However, could be slightly more informative without losing brevity.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
No output schema, low schema coverage. The description fails to explain return values, error messages, or constraints. A mutation tool with 3 parameters should provide more complete context.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema coverage is only 33% (only fields property has a description). Description adds no extra meaning; 'by ROWID' hints at rowId but doesn't explain table or field formats. Baseline compensation for low coverage required but absent.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
Clearly states 'Update an existing FileMaker record by ROWID' with specific verb, resource, and method (PATCH). This distinguishes it from sibling tools like fm_create_record, fm_delete_record, and fm_get_record.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No explicit guidance on when to use this tool vs alternatives. Implies update via ROWID but doesn't describe prerequisites, limitations, or when other tools like fm_query or fm_run_script might be preferred.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections. Dates show when Glama detected each change.
19 tool updates
v1.1.0- First observed
fm_add_field - First observed
fm_assert_count - First observed
fm_assert_record - First observed
fm_batch - First observed
fm_cleanup_test_data - First observed
fm_create_record - First observed
fm_create_table - First observed
fm_create_test_record - First observed
fm_delete_record - First observed
fm_get_metadata - First observed
fm_get_record - First observed
fm_get_service_document - First observed
fm_introspect - First observed
fm_query - First observed
fm_run_script - First observed
fm_run_script_and_assert - First observed
fm_run_script_with_globals - First observed
fm_set_globals - First observed
fm_update_record
TDQS
Each tool serves a distinct purpose: CRUD, metadata, query, testing, scripting, schema, batch. Overlaps are intentional (e.g., create_record vs create_test_record). No ambiguity between tools.
All tools follow a consistent 'fm_verb_noun' pattern. Verbs are clear and standardized (create, get, update, delete, assert, run, set, add, cleanup, introspect). Minor deviations like 'batch' are still effective.
19 tools is slightly above the typical 3-15 range, but each tool addresses a specific aspect of FileMaker interaction (CRUD, schema, testing, scripting, metadata). The count feels earned and not excessive.
Core operations are well-covered: CRUD, query, metadata, scripting, testing. Minor gaps include lack of schema modification beyond adding fields (e.g., no delete table/field) and no tool for file uploads, but these are non-essential.
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Connectors
Cloud-hosted MCP server for secure AI access to enterprise data sources via CData Connect AI.
MCP server unifying ERPs, CRMs, APIs and knowledge base for Claude, ChatGPT and Gemini.
MCP server that lets AI assistants use all OneSchema features exposed via the public API.
- ZapierOAuthcom.zapier
Hosted MCP server connecting AI assistants to 9,000+ apps and 40,000+ actions via Zapier.
Related MCP Servers
- AlicenseAqualityBmaintenanceMCP server for Creatio CRM that enables AI assistants to read, create, update, delete records, execute business processes, and manage settings via OData and REST APIs.18316MIT
- AlicenseNot gradedqualityAmaintenanceMCP server for FileMaker Server OData 4.01 API integration, enabling AI assistants to discover databases, perform CRUD operations, and manage connections.1511MIT
- AlicenseNot gradedqualityCmaintenanceAn MCP server that enables AI assistants to interact with Odoo ERP, allowing natural language queries, record creation, updates, and deletions.LGPL 3.0
- AlicenseNot gradedqualityAmaintenanceAn MCP server that enables AI assistants to interact with Odoo ERP systems, allowing natural language access to business data, CRUD operations, and instance management without requiring Odoo module installation.1MIT
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/JoergKoester/mcp-server-filemaker'
If you have feedback or need assistance with the MCP directory API, please join our Discord server