Connect TripWorks to Supabase

Both apps 316TripWorks 178Supabase 138

• Trigger
  Customer Created

  Triggers when a new customer is added in TripWorks.

• Trigger
  Customer Updated

  Triggers when a customer is added or any of the customer's details change.

• Trigger
  Payment Created

  Triggers when a payment is recorded on a trip.

• Trigger
  Trip Created

  Triggers when a new trip is booked.

• Trigger
  Trip Reserved

  Triggers when a trip reaches the reserved status.

• Trigger
  Trip Updated

  Triggers when a trip is booked or any of its details change.

• Trigger
  Waiver Signed

  Triggers when a guest signs a waiver.

• Action
  Activate Gift Card

  Makes a gift card active and sets its expiry from your account's gift card expiration policy: a date that many years ahead, or no expiry if the account does not expire gift cards. The balance is not changed, and the activation is recorded in the card's transaction history.

• Action
  Add Experience Waiver Config

  Attaches a waiver type to this experience as its next waiver, after the ones already there. Send `waiver_type_id`, the waiver type's internal numeric id. Returns 201 with the new waiver config. An experience can have at most 3 waiver configs and each waiver type can appear once.

• Action
  Assign Custom Field to Experience

  Asks a custom field on this experience, at the end of its order. Assigning a field that is already assigned changes nothing.

• Action
  Cancel Experience Timeslots

  Cancels timeslots and the trip orders booked on them. Choose what to cancel with exactly one of:

• Action
  Clear Callbot Schedule Override

  Ends the schedule override in force, if any, so the schedule decides again. Clearing when none is in force succeeds and changes nothing. Returns the callbot.

• Action
  Clear Resource Blackout Window

  Makes the resources available again for a window: blackouts inside it are deleted, one that spans it is split in two, and one that overlaps an edge is trimmed. Send `resource_ids` (at most 100, else 422 `too_many_resource_ids`), `start_time` and `end_time`; `note` is optional and recorded as the rea

• Action
  Clone Widget

  Creates a copy of a widget, the same way the Clone button in the widget builder does. The copy has the same type, selection, experiences, defaults and configuration (including custom CSS), its name is the original's name followed by " (Copy)", and it gets its own widget id; usage figures and past wi

• Action
  Create Experience Timeslot Config

  Creates a schedule and queues the generation of its timeslots for every activity in `experience_ids`. Replies 202 with `config_id`, `queued_experience_cnt`, `request_id` and `timeslot_cnt` (how many timeslots will be created in total), and a `Location` header pointing at the schedule.

• Action
  Delete Booking

  Removes the booking from its trip order, exactly as removing a guest in the back office does. Send no body. Removing the last booking on a trip order cancels the trip order (`trip_order_cancelled` true), except on an e-commerce cart that is still a draft, where the whole trip order is deleted instea

• Action
  Delete Callbot

  Permanently deletes a callbot, releases its phone number and removes it from the voice provider. Returns 424 `agent_teardown_failed` and keeps the callbot when the provider could not be cleaned up.

• Action
  Delete Callbot Pronunciation

  Removes a word from the list and updates every callbot with the voice provider in the background.

• Action
  Delete Customer

  Permanently deletes a customer. Blocked with 409 `in_use`, which includes the counts of what still references the customer, while the customer has bookings, trips, waivers, credit cards or CRM messages. To combine duplicate customers, use Merge instead of deleting.

• Action
  Delete Custom Field

  Permanently deletes a custom field. Blocked (409) while it has answers on any trip or booking, or is assigned to an experience; the response says how many. Fields that depended on it become always shown.

• Action
  Delete Custom Field Value

  Permanently deletes an answer. The custom field and the trip or booking are untouched.

• Action
  Delete Experience

  Permanently deletes an experience. Blocked (409) if it still has bookings, so cancel or move those bookings first.

• Action
  Delete Experience Customer Type

  Permanently deletes a customer type and its channel mappings. Blocked with 409 `default_type_not_removable` while it is the default, and 409 `type_has_bookings` once any booking uses it; hide it with `is_visible: false` instead.

• Action
  Delete Experience Timeslot

  Permanently deletes a timeslot. Blocked with 409 `delete_blocked_has_bookings` while it has bookings: cancel it instead.

• Action
  Delete Experience Waiver Config

  Removes a waiver config from this experience. Removing the last one turns off the experience's waiver requirement; see the warning on this resource.

• Action
  Delete Gift Card

  Permanently deletes a gift card. Refused while the card's trip is locked.

• Action
  Delete Knowledge Base

  Permanently deletes a knowledge base, its stored content, and its copy at the voice/chat provider.

• Action
  Delete Location

  Permanently deletes a location. Blocked with 409 `last_location` if this is the account's only location, or 409 `in_use` if an experience, trip, trip order, card reader or shipment still uses it; the error's `dependencies` object gives those counts. Set `is_live` to false to archive a location inste

• Action
  Delete Multiple Experience Timeslots

  Permanently deletes many timeslots, chosen with `ids` or `filters` exactly as for updating many. A timeslot that has bookings is skipped and counted in `blocked_cnt`; cancel it instead. `dry_run: true` returns `would_apply_cnt` and `blocked_cnt` and deletes nothing. More than 1,000 timeslots is refu

• Action
  Delete Promo Code

  Permanently deletes a promo code. Blocked with 409 `redeemed`, where `uses` is the number of redemptions, if the code has already been redeemed on an order. To stop such a code being used, set its `promo_code_status_id` to inactive instead.

• Action
  Delete Reseller

  Permanently deletes a reseller. Blocked (409 `in_use`, with the trip and invoice counts) while any trip or invoice still references the reseller; notes and cards on file are not counted.

• Action
  Delete Resource

  Permanently deletes a resource along with its blackouts, past and future. Blocked (409) while a real booking is assigned to it. `blackout_removed_cnt` says how many blackouts went with it.

• Action
  Delete Resource Blackout

  Removes a blackout; the resource is available again for that window.

• Action
  Delete Resource Usage

  Removes a usage: the guest is no longer assigned to the resource.

• Action
  Delete Restriction

  Permanently deletes a restriction. Every experience requires a restriction, so one that experiences still use is refused with 409 `requires_merge` unless you also send `merge_target_id`; the error's `uses` gives the number of experiences affected. Send `merge_target_id` in the request body, the id o

• Action
  Delete Review

  Permanently deletes a review. This cannot be undone and the review is not archived; any booking it was linked to is left unchanged.

• Action
  Delete Trip Note

  Permanently deletes a trip note.

• Action
  Delete Trip Source

  Permanently deletes a trip source. A built-in source cannot be deleted (409 `read_only`). If trips still use the source, the request is blocked (409 `requires_merge`, with the number of trips in `uses`) unless the body includes `merge_target_id`, the public id of another trip source: those trips are

• Action
  Delete Waiver Type

  Permanently deletes a waiver type. Blocked (409 `in_use_delete`) if it has been signed, is used by an activity or is required on a booking; archive it instead. The error includes `dependencies` with the signed, activity and booking counts.

• Action
  Delete Widget

  Deletes a widget. The widget disappears from the list and stops loading on your website (its embed code returns not found); its past widget events are kept and still report the widget's name. This cannot be undone through the API, so to switch a widget off temporarily set `is_active` to `false` inst

• Action
  Get Audit Log

  Returns one audit log entry by id, with every field change or event detail it contains.

