opencode

Connect OpenCode to Airtable and Supabase

Connect OpenCode to both Supabase and Airtable and it can manage your user accounts while keeping the record of who has access in a table your team owns. Supabase is where the auth users live and where the agent creates, updates, and removes them, and Airtable is the readable roster and audit log. OpenCode provisions or offboards a user, then writes the result back as a record or a comment. The pair turns account admin into something that documents itself.

Loading preview…
Opens a workflow with 58 tools ready to use.

Tools OpenCode gets

Pick the operations you want and each becomes a tool the agent can call directly while it works.

Airtable

24 tools
List Accessible Bases

List all accessible bases

Fetch Base Schema

Get the schema (tables and fields) of a base

Create New Table

Create a new table in a base

Update Table Metadata

Update a table's name or description

Create Table Field

Create a new field in a table

Update Table Field

Update a field's name or description

List Table Records

List records from a table with filtering, sorting, and pagination

Fetch Single Record

Get a single record by ID

Create Multiple Records

Create one or more records (batch create up to 10)

Update Multiple Records

Update one or more records (batch update up to 10)

Update Single Record

Update a single record by ID

Delete Multiple Records

Delete one or more records (batch delete up to 10)

Delete Single Record

Delete a single record by ID

Upsert Records by Field Match

Create or update records based on field matching (upsert)

List Record Comments

List comments on a record

Create Record Comment

Create a comment on a record

Update Record Comment

Update a comment

Delete Record Comment

Delete a comment

List Base Webhooks

List all webhooks for a base

Create Base Webhook

Create a webhook for a base

Delete Base Webhook

Delete a webhook

List Webhook Payloads

List payloads for a webhook

Refresh Webhook Expiration

Refresh a webhook to extend its expiration

Enable Webhook Notifications

Enable notifications for a webhook

Supabase

34 tools
Select Table Rows

Select/query rows from a table with filtering, ordering, and pagination

Insert Table Rows

Insert one or more rows into a table

Update Table Rows

Update rows matching filter conditions

Delete Table Rows

Delete rows matching filter conditions

Upsert Table Rows

Insert rows or update if they already exist (based on primary key or unique constraint)

Call Database Function

Call a database function (RPC)

Sign Up User

Sign up a new user with email and password

Sign in with Password

Sign in with email and password

Send Magic Link Signin

Send a magic link to user's email for passwordless signin

Sign Out User

Sign out the current user (requires user's access token)

Get Current User

Get current user details (requires user's access token)

Update Current User

Update current user's email, password, or metadata

Send Password Reset Email

Send password reset email to user

Verify Otp Code

Verify OTP code sent via email or SMS

Refresh Access Token

Refresh an expired access token using refresh token

Admin List Users

List all users (requires service_role API key)

Admin Create User

Create a new user (admin operation, requires service_role API key)

Admin Delete User

Delete a user by ID (admin operation, requires service_role API key)

Admin Update User

Update a user by ID (admin operation, requires service_role API key)

Create Storage Bucket

Create a new storage bucket

List Storage Buckets

List all storage buckets

Get Storage Bucket

Get bucket details

Delete Storage Bucket

Delete a storage bucket

Empty Storage Bucket

Empty a storage bucket (delete all files)

Upload Storage File

Upload a file to storage

Download Storage File

Download a file from storage

List Bucket Files

List files in a storage bucket folder

Delete Storage File

Delete a file from storage

Move Storage File

Move a file within or between buckets

Copy Storage File

Copy a file within or between buckets

Create File Signed Url

Create a signed URL for temporary file access

Get File Public Url

Get public URL for a file in a public bucket

Broadcast Realtime Message

Send broadcast messages to a Realtime channel

Invoke Edge Function

Invoke a Supabase Edge Function

What you can build

Read a table of new hires in Airtable, create their Supabase auth users, send each a magic link, and comment the status on the record.
List your Supabase users with Admin List Users and write the roster into an Airtable table for review.
Offboard someone by deleting their Supabase user and removing the matching row from the Airtable roster.
Send a password reset email in Supabase for a flagged account and log the action as a comment on its Airtable record.

About OpenCode

OpenCode is an open, model-agnostic command-line coding agent. In NoClick it runs hosted and gains your apps as tools, so it can act on real systems rather than just edit files. Wire an integration into the agent and OpenCode can use that app’s operations directly while it works. It is a flexible choice when you want an open agent with broad model support and real tool access.

Open and model-agnostic
Flexible across many underlying models
Good general-purpose tool use
Lightweight to point at a focused task

Frequently asked questions

Open your OpenCode agent in one click

NoClick runs OpenCode for you with Airtable and Supabase wired in as tools. Connect your account and run.