Supabase
About
Supabase is an open source Firebase alternative built around Postgres, auth, storage, edge functions, and project tooling. Its remote MCP server connects assistants to project, database, and documentation context for working with application backends.
Details
- Transport
- SSE
Explore
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
SupabaseCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
{
"mcpServers": {
"supabase": {
"type": "http",
"url": "https://mcp.supabase.com/mcp"
}
}
}
sb_list_records
List records from a Supabase table/view with PostgREST filtering, column selection, ordering, and pagination. Filter syntax: age=gt.18, status=eq.active, name=ilike.*john*, id=in.(1,2,3). Resource embedding (JOINs): select=*,orders(*)
sb_insert_records
Insert one or more records into a Supabase table. Pass a single object or an array of objects. Use return=representation to get the created records back.
sb_update_records
Update records in a Supabase table matching a filter. Filter is REQUIRED to prevent accidental full-table updates. Use return=representation to see what changed.
sb_upsert_records
Upsert (insert or update on conflict) records in a Supabase table. Uses merge-duplicates by default. Specify on_conflict for non-primary-key columns.
sb_delete_records
Delete records from a Supabase table matching a filter. Filter is REQUIRED to prevent accidental full-table deletion. Use sb_list_records first to verify which records will be deleted.
sb_call_function
Call a stored PostgreSQL function (RPC) in Supabase. Use method=GET for immutable functions, POST for volatile ones (default).
sb_list_buckets
List all storage buckets in the Supabase project. Returns bucket name, public status, size limits, and allowed MIME types.
sb_create_bucket
Create a new storage bucket in Supabase. Set public=true for publicly accessible files. Optionally set file size limit and allowed MIME types.
sb_delete_bucket
Delete a storage bucket from Supabase. The bucket must be empty before deletion. Use sb_delete_objects to remove files first.
sb_list_objects
List objects (files) in a Supabase storage bucket. Supports prefix filtering, pagination, and search.
sb_delete_objects
Delete one or more objects from a Supabase storage bucket. Provide an array of file paths to delete.
sb_create_signed_url
Create a temporary signed URL for a private storage object. The URL expires after the specified duration.
sb_list_users
List all users in the Supabase Auth system. Returns paginated results with user details including email, metadata, and creation date.
sb_get_user
Get a single user by ID from Supabase Auth. Returns full user details including metadata, identities, and last sign-in.
sb_create_user
Create a new user in Supabase Auth. Set email_confirm=true to skip email verification. Use app_metadata for admin-controlled data (roles, permissions).
sb_update_user
Update a user in Supabase Auth. Can change email, phone, password, metadata, or ban the user.
sb_delete_user
Delete a user from Supabase Auth. This permanently removes the user and all their auth data.
sb_list_projects
List all Supabase projects in your account. Returns project name, ref, region, status, and database info. Requires SUPABASE_ACCESS_TOKEN.
sb_get_project
Get details of a specific Supabase project by reference ID. Returns name, region, status, database host, and API URL.
sb_create_project
Create a new Supabase project. Requires organization ID, region, and database password. Project creation takes a few minutes.
sb_pause_project
Pause a Supabase project. Paused projects stop all services (database, auth, storage) and free up resources. Free tier projects auto-pause after inactivity.
sb_restore_project
Restore a paused Supabase project. Restarts all services including database, auth, and storage.
sb_run_query
Execute a SQL query on a Supabase project database via the Management API. Supports SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, and all SQL. Returns query results as JSON.
sb_list_migrations
List database migrations for a Supabase project. Shows migration version, name, and status.
sb_get_typescript_types
Generate TypeScript type definitions from the Supabase project database schema. Useful for type-safe database access.
sb_list_functions
List all Edge Functions deployed to a Supabase project. Returns function slug, name, status, and creation date.
sb_get_function
Get details of a specific Edge Function by slug. Returns function metadata, status, version, and entry point.
sb_list_secrets
List all secrets (environment variables) for a Supabase project. Returns secret names only (values are never exposed).
sb_create_secrets
Create or update secrets (environment variables) for a Supabase project. If a secret with the same name exists, it will be overwritten.
sb_delete_secrets
Delete secrets (environment variables) from a Supabase project by name.
sb_list_api_keys
List API keys for a Supabase project. Returns anon key, service_role key, and any custom keys with their names and roles.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"supabase": {
"supabase": {
"type": "http",
"url": "https://mcp.supabase.com/mcp"
}
}
}
}McpServers
{
"supabase": {
"type": "http",
"url": "https://mcp.supabase.com/mcp"
}
}Supabase is an open source Firebase alternative built around Postgres, auth, storage, edge functions, and project tooling. Its remote MCP server connects assistants to project, database, and documentation context for working with application backends.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
