Medieage Supabase MCP Server

🚀 Supabase MCP Server

The Supabase MCP (Management Console) Server is a powerful tool designed to assist users in managing and operating their Supabase databases and related services. It offers various functions, including executing SQL queries, accessing the Supabase management API, viewing logs, and automatically recording database change versions.

🚀 Quick Start

The Supabase MCP Server simplifies the management of Supabase databases and services. It provides a range of features to enhance efficiency and security in database operations.

✨ Features

1. Execute PostgreSQL Queries

The execute_postgresql tool allows users to send SQL queries directly to the database. To mitigate risks, it introduces a security mode:

• Normal Mode: Only read operations (SELECT) are allowed.
• Write Mode: Write and destructive operations are permitted but require explicit confirmation via the live_dangerously tool.

Moreover, starting from v0.3.8, all write and destructive SQL operations automatically generate migration scripts and record them in the version control system. Users can easily track and manage database changes based on these scripts.

2. Manage API Access

Through the MCP Server, users can programmatically access the Supabase management API. All API requests are classified by risk:

• Low Risk: Only read operations (e.g., GET requests).
• Medium Risk: Operations that write data but do not modify the structure (e.g., POST, PUT requests).
• High Risk: Operations that may damage the database structure or cause data loss (e.g., DELETE endpoints).

All high - risk operations require explicit confirmation after enabling the unsafe mode.

3. Database Migration Version Control

Starting from v0.3.8, the MCP Server automatically generates migration scripts for all write and destructive SQL operations. These scripts help users track database changes and ensure that the latest database schema is included in their version control system.

4. Security Mode

The Unified Security Mode has been applied to all services (including databases, APIs, and SDKs) since v0.3.8. Different control strategies are set according to the risk level of operations:

• Low Risk: Always allowed.
• Medium Risk: Requires enabling the unsafe mode.
• High Risk: Requires enabling the unsafe mode and explicit confirmation.
• Extremely High Risk: Completely prohibited (e.g., deleting a project).

5. Query Confirmation Process

All high - risk operations (whether database queries or API requests) are blocked, even if the unsafe mode is enabled. Users must explicitly approve such operations before execution.

💻 Usage Examples

Basic Usage

# Example: Execute a PostgreSQL query and generate a migration script
from supabase_mcp import MCPClient

client = MCPClient(unsafe_mode=True)
response = client.execute_postgresql("SELECT * FROM users", live_dangerously=True)

# Example: Access the Supabase management API
api_response = client.access_management_api(resource="storage", action="list_buckets")

# Example: View database logs
logs = client.get_logs(start_time="2023-10-01 00:00:00", end_time="2023-10-02 00:00:00")

📚 Documentation

Functional Modules

Database Management

• Basic SQL Execution: Supports SELECT, INSERT, UPDATE, and DELETE operations.
• Transaction Handling: Supports transactions with single - commit or rollback.
• Connection Pool Support: Compatible with pooled and direct types of database connections.

API Access

• Resource Management: Includes storage, real - time communication (RTC), edge functions, and scheduled tasks.
• Log Query: Provides log analysis functions with time - based, text - search, field - filtering, or custom SQL queries.

Automation and Tools

• Migration Script Generation: All write and destructive SQL operations automatically generate corresponding migration files.
• Version Control Integration: Records database changes in the version control system for easy tracking and management.

Version Updates

v0.3.8 Update Notes

• Introduced a unified security mode applicable to all operation types.
• Implemented an explicit confirmation mechanism for high - risk operations.
• Started automatically generating migration scripts and recording them in the version control system.

v0.3.7 Update Notes

• Provided log query functions for real - time communication (RTC) and scheduled tasks.
• Optimized the transaction handling logic to support single - commit or rollback.
• Enhanced the error handling mechanism to improve overall stability.

📄 Conclusion

The Supabase MCP Server is a comprehensive tool that helps users efficiently manage their databases and related services. Through features such as the security mode and migration script generation, it greatly enhances the security and traceability of operations. Both developers and operations engineers can benefit from it.

The above is a complete introduction to the project. I hope it is helpful to you!