Skip to main content
Glama
JoergKoester

mcp-server-filemaker

by JoergKoester

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

Related MCP server: filemaker-odata-mcp

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

Create a new record

fm_update_record

Update record (PATCH)

fm_delete_record

Delete record by ROWID

Scripts & Schema

Tool

Description

fm_run_script

Execute a FileMaker script

fm_create_table

Create a new table

fm_add_field

Add a field (SQL-style types: VARCHAR(n), INT, NUMERIC, DATE, etc.)

fm_batch

Batch multiple OData requests in one HTTP call

Data API (Session Context)

Tool

Description

fm_set_globals

Set global fields (Login → PATCH /globals → Logout)

fm_run_script_with_globals

Set globals + run script in one session

Test & Validation

Tool

Description

fm_create_test_record

Create a tagged test record

fm_cleanup_test_data

Delete all records matching a test tag

fm_assert_record

Validate field values (PASS/FAIL with diff)

fm_assert_count

Assert record count for a query

fm_run_script_and_assert

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_record
  • Disabled tools are hidden from the tool list and blocked at execution (double protection)

  • Server startup shows Tools: 17/20 and lists disabled tools

  • Recommended: always disable fm_create_table and fm_add_field on production databases

Architecture

4 files in src/:

File

Responsibility

index.ts

Entry point, env config, STDIO transport, tool routing

odata-client.ts

HTTP client for all OData v4 requests (CRUD, scripts, schema, batch)

data-api-client.ts

HTTP client for FileMaker Data API (globals, session-scoped scripts)

tools.ts

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=true logs the full arguments of every tool call to stderr, which may contain record data from your FileMaker database. Keep this off in production.

  • OData $filter values passed to fm_query are 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 version

OData API Reference

Operation

Method

Endpoint

Service Document

GET

/fmi/odata/v4/{db}

Metadata (EDMX)

GET

/fmi/odata/v4/{db}/$metadata

Read records

GET

/fmi/odata/v4/{db}/{table}?$filter=...

Create record

POST

/fmi/odata/v4/{db}/{table}

Update record

PATCH

/fmi/odata/v4/{db}/{table}({rowId})

Delete record

DELETE

/fmi/odata/v4/{db}/{table}({rowId})

Run script

POST

/fmi/odata/v4/{db}/Script.{scriptName}

Create table

POST

/fmi/odata/v4/{db}/FileMaker_Tables

Add field

PATCH

/fmi/odata/v4/{db}/FileMaker_Tables/{table}

Batch

POST

/fmi/odata/v4/{db}/$batch

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 tools
fm_add_fieldC

Add a new field to an existing FileMaker table. SQL-style field types: VARCHAR(n), INT, NUMERIC, DATE, TIME, TIMESTAMP, BLOB.

ParametersJSON Schema
NameRequiredDescriptionDefault
tableYes
fieldNameYes
fieldTypeYesSQL-style field type: VARCHAR(n), INT, NUMERIC, DATE, TIME, TIMESTAMP, BLOB
fieldRepetitionNoNumber of repetitions (optional)

TDQS

C2.9/5.0
Behavior2/5

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.

Conciseness5/5

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.

Completeness1/5

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.

Parameters2/5

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.

Purpose5/5

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.

Usage Guidelines2/5

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
tableYes
filterNo
expectedYesExpected record count

TDQS

B3/5.0
Behavior2/5

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.

Conciseness5/5

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.

Completeness2/5

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.

Parameters2/5

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.

Purpose4/5

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.

Usage Guidelines3/5

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
tableYes
rowIdYes
expectedYesExpected field values

TDQS

A3.6/5.0
Behavior3/5

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.

Conciseness5/5

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.

Completeness3/5

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.

Parameters2/5

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.

Purpose5/5

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.

Usage Guidelines3/5

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
requestsYesList of OData GET requests. Use individual tools for write operations.

TDQS

A4.2/5.0
Behavior3/5

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.

Conciseness5/5

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.

Completeness4/5

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.

Parameters4/5

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.

Purpose5/5

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.

Usage Guidelines4/5

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
tableYes
tagNo__MCP_TEST__
tagFieldYesField name for the test marker (must exist as a text field in the FM table)

TDQS

B3.3/5.0
Behavior2/5

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.

Conciseness5/5

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.

Completeness2/5

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.

Parameters2/5

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.

Purpose5/5

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.

Usage Guidelines3/5

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
tableYes
fieldsYesField data as a key/value object

TDQS

C2.9/5.0
Behavior1/5

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.

Conciseness5/5

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.

Completeness2/5

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.

Parameters2/5

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.

Purpose5/5

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.

Usage Guidelines2/5

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).

ParametersJSON Schema
NameRequiredDescriptionDefault
tableNameYesName of the new table

TDQS

B3.3/5.0
Behavior2/5

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.

Conciseness5/5

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.

Completeness3/5

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.

Parameters3/5

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.

Purpose5/5

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.

Usage Guidelines2/5

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
tableYes
fieldsYes
tagNoMarker text for later cleanup, e.g. '__TEST__'
tagFieldYesField name for the test marker (must exist as a text field in the FM table)

TDQS

A3.7/5.0
Behavior3/5

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.

Conciseness5/5

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.

Completeness3/5

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.

Parameters3/5

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.

Purpose5/5

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.

