Supabase
Inspect Supabase organizations, projects, database configuration, service health, usage, and other Management API resources.
认证方式
| 方式 | 底层类型 | 状态 | 说明 |
|---|---|---|---|
| OAuth 2.0 | oauth2 | available | — |
| Management personal access token (manual) | api_key | available | — |
调用示例
import { createClient } from "@open-connector/sdk";const oc = createClient({ baseUrl: "https://api.openconnector.dev", apiKey: process.env.OPEN_CONNECTOR_API_KEY!,});const result = await oc.executeTool({ slug: "SUPABASE_V1_GENERATE_TYPESCRIPT_TYPES", connectedAccountId: "conn_...", arguments: { /* match this tool's input schema */ },});import Composio from "@composio/client";const composio = new Composio({ baseURL: "https://api.openconnector.dev/composio", apiKey: process.env.OPEN_CONNECTOR_API_KEY!,});const result = await composio.tools.execute("SUPABASE_V1_GENERATE_TYPESCRIPT_TYPES", { connected_account_id: "conn_...", arguments: { /* match this tool's input schema */ },});oc tools execute SUPABASE_V1_GENERATE_TYPESCRIPT_TYPES --data '{ }'Tool 目录
可用 Tools
65 个可调用操作
Generate TypeScript typesSUPABASE_V1_GENERATE_TYPESCRIPT_TYPESReturns the TypeScript types of your schema for use with supabase-js.需要连接1 scope
Returns the TypeScript types of your schema for use with supabase-js.
认证
需要 Connected AccountScopes
database:readTags
Get a database branchSUPABASE_V1_GET_A_BRANCHFetches the specified database branch by its name.需要连接1 scope
Fetches the specified database branch by its name.
认证
需要 Connected AccountScopes
environment:readTags
Get database branch configSUPABASE_V1_GET_A_BRANCH_CONFIGFetches configurations of the specified database branch需要连接1 scope
Fetches configurations of the specified database branch
认证
需要 Connected AccountScopes
environment:readTags
Retrieve a functionSUPABASE_V1_GET_A_FUNCTIONRetrieves a function with the specified slug and project.需要连接1 scope
Retrieves a function with the specified slug and project.
认证
需要 Connected AccountScopes
edge_functions:readTags
Retrieve a function bodySUPABASE_V1_GET_A_FUNCTION_BODYRetrieves a function body for the specified slug and project.需要连接1 scope
Retrieves a function body for the specified slug and project.
认证
需要 Connected AccountScopes
edge_functions:readTags
Fetch an existing entry from migration historySUPABASE_V1_GET_A_MIGRATIONFetch an existing entry from migration history需要连接1 scope
Fetch an existing entry from migration history
认证
需要 Connected AccountScopes
database:readTags
Gets a specific SQL snippetSUPABASE_V1_GET_A_SNIPPETGets a specific SQL snippet需要连接1 scope
Gets a specific SQL snippet
认证
需要 Connected AccountScopes
database:readTags
Gets a SSO provider by its UUIDSUPABASE_V1_GET_A_SSO_PROVIDERGets a SSO provider by its UUID需要连接1 scope
Gets a SSO provider by its UUID
认证
需要 Connected AccountScopes
auth:readTags
Get the status of an action runSUPABASE_V1_GET_ACTION_RUNReturns the current status of the specified action run.需要连接1 scope
Returns the current status of the specified action run.
认证
需要 Connected AccountScopes
environment:readTags
Get the logs of an action runSUPABASE_V1_GET_ACTION_RUN_LOGSReturns the logs from the specified action run.需要连接1 scope
Returns the logs from the specified action run.
认证
需要 Connected AccountScopes
environment:readTags
Gets all projects for the given organizationSUPABASE_V1_GET_ALL_PROJECTS_FOR_ORGANIZATIONReturns a paginated list of projects for the specified organization. This endpoint uses offset-based pagination. Use the `offset` parameter to skip a number of projects and the `limit` parameter to control the number of projects returned per page.需要连接1 scope
Returns a paginated list of projects for the specified organization. This endpoint uses offset-based pagination. Use the `offset` parameter to skip a number of projects and the `limit` parameter to control the number of projects returned per page.
认证
需要 Connected AccountScopes
projects:readTags
Gets information about the organizationSUPABASE_V1_GET_AN_ORGANIZATIONGets information about the organization需要连接1 scope
Gets information about the organization
认证
需要 Connected AccountScopes
organizations:readTags
Gets project's auth configSUPABASE_V1_GET_AUTH_SERVICE_CONFIGGets project's auth config需要连接1 scope
Gets project's auth config
认证
需要 Connected AccountScopes
auth:readTags
[Beta] Gets the list of available regions that can be used for a new projectSUPABASE_V1_GET_AVAILABLE_REGIONS[Beta] Gets the list of available regions that can be used for a new project需要连接1 scope
[Beta] Gets the list of available regions that can be used for a new project
认证
需要 Connected AccountScopes
organizations:readTags
Gets the backup schedule for a projectSUPABASE_V1_GET_BACKUP_SCHEDULEGets the backup schedule for a project需要连接1 scope
Gets the backup schedule for a project
认证
需要 Connected AccountScopes
database:readTags
Get database disk attributesSUPABASE_V1_GET_DATABASE_DISKGet database disk attributes需要连接
Get database disk attributes
认证
需要 Connected AccountTags
Gets database metadata for the given project.SUPABASE_V1_GET_DATABASE_METADATAThis is an **experimental** endpoint. It is subject to change or removal in future versions. Use it with caution, as it may not remain supported or stable.需要连接1 scope
This is an **experimental** endpoint. It is subject to change or removal in future versions. Use it with caution, as it may not remain supported or stable.
认证
需要 Connected AccountScopes
projects:readTags
Get PostgREST OpenAPI specSUPABASE_V1_GET_DATABASE_OPENAPIReturns the PostgREST OpenAPI specification for the project. This is the replacement for querying `/rest/v1/` directly with the anon key.需要连接1 scope
Returns the PostgREST OpenAPI specification for the project. This is the replacement for querying `/rest/v1/` directly with the anon key.
认证
需要 Connected AccountScopes
database:readTags
Get disk utilizationSUPABASE_V1_GET_DISK_UTILIZATIONGet disk utilization需要连接
Get disk utilization
认证
需要 Connected AccountTags
[Beta] Gets project's custom hostname configSUPABASE_V1_GET_HOSTNAME_CONFIG[Beta] Gets project's custom hostname config需要连接1 scope
[Beta] Gets project's custom hostname config
认证
需要 Connected AccountScopes
domains:readTags
Get user-id to role mappings for JIT accessSUPABASE_V1_GET_JIT_ACCESSMappings of roles a user can assume in the project database需要连接1 scope
Mappings of roles a user can assume in the project database
认证
需要 Connected AccountScopes
database:readTags
[Beta] Get project's temporary access configuration.SUPABASE_V1_GET_JIT_ACCESS_CONFIG[Beta] Get project's temporary access configuration.需要连接1 scope
[Beta] Get project's temporary access configuration.
认证
需要 Connected AccountScopes
database:readTags
[Beta] Gets project's network restrictionsSUPABASE_V1_GET_NETWORK_RESTRICTIONS[Beta] Gets project's network restrictions需要连接1 scope
[Beta] Gets project's network restrictions
认证
需要 Connected AccountScopes
projects:readTags
Get entitlements for an organizationSUPABASE_V1_GET_ORGANIZATION_ENTITLEMENTSReturns the entitlements available to the organization based on their plan and any overrides.需要连接1 scope
Returns the entitlements available to the organization based on their plan and any overrides.
认证
需要 Connected AccountScopes
organizations:readTags
Gets project details for the specified organization and claim tokenSUPABASE_V1_GET_ORGANIZATION_PROJECT_CLAIMGets project details for the specified organization and claim token需要连接
Gets project details for the specified organization and claim token
认证
需要 Connected AccountTags
Gets project performance advisors.SUPABASE_V1_GET_PERFORMANCE_ADVISORSThis is an **experimental** endpoint. It is subject to change or removal in future versions. Use it with caution, as it may not remain supported or stable.需要连接1 scope
This is an **experimental** endpoint. It is subject to change or removal in future versions. Use it with caution, as it may not remain supported or stable.
认证
需要 Connected AccountScopes
database:readTags
Gets project's supavisor configSUPABASE_V1_GET_POOLER_CONFIGGets project's supavisor config需要连接1 scope
Gets project's supavisor config
认证
需要 Connected AccountScopes
database:readTags
Gets project's Postgres configSUPABASE_V1_GET_POSTGRES_CONFIGGets project's Postgres config需要连接1 scope
Gets project's Postgres config
认证
需要 Connected AccountScopes
database:readTags
[Beta] Returns the project's eligibility for upgradesSUPABASE_V1_GET_POSTGRES_UPGRADE_ELIGIBILITY[Beta] Returns the project's eligibility for upgrades需要连接1 scope
[Beta] Returns the project's eligibility for upgrades
认证
需要 Connected AccountScopes
projects:readTags
[Beta] Gets the latest status of the project's upgradeSUPABASE_V1_GET_POSTGRES_UPGRADE_STATUS[Beta] Gets the latest status of the project's upgrade需要连接1 scope
[Beta] Gets the latest status of the project's upgrade
认证
需要 Connected AccountScopes
projects:readTags
Gets project's postgrest configSUPABASE_V1_GET_POSTGREST_SERVICE_CONFIGGets project's postgrest config需要连接1 scope
Gets project's postgrest config
认证
需要 Connected AccountScopes
rest:readTags
Gets the user's profileSUPABASE_V1_GET_PROFILEGets the user's profile需要连接
Gets the user's profile
认证
需要 Connected AccountTags
Gets a specific project that belongs to the authenticated userSUPABASE_V1_GET_PROJECTGets a specific project that belongs to the authenticated user需要连接1 scope
Gets a specific project that belongs to the authenticated user
认证
需要 Connected AccountScopes
projects:readTags
Gets project disk autoscale configSUPABASE_V1_GET_PROJECT_DISK_AUTOSCALE_CONFIGGets project disk autoscale config需要连接
Gets project disk autoscale config
认证
需要 Connected AccountTags
Gets a project's function combined statisticsSUPABASE_V1_GET_PROJECT_FUNCTION_COMBINED_STATSGets a project's function combined statistics需要连接
Gets a project's function combined statistics
认证
需要 Connected AccountTags
Gets all project's logs in a single log streamSUPABASE_V1_GET_PROJECT_LOGSExecutes an SQL or LQL query on the project's unified logs stream. Either the `iso_timestamp_start` and `iso_timestamp_end` parameters must be provided. If both are not provided, only the last 1 minute of logs will be queried. The timestamp range must be no more than 24 hours and is rounded to the nearest minute. If the range is more than 24 hours, a validation error will be thrown. Filter by the `source` column to specify specific log sources, such as edge_logs, postgres_logs, etc. Note: SQL must be written in **ClickHouse SQL dialect**.需要连接1 scope
Executes an SQL or LQL query on the project's unified logs stream. Either the `iso_timestamp_start` and `iso_timestamp_end` parameters must be provided. If both are not provided, only the last 1 minute of logs will be queried. The timestamp range must be no more than 24 hours and is rounded to the nearest minute. If the range is more than 24 hours, a validation error will be thrown. Filter by the `source` column to specify specific log sources, such as edge_logs, postgres_logs, etc. Note: SQL must be written in **ClickHouse SQL dialect**.
认证
需要 Connected AccountScopes
analytics:readTags
Gets project's logsSUPABASE_V1_GET_PROJECT_LOGS_ALLExecutes a SQL query on the project's logs. Either the `iso_timestamp_start` and `iso_timestamp_end` parameters must be provided. If both are not provided, only the last 1 minute of logs will be queried. The timestamp range must be no more than 24 hours and is rounded to the nearest minute. If the range is more than 24 hours, a validation error will be thrown. Note: Unless the `sql` parameter is provided, only edge_logs will be queried. See the [log query docs](/docs/guides/telemetry/logs?queryGroups=product&product=postgres&queryGroups=source&source=edge_logs#querying-with-the-logs-explorer:~:text=logs%20from%20the-,Sources,-drop%2Ddown%3A) for all available sources.需要连接1 scope
Executes a SQL query on the project's logs. Either the `iso_timestamp_start` and `iso_timestamp_end` parameters must be provided. If both are not provided, only the last 1 minute of logs will be queried. The timestamp range must be no more than 24 hours and is rounded to the nearest minute. If the range is more than 24 hours, a validation error will be thrown. Note: Unless the `sql` parameter is provided, only edge_logs will be queried. See the [log query docs](/docs/guides/telemetry/logs?queryGroups=product&product=postgres&queryGroups=source&source=edge_logs#querying-with-the-logs-explorer:~:text=logs%20from%20the-,Sources,-drop%2Ddown%3A) for all available sources.
认证
需要 Connected AccountScopes
analytics:readTags
Get project's pgbouncer configSUPABASE_V1_GET_PROJECT_PGBOUNCER_CONFIGGet project's pgbouncer config需要连接1 scope
Get project's pgbouncer config
认证
需要 Connected AccountScopes
database:readTags
Get a third-party integrationSUPABASE_V1_GET_PROJECT_TPA_INTEGRATIONGet a third-party integration需要连接1 scope
Get a third-party integration
认证
需要 Connected AccountScopes
auth:readTags
Gets project's usage api countsSUPABASE_V1_GET_PROJECT_USAGE_API_COUNTGets project's usage api counts需要连接
Gets project's usage api counts
认证
需要 Connected AccountTags
Gets project's usage api requests countSUPABASE_V1_GET_PROJECT_USAGE_REQUEST_COUNTGets project's usage api requests count需要连接
Gets project's usage api requests count
认证
需要 Connected AccountTags
Returns project's readonly mode statusSUPABASE_V1_GET_READONLY_MODE_STATUSReturns project's readonly mode status需要连接1 scope
Returns project's readonly mode status
认证
需要 Connected AccountScopes
database:readTags
Gets realtime configurationSUPABASE_V1_GET_REALTIME_CONFIGGets realtime configuration需要连接
Gets realtime configuration
认证
需要 Connected AccountTags
Get restore points for projectSUPABASE_V1_GET_RESTORE_POINTGet restore points for project需要连接1 scope
Get restore points for project
认证
需要 Connected AccountScopes
database:readTags
Gets project security advisors.SUPABASE_V1_GET_SECURITY_ADVISORSThis is an **experimental** endpoint. It is subject to change or removal in future versions. Use it with caution, as it may not remain supported or stable.需要连接1 scope
This is an **experimental** endpoint. It is subject to change or removal in future versions. Use it with caution, as it may not remain supported or stable.
认证
需要 Connected AccountScopes
database:readTags
Gets project's service health statusSUPABASE_V1_GET_SERVICES_HEALTHGets project's service health status需要连接1 scope
Gets project's service health status
认证
需要 Connected AccountScopes
projects:readTags
[Beta] Get project's SSL enforcement configuration.SUPABASE_V1_GET_SSL_ENFORCEMENT_CONFIG[Beta] Get project's SSL enforcement configuration.需要连接1 scope
[Beta] Get project's SSL enforcement configuration.
认证
需要 Connected AccountScopes
database:readTags
Gets project's storage configSUPABASE_V1_GET_STORAGE_CONFIGGets project's storage config需要连接
Gets project's storage config
认证
需要 Connected AccountTags
[Beta] Gets current vanity subdomain configSUPABASE_V1_GET_VANITY_SUBDOMAIN_CONFIG[Beta] Gets current vanity subdomain config需要连接1 scope
[Beta] Gets current vanity subdomain config
认证
需要 Connected AccountScopes
domains:readTags
List all action runsSUPABASE_V1_LIST_ACTION_RUNSReturns a paginated list of action runs of the specified project.需要连接1 scope
Returns a paginated list of action runs of the specified project.
认证
需要 Connected AccountScopes
environment:readTags
Lists all backupsSUPABASE_V1_LIST_ALL_BACKUPSLists all backups需要连接1 scope
Lists all backups
认证
需要 Connected AccountScopes
database:readTags
List all database branchesSUPABASE_V1_LIST_ALL_BRANCHESReturns all database branches of the specified project.需要连接1 scope
Returns all database branches of the specified project.
认证
需要 Connected AccountScopes
environment:readTags
Lists all bucketsSUPABASE_V1_LIST_ALL_BUCKETSLists all buckets需要连接1 scope
Lists all buckets
认证
需要 Connected AccountScopes
storage:readTags
List all functionsSUPABASE_V1_LIST_ALL_FUNCTIONSReturns all functions you've previously added to the specified project.需要连接1 scope
Returns all functions you've previously added to the specified project.
认证
需要 Connected AccountScopes
edge_functions:readTags
List all organizationsSUPABASE_V1_LIST_ALL_ORGANIZATIONSReturns a list of organizations that you currently belong to.需要连接1 scope
Returns a list of organizations that you currently belong to.
认证
需要 Connected AccountScopes
organizations:readTags
List all projectsSUPABASE_V1_LIST_ALL_PROJECTSReturns a list of all projects you've previously created.需要连接1 scope
Returns a list of all projects you've previously created.
认证
需要 Connected AccountScopes
projects:readTags
Lists SQL snippets for the logged in userSUPABASE_V1_LIST_ALL_SNIPPETSLists SQL snippets for the logged in user需要连接1 scope
Lists SQL snippets for the logged in user
认证
需要 Connected AccountScopes
database:readTags
Lists all SSO providersSUPABASE_V1_LIST_ALL_SSO_PROVIDERLists all SSO providers需要连接1 scope
Lists all SSO providers
认证
需要 Connected AccountScopes
auth:readTags
Lists available restore versions for the given projectSUPABASE_V1_LIST_AVAILABLE_RESTORE_VERSIONSLists available restore versions for the given project需要连接1 scope
Lists available restore versions for the given project
认证
需要 Connected AccountScopes
projects:readTags
List all user-id to role mappings for JIT accessSUPABASE_V1_LIST_JIT_ACCESSMappings of roles a user can assume in the project database需要连接
Mappings of roles a user can assume in the project database
认证
需要 Connected AccountTags
List applied migration versionsSUPABASE_V1_LIST_MIGRATION_HISTORYList applied migration versions需要连接1 scope
List applied migration versions
认证
需要 Connected AccountScopes
database:readTags
List members of an organizationSUPABASE_V1_LIST_ORGANIZATION_MEMBERSList members of an organization需要连接1 scope
List members of an organization
认证
需要 Connected AccountScopes
organizations:readTags
List billing addons and compute instance selectionsSUPABASE_V1_LIST_PROJECT_ADDONSReturns the billing addons that are currently applied, including the active compute instance size, and lists every addon option that can be provisioned with pricing metadata.需要连接
Returns the billing addons that are currently applied, including the active compute instance size, and lists every addon option that can be provisioned with pricing metadata.
认证
需要 Connected AccountTags
Lists all third-party auth integrationsSUPABASE_V1_LIST_PROJECT_TPA_INTEGRATIONSLists all third-party auth integrations需要连接1 scope
Lists all third-party auth integrations
认证
需要 Connected AccountScopes
auth:readTags
Scrape a project's metricsSUPABASE_V1_SCRAPE_PROJECT_METRICSPrometheus scrape endpoint. Returns metrics of a customer project in the Prometheus open exposition format.需要连接1 scope
Prometheus scrape endpoint. Returns metrics of a customer project in the Prometheus open exposition format.
认证
需要 Connected AccountScopes
analytics:readTags