Supabase

Supabase is a powerful open-source backend-as-a-service platform that provides developers with a suite of tools to build, scale, and manage modern applications. Supabase offers a fully managed PostgreSQL database, robust authentication, instant RESTful and GraphQL APIs, real-time subscriptions, file storage, and edge functions—all accessible through a unified and developer-friendly interface. Its open-source nature and compatibility with popular frameworks make it a compelling alternative to Firebase, with the added benefit of SQL flexibility and transparency.

Why Supabase?

• Instant APIs: Every table and view in your database is instantly available via REST and GraphQL endpoints, making it easy to build data-driven applications without writing custom backend code.
• Real-time Data: Supabase enables real-time subscriptions, allowing your apps to react instantly to changes in your database.
• Authentication & Authorization: Built-in user management with support for email, OAuth, SSO, and more, plus row-level security for granular access control.
• Storage: Securely upload, serve, and manage files with built-in storage that integrates seamlessly with your database.
• Edge Functions: Deploy serverless functions close to your users for low-latency custom logic.

Using Supabase in Sim

Sim’s Supabase integration makes it effortless to connect your agentic workflows to your Supabase projects. With just a few configuration fields—your Project ID, Table name, and Service Role Secret—you can securely interact with your database directly from your Sim blocks. The integration abstracts away the complexity of API calls, letting you focus on building logic and automations.

Key benefits of using Supabase in Sim:

• No-code/low-code database operations: Query, insert, update, and delete rows in your Supabase tables without writing SQL or backend code.
• Flexible querying: Use PostgREST filter syntax to perform advanced queries, including filtering, ordering, and limiting results.
• Seamless integration: Easily connect Supabase to other tools and services in your workflow, enabling powerful automations such as syncing data, triggering notifications, or enriching records.
• Secure and scalable: All operations use your Supabase Service Role Secret, ensuring secure access to your data with the scalability of a managed cloud platform.

Whether you’re building internal tools, automating business processes, or powering production applications, Supabase in Sim provides a fast, reliable, and developer-friendly way to manage your data and backend logic—no infrastructure management required. Simply configure your block, select the operation you need, and let Sim handle the rest.

Usage Instructions

Integrate Supabase into the workflow. Supports database operations (query, insert, update, delete, upsert), full-text search, RPC functions, row counting, vector search, and complete storage management (upload, download, list, move, copy, delete files and buckets).

Tools

supabase_query

Query data from a Supabase table

Input

Output

supabase_insert

Insert data into a Supabase table

Input

Output

supabase_get_row

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

Input

Output

supabase_update

Update rows in a Supabase table based on filter criteria

Input

Output

supabase_delete

Delete rows from a Supabase table based on filter criteria

Input

Output

supabase_upsert

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

Input

Output

supabase_count

Count rows in a Supabase table

Input

Output

supabase_text_search

Perform full-text search on a Supabase table

Input

Output

supabase_vector_search

Perform similarity search using pgvector in a Supabase table

Input

Output

supabase_rpc

Call a PostgreSQL function in Supabase

Input

Output

supabase_storage_upload

Upload a file to a Supabase storage bucket

Input

Output

supabase_storage_download

Download a file from a Supabase storage bucket

Input

Output

supabase_storage_list

List files in a Supabase storage bucket

Input

Output

supabase_storage_delete

Delete files from a Supabase storage bucket

Input

Output

supabase_storage_move

Move a file within a Supabase storage bucket

Input

Output

supabase_storage_copy

Copy a file within a Supabase storage bucket

Input

Output

supabase_storage_create_bucket

Create a new storage bucket in Supabase

Input

Output

supabase_storage_list_buckets

List all storage buckets in Supabase

Input

Output

supabase_storage_delete_bucket

Delete a storage bucket in Supabase

Input

Output

supabase_storage_get_public_url

Get the public URL for a file in a Supabase storage bucket

Input

Output

supabase_storage_create_signed_url

Create a temporary signed URL for a file in a Supabase storage bucket

Input

Output

Notes

• Category: tools
• Type: supabase