Usage Guidelines3/5

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
tableYes
rowIdYes

TDQS

C2.9/5.0
Behavior2/5

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.

Conciseness4/5

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.

Completeness2/5

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.

Parameters2/5

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.

Purpose5/5

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.

Usage Guidelines2/5

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.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

B3.3/5.0
Behavior2/5

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.

Conciseness5/5

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.

Completeness4/5

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.

Parameters4/5

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.

Purpose4/5

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.

Usage Guidelines2/5

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
tableYes
rowIdYesROWID of the record

TDQS

B3.1/5.0
Behavior2/5

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.

Conciseness5/5

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.

Completeness3/5

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.

Parameters3/5

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.

Purpose4/5

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.

Usage Guidelines2/5

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.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

A4/5.0
Behavior4/5

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.

Conciseness5/5

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.

Completeness4/5

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.

Parameters4/5

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.

Purpose5/5

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.

Usage Guidelines2/5

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
tableNoIf empty: list all tables. If set: show fields with types from $metadata.

TDQS

A4.2/5.0
Behavior4/5

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.

Conciseness5/5

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.

Completeness4/5

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.

Parameters3/5

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.

Purpose5/5

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.

Usage Guidelines4/5

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).

ParametersJSON Schema
NameRequiredDescriptionDefault
tableYesFileMaker table name (exact name from FM)
filterNoOData $filter expression, e.g. "Name eq 'Max'". Escape single quotes in string literals: ' → ''
selectNoComma-separated field names, e.g. "ID,Name,Date"
topNoMax number of records
skipNoRecords to skip (pagination)
orderbyNoSort order, e.g. "Name asc"
expandNoInclude related portals, e.g. "LineItems"
countNoReturn total record count

TDQS

A4.1/5.0
Behavior3/5

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.

Conciseness5/5

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.

Completeness3/5

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.

Parameters4/5

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.

Purpose5/5

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.

Usage Guidelines4/5

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
scriptNameYesExact script name as defined in FileMaker. Spaces and special characters are allowed (URL-encoded).
scriptParamNoScript parameter (JSON string recommended)

TDQS

C2.9/5.0
Behavior2/5

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.

Conciseness5/5

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.

Completeness2/5

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.

Parameters3/5

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.

Purpose4/5

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.

Usage Guidelines2/5

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
scriptNameYes
scriptParamNo
expectedResultCodeNo0

TDQS

B3.1/5.0
Behavior2/5

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.

Conciseness5/5

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.

Completeness2/5

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.

Parameters2/5

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.

Purpose5/5

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.

Usage Guidelines2/5

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
globalsYesGlobal fields as key/value. Keys: 'Table::FieldName_g'
layoutYesLayout name for Data API script execution (must be based on the correct table)
scriptNameYesExact script name
scriptParamNoScript parameter (JSON string recommended)

TDQS

A4.1/5.0
Behavior3/5

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.

Conciseness5/5

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.

Completeness3/5

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.

Parameters4/5

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.

Purpose5/5

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.

Usage Guidelines4/5

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'.

ParametersJSON Schema
NameRequiredDescriptionDefault
globalsYesGlobal fields as key/value. Keys must be fully qualified: 'Table::FieldName_g'

TDQS

A3.8/5.0
Behavior3/5

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.

Conciseness5/5

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.

Completeness4/5

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.

Parameters3/5

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.

Purpose5/5

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.

Usage Guidelines3/5

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).

ParametersJSON Schema
NameRequiredDescriptionDefault
tableYes
rowIdYes
fieldsYesFields to update

TDQS

C2.9/5.0
Behavior2/5

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.

Conciseness4/5

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.

Completeness2/5

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.

Parameters2/5

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.

Purpose5/5

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.

Usage Guidelines2/5

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.

  1. 19 tool updatesv1.1.0
    • First observedfm_add_field
    • First observedfm_assert_count
    • First observedfm_assert_record
    • First observedfm_batch
    • First observedfm_cleanup_test_data
    • First observedfm_create_record
    • First observedfm_create_table
    • First observedfm_create_test_record
    • First observedfm_delete_record
    • First observedfm_get_metadata
    • First observedfm_get_record
    • First observedfm_get_service_document
    • First observedfm_introspect
    • First observedfm_query
    • First observedfm_run_script
    • First observedfm_run_script_and_assert
    • First observedfm_run_script_with_globals
    • First observedfm_set_globals
    • First observedfm_update_record

TDQS

A3.6/5.0
Disambiguation5/5

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.

Naming Consistency5/5

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.

Tool Count4/5

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.

Completeness4/5

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

ActivityInactive
ResponsivenessSyncing

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

Related MCP Servers

  • A
    license
    A
    quality
    B
    maintenance
    MCP 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.
    18
    31
    6
    MIT
  • A
    license
    Not graded
    quality
    A
    maintenance
    MCP server for FileMaker Server OData 4.01 API integration, enabling AI assistants to discover databases, perform CRUD operations, and manage connections.
    15
    11
    MIT
  • A
    license
    Not graded
    quality
    C
    maintenance
    An MCP server that enables AI assistants to interact with Odoo ERP, allowing natural language queries, record creation, updates, and deletions.
    LGPL 3.0
  • A
    license
    Not graded
    quality
    A
    maintenance
    An 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.
    1
    MIT

Latest Blog Posts

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