UBOS Asset Marketplace: Query MCP (Supabase MCP Server) - Revolutionize Your Supabase Management

UBOS is proud to feature Query MCP (formerly Supabase MCP Server) in our Asset Marketplace, a powerful tool designed to revolutionize how you manage your Supabase projects. Query MCP enables end-to-end management of your Supabase instance through a chat interface, bringing unprecedented ease and efficiency to database administration, API interactions, and more. By integrating Query MCP with UBOS, you gain access to a seamless, AI-driven workflow that streamlines your development process and empowers your team to achieve more with less effort.

Introducing Query MCP: The Future of Supabase Management

Query MCP is not just another database management tool; it’s a paradigm shift in how you interact with your Supabase projects. Imagine controlling your entire Supabase infrastructure—from executing complex SQL queries to managing user authentication—all through a simple, intuitive chat interface. This is the power of Query MCP.

As the Supabase MCP Server evolves into thequery.dev, users can expect even more advanced features and capabilities, built upon the solid foundation of its open-source core. The commitment remains to keep the core tool free forever, ensuring accessibility for all developers. Premium features will be added on top, enhancing capabilities without limiting existing functionality. The first 2,000 early adopters will get special perks, making it an excellent time to join and experience the future of Supabase management.

Seamless Integration with UBOS

When you integrate Query MCP with the UBOS platform, you unlock a new level of efficiency and collaboration. UBOS is a full-stack AI Agent Development Platform focused on bringing AI Agents to every business department. Our platform helps you orchestrate AI Agents, connect them with your enterprise data, build custom AI Agents with your LLM model and Multi-Agent Systems. With UBOS, you can:

• Orchestrate AI Agents: Connect Query MCP to AI agents within UBOS to automate database tasks, generate reports, and proactively manage your Supabase instance.
• Connect with Enterprise Data: Seamlessly integrate your Supabase data with other enterprise systems, creating a unified view of your business operations.
• Build Custom AI Agents: Leverage UBOS to create custom AI agents that understand your specific Supabase setup and can perform tailored management tasks.
• Multi-Agent Systems: Design multi-agent systems where AI agents coordinate with Query MCP to optimize database performance, enhance security, and ensure data integrity.

Key Features of Query MCP

Query MCP boasts a rich set of features designed to simplify and enhance your Supabase management experience. Here’s a detailed look at what it offers:

• Chat-Based Management: Interact with your Supabase instance using natural language commands. Execute SQL queries, manage APIs, and handle user authentication all through a chat interface.
• End-to-End Supabase Management: Control every aspect of your Supabase project, from database administration to user management, all in one place.
• SQL Query Execution with Risk Assessment: Safely execute SQL queries with built-in risk assessment, ensuring that only authorized operations are performed.
• Three-Tier Safety System: Benefit from a robust safety system with safe (read-only), write (data modifications), and destructive (schema changes) tiers.
• Runtime SQL Query Validation: Validate SQL queries in real-time, with clear feedback on safety requirements and potential risks.
• Automatic Migration Versioning: Automatically version database schema changes, generating descriptive names based on operation type and target.
• Supabase Management API Support: Manage your Supabase projects with Supabase Management API, gaining programmatic access to project settings and configurations.
• Supabase Auth Admin Methods: Manage users with Supabase Auth Admin methods via Python SDK, simplifying user creation, deletion, and management.
• Compatible with Popular MCP Clients: Works seamlessly with Cursor, Windsurf, Cline, and other MCP clients supporting the stdio protocol.
• Dead-Simple Installation: Install and set up Query MCP quickly and easily via package managers like uv and pipx.

Feature Overview: Diving Deeper

Let’s take a closer look at some of the standout features of Query MCP:

Database Query Tools

Query MCP provides comprehensive database management capabilities with built-in safety controls:

• SQL Query Execution: Execute PostgreSQL queries with risk assessment.
  • Three-tier safety system:
    • safe: Read-only operations (SELECT) - always allowed.
    • write: Data modifications (INSERT, UPDATE, DELETE) - require unsafe mode.
    • destructive: Schema changes (DROP, CREATE) - require unsafe mode + confirmation.
• SQL Parsing and Validation:
  • Uses PostgreSQL’s parser (pglast) for accurate analysis and provides clear feedback on safety requirements.
• Automatic Migration Versioning:
  • Database-altering operations are automatically versioned.
  • Generates descriptive names based on operation type and target.
• Safety Controls:
  • Default SAFE mode allows only read-only operations.
  • All statements run in transaction mode via asyncpg.
  • 2-step confirmation for high-risk operations.
• Available Tools:
  • get_schemas: Lists schemas with sizes and table counts.
  • get_tables: Lists tables, foreign tables, and views with metadata.
  • get_table_schema: Gets detailed table structure (columns, keys, relationships).
  • execute_postgresql: Executes SQL statements against your database.
  • confirm_destructive_operation: Executes high-risk operations after confirmation.
  • retrieve_migrations: Gets migrations with filtering and pagination options.
  • live_dangerously: Toggles between safe and unsafe modes.

Management API Tools

