Supabase

Configuration

Get Many Rows

Operation

Get Many Rows

Project ID*

••••••••

Table*

Name of the table

Service Role Secret*

••••••••

Filter (PostgREST syntax)

status=eq.active

Order By

column_name (add DESC for descending)

Limit

100

Get Many Rows (supabase_query)

Query data from a Supabase table

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	Your Supabase project ID (e.g., jdrkgepadsdopsntdlom)
`table`	string	Yes	The name of the Supabase table to query
`filter`	string	No	PostgREST filter (e.g., "id=eq.123")
`orderBy`	string	No	Column to order by (add DESC for descending)
`limit`	number	No	Maximum number of rows to return
`apiKey`	string	Yes	Your Supabase service role secret key

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of records returned from the query

Get a Row

Operation

Get a Row

Project ID*

••••••••

Table*

Name of the table

Service Role Secret*

••••••••

Filter (PostgREST syntax)*

id=eq.123

Get a Row (supabase_get_row)

Get a single row from a Supabase table based on filter criteria

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	Your Supabase project ID (e.g., jdrkgepadsdopsntdlom)
`table`	string	Yes	The name of the Supabase table to query
`filter`	string	Yes	PostgREST filter to find the specific row (e.g., "id=eq.123")
`apiKey`	string	Yes	Your Supabase service role secret key

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array containing the row data if found, empty array if not found

Create a Row

Operation

Create a Row

Project ID*

••••••••

Table*

Name of the table

Service Role Secret*

••••••••

Data*

json

{ "column1": "value1", "column2": "value2" }

Create a Row (supabase_insert)

Insert data into a Supabase table

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	Your Supabase project ID (e.g., jdrkgepadsdopsntdlom)
`table`	string	Yes	The name of the Supabase table to insert data into
`data`	array	Yes	The data to insert (array of objects or a single object)
`apiKey`	string	Yes	Your Supabase service role secret key

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of inserted records

Update a Row

Operation

Update a Row

Project ID*

••••••••

Table*

Name of the table

Service Role Secret*

••••••••

Data*

json

{ "column1": "value1", "column2": "value2" }

Filter (PostgREST syntax)*

id=eq.123

Update a Row (supabase_update)

Update rows in a Supabase table based on filter criteria

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	Your Supabase project ID (e.g., jdrkgepadsdopsntdlom)
`table`	string	Yes	The name of the Supabase table to update
`filter`	string	Yes	PostgREST filter to identify rows to update (e.g., "id=eq.123")
`data`	object	Yes	Data to update in the matching rows
`apiKey`	string	Yes	Your Supabase service role secret key

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of updated records

Delete a Row

Operation

Delete a Row

Project ID*

••••••••

Table*

Name of the table

Service Role Secret*

••••••••

Filter (PostgREST syntax)*

id=eq.123

Delete a Row (supabase_delete)

Delete rows from a Supabase table based on filter criteria

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	Your Supabase project ID (e.g., jdrkgepadsdopsntdlom)
`table`	string	Yes	The name of the Supabase table to delete from
`filter`	string	Yes	PostgREST filter to identify rows to delete (e.g., "id=eq.123")
`apiKey`	string	Yes	Your Supabase service role secret key

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of deleted records

Upsert a Row

Operation

Upsert a Row

Project ID*

••••••••

Table*

Name of the table

Service Role Secret*

••••••••

Data*

json

{ "column1": "value1", "column2": "value2" }

Upsert a Row (supabase_upsert)

Insert or update data in a Supabase table (upsert operation)

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	Your Supabase project ID (e.g., jdrkgepadsdopsntdlom)
`table`	string	Yes	The name of the Supabase table to upsert data into
`data`	array	Yes	The data to upsert (insert or update) - array of objects or a single object
`apiKey`	string	Yes	Your Supabase service role secret key

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of upserted records

Vector Search

Operation

Vector Search

Project ID*

••••••••

Table*

Name of the table

Service Role Secret*

••••••••

Function Name*

match_documents

Query Embedding*

json

[0.1, 0.2, 0.3, ...]

Match Threshold (optional)

0.78

Match Count (optional)

Vector Search (supabase_vector_search)

Perform similarity search using pgvector in a Supabase table

Input

Parameter	Type	Required	Description
`projectId`	string	Yes	Your Supabase project ID (e.g., jdrkgepadsdopsntdlom)
`functionName`	string	Yes	The name of the PostgreSQL function that performs vector search (e.g., match_documents)
`queryEmbedding`	array	Yes	The query vector/embedding to search for similar items
`matchThreshold`	number	No	Minimum similarity threshold (0-1), typically 0.7-0.9
`matchCount`	number	No	Maximum number of results to return (default: 10)
`apiKey`	string	Yes	Your Supabase service role secret key

Output

Parameter	Type	Description
`message`	string	Operation status message
`results`	array	Array of records with similarity scores from the vector search. Each record includes a similarity field (0-1) indicating how similar it is to the query vector.

Usage Instructions

Integrate Supabase into the workflow. Can get many rows, get, create, update, delete, and upsert a row.

Notes

Category: tools
Type: supabase

Supabase

On this page