Frequently Asked Questions (FAQ) - Supabase MCP Server on UBOS

Q: What is an MCP Server? A: MCP (Model Context Protocol) is an open protocol that standardizes how applications provide context to LLMs (Large Language Models). An MCP server acts as a bridge, allowing AI models to access and interact with external data sources, such as Supabase databases.

Q: What is the purpose of the Supabase MCP Server? A: The Supabase MCP Server allows AI assistants, like GitHub Copilot, to interact with your Supabase database. It enables the AI to understand your database schema, table relationships, assist with query writing, and provide context-aware suggestions related to your data model.

Q: How does the Supabase MCP Server integrate with UBOS? A: The Supabase MCP Server is available as an asset in the UBOS Asset Marketplace. UBOS simplifies the installation, configuration, and deployment of the server, providing a seamless integration experience.

Q: What are the key benefits of using the Supabase MCP Server with UBOS? A: Key benefits include:

• Seamless integration with Supabase.
• Automated schema discovery.
• Secure query execution.
• Customizable configuration.
• Comprehensive documentation.
• Simplified deployment through the UBOS Asset Marketplace.

Q: What security measures are in place to protect my data? A: The Supabase MCP Server, when deployed through UBOS, incorporates several security measures, including:

• API Key Management: Using scoped API keys with minimum required permissions.
• Query Restrictions: Defaulting to SELECT-only queries and implementing a query allowlist approach.
• Data Protection: Avoiding exposing PII or sensitive data and supporting row-level security in Supabase.
• Rate Limiting: Implementing rate limiting to prevent abuse.

Q: What kind of queries does Supabase MCP Server support? A: By default, Supabase MCP Server supports SELECT queries. This can be configured through environment variables.

Q: What Node.js version MCP Server supports? A: MCP Server supports Node.js version 18 and above.

Q: Where can I find the VS Code settings for MCP Server? A: Add the Supabase MCP server to your VS Code settings.json:

“mcp”: { “inputs”: [], “servers”: { // …existing servers… “mcp-server-supabase”: { “command”: “node”, “args”: [ “/path/to/mcp-server-supabase/src/index.js” ], “env”: { “SUPABASE_URL”: “https://your-project-ref.supabase.co”, “SUPABASE_SERVICE_KEY”: “your-service-key”, “ALLOWED_QUERY_TYPES”: “SELECT” } } } }

Q: What stored procedures should I create in Supabase Database? A: You’ll need to create these stored procedures in Supabase:

1. get_schema_information() - Returns database schema
2. get_table_information(table_name TEXT) - Returns info about specific table
3. execute_query(query_string TEXT, query_params JSONB) - Safely executes queries

Q: What are the prerequisites for installing the Supabase MCP Server? A: Prerequisites include:

• Node.js 18+ installed
• npm or yarn package manager
• Supabase project with admin API key
• VS Code with Copilot/MCP support
• Git

Q: Can I use the Supabase MCP Server for other databases besides Supabase? A: No, this particular MCP server is specifically designed for Supabase databases. UBOS may offer MCP servers for other database platforms in the future. Check the UBOS Asset Marketplace for the latest offerings.

Q: Where can I find more information about the UBOS platform? A: Visit the UBOS website at https://ubos.tech for more information about the platform and its features.