Query MCP provides secure access to the Supabase Management API with built-in safety controls:

• Available Tools:
  • send_management_api_request: Sends arbitrary requests to Supabase Management API with auto-injection of project ref.
  • get_management_api_spec: Gets the enriched API specification with safety information.
    • Supports multiple query modes: by domain, by specific path/method, or all paths.
    • Includes risk assessment information for each endpoint.
    • Provides detailed parameter requirements and response formats.
    • Helps LLMs understand the full capabilities of the Supabase Management API.
  • get_management_api_safety_rules: Gets all safety rules with human-readable explanations.
  • live_dangerously: Toggles between safe and unsafe operation modes.
• Safety Controls:
  • Uses the same safety manager as database operations for consistent risk management.
  • Operations categorized by risk level:
    • safe: Read-only operations (GET) - always allowed.
    • unsafe: State-changing operations (POST, PUT, PATCH, DELETE) - require unsafe mode.
    • blocked: Destructive operations (delete project, etc.) - never allowed.
  • Default safe mode prevents accidental state changes.
  • Path-based pattern matching for precise safety rules.

Note: Management API tools only work with remote Supabase instances and are not compatible with local Supabase development setups.

Auth Admin Tools

Query MCP supports direct access to Supabase Auth Admin methods via Python SDK:

• Includes the following tools:
  • get_auth_admin_methods_spec to retrieve documentation for all available Auth Admin methods.
  • call_auth_admin_method to directly invoke Auth Admin methods with proper parameter handling.
• Supported methods:
  • 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).

Logs & Analytics

Query MCP provides access to Supabase logs and analytics data, making it easier to monitor and troubleshoot your applications:

• Available Tool: retrieve_logs - Access logs from any Supabase service.
• Log Collections:
  • postgres: Database server logs
  • api_gateway: API gateway requests
  • auth: Authentication events
  • postgrest: RESTful API service logs
  • pooler: Connection pooling logs
  • storage: Object storage operations
  • realtime: WebSocket subscription logs
  • edge_functions: Serverless function executions
  • cron: Scheduled job logs
  • pgbouncer: Connection pooler logs
• Features: Filter by time, search text, apply field filters, or use custom SQL queries

Universal Safety Mode

Query MCP has Safety Mode standardized across all services (database, API, SDK) using a universal safety manager. This provides consistent risk management and a unified interface for controlling safety settings across the entire MCP server.

All operations (SQL queries, API requests, SDK methods) are categorized into risk levels:

• Low risk: Read-only operations that don’t modify data or structure (SELECT queries, GET API requests)
• Medium risk: Write operations that modify data but not structure (INSERT/UPDATE/DELETE, most POST/PUT API requests)
• High risk: Destructive operations that modify database structure or could cause data loss (DROP/TRUNCATE, DELETE API endpoints)
• Extreme risk: Operations with severe consequences that are blocked entirely (deleting projects)

Use Cases: Unleashing the Power of Query MCP

Query MCP can be applied in various scenarios to enhance your Supabase management workflows:

• Automated Database Administration: Use AI agents within UBOS, powered by Query MCP, to automate routine database tasks such as backups, schema migrations, and performance monitoring.
• Real-Time Monitoring and Alerting: Set up AI agents to monitor your Supabase logs and analytics data, alerting you to potential issues or anomalies in real-time.
• Secure API Management: Leverage Query MCP’s safety controls to manage your Supabase Management API securely, preventing accidental or malicious changes to your project.
• Streamlined User Management: Simplify user management tasks with Query MCP’s Auth Admin methods, making it easier to create, delete, and manage users within your Supabase project.
• Enhanced Collaboration: Enable your team to collaborate more effectively by providing a unified, chat-based interface for managing your Supabase infrastructure.

Getting Started with Query MCP on UBOS

Integrating Query MCP with UBOS is a straightforward process. Simply follow these steps:

1. Access the UBOS Asset Marketplace: Navigate to the UBOS Asset Marketplace within your UBOS account.
2. Find Query MCP: Search for Query MCP in the marketplace.
3. Install Query MCP: Click the install button to add Query MCP to your UBOS environment.
4. Configure Query MCP: Follow the configuration instructions to connect Query MCP to your Supabase project.
5. Start Managing Your Supabase Instance: Begin using the chat interface to manage your Supabase project with ease.

Conclusion: Empower Your Supabase Management with Query MCP and UBOS

Query MCP is a game-changing tool that simplifies and enhances your Supabase management experience. By integrating Query MCP with the UBOS platform, you unlock a new level of efficiency, collaboration, and security. Whether you’re automating database tasks, monitoring logs in real-time, or managing users with ease, Query MCP empowers you to achieve more with your Supabase projects. Explore Query MCP on the UBOS Asset Marketplace today and take your Supabase management to the next level.

By leveraging Query MCP within the UBOS ecosystem, businesses gain unparalleled control and insight into their Supabase infrastructure, leading to more efficient development cycles, reduced operational overhead, and a stronger, more secure data environment. Embrace the future of Supabase management with Query MCP and UBOS – where AI-powered automation meets seamless integration.