Supabase Role Provider

List raw role records from the Supabase roles table

{
  "data": [
    {
      "record_id": "rpr_11a2b3c4",
      "user_id": "usr_8f3a1b2c",
      "role": "coordinator",
      "source": "supabase_table",
      "jwt_claim": null,
      "fetched_at": "2026-03-26T10:00:00Z"
    },
    {
      "record_id": "rpr_22d3e4f5",
      "user_id": "usr_9d4e2c3f",
      "role": "admin",
      "source": "jwt_claim",
      "jwt_claim": "app_metadata.role",
      "fetched_at": "2026-03-26T10:01:00Z"
    }
  ],
  "pagination": {
    "page": 1,
    "limit": 20,
    "total": 56
  }
}

Get a single role record from Supabase by record ID

{
  "record_id": "rpr_11a2b3c4",
  "user_id": "usr_8f3a1b2c",
  "role": "coordinator",
  "source": "supabase_table",
  "jwt_claim": null,
  "fetched_at": "2026-03-26T10:00:00Z"
}

Insert a role record into the Supabase roles table

{
  "user_id": "usr_5c6d7e8f",
  "role": "mentor",
  "source": "supabase_table"
}

{
  "record_id": "rpr_33f4a5b6",
  "user_id": "usr_5c6d7e8f",
  "role": "mentor",
  "source": "supabase_table",
  "jwt_claim": null,
  "fetched_at": "2026-03-26T10:20:00Z"
}

Update a role record in the Supabase roles table

{
  "role": "coordinator",
  "source": "supabase_table"
}

{
  "record_id": "rpr_33f4a5b6",
  "user_id": "usr_5c6d7e8f",
  "role": "coordinator",
  "source": "supabase_table",
  "jwt_claim": null,
  "fetched_at": "2026-03-26T10:25:00Z"
}

Delete a role record from the Supabase roles table

{
  "deleted": true,
  "record_id": "rpr_33f4a5b6"
}

{
  "contract_summary": {
    "total_contracts": 410,
    "total_endpoints": 2416,
    "api_styles_used": [
      "rest"
    ]
  },
  "generated_at": "2026-03-26T06:55:53.316Z"
}