The Autohive Supabase integration connects your Supabase project with Autohive’s automation platform, enabling:

  • Database operations - Run SQL queries, insert, update, delete, and upsert records across all your tables
  • Row-level data access - Fetch individual rows or filtered datasets using PostgREST-style queries
  • Authentication management - Create, update, list, and delete users in your Supabase Auth system
  • Storage management - Upload, download, list, and delete files across your Supabase storage buckets
  • Edge Function invocation - Trigger your deployed Supabase Edge Functions with custom payloads
  • Realtime awareness - Query live table state to power dynamic, data-driven workflows

Install the integration

Supabase uses API key authentication. You will need your project URL and service role key from the Supabase dashboard.

  1. Log in to Autohive and navigate to Your user profile > Connections or Your workspace → Manage workspace

  2. Locate the Supabase Integration card and click Connect

    List of integrations in Autohive

  3. Enter your credentials:

    • Project URL — Your Supabase project URL, e.g. https://xyzcompany.supabase.co
    • Service Role Key — Your project’s service_role secret key (found in Project Settings → API)

  4. Click Save to complete the connection

Finding your credentials

  1. Log in to the Supabase Dashboard
  2. Select your project
  3. Navigate to Project Settings → API
  4. Copy the Project URL and the service_role key (under “Project API keys”)

Use the integration

You can now use the integration with your agents, workflows, and scheduled tasks!

  1. Follow our Create your first agent guide on how to create an agent.
  2. In the Agent settings, scroll down to the Add capabilities section and turn on the Supabase capability. You can choose which individual Supabase capabilities to turn on and off.
  3. Once the settings have been selected, begin prompting the agent with the workflow you’d like to achieve with Autohive and Supabase!

Available capabilities

Database Operations

  • Execute SQL — Run arbitrary SQL queries against your Supabase Postgres database, including SELECT, INSERT, UPDATE, DELETE, and DDL statements
  • Select Rows — Fetch rows from a table with filtering, ordering, and pagination using PostgREST query syntax
  • Insert Rows — Insert one or more rows into a table with support for upsert (insert or update on conflict)
  • Update Rows — Update existing rows matching a filter condition
  • Delete Rows — Delete rows from a table matching a filter condition
  • Upsert Rows — Insert rows, updating existing ones on primary key conflict

Authentication (Auth)

  • List Users — Retrieve all users registered in your Supabase Auth system with pagination support
  • Get User — Fetch a single user’s profile by their UUID
  • Create User — Create a new auth user with email, password, and optional metadata
  • Update User — Update an existing user’s email, password, metadata, or role
  • Delete User — Permanently delete a user from Supabase Auth

Storage

  • List Buckets — Retrieve all storage buckets in your Supabase project
  • List Files — List files within a specific bucket and folder path
  • Upload File — Upload a file to a bucket with configurable content type and upsert support
  • Download File — Download a file’s content from a bucket
  • Delete Files — Delete one or more files from a bucket
  • Get Public URL — Generate a public URL for a file in a public bucket
  • Create Signed URL — Generate a time-limited signed URL for private file access

Edge Functions

  • Invoke Edge Function — Call a deployed Supabase Edge Function by name with a custom JSON payload and optional HTTP headers

Key features

Full Postgres Access

  • Direct SQL execution against your Supabase Postgres database
  • Support for complex queries, joins, aggregations, and stored procedures
  • PostgREST-style row-level operations for common CRUD patterns without writing SQL
  • Handles both public and private schema tables

Complete Auth User Lifecycle

  • Manage users from sign-up through deletion entirely via Autohive agents
  • Update user metadata, roles, and credentials programmatically
  • List and audit registered users for compliance or reporting workflows

Flexible Storage Operations

  • Full file lifecycle management across all your storage buckets
  • Support for public and private buckets with signed URL generation
  • Upload binary content or text files with configurable MIME types

Edge Function Integration

  • Trigger serverless business logic hosted on Supabase directly from Autohive workflows
  • Pass structured JSON payloads and capture function responses for downstream processing

Common use cases

Automated Data Pipelines

  • Insert data collected from forms, webhooks, or external APIs directly into Supabase tables
  • Run scheduled SQL queries to aggregate or clean data and write results back to the database
  • Sync records between Supabase and other platforms (CRMs, spreadsheets, data warehouses)

User Management Automation

  • Automatically provision Supabase Auth users when new members join your platform
  • Bulk update user metadata or roles based on external events or subscription changes
  • Generate user audit reports by listing and filtering auth users on a schedule

AI-Powered Database Queries

  • Let an Autohive agent answer natural language questions about your data by translating them into SQL
  • Generate weekly summaries or reports by querying tables and formatting results with AI
  • Detect anomalies or trends in your database and surface insights via Slack or email

File Processing Workflows

  • Upload processed files (generated PDFs, images, exports) to Supabase Storage after AI generation
  • Retrieve files from storage, process their content with an agent, and write results back to the database
  • Generate signed URLs for secure, time-limited access to private assets

Backend Automation via Edge Functions

  • Trigger Edge Functions to execute business logic (send emails, process payments, run validations) from within Autohive workflows
  • Chain Edge Function calls with database reads and writes in a single automated task

Disconnect the integration

  1. Navigate to Your user profile → Connections or Your workspace → Manage workspace
  2. Find the Supabase Integration
  3. Click Disconnect and confirm

Data Impact: Existing data in your Supabase project remains completely unchanged. Disconnecting only removes Autohive’s API access.

Notes

  • The service role key has full database access and bypasses RLS. Use it only in server-side contexts like Autohive — never in client-side applications.
  • SQL execution supports any valid Postgres statement. Use with care when running destructive queries (e.g. DROP, TRUNCATE).
  • Storage upload accepts base64-encoded content or raw text. Binary files should be base64-encoded before passing to the upload capability.
  • Edge Functions must be deployed to your Supabase project before they can be invoked via Autohive.