• Action
  Get Availability Insights

  Returns how each timeslot is selling, with a summary over the selection. The overview above explains every field. Requires the `availability.read` scope; add `reports.read` for the revenue fields.

• Action
  Get Booking

  Returns a single booking by id, including `booking_status_id`, the price breakdown (see Money), `customer_id`, `trip_order_id`, `resources` (each assignment with resource name and type, start and end time, duration and note), `custom_fields` and `a

• Action
  Get Booking Check-in QR Code

  The QR code to print on, or show with, this guest's ticket, as a PNG data URI you can put in an `img` tag, plus the address it encodes (`check_in_url`). Scanning it opens that address, which needs a signed-in user of this account; the address identifies the guest by this id, never by name, so it wor

• Action
  Get Callbot

  Returns a single callbot by id with its weekly hours, its knowledge base and team member ids, and any schedule override in force.

• Action
  Get Callbot Pronunciation

  Returns a single pronunciation by id.

• Action
  Get Country

  Returns a single country by its `id` — the same public id other resources return as `country_id`.

• Action
  Get Country by Code

  Returns a single country by its two-letter ISO 3166-1 alpha-2 code (case-insensitive). Responds 404 when the code is not supported.

• Action
  Get Customer

  Returns a single customer by id.

• Action
  Get Custom Field

  Returns a single custom field by id, with its dropdown `options`, the `experience_ids` it is asked on and any dependency on another field.

• Action
  Get Custom Field Value

  Returns a single custom field answer by id.

• Action
  Get Experience

  Returns a single experience by id, with its ticket types and images.

• Action
  Get Experience Customer Type

  Returns one customer type of this experience. Returns 404 `mismatched_experience` when it belongs to a different experience.

• Action
  Get Experience Timeslot

  Returns one timeslot by id, including the ids of its assigned guides and its ticket types with their booked, held and availability counts (`customer_types`, the same name the activity uses for its ticket types; not part of the list). An id that matches no timeslot returns 404.

• Action
  Get Experience Timeslot Config

  Returns one schedule by id, with `generation`: for each activity, `state` (`idle`, `running` or `failed`) and `failed_at`. An id that matches no schedule returns 404.

• Action
  Get Gift Card

  Returns a single gift card by id, with its balance, status and recipient.

• Action
  Get Knowledge Base

  Returns a single knowledge base by id, including its text content for a `text` knowledge base.

• Action
  Get Knowledge Base Citation

  Returns a single knowledge base lookup by id.

• Action
  Get Location

  Returns one location by id. An id that matches no location returns 404.

• Action
  Get Manifest

  Returns the guest roster for a day or a range of up to 31 days, in departure order. The overview above explains how an entry is organised, the filters and how to check guests in. Requires both the `manifest.read` and `bookings.read` scopes.

• Action
  Get Payment Detail Report

  One row per successful payment in the date range, with the trip it was taken against. Amounts are integers in cents.

• Action
  Get Payout Detail Report

  One row per transaction inside each payout in the date range, with the payout it was paid out in and the trip's confirmation code. Columns starting `payout.` are the payout's own figures, repeated on every row of that payout, so do not add them up across rows; use Payouts for payout totals. Amounts

• Action
  Get Payouts Report

  One row per payout, the deposits made to your bank account. `gross_amount` is Charges and `net_amount` is the Deposit Amount. Amounts are integers in the smallest currency unit (cents for USD), and `currency` names it; refunds and fees are negative. Use Payout Detail for the transactions inside each

• Action
  Get Phone Call

  Returns a single phone call by id, with its transcript and tags.

• Action
  Get Phone Call Tag

  Returns a single phone call tag by id.

• Action
  Get Promo Code

  Returns a promo code, including the experiences, ticket types and date windows it applies to.

• Action
  Get Report Run

  Returns one report run.

• Action
  Get Reseller

  Returns a single reseller by id.

• Action
  Get Resource

  Returns a single resource by id.

• Action
  Get Resource Blackout

  Returns a single blackout by id.

• Action
  Get Resource Usage

  Returns a single resource usage by id.

• Action
  Get Restriction

  Returns one restriction by id. An id that matches no restriction returns 404.

• Action
  Get Review

  Returns a single review by its id, including its derived sentiment fields. Responds 404 for an id that does not exist in your account.

• Action
  Get Sales Detail Report

  One row per trip in the date range. Amounts are integers in cents.

• Action
  Get Team Member

  Returns one team member by id, including the permission groups they belong to. An id that matches no visible team member returns 404.

• Action
  Get Trip

  Returns a single trip by id with its full tree: `trip_orders` (every activity on the trip, including cancelled ones) and each order's `bookings`, fully detailed. Each booking lists its `addons`. A deleted trip (removed by staff, not a cancellation) is still returned; its `trip_status` is `deleted`.

• Action
  Get Trip Note

  Returns a single trip note by id.

• Action
  Get Trip Order Detail Report

  One row per booked trip order on a reserved trip in the date range, with its experience and trip. Amounts are integers in cents.

• Action
  Get Trip Payment

  Returns a single payment or refund by id.

• Action
  Get Trip Source

  Returns a single trip source by id.

• Action
  Get Waiver

  Returns a single signed waiver by id, with the same fields as the list.

• Action
  Get Waiver Document Link

  Returns a link to the signed PDF of this waiver, valid for five minutes. Each call issues a new link and writes an audit log entry naming the key that asked.

• Action
  Get Waiver Type

  Returns a single waiver type by id, including its waiver text and every signer requirement.

• Action
  Get Widget

  Returns a single widget by the widget id from its embed code. Responds 404 for an id that does not exist in your account, or belongs to a deleted widget.

• Action
  Get Widget Funnel

  A conversion funnel over the widget events: how many visitor sessions reached each stage, with the percent of the first stage and of the previous stage. Each stage counts the distinct sessions that fired that event in the period, in any order, so a visitor counts once per stage however many times th

• Action
  Get Widget Log

  Returns a single widget event by its id. Responds 404 for an id that does not exist in your account.

• Action
  List Audit Log

  Returns audit log entries, newest first, optionally filtered and sorted. The overview above explains what is recorded, how to read an entry and how to filter by record, team member, entry type and date.

• Action
  List Blackouts of Resource

  Returns the blackouts on one resource: the times it is unavailable, earliest first.

• Action
  List Booking Add-ons

  Returns the add-ons on this booking (options the guest picked, such as an extra hour or a meal choice), oldest first, each with its `addon_title`: exactly the booking's `addons`. The `total` of every line whose `price_adjust_type_id` is not 2 adds up to the booking's `addons_total`, and `total_gross

