Supabase API - Database, Storage, Auth & Project Management

API Integration

This actor connects to an external API service. You'll need valid API credentials from the service provider.

---

API Integration

This actor connects to an external API service. You'll need valid API credentials from the service provider.

---

Access Supabase programmatically. Query and manage databases, upload/download files from storage, manage authentication users, and control projects. Perfect for database automation, data migration, backup workflows, and Supabase-powered app integrations.

Features

Database Operations

• query_table - Query any table with PostgREST filters, sorting, and pagination
• insert_rows - Insert one or multiple rows into a table
• update_rows - Update rows matching filter criteria
• delete_rows - Delete rows matching filter criteria
• list_tables - List all tables in your database
• run_sql - Execute raw SQL queries (service_role key required)

Storage Operations

• list_buckets - List all storage buckets
• list_files - List files in a bucket
• download_file - Get download URL for a file
• upload_file - Upload a file to storage from URL
• delete_file - Delete a file from storage

Auth Operations

• list_users - List all authenticated users
• get_user - Get user details by ID
• create_user - Create a new user account
• delete_user - Delete a user account

Project Management

• list_projects - List all your Supabase projects
• get_project - Get project details
• get_project_settings - Get project configuration and settings

Quick Start

{
  "input": "your input here"
}

Demo Mode

Set demoMode: true to test with sample data (no charges). When you're ready for real results, set demoMode: false or omit it.

{
  "demoMode": true,
  ...
}

Input Parameters

Parameter	Type	Required	Description
See input schema

Output Format

{
  "task": "query_table",
  "success": true,
  "results": [
    {
      "id": 1,
      "name": "John Doe",
      "email": "john@example.com",
      "created_at": "2024-01-15T10:00:00Z"
    }
  ],
  "count": 1,
  "pagination": {
    "limit": 100,
    "offset": 0
  },
  "timestamp": "2024-01-20T14:30:00Z"
}

Pricing

This actor uses pay-per-event billing: $0.01 per query (all tasks)

Use Cases

• Database Automation - Scheduled data exports, imports, and transformations
• Data Migration - Move data between Supabase projects or from other sources
• Backup Workflows - Automated data and file backups
• User Management - Bulk user operations and sync with external systems
• Content Management - Programmatic file uploads for CMS workflows
• Analytics Pipelines - Extract data for reporting and analysis
• Multi-tenant Apps - Manage multiple projects programmatically

---

Common Problems & Solutions

"Invalid API key" error

Cause: Your API key is wrong, expired, or doesn't have the right permissions. Fix: Double-check your API key. Make sure you copied it exactly without extra spaces.

"Rate limit exceeded" error

Cause: You've hit the API's rate limits. Fix: Wait a few minutes, then try again. Consider reducing the number of concurrent requests.

Empty or incomplete results

Cause: The target may have anti-scraping protection or the data doesn't exist. Fix:

• Check if the URL/search query is correct
• Try with different parameters
• Some sites may block automated access

Demo data showing instead of real results

Cause: demoMode is still set to true. Fix: Set demoMode: false and provide your API key(s).

---

Built by John Rippy | Actor Arsenal