Alle integrationer

Supabase

Administrer Supabase-organisationer og -projekter via MCP — kør SQL, deploy Edge Functions, konfigurér Auth og administrer secrets med en personal access token.

Manual setup 158 værktøjer

Overblik

Forbind Supabase, så AI-klienter kan administrere dine organisationer og projekter via Management API — list projekter, kør SQL, anvend migrationer, deploy Edge Functions, konfigurér Auth/PostgREST/Realtime/Storage og administrer secrets eller API-nøgler.

stackgate.ai gemmer din personal access token krypteret og kalder https://api.supabase.com på dine vegne. Værktøjsresultater returneres til din AI-klient for den pågældende forespørgsel.

Forudsætninger

  • En Supabase-konto
  • En stackgate.ai-konto

Credentials

  1. Log ind på Supabase Dashboard.
  2. Åbn Account → Access Tokens (eller gå til Account tokens).
  3. Opret en personal access token, kopiér den én gang, og gem den sikkert.
  4. I stackgate.ai, åbn Mine integrationer → Supabase.
  5. Indsæt tokenen i Personal access token, og klik Connect & enable.
  6. Brug eventuelt Edit tool access til at begrænse forbindelsen til Read-værktøjer (eller en tilpasset allowlist).

Behandl tokenen som en adgangskode. PAT'er har samme rettigheder som din Supabase-bruger på tværs af organisationer og projekter. Tilbagekald eller roter tokenen i Supabase, hvis den bliver eksponeret.

Brug med AI-klienter

  • Dedikeret endpoint: POST /mcp/supabase med Sanctum bearer token
  • Private gateway: én config til alle integrationer — brug supabase__*-navngivne værktøjer

Se Dokumentation for HTTP-autentificering og opsætning af private gateway.

Foreslået workflow

  1. list_organizations / list_projects — find organisations-slugs og project refs.
  2. get_project / get_database_openapi — inspicér et projekt og schema.
  3. Foretræk run_sql_query_read_only før run_sql_query.
  4. Brug Edge Function-, Auth config-, branch- og secrets-værktøjer efter behov.

Fejlfinding

  • 422 integration not configured — indsæt en personal access token under Mine integrationer.
  • 401 Unauthorized — generér en ny token under Supabase Account → Access Tokens, og opdater integrationen.
  • 403 Forbidden — din Supabase-rolle mangler måske tilladelse til projektet eller handlingen.
  • 429 Too many requests — Management API begrænser til 120 forespørgsler pr. minut pr. projekt/organisation (lavere for nogle analytics-endpoints). Vent og prøv igen.
  • Destruktive handlinger — værktøjer som delete_project, rollback_migrations og restore_pitr_backup kan medføre datatab; bekræft intentionen i AI-klienten, før du godkender Write-adgang.

