Connecting to Supabase

Supabase uses Management API tokens to control access to the Management API.

Using API Key Authentication

To obtain a Management API token, log in to your Supabase account and navigate to Account Settings > Access Tokens. Generate a new token with the appropriate permissions for managing your organizations and projects. You can set your API key in the ProfileSettings connection property.

Example connection string

Profile=C:\profiles\Supabase.apip;ProfileSettings='APIKey=sbp_your_management_api_token'AuthScheme=APIKey;

Usage Examples

Branch:

SELECT * FROM Branch

OrganizationMembers:

SELECT * FROM OrganizationMembers WHERE OrganizationId = 'org123'

OrganizationProjects:

SELECT * FROM OrganizationProjects WHERE OrganizationId = 'org123'

Organizations:

SELECT * FROM Organizations

ProjectAnalyticsApiCounts:

SELECT * FROM ProjectAnalyticsApiCounts WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectAnalyticsApiRequestsCount:

SELECT * FROM ProjectAnalyticsApiRequestsCount WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectApiKeys:

SELECT * FROM ProjectApiKeys WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectAuthConfig:

SELECT * FROM ProjectAuthConfig WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectAvailableRegions:

SELECT * FROM ProjectAvailableRegions WHERE OrganizationSlug = 'myorg'

ProjectBillingAddons:

SELECT * FROM ProjectBillingAddons WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectBranches:

SELECT * FROM ProjectBranches WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectDatabaseBackups:

SELECT * FROM ProjectDatabaseBackups WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectDatabaseJitAccess:

SELECT * FROM ProjectDatabaseJitAccess WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectDatabaseMigrations:

SELECT * FROM ProjectDatabaseMigrations WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectDatabasePostgresConfig:

SELECT * FROM ProjectDatabasePostgresConfig WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectFunctions:

SELECT * FROM ProjectFunctions WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectHealth:

SELECT * FROM ProjectHealth WHERE ProjectId = 'ttvohtavntbpzzvcznof' AND Services = 'api'

ProjectNetworkRestrictions:

SELECT * FROM ProjectNetworkRestrictions WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectPostgrestConfig:

SELECT * FROM ProjectPostgrestConfig WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectRealtimeConfig:

SELECT * FROM ProjectRealtimeConfig WHERE ProjectId = 'ttvohtavntbpzzvcznof'

Projects:

SELECT * FROM Projects

ProjectSslEnforcement:

SELECT * FROM ProjectSslEnforcement WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectStorageBuckets:

SELECT * FROM ProjectStorageBuckets WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectStorageConfig:

SELECT * FROM ProjectStorageConfig WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectUpgradeEligibility:

SELECT * FROM ProjectUpgradeEligibility WHERE ProjectId = 'ttvohtavntbpzzvcznof'

ProjectUpgradeStatus:

SELECT * FROM ProjectUpgradeStatus WHERE ProjectId = 'ttvohtavntbpzzvcznof'

Snippets:

SELECT * FROM Snippets

Connection Properties

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.

---

Property	Description
APIKey	Your Supabase Management API token for authentication.
AuthScheme	The scheme used for authentication. Accepted entries are APIKey or None. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT