Supabase
API actions for the Supabase integration.
Supabase
Manage Supabase tables, stored procedures, and storage buckets.
Call a Supabase function
Invoke a Postgres function through Supabase.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
function_name | string | Yes | Name of the Postgres function. |
params | object | No | Parameters to pass to the function. |
Response
{
"result": {}
}Delete rows from a table
Delete rows in a Supabase table matching filters.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
table | string | Yes | Table name. |
filters | array | No | Filters to identify rows to delete. |
Response
{
"deleted": 1
}Insert row into a table
Insert a new row into a Supabase table.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
table | string | Yes | Table name. |
row | object | Yes | Row data to insert as a JSON object. |
Response
{
"row": {
"id": 2,
"name": "Inserted row"
}
}List rows from a table
Retrieve rows from a Supabase table with optional filters.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
table | string | Yes | Table name to query. |
select | string | No | Comma-separated list of columns to return. |
limit | number | No | Maximum number of rows to return. |
filters | array | No | Filters to apply (list of {column, operator, value}). |
Response
{
"rows": [
{
"id": 1,
"name": "Sample"
}
]
}List storage buckets
List Supabase storage buckets.
Response
{
"buckets": [
{
"id": "bucket_123",
"name": "public-assets",
"public": true
}
]
}List tables in a schema
Retrieve the tables available in a Supabase schema.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
schema | string | No | Schema name to query (defaults to public). |
Response
{
"tables": [
{
"schema": "public",
"table_name": "customers"
}
]
}Update rows in a table
Update rows in a Supabase table matching filters.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
table | string | Yes | Table name. |
updates | object | Yes | Fields and values to update. |
filters | array | No | Filters to identify rows to update. |
Response
{
"updated": 1
}