Lodol Docs

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

ParameterTypeRequiredDescription
function_namestringYesName of the Postgres function.
paramsobjectNoParameters to pass to the function.

Response

{
  "result": {}
}

Delete rows from a table

Delete rows in a Supabase table matching filters.

Parameters

ParameterTypeRequiredDescription
tablestringYesTable name.
filtersarrayNoFilters to identify rows to delete.

Response

{
  "deleted": 1
}

Insert row into a table

Insert a new row into a Supabase table.

Parameters

ParameterTypeRequiredDescription
tablestringYesTable name.
rowobjectYesRow 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

ParameterTypeRequiredDescription
tablestringYesTable name to query.
selectstringNoComma-separated list of columns to return.
limitnumberNoMaximum number of rows to return.
filtersarrayNoFilters 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

ParameterTypeRequiredDescription
schemastringNoSchema 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

ParameterTypeRequiredDescription
tablestringYesTable name.
updatesobjectYesFields and values to update.
filtersarrayNoFilters to identify rows to update.

Response

{
  "updated": 1
}

On this page