How do I use Supabase MCP?

1. Click on "Deploy Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Supabase MCP list the first 10 users from the profiles table" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

Supabase MCP

Q: Which integrations are available for this server?

Provides 31 tools for managing Supabase projects, including database CRUD operations, storage management, auth admin, project management, edge functions, and secrets, enabling full programmatic control over a Supabase instance.

by node2flow-th

Overview Schema Source Related Servers Discussions Admin

TypeScript

Remote

@node2flow/supabase-mcp

npm version License: MIT

MCP server for Supabase — 31 tools for database CRUD, storage management, auth admin, project management, edge functions, and secrets via the Model Context Protocol.

Quick Start

Claude Desktop / Cursor

Add to your MCP config:

{
  "mcpServers": {
    "supabase": {
      "command": "npx",
      "args": ["-y", "@node2flow/supabase-mcp"],
      "env": {
        "SUPABASE_URL": "https://your-project.supabase.co",
        "SUPABASE_SERVICE_ROLE_KEY": "your-service-role-key",
        "SUPABASE_ACCESS_TOKEN": "your-personal-access-token"
      }
    }
  }
}

Note: SUPABASE_URL + SUPABASE_SERVICE_ROLE_KEY are needed for database, storage, and auth tools. SUPABASE_ACCESS_TOKEN is needed for project management tools. You can configure one or both.

HTTP Mode

SUPABASE_URL=https://xxx.supabase.co SUPABASE_SERVICE_ROLE_KEY=xxx npx @node2flow/supabase-mcp --http

MCP endpoint: http://localhost:3000/mcp

Cloudflare Worker

Available at: https://supabase-mcp-community.node2flow.net/mcp

POST https://supabase-mcp-community.node2flow.net/mcp?SUPABASE_URL=https://xxx.supabase.co&SUPABASE_SERVICE_ROLE_KEY=xxx&SUPABASE_ACCESS_TOKEN=xxx

Related MCP server: Supabase MCP Server - Self-Hosted Edition

Tools (31)

Database — REST API (6)

Tool	Description
`sb_list_records`	List records with PostgREST filters, select, order, pagination
`sb_insert_records`	Insert one or more records
`sb_update_records`	Update records matching a filter (filter required)
`sb_upsert_records`	Upsert — insert or update on conflict
`sb_delete_records`	Delete records matching a filter (filter required)
`sb_call_function`	Call stored PostgreSQL function (RPC)

Storage (6)

Tool	Description
`sb_list_buckets`	List all storage buckets
`sb_create_bucket`	Create bucket with public/private, size limit, MIME types
`sb_delete_bucket`	Delete empty bucket
`sb_list_objects`	List objects with prefix, search, pagination
`sb_delete_objects`	Delete objects by file path
`sb_create_signed_url`	Create temporary signed URL for private files

Auth Admin (5)

Tool	Description
`sb_list_users`	List users (paginated)
`sb_get_user`	Get user by ID
`sb_create_user`	Create user with email/password, metadata
`sb_update_user`	Update user metadata, role, ban status
`sb_delete_user`	Delete user permanently

Management — Projects (5)

Tool	Description
`sb_list_projects`	List all projects in account
`sb_get_project`	Get project details
`sb_create_project`	Create new project
`sb_pause_project`	Pause project (stop all services)
`sb_restore_project`	Restore paused project

Management — Database (3)

Tool	Description
`sb_run_query`	Execute SQL query on project database
`sb_list_migrations`	List database migrations
`sb_get_typescript_types`	Generate TypeScript types from schema

Management — Edge Functions (2)

Tool	Description
`sb_list_functions`	List deployed edge functions
`sb_get_function`	Get edge function details

Management — Secrets & Keys (4)

Tool	Description
`sb_list_secrets`	List project secrets (names only)
`sb_create_secrets`	Create or update secrets
`sb_delete_secrets`	Delete secrets by name
`sb_list_api_keys`	List project API keys (anon, service_role)

Filter Syntax

The REST API uses PostgREST filter syntax:

# Comparison
age=gt.18                    # greater than
status=eq.active             # equals
price=lte.100               # less than or equal

# Pattern matching
name=ilike.*john*            # case-insensitive LIKE
email=like.*@gmail.com       # case-sensitive LIKE

# Lists and NULL
id=in.(1,2,3)               # IN list
deleted_at=is.null           # NULL check

# Logic
or=(age.lt.18,age.gt.65)    # OR conditions

# Full-text search
content=fts.supabase         # full-text search

Resource Embedding (JOINs)

Query related tables using the select parameter:

*,orders(*)                         — embed all columns from related table
id,name,orders(id,total,status)     — specific columns
id,author:user_id(name,email)       — renamed embed

Configuration

Parameter	Required	For	Description
`SUPABASE_URL`	Yes*	REST/Storage/Auth	Project URL (`https://xxx.supabase.co`)
`SUPABASE_SERVICE_ROLE_KEY`	Yes*	REST/Storage/Auth	Service role key (bypasses RLS)
`SUPABASE_ACCESS_TOKEN`	No	Management API	Personal access token from dashboard

*Required for database, storage, and auth tools. Management tools only need SUPABASE_ACCESS_TOKEN.

Getting Your Keys

Project URL + Service Role Key: Go to your Supabase project → Settings → API
Access Token: Go to supabase.com/dashboard/account/tokens → Generate new token

Safety

Update and Delete require a filter — prevents accidental full-table operations
Use sb_list_records to verify filter matches before delete
Use return="representation" to see what was changed
Service role key bypasses RLS — use with caution in production

License

MIT License - see LICENSE

Links

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityInactive

ResponsivenessNo issues

Resources

Need Help?

Related Servers

Related MCP Connectors

SupabaseOAuth
com.supabase
MCP server for interacting with the Supabase platform
Cloud Platforms Databases Developer Tools
32,916
mcp AOAuth
io.github.butterbase-ai
Butterbase MCP server — manage your backend: schemas, auth, functions, storage, RAG, deploys.
Databases RAG Systems Cloud Platforms
23,574
mcpOAuth
io.prisma
MCP server for managing Prisma Postgres.
Databases Developer Tools
249
MisterSandFR-supabase-mcp-selfhostedOAuth
ai.smithery
Manage Supabase projects end to end across database, auth, storage, realtime, and migrations. Moni…
Databases Cloud Platforms Developer Tools
27

Related MCP Servers

supabase-mcp
Databases Cloud Storage Developer Tools
DynamicEndpoints
A
license
Not graded
quality
Not graded
maintenance
An MCP server that provides tools for interacting with Supabase databases, storage, and edge functions.
Updated a year ago (2025-05-01 13:45 UTC)
45
MIT
Supabase MCP Server - Self
Databases Cloud Platforms Developer Tools
abdqum
F
license
Not graded
quality
D
maintenance
Enables comprehensive management of self-hosted or cloud Supabase instances with 54+ tools for database operations, authentication, storage, real-time subscriptions, migrations, and monitoring through MCP protocol.
Updated a year ago (2025-10-15 11:35 UTC)
-
SupaMCPBuilder
Databases Developer Tools App Automation
vivek100
A
license
Not graded
quality
D
maintenance
A runtime-configurable MCP server for Supabase databases that enables dynamic tool creation through JSON configuration. Build custom database operations (select, insert, update, delete) without writing code, with built-in authentication and template support.
Updated a year ago (2025-06-28 21:55 UTC)
3 npm
11
MIT
Supabase MCP Server
Databases Cloud Platforms
mcp-use
A
license
Not graded
quality
D
maintenance
A powerful MCP server for Supabase that provides interactive tools and React widgets for exploring and querying your Supabase database.
Updated 9 months ago (2025-12-18 14:44 UTC)
3,049,943 npm
20
MIT