Lists the schemas (tables or objects) available on a connection for use as a bulk sync source, optionally including per-schema field details.

The response reflects what the connection currently has cached; if the upstream source has changed, trigger a refresh first with POST /api/connections/{id}/schemas/refresh.

These are the schemas available for selection, not the schemas already configured on any particular sync. To inspect schemas on a running sync, use GET /api/bulk/syncs/{id}/schemas.

Pass include_fields=true to receive per-schema field details in a single call. Omit it when you only need the schema list, as field enumeration can be slow for large sources.

{
  "data": {
    "schemas": [
      {
        "fields": [
          {
            "id": "email",
            "is_primary_key": true,
            "name": "Email",
            "primary_key_override": true,
            "remote_type": "varchar(255)"
          }
        ],
        "id": "contact",
        "name": "Contact"
      }
    ]
  }
}