• Action
  List Booking Custom Fields

  Returns the booking's custom fields: exactly the entries of the booking's `custom_fields`, `{id, slug, name, type, value, required}` (plus `unit`, `lbs` or `kg`, on Weight fields), for every booking-level custom field that applies to its experience, in back-office order, answered or not (`value` is

• Action
  List Booking Products

  Returns the products (extras sold with the ticket, such as a photo package or a rental) on this booking, oldest first. It is a full breakdown of the booking's `products_total`: the `total` of every line adds up to `products_total`, and `total_gross` adds up to `products_total_gross`. Amounts are int

• Action
  List Booking Resource Usages

  Returns the resource usages on a booking: the resources (boats, vehicles, guides and so on) this guest is assigned to, earliest first.

• Action
  List Bookings

  Returns a paginated list of bookings, newest first (highest `id` first; ids only ever increase, so this is creation order). Filter by `trip_order_id`, `customer_id`, `booking_status_id`, `experience_customer_type_id` and `booking_waiver_status` (a slug). Only these indexed fields can be filtered, an

• Action
  List Booking Statuses

  Returns the account's booking statuses in display order. Use an `id` from this list as `booking_status_id` when setting a booking's status or adding a booking. Custom statuses share the slug `user`, so always identify a status by `id`, never by `slug` or `name`.

• Action
  List Booking Waivers

  Returns the booking's waiver requirements: exactly the entries of the booking's `waivers`, `{waiver_type_id, name, status, has_signed_waiver, waiver_id}`, one for every waiver requirement of its experience, signed or not. `status` is `signed` or `unsigned` (a requirement with no record is `unsigned`

• Action
  List Callbot Pronunciations

  Returns the account's pronunciation list ordered by word, paginated. Filter by `word` or `say`; `?sort=word` and `?sort=-word` change the order.

• Action
  List Callbots

  Returns a paginated list of callbots ordered by name, one flat row each without the weekly hours, the knowledge base and team member ids or the schedule override details. Filter by `name`, `is_active`, `voice_id`, `phone_number`, `twilio_number`, `notification_mode`, `hours_mode`, the `can_*` flags,

• Action
  List Callbot Voices

  Returns the voices a callbot can use: the `id` is the value to send as `voice_id` when creating or updating a callbot. This is a short list returned whole, without pagination or a `meta` block.

• Action
  List Countries

  Returns a paginated list of supported countries, ordered by name. Filter by code, name, three-letter code or dialing code, and sort by `name` or `code`.

• Action
  List Customers

  Returns customers.

• Action
  List Custom Fields

  Returns a paginated list of custom fields in the account-wide order. Filter by `custom_field_map` (`trip` or `booking`), `custom_field_type` slug, `visibility`, `is_required`, `internal_name`, `title`, `parent_custom_field_id`, or by ranges on `sort_order`, `min_value`, `max_value` and `created_at`.

• Action
  List Custom Field Values

  Returns a paginated list of custom field answers, newest first. Filter by `booking_id` for one guest's answers, `trip_id` for one reservation's, or `custom_field_id` for every answer to one field.

• Action
  List Experience Customer Types

  Returns every customer type of this experience in display order, lowest `sort_order` first. The list is not paginated. Narrow it with the filters below, for example `?is_visible=true` or `?name[contains]=adult`. Customer types with no value for a numeric filter never match it, and `is_group=false` m

• Action
  List Experience Custom Fields

  Returns the custom fields asked on this experience, in the order guests and staff see them. Guests answer trip fields once per reservation and booking fields once per guest.

• Action
  List Experiences

  Returns a paginated list of experiences, ordered by name unless you pass `sort`. Filter by name, location, status, capacity type and the other settings listed below.

• Action
  List Experience Timeslot Configs

  Returns a paginated list of schedules in id order unless you pass `sort`. Filter by `id`, `name`, `start_date` and `end_date`. Generation status is only on a single schedule.

• Action
  List Experience Timeslots

  Returns a paginated list of timeslots in id order (creation order), optionally filtered and sorted. Each timeslot carries its `guide_ids`. Filter by `id`, `experience_id`, `status`, `start_time`, `is_anytime`, `schedule_id` and the three visibility flags.

• Action
  List Experience Waiver Configs

  Returns every waiver config attached to this experience in display order, lowest `sort_order` first. The list is not paginated. A config's `waiver_option_overrides` is left out when it has no value.

• Action
  List Gift Cards

  Returns a paginated list of gift cards, newest first unless you pass `sort`. Filter by status, balance, expiry date, trip, code or style.

• Action
  List Gift Card Styles

  Returns the gift card styles available to choose from: the value to use for `gift_card_style_id` when creating or updating a gift card. Styles are read-only here; they are managed in the back office.

• Action
  List Knowledge Base Citations

  Returns a paginated list of knowledge base lookups, optionally filtered and sorted.

• Action
  List Knowledge Bases

  Returns a paginated list of knowledge bases, optionally filtered and sorted. Text content is only returned when fetching one knowledge base.

• Action
  List Locations

  Returns a paginated list of locations, ordered by name unless you pass `sort`, optionally filtered and sorted. Filter by `id`, `name`, `is_live` or `country_id`.

• Action
  List Phone Calls

  Returns phone calls, newest first unless you pass `sort`, optionally filtered and sorted. The overview above explains where calls come from, how to read one and how to filter.

• Action
  List Phone Call Tags

  Returns phone call tags, optionally filtered. The overview above explains the tag types and how to filter.

• Action
  List Promo Codes

  Returns a page of promo codes, up to 25, ordered by code unless you pass `sort`. Rows leave out `experiences`, `customerTypes` and `promo_code_dates`; Get one includes them. See Finding promo codes above for filter and sort examples.

• Action
  List Report Runs

  Returns a paginated list of report runs across all reports, newest first. Filter with `?report_type=sales_detail.1`, `?report_run_status=succeeded|pending|failed` or `?created_at[gte]=`. Sort with `?sort=created_at`.

• Action
  List Report Types

  Returns every report you can run, with the parameters each one takes and every column it can return.

• Action
  List Resellers

  Returns a page of resellers, up to 25, ordered by id unless you sort. See Finding resellers above for filter and sort examples.

• Action
  List Resource Blackouts

  Returns a paginated list of blackouts, earliest first by default. Filter by `resource_id` for one resource, or by `start_time`/`end_time` with `[gte]` and `[lte]`. To find blackouts overlapping a window send `end_time[gte]=<window start>&start_time[lte]=<window end>`. Time filters take any RFC 3339

• Action
  List Resource Groups

  Returns the resource groups available to choose from: the value to use for `resource_type_id` when creating or updating a resource.

• Action
  List Resource Icons

  Returns the icons available to choose from: the value to use for `resource_icon` when creating or updating a resource.

• Action
  List Resources

  Returns a paginated list of resources, ordered by name by default. Filter by `name`, by `resource_type_id` for one group, by `resource_icon` slug, by `pax` range, or by `color`.

• Action
  List Resource Usages

  Returns a paginated list of resource usages, earliest first by default. Filter by `booking_id` for one guest, by `resource_id` for one resource, or by `start_time`/`end_time` with `[gte]` and `[lte]`. To find usages overlapping a window send `end_time[gte]=<window start>&start_time[lte]=<window end>

• Action
  List Restrictions

  Returns a paginated list of restrictions, optionally filtered and sorted. The default order applies when `sort` is omitted. Every field can be filtered; the `*_min`, `*_max`, hours and days fields accept `gte` and `lte`, and the names accept `contains` and `begins_with`.

• Action
  List Reviews

  Returns a paginated list of reviews, newest first by default. Filter by `id` (also `[gte]`/`[lte]`), `rating`, `sentiment_positive`, `sentiment_negative` or `sentiment_neutral` (each also `[gte]`/`[lte]`), `is_approved`, `name` or `location` (also `[contains]`/`[begins_with]`), `overall_comment` or

• Action
  List Team Members

  Returns a paginated list of team members in the order they were added unless you pass `sort`, optionally filtered and sorted. TripWorks-managed accounts and accounts linked to a reseller or affiliate are never included. The list leaves out `groups`; get one team member to see their permission groups

• Action
  List Trip Custom Fields

  Returns the trip's own custom fields: `{id, slug, name, type, value, required}` (plus `unit`, `lbs` or `kg`, on Weight fields) for every trip-level custom field asked on any of its activities, in back-office order, answered or not (`value` is null when unanswered). Guest-level fields are on each boo

• Action
  List Trip Notes

  Returns a paginated list of trip notes, newest first by default. Filter by `trip_id` to get every note on one trip, by `user_avatar_id` for one author, or by `created_at[gte]`/`created_at[lte]` for a time range.

• Action
  List Trip Payments

  Returns a paginated list of payments and refunds, newest first by default, including those on draft and deleted trips. Filter by `trip_id` to get every payment on one trip, by `payment_status`, `payment_type_id` or `payment_direction_id`, by `created_at[gte]`/`created_at[lte]` for a time range, or b

• Action
  List Trips

  Returns a paginated list of trips ordered by activity date with the latest first (upcoming trips before past ones), then newest created, one flat row per trip with no `trip_orders` or `bookings`. Filter by `confirmation_code`, `trip_status`, `trip_type`, `customer_id`, `trip_source_id`, `reseller_id

• Action
  List Trip Sources

  Returns a page of trip sources, up to 25. See Finding trip sources above for filter and sort examples.

• Action
  List Usages of Resource

  Returns the resource usages on one resource: the guests assigned to it, earliest first.

• Action
  List Waivers

  Returns a paginated list of signed waivers, newest signed first, one row per signature. Filter by `waiver_type_id`, `customer_id`, `trip_order_id`, `is_waiver_adult`, a date range on `created_at` (`created_at[gte]`, `created_at[lte]`), a date of birth or range on `dob`, text on `first_name`, `last_n

• Action
  List Waiver Types

  Returns a paginated list of waiver types, ordered by name, optionally filtered and sorted. Every field can be filtered: `name` and `title` with `eq`, `contains` or `begins_with`; `body` and `body_minor` with `contains`; the age limits with `eq`, `gte` or `lte`; the flags and `waiver_type_status` (a

• Action
  List Widget Logs

  Returns a paginated list of widget events, newest first by default. With no lower bound on `created_at` the list covers the 30 days up to now, or up to `created_at[lte]` when only that is given; pass `created_at[gte]` to look further back. Filter by `id` (an exact match), `created_at` (also `[gte]`/

• Action
  List Widgets

  Returns a paginated list of widgets, ordered by name. Deleted widgets are never included. Filter by `name` (also `[contains]`/`[begins_with]`), `widget_type`, `selection_type`, `default_view`, `default_language`, `embed_type`, `is_active`, `clicks` or `embeds` (each also `[gte]`/`[lte]`), or `create

• Action
  Mark Booking Waivers Signed

  Marks every waiver the booking's experience requires as signed, using the same per-requirement step as `.

• Action
  Mark One Booking Waiver Signed

  Marks a single one of the booking's waiver requirements as signed. The requirement is identified by its `waiver_type_id` from the booking's `waivers`. Send no body. This is a staff override: it records that requirement as signed without a signed waiver document

• Action
  Merge Customers

  Merges two or more customers into one and permanently deletes the duplicates. Send at least two customer ids in `ids`. TripWorks chooses the destination: the customer with the most complete name, phone and email, and the oldest record if they tie. Blank phone, country, street address, city, state, p

• Action
  Reload Gift Card

  Adds `amount`, a positive whole number of cents, to both the original and the current balance, and sets the card to `pending` until the paying trip settles. Refused for a deleted or expired card.

• Action
  Reorder Custom Field

  Moves the field to a position in the account-wide order (0 is first) and shifts the fields in between. A position past the end puts it last. Returns the field with its new `sort_order`.

• Action
  Reorder Experience Custom Fields

  Sets the order the experience's custom fields are asked in. `custom_field_ids` lists assigned field ids in the order you want; fields you leave out keep their relative order after the listed ones.

• Action
  Reorder Experience Waiver Configs

  Sets the display order of this experience's waiver configs. Send `order` as a list that contains the `id` of every waiver config on the experience exactly once, in the order you want. An empty list returns 400. An id that is not a waiver config of this experience, or a list that leaves one out, retu

• Action
  Run Analytics Query

  Aggregates over your data: counts, sums, averages, minimums and maximums, optionally over a date range with an automatic comparison to the preceding period, and grouped by a dimension or by time. It also returns the headline business metrics.

• Action
  Set Booking Status

  Sets the booking's status to any of the account's booking statuses, the same choice the back office offers (for example checked in, no-show, or back to not checked in).

• Action
  Set Callbot Schedule Override

  Starts a schedule override that beats the schedule, replacing any already in force. `mode` is `answer` (answer every call) or `transfer` (send every call to a person). `duration` is `next_schedule` (until the schedule next changes), `custom` (until `until`, a date and time in the account's timezone,

• Action
  Set Status for Multiple Bookings

  Sets the status of up to 50 bookings in one call, for example to check in a whole party. Identify the target status by `booking_status_id` or by `status`, the shorthand for a built-in status. Pass `dry_run: true` to see what wo

• Action
  Sync Callbot

  Queues another attempt at setting the callbot up with the voice provider, for one whose last sync failed or is stuck. Returns immediately with the status the sync is now in (`sync_status`).

• Action
  Sync Callbot Prompt from Template

  Brings the callbot up to date with the latest TripWorks callbot template at the voice provider. Returns 409 `template_sync_failed` with a plain-language message when the provider rejects it, and `notice` names any knowledge base documents that were dropped to let it through.

• Action
  Sync Knowledge Base

  Queues a re-sync of the knowledge base to the voice/chat provider. Returns immediately; poll `sync_status` for progress. Blocked (409) for a type that cannot be synced.

• Action
  Unassign Custom Field from Experience

  Stops asking a custom field on this experience. Answers already given are kept. Returns 404 if the field is not assigned to the experience.

• Action
  Update Callbot

  Updates a callbot and queues re-syncing it with the voice provider. Only the fields you include are changed; omitted fields are left as they are. The `schedule_override_*` fields cannot be written here: use the set and clear schedule override actions.

• Action
  Update Callbot Pronunciation

  Changes a word or its respelling and updates every callbot with the voice provider in the background. Only the fields you include are changed.

• Action
  Update Customer

  Updates a customer and returns it. Only the fields you include are changed; omitted fields are left as they are. Write `sms_paused: false` to let texts go to the customer's number again after the carrier reported it cannot receive them; it is refused (422) for a customer who opted out, which only th

• Action
  Update Custom Field

  Updates a custom field. Only the fields you include are changed. `custom_field_type` and `custom_field_map` cannot be changed: sending the value the field already has is accepted, anything else is rejected with 422. When you send `options` or `experience_ids` the list you send replaces the current o

• Action
  Update Custom Field Value

  Changes the answer. `value` is the only field that can be changed; the custom field and the trip or booking are fixed. Send `null` to empty the answer.

• Action
  Update Experience

  Updates an experience. Only the fields you include are changed; omitted fields are left as they are. The status, ticket types and images cannot be changed here; ticket types are managed at `/rest/experiences/{id}/customer-types`, except which one is the default: set `default_customer_type_id` here.

• Action
  Update Experience Customer Type

  Changes a customer type. Only the fields you include are changed. `is_default` cannot be written here: set `default_customer_type_id` on the experience to change the default. `null` clears `description`, `pax_fixed`, `pax_min`, `pax_max`, `deposit_amount` and `deposit_percent`. `capacity` is only ac

• Action
  Update Experience Timeslot

  Updates a timeslot. Only the fields you include are changed, and the change is all or nothing: if any field is refused, none is applied.

• Action
  Update Experience Waiver Config

  Changes which waiver type a config uses with `waiver_type_id`, who signs it for each ticket type with `waiver_option_overrides`, or both. Only the fields you include are changed. Send `waiver_option_overrides` as `null` to clear the overrides. Each override value must be 1 (Adult), 2 (Minor) or 3 (C

• Action
  Update Gift Card

  Updates a gift card. Only the fields you include are changed; omitted fields are left as they are. `trip_id` cannot be changed after creation, and the balance and status cannot be written.

• Action
  Update Knowledge Base

  Updates a knowledge base and queues a re-sync. Only the fields you include are changed — omitted fields are left as-is. The type cannot be changed (409).

• Action
  Update Location

  Updates a location. Only the fields you include are changed — omitted fields are left as-is.

• Action
  Update Multiple Experience Timeslots

  Makes the same change to many timeslots: the same fields and the same decisions as updating one. Choose them with `ids`, or with `filters`. Add `dry_run: true` to see what would happe

• Action
  Update Promo Code

  Updates a promo code and returns it. Only the fields you include are changed; omitted fields are left as they are. The experiences and ticket types of a code cannot be changed: `experience_ids` and `customer_type_ids` are accepted on Create only, and sending them here is rejected with 422 `unknown_f

• Action
  Update Reseller

  Updates a reseller. Only the fields you include are changed — omitted fields are left as-is. The reseller type is set at creation and cannot be changed: sending `reseller_type_id` is rejected with 422 `unknown_fields`, as is any other field that is not writable (including `collect_type` and `commiss

• Action
  Update Resource

  Updates a resource. Only the fields you include are changed; omitted fields are left as they are. `resource_type_id` can be null to remove the resource from its group.

• Action
  Update Resource Blackout

  Changes the note of a blackout; `note` is the only field that can be changed, and null clears it. To change the times, clear the window and create a new blackout.

• Action
  Update Resource Usage

  Changes a usage in one atomic write. Only the fields you include are changed. `resource_id` moves the guest to another resource, `start_time` and `end_time` or `duration` change the window (without `end_time` or `duration` the length is kept), and `internal_note` sets or clears the staff note. The b

• Action
  Update Restriction

  Updates a restriction. Only the fields you include are changed; omitted fields are left as they are. The change applies to every experience that uses the restriction.

• Action
  Update Review

  Partially updates a review. Only the fields you include are changed — omitted fields are left as-is, and an explicit `null` clears nullable fields such as `location` and `experience_id` (comments are cleared and then omitted from responses; `name`, `rating` and `review_type` cannot be cleared). Chan

• Action
  Update Team Member

  Updates a team member's profile. Only the fields you include are changed. `email` and `cell_phone` are read only, and login passwords and permission-group assignment cannot be changed through the API. A failed validation returns 422 with an `errors` object keyed by field.

• Action
  Update Trip Note

  Changes the text of a note and marks it as edited. `text` is the only field that can be changed after creation; the trip and author are fixed.

• Action
  Update Trip Payment

  Changes the note and the details of the payment's own type: `notes` for any payment, `check_number` and `check_date` together for a check, `wire_date` for a wire, `voucher_number` for a voucher. Send `notes` on its own, not with a detail field (refused even as `null` or an empty string); alone, `nul

• Action
  Update Trip Source

  Updates a trip source and returns it. Only the fields you include are changed; omitted fields are left as they are. On a built-in source, a new `name` is ignored. `is_read_only` and `category_slug` cannot be set: sending either is rejected with 422 `unknown_fields`.

• Action
  Update Waiver Type

  Updates a waiver type. Only the fields you include are changed; omitted fields are left as-is. Setting `waiver_type_status` to `archived` is refused with 409 `in_use_archive` while an activity uses the waiver type. Sending `waiver_type_status: null` is rejected with 422; the status cannot be cleared

• Action
  Update Widget

  Partially updates a widget: only the fields you include are changed. Writable fields are `name`, `widget_type`, `selection_type`, `experience_ids` (the full list, as ids from `/rest/experiences`; it replaces the existing list), `default_view`, `default_language`, `embed_type`, `is_active` and `custo

• Action
  Alpha Create Api Key

  Creates a 'publishable' or 'secret' API key for an existing Supabase project, optionally with a description; 'secret' keys can have customized JWT templates.

• Action
  Alpha Creates A New Api Key For The Project

  Creates a 'publishable' or 'secret' api key for an existing supabase project, optionally with a description; 'secret' keys can have customized jwt templates.

• Action
  Alpha Delete Api Key

  Permanently deletes a specific API key (identified by `id`) from a Supabase project (identified by `ref`), revoking its access.

• Action
  Alpha Delete Third Party Auth Integration

  Removes a third-party authentication provider (e.g., Google, GitHub) from a Supabase project's configuration; this immediately prevents users from logging in via that method.

• Action
  Alpha Get A Third Party Integration

  Retrieves the detailed configuration for a specific third-party authentication (tpa) provider, identified by `tpa id`, within an existing supabase project specified by `ref`.

• Action
  Alpha Lists All Third Party Auth Integrations

  Lists all configured third-party authentication provider integrations for an existing supabase project (using its `ref`), suitable for read-only auditing or verifying current authentication settings.

• Action
  Alpha List Third Party Auth Integrations

  Lists all configured third-party authentication provider integrations for an existing Supabase project (using its `ref`), suitable for read-only auditing or verifying current authentication settings.

• Action
  Alpha Removes A Third Party Auth Integration

  Removes a third-party authentication provider (e.g., google, github) from a supabase project's configuration; this immediately prevents users from logging in via that method.

• Action
  Alpha Update Api Key

  Updates an existing Supabase project API key's `description` and/or `secret_jwt_template` (which defines its `role`); does not regenerate the key string.

• Action
  Alpha Updates An Api Key For The Project

  Updates an existing supabase project api key's `description` and/or `secret jwt template` (which defines its `role`); does not regenerate the key string.

• Action
  Apply A Migration

  Tool to apply database migrations to a Supabase project. Use when you need to execute SQL schema changes, create tables, alter columns, or run other DDL/DML operations as part of a tracked migration. This is a Beta feature in the Supabase Management API.

• Action
  Beta Activates A Vanity Subdomain For A Project

  Activates a vanity subdomain for the specified supabase project, requiring subsequent dns configuration for the subdomain to become operational.

• Action
  Beta Activate Vanity Subdomain

  Activates a vanity subdomain for the specified Supabase project (e.g., 'my-brand.supabase.co'). Important notes: - Vanity subdomains require a paid plan (Pro/Team/Enterprise) - Usage of vanity subdomains and custom domains is mutually exclusive - After activation, your project's auth services will no longer work on the original {project-ref}.supabase.co hostname - Schedule a downtime window to update client code and OAuth providers before activating

• Action
  Beta Checks Vanity Subdomain Availability

  Checks if a specific vanity subdomain is available for a supabase project; this action does not reserve or assign the subdomain.

• Action
  Beta Check Vanity Subdomain Availability

  Checks if a specific vanity subdomain is available for a Supabase project; this action does not reserve or assign the subdomain.

• Action
  Beta Enable Database Webhooks

  Enables database webhooks for the Supabase project `ref`, triggering real-time notifications for INSERT, UPDATE, or DELETE events.

• Action
  Beta Get Project Network Bans

  Retrieves the list of banned IPv4 addresses for a Supabase project using its unique project reference string; this is a read-only operation.

• Action
  Beta Get Project Network Restrictions

  Retrieves the network restriction settings (IP allowlists) for a Supabase project. Use this action to: - Check which IPv4/IPv6 CIDR blocks are allowed to connect to the project's database - Verify if network restrictions are enabled (entitlement: "allowed") or disabled ("disallowed") - Audit current network security configuration - Check if network restrictions have been modified (old_config present) Note: Default values 0.0.0.0/0 (IPv4) and ::/0 (IPv6) mean all IPs are allowed. Network restrictions require a Pro, Team, or Enterprise plan.

• Action
  Beta Get Project Pgsodium Config

  Retrieves the PGSodium configuration, including the root encryption key, for an existing Supabase project identified by its `ref`.

• Action
  Beta Get Project Ssl Enforcement Config

  Retrieves the SSL enforcement configuration for a specified Supabase project, indicating if SSL connections are mandated for its database.

• Action
  Beta Get Project S Ssl Enforcement Configuration

  Retrieves the ssl enforcement configuration for a specified supabase project, indicating if ssl connections are mandated for its database.

• Action
  Beta Gets Current Vanity Subdomain Config

  Fetches the current vanity subdomain configuration, including its status and custom domain name, for a supabase project identified by its reference id.

• Action
  Beta Gets Project S Network Bans

  Retrieves the list of banned ipv4 addresses for a supabase project using its unique project reference string; this is a read-only operation.

• Action
  Beta Gets Project S Network Restrictions

  Retrieves the current network restriction settings (e.g., ip whitelists) for a supabase project using its reference id; this is a read-only operation for auditing or verifying network security.

• Action
  Beta Gets Project S Pgsodium Config

  Retrieves the pgsodium configuration, including the root encryption key, for an existing supabase project identified by its `ref`.

• Action
  Beta Get Vanity Subdomain Config

  Fetches the current vanity subdomain configuration, including its status and custom domain name, for a Supabase project identified by its reference ID.

• Action
  Beta Remove Network Bans

  Removes specified ipv4 addresses from a supabase project's network ban list, granting immediate access; ips not currently banned are ignored.

• Action
  Beta Run Sql Query

  Executes a given sql query against the project's database; use for advanced data operations or when standard api endpoints are insufficient, ensuring queries are valid postgresql and sanitized. use the get table schemas or generate type script types tool to retrieve the table schema, then base your query on it.

• Action
  Beta Update Project Network Restrictions

  Updates and applies network access restrictions (IPv4/IPv6 CIDR lists) for a Supabase project, which may terminate existing connections not matching the new rules.

• Action
  Beta Updates Project S Network Restrictions

  Updates and applies network access restrictions (ipv4/ipv6 cidr lists) for a supabase project, which may terminate existing connections not matching the new rules.

• Action
  Config Pgsodium Update With Root Key Warning

  Critically updates or initializes a supabase project's pgsodium root encryption key for security setup or key rotation, requiring secure backup of the new key to prevent irreversible data loss.

• Action
  Count Action Runs

  Counts the number of action runs for a Supabase project using a HEAD request. Use this when you need to retrieve the total count of action runs without fetching the full list of runs.

• Action
  Create A Database Branch

  Creates a new, isolated database branch from an existing supabase project (identified by `ref`), useful for setting up separate environments like development or testing, which can optionally be linked to a git branch.

• Action
  Create A Function

  Creates a new serverless edge function for a supabase project (identified by `ref`), requiring valid javascript/typescript in `body` and a project-unique `slug 1` identifier.

• Action
  Create Bulk Secrets

  Tool to bulk create secrets for a Supabase project. Use when you need to create multiple project secrets at once. Each secret name must not start with SUPABASE_.

• Action
  Create Login Role

  Creates a temporary CLI login role for database access with specified permissions; use when setting up CLI authentication for development or administrative tasks.

• Action
  Create Project Signing Key

  Create a new signing key for JWT authentication in a Supabase project. The key is created in standby status by default and must be activated separately.

• Action
  Creates A New Sso Provider

  Creates a new saml 2.0 single sign-on (sso) provider for a supabase project, requiring either `metadata xml` or `metadata url` for saml idp configuration.

• Action
  Creates A New Third Party Auth Integration

  Call this to add a new third-party authentication method (oidc or jwks) to a supabase project for integrating external identity providers (e.g., for sso); the api may also support `custom jwks` if sent directly.

• Action
  Create Signed Upload Url

  Create a two-hour signed authorization for uploading a Storage object. OAuth connections need ``secrets:read``. Fine-grained personal access tokens need ``api_gateway_keys_read`` and ``api_gateway_keys_secret_read``.

• Action
  Create Sso Provider

  Creates a new SAML 2.0 Single Sign-On (SSO) provider for a Supabase project, requiring either `metadata_xml` or `metadata_url` for SAML IdP configuration.

• Action
  Create Third Party Auth Integration

  Call this to add a new third-party authentication method (OIDC or JWKS) to a Supabase project for integrating external identity providers (e.g., for SSO); the API may also support `custom_jwks` if sent directly.

• Action
  Delete A Database Branch

  Permanently and irreversibly deletes a specific, non-default database branch by its `branch id`, without affecting other branches.

• Action
  Delete A Function

  Permanently deletes a specific edge function (by `function slug`) from a supabase project (by `ref`); this action is irreversible and requires prior existence of both project and function.

• Action
  Delete Edge Function

  Deletes an Edge Function from a Supabase project by its slug. Use this action when you need to permanently remove a deployed Edge Function that is no longer needed or should be replaced. This action is irreversible — the function cannot be recovered once deleted, though you can redeploy it from source if needed.

• Action
  Delete Login Roles

  [Beta] Deletes existing login roles used by the Supabase CLI for the specified project. Use when you need to remove CLI authentication roles that were previously created for project access.

• Action
  Delete Project Vanity Subdomain

  Permanently and irreversibly deletes an active vanity subdomain configuration for the specified supabase project, reverting it to its default supabase url.

• Action
  Delete Sso Provider

  Deletes a specific SSO provider by its ID (`provider_id`) from a Supabase project (`ref`), which disables it and returns its details; ensure this action will not inadvertently lock out users.

• Action
  Deploy Function

  Deploys edge functions to a supabase project using multipart upload.

• Action
  Disable Project Readonly

  Temporarily disables a supabase project's read-only mode for 15 minutes to allow write operations (e.g., for maintenance or critical updates), after which it automatically reverts to read-only.

• Action
  Disables Preview Branching

  Disables the preview branching feature for an existing supabase project, identified by its unique reference id (`ref`).

• Action
  Generate Typescript Types

  Generates and retrieves TypeScript types from a Supabase project's database; any schemas specified in `included_schemas` must exist in the project.

• Action
  Generate Type Script Types

  Generates and retrieves typescript types from a supabase project's database; any schemas specified in `included schemas` must exist in the project.

• Action
  Get Auth Config

  Retrieves the complete authentication configuration for a Supabase project. Use this action when you need to inspect auth settings, OAuth provider configurations, MFA policies, email/SMS templates, security policies, or webhook hooks. Returns all auth configuration fields including enabled providers (Apple, Google, GitHub, etc.), JWT settings, rate limits, password requirements, session policies, and mailer configuration. This is a read-only operation that does not modify any settings.

• Action
  Get Available Regions

  Tool to get the list of available regions for creating a new Supabase project. Use when you need to determine which regions are available for project deployment, or to get region recommendations based on geographic location and instance size requirements. Note: This is a Beta endpoint.

• Action
  Get Branch

  Retrieves detailed information about a specific database branch by its name and project reference. Use this to check branch status, configuration, and metadata before performing operations on the branch.

• Action
  Get Database Branch Config

  Retrieves the read-only configuration and status for a supabase database branch, typically for monitoring or verifying its settings.

• Action
  Get Database Metadata

  Gets database metadata for the given project. Returns information about databases, schemas, and tables structure. Note: This endpoint is deprecated and may be removed in future versions.

• Action
  Get Function

  Retrieves detailed information, metadata, configuration, and status for a specific Edge Function using its project reference ID and function slug.

• Action
  Get Function Body

  Retrieves the source code (body) for a specified serverless Edge Function using its project reference and function slug; this is a read-only operation that does not execute the function or return runtime logs.

• Action
  Get Legacy Signing Key

  Retrieves the signing key information for the JWT secret imported as signing key for this project. This endpoint is deprecated and will be removed in the future; check for HTTP 404 Not Found which indicates the endpoint is no longer available.

• Action
  Get Migration

  Retrieves a specific database migration entry from the migration history using its version identifier. Use when you need to inspect migration details, SQL statements, or rollback commands for a specific migration version.

• Action
  Get Organization

  Fetches comprehensive details for a specific Supabase organization using its unique slug.

• Action
  Get Performance Advisors

  Retrieves project performance advisors for a Supabase project. Returns a list of performance lints that identify potential issues and optimization opportunities. Note: This endpoint is deprecated.

• Action
  Get Project

  Retrieves detailed information about a specific Supabase project by its unique reference ID. Use when you need to get comprehensive project details including status, database configuration, and metadata. Authentication: - Requires a valid Bearer token in the Authorization header.

• Action
  Get Project Api Key

  Retrieves details of a specific API key for a Supabase project by its UUID. Use when you need to inspect a single key's configuration, type, or metadata.

• Action
  Get Project Api Keys

  Retrieves all api keys for an existing supabase project, specified by its unique reference id (`ref`); this is a read-only operation.

• Action
  Get Project Legacy Api Keys

  Checks whether JWT-based legacy API keys (anon, service_role) are enabled for a Supabase project. This API endpoint is deprecated and may be removed in the future (returns HTTP 404 Not Found when unavailable).

• Action
  Get Project Logs

  Retrieves the unified logs stream for a Supabase project, including database, API, and edge function logs, for monitoring and debugging. Custom queries use ClickHouse SQL against the logs table, filtering by source; legacy source tables and metadata joins must be migrated. Provide both UTC timestamps for a time window; Supabase documents a last-minute fallback without both and a maximum 24-hour range. Check the response's error field even when execution reports success. Returned row fields depend on the query.

• Action
  Get Project Metrics

  Retrieve a Supabase project's Prometheus/OpenMetrics exposition.

• Action
  Get Project Postgres Config

  Retrieves the current read-only PostgreSQL database configuration for a specified Supabase project's `ref`, noting that some advanced or security-sensitive details might be omitted from the response.

• Action
  Get Project Postgrest Config

  Retrieves the PostgREST configuration for a specific Supabase project.

• Action
  Get Project Readonly Mode Status

  Retrieves the read-only mode status for a specified Supabase project to check its operational state; this action does not change the read-only state.

• Action
  Get Project Signing Keys

  Tool to list all signing keys for a Supabase project. Use when you need to retrieve JWT signing keys for authentication verification or rotation management.

• Action
  Get Project S Pgbouncer Config

  Retrieves the active pgbouncer configuration (postgresql connection pooler) for a supabase project, used for performance tuning, auditing, or getting the connection string.

• Action
  Get Project Supavisor Config

  Retrieves the Supavisor (connection pooler) configuration for a specified Supabase project, identified by its reference ID.

• Action
  Get Project Upgrade Eligibility

  Checks a supabase project's eligibility for an upgrade, verifying compatibility and identifying potential issues; this action does not perform the actual upgrade.

• Action
  Get Project Upgrade Status

  Retrieves the latest status of a supabase project's database upgrade for monitoring purposes; does not initiate or modify upgrades.

• Action
  Gets A Specific Sql Snippet

  Retrieves a specific sql snippet by its unique identifier.

• Action
  Gets A Sso Provider By Its Uuid

  Retrieves the configuration details for a specific single sign-on (sso) provider (e.g., saml, google, github, azure ad), identified by its uuid, within a supabase project.

• Action
  Get Security Advisors

  Retrieves security advisor findings and recommendations for a Supabase project. Use when you need to audit project security posture, identify SQL-based security issues, or get remediation guidance. Note: This endpoint is deprecated and may be removed in future API versions.

• Action
  Gets Information About The Organization

  Fetches comprehensive details for a specific supabase organization using its unique slug.

• Action
  Gets Project S Auth Config

  Retrieves the project's complete read-only authentication configuration, detailing all settings (e.g., providers, mfa, email/sms, jwt, security policies) but excluding sensitive secrets.

• Action
  Gets Project S Postgres Config

  Retrieves the current read-only postgresql database configuration for a specified supabase project's `ref`, noting that some advanced or security-sensitive details might be omitted from the response.

• Action
  Gets Project S Postgrest Config

  Retrieves the postgrest configuration for a specific supabase project.

• Action
  Gets Project S Service Health Status

  Retrieves the current health status for a supabase project, for specified services or all services if the 'services' list is omitted.

• Action
  Gets Project S Supavisor Config

  Retrieves the supavisor (connection pooler) configuration for a specified supabase project, identified by its reference id.

• Action
  Get Sql Snippet

  Retrieves a specific SQL snippet by its unique identifier.

• Action
  Get Sso Provider

  Retrieves the configuration details for a specific Single Sign-On (SSO) provider (e.g., SAML, Google, GitHub, Azure AD), identified by its UUID, within a Supabase project.

• Action
  Get Table Schemas

  Retrieves column details, types, and constraints for multiple database tables to help debug schema issues and write accurate sql queries.

• Action
  Invoke Database Function

  Invoke a known exposed Postgres function with named JSON arguments. Supports custom exposed schemas and table-valued result selection, filters, ordering, pagination, and counts. The function runs with a service-role project key that bypasses Row Level Security and may create, update, or delete data or execute DDL.

• Action
  Invoke Edge Function

  Tool to invoke a deployed Supabase Edge Function over HTTPS. Use for testing and debugging Edge Functions with configurable method, headers, body, and authentication.

• Action
  List All Database Branches

  Lists all database branches for a specified supabase project, used for isolated development and testing of schema changes; ensure the project reference id is valid.

• Action
  List All Functions

  Lists metadata for all edge functions in a supabase project (specified by 'ref'), excluding function code or logs; the project must exist.

• Action
  List All Organizations

  Lists all organizations (id and name only) associated with the supabase account, excluding project details within these organizations.

• Action
  List All Projects

  Retrieves a list of all supabase projects, including their id, name, region, and status, for the authenticated user.

• Action
  List All Secrets

  Retrieves all secrets for a supabase project using its reference id; secret values in the response may be masked.

• Action
  List Backups

  Lists all database backups for a Supabase project, providing details on existing backups but not creating new ones or performing restores; availability may depend on plan and configuration.

• Action
  List Branches

  Lists all database branches for a specified Supabase project, providing information about each branch's status, configuration, and metadata. Use this action when you need to view all branches in a project, check branch statuses, or identify available branches before performing operations. Database branches are useful for isolated development and testing of schema changes.

• Action
  List Buckets

  Retrieves a list of all storage buckets for a Supabase project, without returning bucket contents or access policies.

• Action
  List Database Branches

  Lists all database branches for a specified Supabase project, used for isolated development and testing of schema changes; ensure the project reference ID is valid.

• Action
  List Functions

  Lists metadata for all Edge Functions in a Supabase project (specified by 'ref'), excluding function code or logs; the project must exist.

• Action
  List Members Of An Organization

  Retrieves all members of a supabase organization, identified by its unique slug, including their user id, username, email, role, and mfa status.

• Action
  List Migration History

  Retrieves the list of applied database migration versions for a Supabase project. Use this to track which migrations have been applied to the project's database. This is a read-only operation that requires the project reference ID.

• Action
  List Project Secrets

  Retrieves all secrets (environment variables) for a Supabase project by its reference ID. Use this action when you need to view the secrets configured for a project, such as API keys, database URLs, or other environment variables. Note that secret values in the response may be masked for security reasons.

• Action
  Lists All Backups

  Lists all database backups for a supabase project, providing details on existing backups but not creating new ones or performing restores; availability may depend on plan and configuration.

• Action
  Lists All Buckets

  Retrieves a list of all storage buckets for a supabase project, without returning bucket contents or access policies.

• Action
  Lists All Sso Providers

  Lists all configured single sign-on (sso) providers for a supabase project, requiring the project reference id (`ref`) of an existing project.

• Action
  List Secrets

  Retrieves all secrets for a Supabase project using its reference ID; secret values in the response may be masked.

• Action
  List Sso Providers

  Lists all configured Single Sign-On (SSO) providers for a Supabase project, requiring the project reference ID (`ref`) of an existing project.

• Action
  Lists Sql Snippets For The Logged In User

  Retrieves a list of sql snippets for the logged-in user, optionally filtered by a specific supabase project if `project ref` is provided.

• Action
  List Tables

  Lists all tables and views in specified database schemas, providing a quick overview of database structure to help identify available tables before fetching detailed schemas.

• Action
  Merge Branch

  Merges a database branch, applying all schema changes and migrations from the branch to the target database. Use this action when you need to promote changes from a database branch to production or another target environment after testing and validation are complete. This operation is irreversible - once merged, the changes cannot be automatically rolled back.

• Action
  Patch Migration

  [Beta] Patches an existing entry in the project's migration history, updating the name or rollback script. Use this to correct migration metadata after the migration has been created.

• Action
  Patch Network Restrictions

  Updates project's network restrictions by incrementally adding or removing IPv4/IPv6 CIDR blocks. Use when you need to modify existing restrictions without replacing the entire configuration.

• Action
  Push Branch

  Pushes a database branch, applying migrations and changes to the specified branch. Use when you need to deploy schema changes or migrations to a database branch.

• Action
  Removes A Sso Provider By Its Uuid

  Deletes a specific sso provider by its id (`provider id`) from a supabase project (`ref`), which disables it and returns its details; ensure this action will not inadvertently lock out users.

• Action
  Resets A Database Branch

  Resets an existing supabase database branch, identified by `branch id`, to its initial clean state, irreversibly deleting all its current data and schema changes.

• Action
  Retrieve A Function

  Retrieves detailed information, metadata, configuration, and status for a specific edge function using its project reference id and function slug.

• Action
  Retrieve A Function Body

  Retrieves the source code (body) for a specified serverless edge function using its project reference and function slug; this is a read-only operation that does not execute the function or return runtime logs.

• Action
  Returns Project S Readonly Mode Status

  Retrieves the read-only mode status for a specified supabase project to check its operational state; this action does not change the read-only state.

• Action
  Run Read Only Query

  [Beta] Run a SQL query as supabase_read_only_user. Use when you need to safely execute SELECT queries without risk of modifying data. Only read operations are allowed.

• Action
  Select From Table

  Tool to select rows from a Supabase/PostgREST table. Use for read-only queries with filtering, sorting, and pagination.

• Action
  Update A Function

  Updates an existing supabase edge function's properties (like name, slug, source code, jwt settings, import map) identified by project `ref` and `function slug`, supporting plain text code or eszip for the body.

• Action
  Update Api Key

  Updates an existing Supabase project API key's metadata including name, description, and JWT template configuration. This action modifies key properties without regenerating the actual key value. Use this action when you need to change a key's display name, update its description for better organization, or modify the JWT role template for secret-type keys. Note: This does not rotate or regenerate the key string itself - the key value remains unchanged unless explicitly revealed with reveal=true.

• Action
  Update Database Branch Config

  Updates the configuration of a supabase database branch, allowing modification of its name, associated git branch, reset-on-push behavior, persistence, and status.

• Action
  Update Project

  Updates a Supabase project's configuration (currently supports updating the project name). Use when you need to rename an existing project.

• Action
  Update Project Auth Config

  Update Supabase project Auth configuration via the Management API. Use to fix misconfigured Auth redirects, SMTP settings, or other auth parameters. Only provided fields are updated; others remain unchanged. Before updating, confirm the Auth service status is ACTIVE_HEALTHY by checking project health.

• Action
  Update Project Postgres Config

  Updates specified PostgreSQL configuration parameters for an existing Supabase project (`ref`) to optimize database performance; note that unspecified parameters remain unchanged, and caution is advised as incorrect settings can impact stability or require a restart.

• Action
  Update Project Postgrest Config

  Updates PostgREST configuration settings (e.g., `max_rows`, `db_pool`, `db_schema`, `db_extra_search_path`) for a Supabase project to fine-tune API performance, data exposure, and database resource usage.

• Action
  Update Project Supavisor Config

  Updates the Supavisor (database pooler) configuration, such as `default_pool_size`, for an existing Supabase project identified by `ref`; the `pool_mode` parameter in the request is deprecated and ignored.

• Action
  Updates A Sso Provider By Its Uuid

  Updates an existing sso provider's saml metadata, associated email domains, or attribute mappings for a supabase project, identified by `ref` and `provider id`.

• Action
  Updates Project S Postgres Config

  Updates specified postgresql configuration parameters for an existing supabase project (`ref`) to optimize database performance; note that unspecified parameters remain unchanged, and caution is advised as incorrect settings can impact stability or require a restart.

• Action
  Updates Project S Postgrest Config

  Updates postgrest configuration settings (e.g., `max rows`, `db pool`, `db schema`, `db extra search path`) for a supabase project to fine-tune api performance, data exposure, and database resource usage.

• Action
  Updates Project S Supavisor Config

  Updates the supavisor (database pooler) configuration, such as `default pool size`, for an existing supabase project identified by `ref`; the `pool mode` parameter in the request is deprecated and ignored.

• Action
  Update Ssl Enforcement Config

  Updates the ssl enforcement configuration (enable/disable) for a specified supabase project's database.

• Action
  Update Sso Provider

  Updates an existing SSO provider's SAML metadata, associated email domains, or attribute mappings for a Supabase project, identified by `ref` and `provider_id`.

• Action
  Upsert Migration

  Tool to upsert a database migration without applying it. Use when you need to track migration changes for a project. [Beta] This endpoint stores migration metadata without executing the SQL.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.