Supabase
Automate database operations with Supabase and emma
With emma's Supabase integration, you can directly interact with your Supabase database. Manage tables, query data, and perform CRUD operations through automated workflows.
Features
Supabase_Operator supports the following 9 tools:
Authentication
Authentication Method:API Key
Supabase uses API key authentication. Choose between Anon Key (read-only) or Service Role Key (full access).
| Category | Tools | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Read Operations | 5 | |||||||||||||||||||
| ||||||||||||||||||||
| Write Operations | 4 | |||||||||||||||||||
| ||||||||||||||||||||
Main Parameters
| Parameter | Description |
|---|---|
| table | Name of the target table |
| columns | Columns to select (array of column names) |
| filter | Filter conditions for the query |
| order | Sort order (column and direction) |
| limit | Maximum number of rows to return |
| offset | Number of rows to skip (for pagination) |
| data | Data object for insert/update operations |
API Key Types and Permissions
Supabase offers two types of API keys. The operations you can perform depend on which key you use.
Anon Key
A public key with Row Level Security (RLS) applied.
- ✓ Read operations allowed
- ✓ Access restricted by RLS policies
- ✗ Cannot write/delete unless RLS allows
Service Role Key
A secret admin key that bypasses RLS.
- ✓ Full access to all tables
- ✓ Bypasses RLS for direct operations
- ⚠ Use only server-side, never expose publicly
Prerequisites
- • emma account
- • Supabase account
- • Supabase project with database
- • Supabase URL and anon/service key
Setup
Simply select Supabase_Operator in emma and configure your Supabase URL and API key to start using it immediately.
