Skip to main content

Overview

The Supabase integration enables Steadwing to access your Supabase projects, database metrics, and configuration data. During root cause analysis, Steadwing can investigate database performance issues, connection pool problems, authentication errors, and service health to identify the underlying causes of incidents.

Why Use Supabase with Steadwing?

Database Health Monitoring

Monitor PostgreSQL performance, connection pools, and query metrics

Service Status Tracking

Track the health status of all Supabase services (Auth, Storage, PostgREST)

Configuration Analysis

Analyze database and API configurations to identify misconfigurations

Schema Investigation

Inspect table schemas, functions, and database branches during incidents

Setup Instructions

Step 1: Connect Supabase OAuth

  1. Navigate to Steadwing Settings
  2. Find the Supabase integration card
  3. Click the Connect button (toggle switch)
  4. You will be redirected to Supabase’s authorization page
  5. Select the organization you want to connect
  6. Click Authorize to grant Steadwing access to your Supabase projects

Step 2: Verify Connection

  1. Return to Steadwing Settings
  2. Confirm the Supabase integration shows as Connected
  3. The integration will now be available during incident analysis

How Supabase Integration Works

Data Collection

Steadwing can query Supabase for:
  • Service Health - Real-time health status of all Supabase services
  • Database Metrics - PostgreSQL configuration, connection pool stats, and performance data
  • Project Information - All projects, branches, and their configurations
  • Schema Details - Table schemas, database functions, and stored procedures
  • Storage Data - Storage buckets and their configurations
  • Auth Configuration - Authentication settings and providers
  • Network Settings - Network restrictions, bans, and security configurations

Root Cause Analysis

When analyzing an incident, Steadwing:
  1. Checks overall Supabase service health status
  2. Investigates PostgreSQL and PostgREST configurations
  3. Analyzes connection pool settings (PgBouncer)
  4. Reviews authentication configuration for auth-related issues
  5. Inspects table schemas and database functions
  6. Examines database branches and their configurations
  7. Provides database-specific insights in the RCA report

Available Capabilities

Database Management

  • List all database tables and their schemas
  • Retrieve database function definitions
  • Inspect database branches and configurations
  • View backup history

Project Configuration

  • Get PostgreSQL configuration settings
  • Review PostgREST API configuration
  • Check PgBouncer connection pooling settings
  • Analyze authentication configuration

Service Monitoring

  • Monitor service health status across all components
  • Track project upgrade status
  • Review network restrictions and security settings
  • Inspect pgsodium encryption configuration

Configuration

Required Permissions

The Supabase OAuth integration requires:
  • Read access to your Supabase organization
  • Read access to project configurations
  • Read access to database metadata
Steadwing does NOT have permission to:
  • Modify database data
  • Change project configurations
  • Delete or create resources
  • Access sensitive user data

Supported Features

  • Service health monitoring
  • Database configuration analysis
  • Schema and function inspection
  • Connection pool monitoring
  • Authentication configuration review
  • Storage bucket management
  • Network security analysis

FAQs

Steadwing reads project configurations, database schemas, service health status, and metadata. It does NOT access your actual database data, user information, or modify any settings.
The OAuth flow grants access at the organization level. You can control which projects Steadwing analyzes by managing your Supabase organization permissions.
No, Steadwing only has read access. It cannot modify database configurations, change settings, or alter any data.
When an incident occurs, Steadwing queries relevant Supabase metrics and configurations to identify database-related issues like connection pool exhaustion, slow queries, or service degradation.
Yes, go to Settings, find the Supabase integration, and click the toggle to disconnect. This will revoke Steadwing’s access to your Supabase organization.
OAuth tokens are automatically refreshed by Supabase. If the connection is lost, you’ll need to reconnect by following the setup instructions again.
Need additional help? Please reach out to us at [email protected]