Supabase MCP Server

🚀 Supabase MCP Server

The Supabase MCP (Management Console) Server is a powerful tool for managing and operating your Supabase database. It offers a variety of functions, including executing queries via SQL, integrating the Supabase management API, automatic version control, and security management. The MCP server aims to simplify the management process of databases and related services.

🚀 Quick Start

The Supabase MCP Server simplifies the management of Supabase databases. With features like direct SQL execution, API integration, and security controls, it streamlines database operations.

✨ Features

PostgreSQL Query Execution

• Direct SQL Execution: Supports running any PostgreSQL query, including SELECT, INSERT, UPDATE, DELETE, etc.
• Transaction Handling: Supports atomic transactions, ensuring operations are either fully successful or fully failed.
• Result Viewing: Provides intuitive result display, supporting JSON format output and custom column formatting.

Supabase Management API Integration

• Resource Management: Directly create, delete, or modify database objects (tables, columns, indexes).
• Permission Management: Easily configure access permissions for users and roles.
• Backup and Recovery: Perform manual or automatic data backups and restore from backups.

Security Mode

• Risk Classification: All operations are classified by risk level:
  • Low Risk: Only read data (SELECT queries, GET API requests).
  • Medium Risk: Modify data but not the structure (INSERT/UPDATE/DELETE, most POST/PUT API requests).
  • High Risk: Modify the database structure or operations that may cause data loss (DROP/TRUNCATE, DELETE API endpoints).
  • Extremely High Risk: Operations with severe consequences are completely blocked (deleting a project).

Automatic Version Control

• Migration Script Generation: All write and destructive SQL operations on the database automatically generate migration scripts.
• Confirmation Process: In unsafe mode, all high - risk operations require explicit user approval to execute.

Logging and Auditing

• Query Recording: Records all executed queries and their results.
• Audit Trail: Provides detailed log information for easy tracking and review of operation history.

📦 Installation

Installation via Package Manager

pip install supabase-mcp-server

Manual Installation

Download the source code and run:

git clone https://github.com/alexander-zuev/supabase-mcp-server.git
cd supabase-mcp-server
python setup.py install

💻 Usage Examples

Connecting to the Database

Connect to your Supabase database using default credentials or custom configurations.

Executing Queries

Run any PostgreSQL query:

SELECT * FROM users;

Calling the Management API

Manage database resources through the API methods provided by the MCP server.

Enabling the Security Mode

Enable security features in the configuration file:

security:
  enabled: true

Confirming High - Risk Operations

When performing high - risk operations, the system will prompt the user to enter confirmation information.

📚 Documentation

Change Log

v1.0.0

• Initial version released, including basic SQL execution and API management features.
• Introduced security mode and transaction support.

v2.0.0

• Added automatic version control function.
• Supported the high - risk operation confirmation process.
• Optimized logging and auditing functions.

v3.0.0

• Enhanced security and fixed several security vulnerabilities.
• Improved performance monitoring and resource management.

🖼️ Attached Images

The attached images show the confirmation interface for high - risk operations and the query result viewing interface of the MCP server.