fsans/fms-odata-mcp

Developer tools

Эта страница переведена автоматически. Технические детали смотрите в оригинале. Открыть оригинал

14 stars 7 forks Качество 86 Тренд 34MIT

Repository Install

Model Context Protocol (MCP) server for FileMaker Server OData 4.01 API integration

Обзор

Model Context Protocol (MCP) server providing FileMaker Server OData 4.01 API integration for AI assistants like Claude Desktop, Windsurf, Cursor, and Cline. - for FileMaker database operations (33 standard + 6 optional schema editing) - - Connect to multiple databases simultaneously (fm_odata_connect_multi) - - List and target active sessions per call (fm_odata_list_active_sessions, per-call connection param) - - Merged schema across all active sessions (fm_odata_describe_sessions) - - Explore tables, fields, and metadata - - Create, read, update, and delete records - - SSL support for self-signed certificates - - Save and reuse database connections - - Full query capabilities ($filter, $select, $orderby, $apply, etc.) - - Credentials are scrubbed from debug logs - - Server-side $apply via fm_odata_aggregate (v22.0.1+) - - fm_odata_cast and fm_odata_build_filter (v21.

README

Показан фрагмент оригинального README. Открыть оригинал.

FileMaker Server OData MCP

Model Context Protocol (MCP) server providing FileMaker Server OData 4.01 API integration for AI assistants like Claude Desktop, Windsurf, Cursor, and Cline.

Features

39 MCP Tools for FileMaker database operations (33 standard + 6 optional schema editing)
Multi-File Support - Connect to multiple databases simultaneously (fm_odata_connect_multi)
Session Management - List and target active sessions per call (fm_odata_list_active_sessions, per-call connection param)
Schema Discovery - Merged schema across all active sessions (fm_odata_describe_sessions)
Database Discovery - Explore tables, fields, and metadata
CRUD Operations - Create, read, update, and delete records
Secure Connections - SSL support for self-signed certificates
Connection Management - Save and reuse database connections
OData 4.01 Standard - Full query capabilities ($filter, $select, $orderby, $apply, etc.)
Password Redaction - Credentials are scrubbed from debug logs
FileMaker 2025 Aggregation - Server-side $apply via fm_odata_aggregate (v22.0.1+)
Type Casting & Parameterized Filters - fm_odata_cast and fm_odata_build_filter (v21.1+)
Server Version Detection - fm_odata_get_server_version reports the FM Server version and a feature-compatibility map; version-gated tools fall back gracefully on older servers
FileMaker 2026 Metadata Comments - Table/field comments and AI annotations extracted from $metadata on v26+ servers (fm_odata_list_tables with includeDetails, enriched fm_odata_describe_sessions output)
Automatic FMFID Resolution (v26+) - Non-ASCII field names are automatically resolved to stable internal FMFID IDs in $filter expressions, eliminating double-quote escaping and preventing breakage on field renames. Falls back to auto-quoting on older servers.
Script Execution by FMSID (v26+) - Run FileMaker scripts by stable internal FMSID instead of script name, preventing integration breakage when scripts are renamed. fm_odata_list_scripts exposes IDs so agents can prefer ID-based calls.
Schema Editing (DDL) - Create/alter/delete tables, fields, and indexes via FileMaker’s OData schema endpoints (opt-in with FM_ALLOW_SCHEMA_EDITS=true)

Quick Start

Installation

# Via NPM (recommended)
npm install -g fms-odata-mcp

# Or local development
git clone https://github.com/fsans/fms-odata-mcp.git
cd fms-odata-mcp
npm install
npm run build

Note: This package was previously published as filemaker-odata-mcp. It has been renamed to fms-odata-mcp to align with the related fms-* repositories

Открыть полный README на GitHub

Установка

npx -y fms-odata-mcp

Новичок в MCP? Начните с руководства на mcpskill.org →

Конфигурация

{
  "mcpServers": {
    "filemaker-odata": {
      "command": "npx",
      "args": ["-y", "fms-odata-mcp"],
      "env": {
        "FM_SERVER": "https://your-filemaker-server.com",
        "FM_DATABASE": "YourDatabase",
        "FM_USER": "your-username",
        "FM_PASSWORD": "your-password",
        "FM_VERIFY_SSL": "true",
        "FM_ALLOW_SCHEMA_EDITS": "false"
      }
    }
  }
}