BuildShip Logo
BuildShip Community
TemplatesSupabase CRUD Operations

Supabase CRUD Operations

Simple template to showcase how you can create workflows for Read, Write/Update and Delete operations on your Supabase database

798

Report this template

Select the reason for reporting

Describe the issue in detail

Share template

Link to template

https://templates.buildship.com/template/oHqPvCuFZXun/
BuildShipBy BuildShip

This template contains 3 flows:

Inputs

Table name

restaurant-menu
This is a static example using sample inputs. Remix the template to run it with your own values.

Output

Read me

đź“– How to do CRUD operations in your Supabase tables

Overview

This template allows you to perform the following actions on a Supabase table:

  • Read Data
  • Create Data
  • Update Data
  • Delete Data

This template uses an example Supabase with mock data to test the 'READ DATA' flow only.

Prerequisites

  • Get your API Key and Project URL from your Supabase account. Get it from your Supabase Project API.
  • Set up a Table in Supabase. Add the name of the table and the fields necessary for your data. Click on Import data via spreadsheet
  • On the next screen select the option Paste text and copy/paste the following data 
name	description	price	category	vegetarian	ingredients	ID
Aperol Spritz	A popular Italian aperitif cocktail, light and refreshing	8	Drink	YES	Aperol, prosecco, soda water	82738969-aaa7-4f72-9f6a-a1c254b4ff41
Arancini	Crispy fried risotto balls, often stuffed with mozzarella and peas	12	Starter	NO	Rice, mozzarella, tomato sauce	2aad99d9-f00c-413f-91c1-e1738b7aa7c6
Bistecca Fiorentina	A large, thick cut of T-bone steak from the Tuscany region	30	Main	NO	T-bone steak, olive oil, rosemary	fba7998b-4a5e-4dda-a2e7-824fb4f0b7df
Chianti Classico	From the heart of the Chianti region, this red wine is bold	9	Drink	YES	Sangiovese grapes	0098c6ff-8644-45ce-8ee1-0e82fe67e88c
Eggplant Parmigiana	Layers of thinly sliced eggplants, coated with tomato sauce and mozzarella	15	Vegetarian	YES	Eggplant, tomato sauce, mozzarella	66ce20c3-f833-4ecf-986b-4c08d0ecf6c1
Fettuccine Alfredo	A simple yet rich pasta dish combining butter and parmesan	13	Main	YES	Fettuccine, butter, parmesan	625de5f3-838b-4256-b8cf-178b5e1d2b74
Lasagna Bolognese	A traditional Italian lasagna made with layers of ragù and béchamel sauce	15	Main	NO	Lasagna noodles, ragù (beef sauce), béchamel	fe97fb48-c509-4195-8ecd-372c1f60abeb
Linguine with Clam Sauce	A flavorful pasta dish featuring linguine tossed with clams and garlic	18	Main	NO	Linguine, clams, garlic, white wine	fdaa0d6e-2e1d-4830-8911-baae1138cd1f
Mineral Water	From the heart of the Chianti region, this still water is pure and refreshing	9	Drink	YES	Sangiovese grapes	0098c6ff-8644-45ce-8ee1-0e82fe67e88c
Negroni	An iconic Italian cocktail, known for its bittersweet balance	10	Drink	YES	Gin, Campari, sweet vermouth	1e937e76-775e-40c9-aa18-9d9d9e3ed4a6
Panna Cotta	A smooth, creamy dessert made with cream and gelatin	6	Dessert	YES	Cream, sugar, gelatin, vanilla	cf10d507-082d-49b6-b7f5-313f4703b1d7
Penne Arrabbiata	A spicy pasta dish from Rome made with tomato sauce and chili peppers	12	Main	YES	Penne, tomato sauce, garlic, chili	fed7c69b-e287-4952-b549-cf02f74b2169
Peroni	A premium Italian lager with a crisp, refreshing taste	6	Drink	YES	Barley malt, hops	809462e9-73bc-4936-84a1-6fdf0cd0fefe
Risotto al Funghi	Creamy and aromatic risotto cooked with mushrooms and parmesan	16	Main	YES	Arborio rice, mushrooms, parmesan	839a5277-93e8-403e-ac4c-9e6b9f37d4e9
Soave Classico	A light-bodied white wine from the Verona region	10	Drink	YES	Garganega grapes	64733896-31eb-481a-8414-73620c03a9a7
Strawberry Smoothie	A creamy, refreshing smoothie made with fresh strawberries and yogurt	6	Drink	YES	Strawberries, yogurt, honey, ice	62424730-0465-4723-91d4-772e06e2fb0e
Tiramisu	A classic Italian no-bake dessert made with layers of mascarpone and coffee-soaked ladyfingers	7	Dessert	YES	Mascarpone, espresso, ladyfinger	ae2b3c84-8693-46ad-8247-69f1cb7f599a
Water (Still)	Pure, still water, served chilled for refreshment	2	Drink	YES	EMPTY	13adebeb-fa1a-44e9-bb2a-6e3250ac2fd3

✍️ How to Use

Step 1. Add your Supabase Key

Step 2. Add your Supabase Project URL as a variable

Step 3. Change the default value to your table name

Step 4. Test your workflow with your table from Supabase or run an example to see what the response would look like

-

đź”— Resources

Supabase Mock up data

Related Templates

BuildShip Database
OpenAI

AI Chatbot

Create a simple AI Chatbot with BuildShip and OpenAI Assistant, using a BuildShip database to keep track of the thread ID to enable conversation history.

BuildShipBy BuildShip
2470
OpenAI

AI Assistant

Great for building chatbots and virtual assistants.

BuildShipBy BuildShip
1395
BuildShip Workspace

Scrape Website

Extract all visible text from a website. Enter a website URL and optionally a CSS selector to target a specific section; the tool scrapes the main page or, if chosen, all linked pages, returning the collected text content as output.

BuildShipBy BuildShip
1380
Anthropic

AI Web Scraper (Anthropic)

Extract structured data from any website by specifying the fields you want. Enter a website URL and a comma-separated list of field names; the tool scrapes the page and returns the extracted information as a structured array of objects.

BuildShipBy BuildShip
721
Google Sheets
OpenAI

Chat with Google Sheets

Create an AI Assistant that can chat with your data on Google Sheets. This template is connected to a Furniture store's inventory data on Google Sheets and users can chat with the data to get meaningful recommendation for products.

BuildShipBy BuildShip
660
YouTube
OpenAI

YouTube Creators Finder

Struggling to find YouTube creators in your niche? This AI-powered BuildShip workflow scans YouTube, identifies creators, and delivers insightful reports—fast. Discover, analyze, and connect in seconds!

BuildShipBy BuildShip
580