supabase

This Supabase MCP Server provides an interactive suite of tools to explore and query your Supabase database directly through MCP widgets. The server exposes a Schema Explorer to browse all tables and schemas, a Table Viewer to inspect and interact with table data, and a SQL Query Executor to run read-only queries with results displayed in a dedicated widget. Each tool renders as a React widget built with Tailwind CSS and Radix UI components, allowing you to navigate schemas, view data, and run queries in a unified UI without leaving the MCP environment. The client connects directly to Supabase without LangChain, emphasizing type-safety and a streamlined development experience via mcp-use’s tooling.

Prerequisites:

• Node.js 18+ (with yarn)
• A Supabase project
• A valid Supabase Personal Access Token

Installation steps:

1. Clone the repository or install via npm/yarn as appropriate for your project.
2. Install dependencies: yarn install
3. Set required environment variables (see later under Configuration).
4. Start the development server: yarn dev
5. Open the UI in your browser (the dev server will provide the local URL).
6. When deploying, build for production and start the production server as needed (e.g., yarn build then yarn start).

Notes:

• Ensure your environment variables are correctly set before starting the server.
• The MCP widgets rely on React, Tailwind CSS, and the OpenAI Apps SDK within the mcp-use framework.

Environment variables:

• ACCESS_TOKEN: Your Supabase Personal Access Token. This enables secure access to your Supabase project.
• CSP_URLS: Content Security Policy URLs required for loading widgets. Example: https://supabase.com,https://mcp.supabase.com,https://*.mcp-use.com,https://*.supabase.co

Tips:

• Use the development commands provided by mcp-use to hot-reload and test widgets during development.
• If widgets fail to load, verify CSP_URLS and ACCESS_TOKEN are correct and that the Supabase project allows access with the provided token.
• The available tools (list-tables, show-table, execute-sql) correspond to interactive widgets: schema-explorer, table-viewer, and query-results respectively.