Supabase

What is the Supabase Connection?

The Supabase connection connects your Supabase project to Duvo, enabling your assignments to query databases, manage tables, and access your project resources. You will need to authenticate with your Supabase account before your assignments can use it.

What Can It Do?

The Supabase connection provides actions that allow your assignments to:

• Query databases: Run queries against your Supabase PostgreSQL database to retrieve business data

• Manage tables: Browse table structures, read records, and understand your data schema

• Access project resources: Interact with your Supabase project settings and resources

Why This Matters

Supabase is a popular backend platform used by many teams to store and manage application data. The Supabase connection allows your assignments to access this data directly -- pulling records for reports, checking application data for decision-making, and incorporating database information into automated workflows without writing custom queries or building API integrations.

When to Use It

Use the Supabase connection when your assignment needs to:

• Pull application data: Retrieve records from your Supabase database for analysis or reporting

• Monitor data changes: Check database records to trigger actions based on new or updated entries

• Generate data summaries: Query your database and compile results into written reports or emails

• Validate records: Cross-reference Supabase data with other systems for accuracy checks

• Automate data workflows: Use database data alongside other connections to drive automated processes

How It Works

After connecting your Supabase account, your assignments can access your project's database using your credentials and permissions. When you include Supabase actions in your assignment's SOP, it will query your database to retrieve the information needed for workflow decisions, respecting your existing row-level security and access controls.

Key Benefits

• Direct database access: Query your Supabase data without manual exports or custom API calls

• Secure authentication: Uses your Supabase credentials with your existing permissions and security policies

• Flexible querying: Retrieve exactly the data your workflow needs from any table in your project

• Real-time data: Access current database records rather than relying on periodic exports

Works Well With

• Google Sheets or Microsoft Excel: Pull Supabase data and write it into spreadsheets for stakeholder reporting or further analysis

• Gmail or Microsoft Outlook: Query database records and include them in automated notification or summary emails

• Slack or Microsoft Teams: Retrieve data from Supabase and post updates or alerts to team channels