# Supabase

Supabase is an open-source backend-as-a-service providing a Postgres database, authentication, storage, and real-time subscription APIs for building modern applications

Category: Developer. Connect from any Rakazo bot at https://rakazo.com/integrations/supabase/.

## Actions

- **Create an organization**: Creates a new supabase organization, which serves as a top-level container for projects, billing, and team access.
- **Create new project**: Creates a new supabase project, requiring a unique name (no dots) within the organization.
- **Execute project database query**: Executes a given sql query against the project's database.
- **Generate TypeScript types** (read-only): Generates and retrieves typescript types from a supabase project's database.
- **Get Table Schemas** (read-only): Retrieves column details, types, and constraints for multiple database tables to help debug schema issues and write accurate sql queries.
- **List all organizations** (read-only): Lists all organizations (id and name only) associated with the supabase account, excluding project details within these organizations.
- **List all projects** (read-only): Retrieves a list of all supabase projects, including their id, name, region, and status, for the authenticated user.
- **Activate vanity subdomain for project**: Activates a vanity subdomain for the specified supabase project, requiring subsequent dns configuration for the subdomain to become…
- **Authorize user through OAuth** (read-only): Generates a supabase oauth 2.0 authorization url for user redirection, requiring a pre-registered client id and a redirect uri that…
- **Beta activate custom hostname for project**: Activates a previously configured custom hostname for a supabase project, assuming dns settings are verified externally.
- **Beta get project's custom hostname config** (read-only): Retrieves a supabase project's custom hostname configuration, including its status, ssl certificate, and ownership verification, noting…
- **Beta remove a read replica**: Irreversibly initiates the removal of a specified read replica from an existing supabase project, confirming only the start of the…
- **Beta update project network restrictions**: Updates and applies network access restrictions (ipv4/ipv6 cidr lists) for a supabase project, which may terminate existing connections…
- **Check vanity subdomain availability** (read-only): Checks if a specific vanity subdomain is available for a supabase project.
- **Create a database branch**: Creates a new, isolated database branch from an existing supabase project (identified by ref), useful for setting up separate environments…
- **Create a function**: Creates a new serverless edge function for a supabase project (identified by ref), requiring valid javascript/typescript in body and a…
- **Create 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…
- **Create project api key**: Creates a 'publishable' or 'secret' api key for an existing supabase project, optionally with a description.
- **Create SSO provider configuration**: 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…
- **Delete an API key from the project**: Permanently deletes a specific api key (identified by id) from a supabase project (identified by ref), revoking its access.
- **Delete an edge function by slug**: Permanently deletes a specific edge function (by function slug) from a supabase project (by ref).
- **Delete branch by id**: Permanently and irreversibly deletes a specific, non-default database branch by its branch id, without affecting other branches.
- **Delete custom hostname config**: Deletes an active custom hostname configuration for the project identified by ref, reverting to the default supabase-provided hostname.
- **Delete project by ref**: Permanently and irreversibly deletes a supabase project, identified by its unique ref id, resulting in complete data loss.
- **Delete third party auth config**: Removes a third-party authentication provider (e.g., google, github) from a supabase project's configuration.
- **Delete vanity subdomain for project**: Permanently and irreversibly deletes an active vanity subdomain configuration for the specified supabase project, reverting it to its…
- **Deploy function**: Deploys edge functions to a supabase project using multipart upload.
- **Disable preview branching**: Disables the preview branching feature for an existing supabase project, identified by its unique reference id (ref).
- **Disable project readonly mode**: Temporarily disables a supabase project's read-only mode for 15 minutes to allow write operations (e.g., for maintenance or critical…
- **Enable project database webhooks**: Enables database webhooks for the supabase project ref, triggering real-time notifications for insert, update, or delete events.
- **Exchange auth code for access and refresh token**: (beta) implements the oauth 2.0 token endpoint to exchange an authorization code or refresh token for access/refresh tokens, based on…
- **Get a specific SQL snippet** (read-only): Retrieves a specific sql snippet by its unique identifier.
- **Get a SSO provider by its UUID** (read-only): Retrieves the configuration details for a specific single sign-on (sso) provider (e.g., saml, google, github, azure ad), identified by its…
- **Get a third-party integration** (read-only): Retrieves the detailed configuration for a specific third-party authentication (tpa) provider, identified by tpa id, within an existing…
- **Get current vanity subdomain config** (read-only): Fetches the current vanity subdomain configuration, including its status and custom domain name, for a supabase project identified by its…
- **Get database branch config** (read-only): Retrieves the read-only configuration and status for a supabase database branch, typically for monitoring or verifying its settings.
- **Get information about an organization** (read-only): Fetches comprehensive details for a specific supabase organization using its unique slug.
- **Get project API keys** (read-only): Retrieves all api keys for an existing supabase project, specified by its unique reference id (ref).
- **Get project PgBouncer config** (read-only): Retrieves the active pgbouncer configuration (postgresql connection pooler) for a supabase project, used for performance tuning, auditing,…
- **Get project pgsodium config** (read-only): Retrieves the pgsodium configuration, including the root encryption key, for an existing supabase project identified by its ref.
- **Get project postgres config** (read-only): Retrieves the current read-only postgresql database configuration for a specified supabase project's ref, noting that some advanced or…
- **Get project SSL enforcement configuration** (read-only): Retrieves the ssl enforcement configuration for a specified supabase project, indicating if ssl connections are mandated for its database.
- **Get project Supavisor configuration** (read-only): Retrieves the supavisor (connection pooler) configuration for a specified supabase project, identified by its reference id.
- **Get Project Upgrade Eligibility** (read-only): Checks a supabase project's eligibility for an upgrade, verifying compatibility and identifying potential issues.
- **Get project upgrade status** (read-only): Retrieves the latest status of a supabase project's database upgrade for monitoring purposes.
- **Get project's auth config** (read-only): Retrieves the project's complete read-only authentication configuration, detailing all settings (e.g., providers, mfa, email/sms, jwt,…
- **Get project's PostgREST config** (read-only): Retrieves the postgrest configuration for a specific supabase project.
- **Get project's read-only mode status** (read-only): Retrieves the read-only mode status for a specified supabase project to check its operational state.
- **Get project's service health status** (read-only): Retrieves the current health status for a supabase project, for specified services or all services if the 'services' list is omitted.
- **List all buckets** (read-only): Retrieves a list of all storage buckets for a supabase project, without returning bucket contents or access policies.
- **List all database branches** (read-only): Lists all database branches for a specified supabase project, used for isolated development and testing of schema changes.
- **List all functions** (read-only): Lists metadata for all edge functions in a supabase project (specified by 'ref'), excluding function code or logs.
- **List all secrets** (read-only): Retrieves all secrets for a supabase project using its reference id.
- **List all SSO providers** (read-only): Lists all configured single sign-on (sso) providers for a supabase project, requiring the project reference id (ref) of an existing project.
- **List members of an organization** (read-only): Retrieves all members of a supabase organization, identified by its unique slug, including their user id, username, email, role, and mfa…
- **List project database backups** (read-only): Lists all database backups for a supabase project, providing details on existing backups but not creating new ones or performing restores.
- **List SQL snippets for the logged in user** (read-only): Retrieves a list of sql snippets for the logged-in user, optionally filtered by a specific supabase project if project ref is provided.
- **List third-party auth integrations for project** (read-only): Lists all configured third-party authentication provider integrations for an existing supabase project (using its ref), suitable for…
- **Remove an SSO provider**: Deletes a specific sso provider by its id (provider id) from a supabase project (ref), which disables it and returns its details.
- **Remove project network bans**: Removes specified ipv4 addresses from a supabase project's network ban list, granting immediate access.
- **Reset a database branch**: Resets an existing supabase database branch, identified by branch id, to its initial clean state, irreversibly deleting all its current…
- **Restore database PITR backup**: Restores a supabase project's database to a specific unix timestamp using point-in-time recovery (pitr), overwriting the current state.
- **Retrieve a function** (read-only): Retrieves detailed information, metadata, configuration, and status for a specific edge function using its project reference id and…
- **Retrieve a function body** (read-only): Retrieves the source code (body) for a specified serverless edge function using its project reference and function slug.
- **Retrieve network bans for project** (read-only): Retrieves the list of banned ipv4 addresses for a supabase project using its unique project reference string.
- **Retrieve project network restrictions** (read-only): Retrieves the current network restriction settings (e.g., ip whitelists) for a supabase project using its reference id.
- **Reverify custom hostname** (read-only): Re-verifies dns and ssl configurations for an existing custom hostname associated with a supabase project.
- **Setup read replica for project**: Provisions a read-only replica for a supabase project in a specified, supabase-supported aws region to enhance read performance and reduce…
- **Update a function**: Updates an existing supabase edge function's properties (like name, slug, source code, jwt settings, import map) identified by project ref…
- **Update an API key for the project**: Updates an existing supabase project api key's description and/or secret jwt template (which defines its role).
- **Update an 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…
- **Update database branch config**: Updates the configuration of a supabase database branch, allowing modification of its name, associated git branch, reset-on-push behavior,…
- **Update database pooler config**: Updates the supavisor (database pooler) configuration, such as default pool size, for an existing supabase project identified by ref.
- **Update pgsodium root key**: Critically updates or initializes a supabase project's pgsodium root encryption key for security setup or key rotation, requiring secure…
- **Update project's custom hostname configuration**: Updates the custom hostname for a supabase project, requiring subsequent dns changes to a user-controlled domain for ssl certificate…
- **Update project's postgres config**: Updates specified postgresql configuration parameters for an existing supabase project (ref) to optimize database performance.
- **Update 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…
- **Update SSL enforcement config**: Updates the ssl enforcement configuration (enable/disable) for a specified supabase project's database.
- **Upgrade the project's PostgreSQL version**: Initiates an asynchronous upgrade of a supabase project's postgresql database to a specified target version from a selected release…