supabase-mcp-server

supabase-mcp-server

SupabasePostgresqlPythonMcpModelContextProtocolCursorWindsurfDatabaseManagementSqlManagementApiAuthAdminSdkJavascriptGoRubyR

About This Server

Supabase MCP Server enabling Cursor & Windsurf to use any method from Management API and query your database

Server Information

šŸ“‹ Overview:

This webpage is the GitHub repository page for `alexander-zuev/supabase-mcp-server`. This project provides a Supabase MCP (Model Context Protocol) server that enables IDEs like Cursor and Windsurf to interact with Supabase databases and Management APIs more effectively and safely. The server includes features such as SQL query validation, database schema change versioning, and user authentication management with safety controls. The page provides a comprehensive guide on installing, configuring, and using the server, along with troubleshooting tips and a changelog.


ā­ Key Points:
* Supabase MCP Server designed for secure Supabase database interaction
* Compatible with Cursor, Windsurf, Cline, and Claude Desktop
* Offers features like SQL query validation, risk level assessment, automatic migration versioning, and transaction handling
* Includes tools for Supabase Management API access and Auth Admin SDK method invocation

* Supports different configuration methods, including environment variables and config files


šŸ” Main Findings:
* The Supabase MCP Server enhances the functionality of various IDEs by enabling them to safely interact with Supabase databases and Management APIs.
* The server emphasizes security through a three-tier safety system for SQL operations and a universal safety mode.
* It provides detailed guides for installation, configuration, and usage with specific MCP clients.
* The automatic migration versioning and enhanced API specifications indicate a focus on database management and developer experience.

* The project supports multiple regions and has a clear roadmap for future development.


šŸ“Š Details:
* The repository includes comprehensive instructions for setting up and configuring the server with various IDEs and tools.
* It lists specific environment variables required for configuration and provides instructions for different installation methods.
* The page details various supported regions and the limitations of the server.
* It gives a clear overview of available tools for database management, management API access, and Auth Admin SDK invocation.

* There are clear instructions for accessing logs for troubleshooting.


šŸŽÆ Conclusion:
The GitHub repository provides a well-documented and feature-rich Supabase MCP Server project designed to enhance the capabilities of MCP clients while ensuring secure database management and API access. The project is actively maintained, with clear instructions for usage, configuration, and troubleshooting.

Server Features

MCP Client Compatibility

Compatible with Cursor, Windsurf, Cline and other MCP clients supporting stdio protocol

SQL Query Mode Control

Control read-only and read-write modes of SQL query execution

SQL Query Validation

Runtime SQL query validation with risk level assessment

Three-Tier Safety System

Three-tier safety system for SQL operations: safe, write, and destructive

Robust Transaction Handling

Robust transaction handling for both direct and pooled database connections

Automatic Migration Versioning

Automatic versioning of database schema changes

Supabase Management API

Manage your Supabase projects with Supabase Management API

Auth Admin SDK

Manage users with Supabase Auth Admin methods via Python SDK

Pre-built Tools

Pre-built tools to help Cursor & Windsurf work with MCP more effectively

Simple Install & Setup

Dead-simple install & setup via package manager (uv, pipx, etc.)

Provider Information

AlexanderZuev logo

AlexanderZuev

cloud Provider

Visit Provider Website

Quick Actions

Visit Website

MCP Configuration

Available Tools

get_schemasget_tablesget_table_schemaexecute_postgresqlconfirm_destructive_operationretrieve_migrationslive_dangerouslysend_management_api_requestget_management_api_specget_management_api_safety_rulesget_auth_admin_methods_speccall_auth_admin_method

Available Resources

SQL Query ExecutionManagement APIAuth Admin SDK