stitch-data-mcp

MCP server for the Stitch Data Connect API. Manage sources, destinations, streams, and replication jobs directly from Cursor, Claude Desktop, or any MCP client.

Not to be confused with Google Stitch (the UI generation tool).

Requirements

• Node.js 18+
• A Stitch Data API access token (Account Settings → API Access Tokens)
• For extraction/load history: your Stitch client account ID (the numeric ID in your Stitch account URL)

Quick start

No install needed — configure your MCP client to run it via npx:

Cursor — .cursor/mcp.json

{
  "mcpServers": {
    "stitch-data": {
      "command": "npx",
      "args": ["-y", "stitch-data-mcp"],
      "env": {
        "STITCH_API_KEY": "your-api-token",
        "STITCH_CLIENT_ID": "your-account-id",
        "STITCH_READ_ONLY": "true"
      }
    }
  }
}

Claude Desktop — ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "stitch-data": {
      "command": "npx",
      "args": ["-y", "stitch-data-mcp"],
      "env": {
        "STITCH_API_KEY": "your-api-token",
        "STITCH_CLIENT_ID": "your-account-id",
        "STITCH_READ_ONLY": "true"
      }
    }
  }
}

Environment variables

| Variable | Required | Default | Description | |---|---|---|---| | STITCH_API_KEY | Yes | — | Your Stitch API access token | | STITCH_CLIENT_ID | No* | — | Your numeric Stitch account ID. Required for list_extractions, get_extraction_logs, and list_loads | | STITCH_READ_ONLY | No | "true" | Set to "false" to enable write operations (create, update, delete, pause, trigger jobs) |

Read-only vs read-write

By default the server starts in read-only mode — only GET operations are exposed. This is safe for exploration and monitoring without risk of accidental mutations.

Set STITCH_READ_ONLY=false to unlock all write tools.

| Mode | Tools | Set via | |---|---|---| | Read-only (default) | 16 tools — all list/get operations | STITCH_READ_ONLY=true | | Read-write | 37 tools — full API coverage | STITCH_READ_ONLY=false |

Available tools

Sources

| Tool | Mode | Description | |---|---|---| | list_sources | read | List all data sources | | get_source | read | Get a source by ID | | list_source_types | read | List all available source types | | get_source_type | read | Get connection properties for a source type | | get_connection_check | read | Get the last connection check result for a source | | list_import_api_tokens | read | List Import API token IDs for a source | | create_source | write | Create a new data source | | update_source | write | Update a source's properties | | pause_source | write | Pause replication for a source | | unpause_source | write | Resume a paused source | | delete_source | write | Delete a source | | generate_import_api_token | write | Generate an Import API token | | revoke_import_api_token | write | Revoke an Import API token |

Destinations

| Tool | Mode | Description | |---|---|---| | list_destinations | read | List all destinations | | list_destination_types | read | List available destination types | | get_destination_type | read | Get connection properties for a destination type | | create_destination | write | Create a new destination | | update_destination | write | Update a destination's connection properties | | delete_destination | write | Delete a destination |

Streams

| Tool | Mode | Description | |---|---|---| | list_streams | read | List all streams (tables) for a source | | get_stream_schema | read | Get the schema for a specific stream | | update_stream_metadata | write | Select streams and set replication method/key |

Replication

| Tool | Mode | Description | |---|---|---| | list_extractions | read | List recent extraction jobs (requires STITCH_CLIENT_ID) | | get_extraction_logs | read | Get logs for an extraction job (requires STITCH_CLIENT_ID) | | list_loads | read | List recent load attempts (requires STITCH_CLIENT_ID) | | start_replication_job | write | Trigger an immediate replication job | | stop_replication_job | write | Stop an in-progress replication job |

Notifications

| Tool | Mode | Description | |---|---|---| | list_email_notifications | read | List custom email notification recipients | | list_webhook_notifications | read | List webhook notification endpoints | | create_email_notification | write | Add an email notification recipient | | disable_email_notification | write | Disable an email recipient | | enable_email_notification | write | Re-enable an email recipient | | delete_email_notification | write | Delete an email recipient | | create_webhook_notification | write | Create a webhook endpoint | | disable_webhook_notification | write | Disable a webhook | | enable_webhook_notification | write | Re-enable a webhook | | delete_webhook_notification | write | Delete a webhook |

License

MIT