Tilgængelige værktøjer

  • get_profile

    Get the Supabase account profile for the connected access token.

  • list_organizations

    List Supabase organizations accessible to the connected account.

  • get_organization

    Get a Supabase organization by slug.

  • get_organization_entitlements

    Get entitlements for a Supabase organization.

  • list_organization_members

    List members of a Supabase organization.

  • list_organization_projects

    List projects in a Supabase organization.

  • create_organization

    Create a Supabase organization.

  • list_projects

    List alle Supabase-projekter for den forbundne konto.

  • get_project

    Hent detaljer for et Supabase-projekt.

  • create_project

    Create a new Supabase project.

  • update_project

    Update a Supabase project.

  • delete_project

    Permanently delete a Supabase project. Destructive — confirm with the user first.

  • list_available_regions

    List available Supabase project regions for an organization.

  • get_project_health

    Get health status for a Supabase project service.

  • pause_project

    Pause a Supabase project.

  • restore_project

    Restore a paused Supabase project.

  • get_project_restore_status

    Get restore status for a Supabase project.

  • cancel_project_restore

    Cancel an in-progress project restore.

  • restart_project

    Restart a Supabase project.

  • get_upgrade_eligibility

    Check whether a project is eligible for a database upgrade.

  • get_upgrade_status

    Get database upgrade status for a project.

  • upgrade_project

    Start a database upgrade for a project.

  • list_api_keys

    List API keys for a Supabase project. Responses may include secret values — handle carefully.

  • get_api_key

    Get one API key by id for a Supabase project.

  • create_api_key

    Create an API key for a Supabase project.

  • update_api_key

    Update an API key for a Supabase project.

  • delete_api_key

    Delete an API key from a Supabase project.

  • list_legacy_api_keys

    List legacy anon/service_role API keys for a project.

  • update_legacy_api_keys

    Update legacy API keys for a project.

  • list_secrets

    List project secrets. Værdier kan være følsomme.

  • create_secrets

    Create or update project secrets (array of name/value pairs).

  • delete_secrets

    Delete project secrets by name.

  • get_pgsodium_config

    Get pgsodium configuration for a project.

  • update_pgsodium_config

    Update pgsodium configuration for a project.

  • run_sql_query_read_only

    Kør SQL som supabase_read_only_user — foretræk dette til udforskning.

  • run_sql_query

    Kør SQL med skrivprivilegier. Bekræft destruktiv SQL med brugeren først.

  • get_database_openapi

    Get the PostgREST OpenAPI specification for a project database.

  • generate_typescript_types

    Generate TypeScript types from the project database schema.

  • get_database_context

    Get database metadata context for a project. Deprecated and rate-limited — prefer OpenAPI/types tools.

  • list_migrations

    List applied database migration versions.

  • get_migration

    Fetch one migration history entry by version.

  • apply_migration

    Apply a database migration.

  • upsert_migration

    Upsert a migration history entry without applying it.

  • patch_migration

    Patch an existing migration history entry.

  • rollback_migrations

    Rollback database migrations and remove them from history. Destructive.

  • list_backups

    List database backups for a project.

  • get_backup_schedule

    Get the backup schedule for a project.

  • update_backup_schedule

    Update the backup schedule for a project.

  • restore_pitr_backup

    Restore a point-in-time backup. Destructive — confirm with the user.

  • get_readonly_status

    Get database readonly mode status.

  • temporary_disable_readonly

    Temporarily disable readonly mode for ~15 minutes.

  • get_postgres_config

    Get Postgres configuration for a project.

  • update_postgres_config

    Update Postgres configuration for a project.

  • get_pooler_config

    Get Supavisor/pooler configuration.

  • update_pooler_config

    Update Supavisor/pooler configuration.

  • get_pgbouncer_config

    Get pgbouncer configuration for a project.

  • get_ssl_enforcement

    Get SSL enforcement configuration.

  • update_ssl_enforcement

    Update SSL enforcement configuration.

  • update_database_password

    Update the database password for a project.

  • enable_database_webhooks

    Enable database webhooks on the project.

  • setup_read_replica

    Set up a read replica for the project.

  • remove_read_replica

    Remove a read replica from the project.

  • list_sql_snippets

    List SQL snippets for the logged-in user.

  • get_sql_snippet

    Get a SQL snippet by id.

  • get_auth_config

    Get Auth (GoTrue) configuration for a project.

  • update_auth_config

    Update Auth configuration. Send only fields you intend to change.

  • list_sso_providers

    List SAML SSO providers for a project.

  • get_sso_provider

    Get a SAML SSO provider by id.

  • create_sso_provider

    Create a SAML SSO provider.

  • update_sso_provider

    Update a SAML SSO provider.

  • delete_sso_provider

    Delete a SAML SSO provider.

  • list_third_party_auth

    List third-party auth integrations for a project.

  • get_third_party_auth

    Get a third-party auth integration by id.

  • create_third_party_auth

    Create a third-party auth integration.

  • delete_third_party_auth

    Delete a third-party auth integration.

  • list_signing_keys

    List JWT signing keys for a project.

  • get_signing_key

    Get a JWT signing key by id.

  • create_signing_key

    Create a new JWT signing key (standby).

  • update_signing_key

    Update a JWT signing key status.

  • delete_signing_key

    Delete a revoked JWT signing key.

  • get_legacy_signing_key

    Get legacy JWT secret imported as a signing key.

  • create_legacy_signing_key

    Import the project's existing JWT secret as an in_use signing key.

  • list_functions

    List Edge Functions for et projekt.

  • get_function

    Get metadata for one Edge Function.

  • get_function_body

    Download the body/source of an Edge Function.

  • create_function

    Create an Edge Function.

  • update_function

    Update an Edge Function.

  • delete_function

    Delete an Edge Function.

  • bulk_update_functions

    Bulk create/update Edge Functions.

  • deploy_function

    Deploy an Edge Function (bundle upload flow).

  • list_branches

    List database branches for a project.

  • get_branch

    Get a database branch by id or ref.

  • get_branch_by_name

    Get a database branch by name within a project.

  • create_branch

    Create a database branch.

  • update_branch

    Update a database branch.

  • delete_branch

    Delete a database branch.

  • delete_all_branches

    Delete all database branches for a project.

  • get_branch_diff

    Get the migration diff for a database branch.

  • merge_branch

    Merge a database branch into production.

  • push_branch

    Push migrations from a database branch.

  • reset_branch

    Reset a database branch.

  • restore_branch

    Restore a scheduled branch deletion.

  • get_project_logs

    Get project logs from the analytics log stream.

  • get_all_project_logs

    Get all project logs (deprecated endpoint; stricter rate limits).

  • get_usage_api_counts

    Get project API usage counts (rate-limited).

  • get_usage_api_requests_count

    Get project API requests count (rate-limited).

  • get_functions_combined_stats

    Get combined Edge Function statistics.

  • list_log_drains

    List log drains for a project.

  • create_log_drain

    Create a log drain for a project.

  • update_log_drain

    Update a project log drain.

  • delete_log_drain

    Delete a project log drain.

  • get_performance_advisors

    Get performance advisors (deprecated/experimental).

  • get_security_advisors

    Get security advisors (deprecated/experimental).

  • get_network_restrictions

    Get network restrictions for a project.

  • update_network_restrictions

    Update network restrictions configuration.

  • apply_network_restrictions

    Apply network restrictions to a project.

  • retrieve_network_bans

    Retrieve network bans for a project.

  • retrieve_network_bans_enriched

    Retrieve enriched network bans for a project.

  • delete_network_bans

    Remove network bans for a project.

  • get_custom_hostname

    Get custom hostname configuration.

  • initialize_custom_hostname

    Initialize a custom hostname.

  • reverify_custom_hostname

    Reverify custom hostname DNS.

  • activate_custom_hostname

    Activate a custom hostname.

  • get_vanity_subdomain

    Get vanity subdomain configuration.

  • check_vanity_subdomain_availability

    Check vanity subdomain availability.

  • activate_vanity_subdomain

    Activate a vanity subdomain.

  • delete_vanity_subdomain

    Delete vanity subdomain configuration.

  • get_storage_config

    Get Storage configuration for a project.

  • update_storage_config

    Update Storage configuration.

  • list_storage_buckets

    List Storage buckets for a project.

  • get_realtime_config

    Get Realtime configuration.

  • update_realtime_config

    Update Realtime configuration.

  • shutdown_realtime

    Shut down Realtime connections for a project.

  • get_postgrest_config

    Get PostgREST configuration.

  • update_postgrest_config

    Update PostgREST configuration.

  • get_disk_config

    Get disk configuration for a project.

  • get_disk_util

    Get disk utilization for a project.

  • get_disk_autoscale

    Get disk autoscale configuration.

  • update_disk_config

    Update disk configuration.

  • list_billing_addons

    List billing addons and compute selections.

  • update_billing_addons

    Apply or update billing addons including compute size.

  • remove_billing_addon

    Remove a billing addon or revert compute sizing.

  • list_actions

    List project actions / runs.

  • get_action

    Get a project action run by id.

  • get_action_logs

    Get logs for a project action run.

  • update_action_status

    Update the status of an action run.

  • get_jit_access

    Get temporary JIT access configuration for a project.

  • update_jit_access

    Update temporary JIT access configuration.

  • list_database_jit_mappings

    List user-id to role mappings for database JIT access.

  • get_database_jit_mappings

    Get user-id to role mappings for database JIT access.

  • create_database_jit_mapping

    Authorize user-id to role mappings for JIT access.

  • update_database_jit_mapping

    Update a JIT access user mapping.

  • delete_database_jit_mapping

    Delete JIT access by user id.

  • invite_database_jit

    Invite an external user for database JIT access.

  • accept_database_jit_invite

    Accept a JIT database access invitation.

  • delete_database_jit_invite

    Delete a JIT database access invite.

  • create_cli_login_role

    Create a temporary CLI login role (beta).

  • delete_cli_login_role

    Delete temporary CLI login roles (beta).

MCP-endpoint: https://stackgate.ai/mcp/supabase (HTTP) eller via private gateway.