Skip to content

MCP migration: Airtable schema drift handling #14

@Mayank-glitch-cpu

Description

@Mayank-glitch-cpu

Tracking tradeoff from agentic MCP migration plan.

Open question: How should the MCP server adapt when a user's Airtable base schema doesn't match the hardcoded fields in mapToAirtableRecord (backend/src/services/airtable-sync.ts:9)?

Options:

  • Auto-detect via airtable_get_schema tool and build field map at runtime
  • Require user-supplied fieldMap in ~/.jobsync/config.json
  • Hybrid: auto-detect, allow override

Other concerns:

  • Graceful degradation when a field is missing (skip vs error)
  • Field type validation (single-select options, linked records)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions