What features does Supabase MCP Server offer?

It provides features like read-only/read-write mode control, robust transaction handling, Supabase Management API access, and user management via the Supabase Auth Admin Python SDK.

What is Supabase MCP Server?

Supabase MCP Server is a tool that enables AI tools like Cursor and Windsurf to interact with your Supabase databases in a safe and controlled manner. It allows for SQL query execution, database management, and user administration.

What credentials does it need?

It reads `SUPABASE_PROJECT_REF`, `SUPABASE_DB_PASSWORD`, `SUPABASE_REGION`, `SUPABASE_ACCESS_TOKEN` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Supabase MCP Server

Enables Cursor and Windsurf to manage Supabase databases and execute SQL queries safely.

Local serverstdioPython★ 10

What is the Supabase MCP Server?

Enables Cursor and Windsurf to manage Supabase databases and execute SQL queries safely.

The short version

Functionality — Enables operations not possible with SQL alone (invites, magic links, MFA)
Accuracy — More reliable then creating and executing raw SQL queries on auth schemas
Simplicity — Offers clear methods with proper validation and error handling
Response format:
All methods return structured Python objects instead of raw dictionaries
Object attributes can be accessed using dot notation (e.g., user.id instead of user["id"])

What it needs from you

Installing the server requires the following on your system: - Python 3.12+ - PostgresSQL 16+ If you plan to install via uv, ensure it's installed.

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
get_user_by_id	Retrieve a user by their ID
list_users	List all users with pagination
create_user	Create a new user
delete_user	Delete a user by their ID
invite_user_by_email	Send an invite link to a user's email
generate_link	Generate an email link for various authentication purposes
update_user_by_id	Update user attributes by ID
delete_factor	Delete a factor on a user (currently not implemented in SDK)

Configuration

Installing the server requires the following on your system: - Python 3.12+ - PostgresSQL 16+ If you plan to install via uv, ensure it's installed.

Variable	Description	Required
SUPABASE_PROJECT_REF	Configuration value read at startup.	Optional
SUPABASE_DB_PASSWORD	Configuration value read at startup.	Optional
SUPABASE_REGION	Configuration value read at startup.	Optional
SUPABASE_ACCESS_TOKEN	Credential the server authenticates with.	Yes

Example prompts to try

“Use Supabase to get user by id.”
“Use Supabase to list users.”
“Use Supabase to create user.”

Frequently asked questions

The server is compatible with Cursor, Windsurf, Cline and any other Model Context Protocol (MCP) client that supports the `stdio` protocol.

Alternatives to the Supabase MCP Server

PostgreSQL

Inspect PostgreSQL schemas and run read-only queries with the archived MCP reference server. Review its maintenance status before choosing it.

DatabasesTypeScript★ 63.0k

Notion

Official

Connect the Notion MCP server to search workspace content and work with pages and databases through Notion’s hosted OAuth service.

Productivity & Project ManagementRemoteTypeScript★ 3.3k

MCP Ran Poc

This repository contains MCP (Model Context Protocol) servers and an ADK agent for database querying and Kubernetes cluster management:

DatabasesPython

Coderadius

Prevent cross-repo architectural breakage before merge. Architecture knowledge graph from static analysis, blast radius in CI, MCP server for AI

Developer ToolsPython

Mcp-schema-designer

Design database schemas from natural language, validate SQL, generate migrations and types

Databases

Zoho Projects By Cdata

CData JDBC Driver connects to Zoho Projects by exposing them as relational SQL models.

DatabasesRemote