/

Supabase

&

OpenAI

Integrate Supabase and OpenAI

Connect Supabase and OpenAI nodes in your workflow. Integrate with any tool or database and ship powerful backend logic and APIs instantly - No code required!

Node stack

Supported Supabase and OpenAI Nodes

Add any other tools or your preferred database nodes. If an integration is not available generate your own using AI

Supabase Trigger

Creates a database webhook on Supabase. In other words, this workflow will be executed when there is an event on the provided table. [Full Documentation](https://docs.buildship.com/trigger-nodes/supabase-trigger)

Create Row

Add new row(s) to your Supabase table.

Create Row with Token

Insert a JSON object to an existing table on Supabase via a POST request

Delete Row

Delete an existing table row using Supabase Realtime API endpoint.

Delete Row with Token

Delete an existing table row using Supabase Realtime API endpoint.

Get Columns

Gets all the values for the specified columns of a Supabase table.

Get Columns with Token

Read the specified columns of a Supabase table.

Get Row

Fetch a row from a Supabase table using the API URL, Key, table name, filter, and Authorization token.

Get Row with Token

Fetch a row from a Supabase table using the API URL, Key, table name, filter, and Authorization token.

List Supabase Projects

Returns a list of all projects you've previously created.

Postgres RPC

Initializes a Supabase client and calls a Postgres function as Remote Procedure Call.

Update Row

Update an existing table row using Supabase Realtime API endpoint

Update Row with Token

Update an existing table row using Supabase Realtime API endpoint

Upload File

Upload a file to a public Supabase storage bucket and return the download URL.

Fetch OpenAI File

Generates a readable stream for a file stored in OpenAI Storage. Return this stream using a 'Return' node to receive it through an API endpoint (to download the file, write it to the file system, etc.)

Generate Embeddings

Generate embeddings for a given content using OpenAI text-embedding-ada-002 model

GPT-4 Vision

Use GPT-4 Vision to ask questions about images.

Image Generator

Converts text to Base64 image using OpenAI's DALL·E models.

JSON Generator

Generates text based on a given user and system prompt and always returns a JSON object using the OpenAI GPT (Turbo) APIs.

LLM Extract

Extract structured data from any text input.

LLM Extract URL

Extract structured data from any web page.

Multi-Image GPT-4 Vision

Analyses multiple images using the OpenAI GPT-4 Vision model.

Neighbor Search

Find the nearest neighbors for a given search query using OpenAI embeddings

OpenAI Assistant

Add different script nodes and let the AI Assistant automatically choose which to execute based on the input. Built to work with OpenAI Assistants API V2.

OpenAI Assistant (Stream Response)

Add different script nodes and let the AI Assistant automatically choose which to execute based on the input. The node returns a streamed text response (meant to be returned back to the client) and the thread ID (to track the conversation). Built to work with OpenAI Assistants API.

Stream Response

Send a chat message to OpenAI and return the response stream. --- If you plan on sending this stream back to the client as the response, you may want to consider adding a **Set Response Header** node following this node (and before the return node) with the key set to `content-type` and the value set to `text/plain`, to make it easier for the client to figure out how to handle the stream.

Text Generator

Generates text using OpenAI API for a given user and system prompt

Text to Speech

Converts text to speech using OpenAI API and returns audio in Base64.

Whisper Speech To Text

Convert audio/speech to text using OpenAI's Whisper API.

Quick start

How to integrate Supabase and OpenAI

Step 1 — Add the nodes to your workflow

Create a new workflow in BuildShip, click “Add node”, and select the Supabase and OpenAI actions you want to use.

Step 2 — Configure each node

Go to each node to authenticate (or add your API key) and fill in the required parameters.

Step 3 — Connect the nodes

Each node in BuildShip can connect to others by using their output variables. When you reference a variable from one node in another, BuildShip automatically links them in the workflow.

Step 4 — Test your workflow

Define your starting data in the Inputs node and choose what to do with the result in the Flow Output node. Finally, run a test to see your workflow in action.

blog posts & tutorials

Recommended Reads

Below are recommneded blogs that will help in your journey