How to integrate Supabase MCP with ChatGPT

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

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

Removes a third-party authentication provider (e.

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

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.

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

Tool to apply database migrations to a Supabase project.

Activates a previously configured custom hostname for a Supabase project, assuming DNS settings are verified externally.

Activates a vanity subdomain for the specified Supabase project (e.

Generates a Supabase OAuth 2.

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

Provisions a read-only replica for a Supabase project in a specified, Supabase-supported AWS region to enhance read performance and reduce latency.

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

Retrieves a Supabase project's custom hostname configuration, including its status, SSL certificate, and ownership verification, noting that availability may depend on the project's plan.

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

Retrieves the network restriction settings (IP allowlists) for a Supabase project.

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

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

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

Removes specified IPv4 addresses from a Supabase project's network ban list, granting immediate access; IPs not currently banned are ignored.

Remove a read replica from a Supabase project (Pro plan or higher required).

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.

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

Initiates an asynchronous upgrade of a Supabase project's PostgreSQL database to a specified `target_version` from a selected `release_channel`, returning a `tracking_id` to monitor status; the `target_version` must be available in the chosen channel.

Counts the number of action runs for a Supabase project using a HEAD request.

Creates a new Supabase project, requiring a unique name (no dots) within the organization; project creation is asynchronous.

Tool to bulk create secrets for a Supabase project.

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.

Creates a new serverless Edge Function for a Supabase project (identified by `ref`), requiring valid JavaScript/TypeScript in `body` and a project-unique `slug` identifier.

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

Creates a new Supabase organization, which serves as a top-level container for projects, billing, and team access.

Create a new signing key for JWT authentication in a Supabase project.

Creates a new SAML 2.

Call this to add a new third-party authentication method (OIDC or JWKS) to a Supabase project for integrating external identity providers (e.

Deletes an active custom hostname configuration for the project identified by `ref`, reverting to the default Supabase-provided hostname; this action immediately makes the project inaccessible via the custom domain and requires subsequent updates to client, OAuth, and DNS settings.

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

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.

[Beta] Deletes existing login roles used by the Supabase CLI for the specified project.

Permanently and irreversibly deletes a Supabase project, identified by its unique `ref` ID, resulting in complete data loss.

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

Tool to bulk delete secrets from a Supabase project.

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.

Deploys Edge Functions to a Supabase project using multipart upload.

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

Temporarily disables a Supabase project's read-only mode for 15 minutes to allow write operations (e.

(Beta) Implements the OAuth 2.

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

Retrieves the status and details of a specific action run, including its steps, timestamps, and configuration.

Retrieves the execution logs for a specific action run by its ID.

Tool to get the list of available regions for creating a new Supabase project.

Retrieves detailed information about a specific database branch by its name and project reference.

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

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

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.

Tool to check the health status of the Supabase API.

[Beta] Retrieves the project's just-in-time (JIT) access configuration, including user roles and their expiration settings.

Retrieves a specific database migration entry from the migration history using its version identifier.

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

Retrieves detailed information about a specific Supabase project by its unique reference ID.

Retrieves details of a specific API key for a Supabase project by its UUID.

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

Retrieves analytics logs for a Supabase project.

Retrieves the active PgBouncer configuration (PostgreSQL connection pooler) for a Supabase project, used for performance tuning, auditing, or getting the connection string.

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.

Retrieves the PostgREST configuration for a specific Supabase project.

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.

Tool to list all signing keys for a Supabase project.

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

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

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

Handles OPTIONS request for TUS Resumable uploads to discover server capabilities.

Handles OPTIONS request for TUS Resumable uploads to discover server capabilities.

Retrieves the project's complete read-only authentication configuration, detailing all settings (e.

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

Retrieves a specific SQL snippet by its unique identifier.

Retrieves the configuration details for a specific Single Sign-On (SSO) provider (e.

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

Handles CORS preflight OPTIONS request for TUS resumable upload signing.

Handles CORS preflight OPTIONS request for TUS resumable upload signing endpoints.

Tool to invoke a deployed Supabase Edge Function over HTTPS.

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

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

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.

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

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.

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

Retrieves the list of applied database migration versions for a Supabase project.

Retrieves all members of a Supabase organization, identified by its unique slug, including their user ID, username, email, role, and MFA status.

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

Retrieves a list of SQL snippets for the logged-in user, optionally filtered by a specific Supabase project if `project_ref` is provided.

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

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.

[Beta] Patches an existing entry in the project's migration history, updating the name or rollback script.

Updates project's network restrictions by incrementally adding or removing IPv4/IPv6 CIDR blocks.

Pushes a database branch, applying migrations and changes to the specified 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.

Restores a Supabase project's database to a specific Unix timestamp using Point-in-Time Recovery (PITR), overwriting the current state; requires a paid plan with PITR and physical backups enabled.

[Beta] Run a SQL query as supabase_read_only_user.

Tool to select rows from a Supabase/PostgREST table.

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.

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

Updates the database password for a Supabase project.

Tool to bulk update Edge Functions in a Supabase project.

[Beta] Update a Supabase project's just-in-time (JIT) access configuration.

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.

Updates a Supabase project's configuration (currently supports updating the project name).

Update Supabase project Auth configuration via the Management API.

Updates the custom hostname for a Supabase project, requiring subsequent DNS changes to a user-controlled domain for SSL certificate issuance and domain ownership.

Tool to disable or re-enable JWT-based legacy API keys (anon, service_role) for a Supabase project.

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.

Updates PostgREST configuration settings (e.

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.

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

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

Tool to upsert a database migration without applying it.

Re-verifies DNS and SSL configurations for an existing custom hostname associated with a Supabase project.