fm_get_schema
Retrieve the database schema from FileMaker, including field names, types, and primary keys, to build accurate queries. Optionally list all available tables or get details for a specific table.
Instructions
Get the database schema (field names and types) from FileMaker.
Use this to discover exact field names, their types, and primary keys before constructing queries. Essential for building accurate filter and select expressions.
IMPORTANT: Always call this with a specific table name before querying that table for the first time — many field names contain spaces.
Schema is cached in memory for the session. If you need a table not in the standard list, just request it — the server will auto-discover it from FileMaker.
Args: table: Table name to get fields for (e.g., "Customers", "Orders"). Leave empty to list all available tables. You can request any table that exists in FileMaker — not just the standard list. Unknown tables are auto-discovered. refresh: Force re-fetch from live FM server. Use when you suspect the schema has changed (e.g., new fields added in FileMaker). Default uses cached DDL (instant, no API call). show_all: Show all fields including internal/system fields. Default hides internal fields (globals, speed fields, etc.) to keep schema output concise.
Returns: Formatted listing of fields with names, types, and annotations.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | No | ||
| refresh | No | ||
| show_all | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |