The Challenge
Many teams invest significant time building sophisticated logic directly into PostgreSQL stored procedures—calculated procedures, complex transformations, and database-level transactions. The problem is triggering that logic automatically:
- Manually running stored procedures requires database access and engineering time
- Rebuilding the same logic in an automation layer creates duplication and maintenance burden
- Scheduling or event-driven execution of database functions requires custom infrastructure
- Coordinating backend function calls across multi-step workflows is complex without the right tools
The Autohive Solution
Autohive’s Supabase integration includes full RPC (Remote Procedure Call) support, letting you invoke any PostgreSQL function you’ve defined in your Supabase project—directly from your automation workflows, with optional parameters for tailored execution.
Trigger Any PostgreSQL Function
Call your custom stored procedures as part of any Autohive workflow. Whether it’s a data aggregation function, a business rule evaluator, or a complex transformation procedure, Autohive can invoke it automatically.
Pass Dynamic Parameters
Supply runtime parameters to your PostgreSQL functions based on workflow context—making each function call tailored to the specific data or trigger condition at hand. No hardcoded values, no manual intervention.
Compose Multi-Step Backend Workflows
Chain RPC calls with other Autohive actions. Query data first, pass results into a stored procedure, then use the output to update records or trigger downstream notifications—all in a single automated workflow.
Event-Driven Execution
Trigger backend logic based on external events, schedules, or upstream workflow steps. Your PostgreSQL functions run exactly when needed, without anyone manually firing them.
Benefits
- Reuse existing backend logic - Leverage the stored procedures your team already built, without rebuilding them
- Zero duplication - Your business logic lives in one place (your database), and automation calls it rather than duplicating it
- Flexible parameterization - Dynamic inputs mean each function call is contextually relevant, not generic
- Reduced engineering involvement - Non-technical workflows can trigger complex backend operations automatically
How It Works
- Identify the PostgreSQL function - Choose the stored procedure or RPC endpoint you want to invoke in your Supabase project
- Configure your trigger - Set the event, schedule, or upstream workflow condition that should fire the function
- Define your parameters - Map dynamic values from your workflow context to the function’s input parameters
- Execute and route results - Autohive calls the function, captures the output, and passes results to the next step in your workflow
Getting Started
- Sign up at app.autohive.com
- Connect your Supabase project from the marketplace: Supabase Integration
- Build your RPC-based workflow using the visual workflow editor
- Deploy your agents and let automation call your backend logic on demand
