[{"_1":2,"_531":-5,"_532":-5},"loaderData",{"_3":4,"_28":29,"_30":31,"_32":33,"_392":393},"root",{"_5":6,"_16":17},"toasts",[7,14],{"_8":9,"_10":11,"_12":13},"uid","dda21e29-c16e-4ec2-8744-810e6f5067a1","title","This MCP server does not support inspection","type","error",{"_8":15,"_10":11,"_12":13},"a42f73c3-1fc3-409c-a997-d917304838dc","visitor",{"_18":19,"_20":21},"viewportWidth",1280,"visitorSession",{"_22":23,"_25":-5,"_8":26,"_27":-5},"attributes",[24],"BOT","membership","3LiJfiT7Hs","userAccount","routes/_public/_layout",{},"routes/_public/mcp/servers/~namespace/_layout",{},"routes/_public/mcp/servers/~namespace/~slug/_pages/_layout",{"_34":-5,"_35":36,"_37":38,"_311":312},"githubUser","maintainer",false,"mcpServer",{"_39":40,"_41":42,"_22":67,"_75":76,"_77":76,"_78":79,"_84":85,"_108":-5,"_109":110,"_111":112,"_113":114,"_94":132,"_133":99,"_134":-5,"_135":-5,"_136":137,"_138":139,"_146":-5,"_147":148,"_153":-5,"_121":95,"_154":155,"_159":160,"_8":308,"_309":310},"addedAt",["D",1739664017660],"argumentsJsonSchema",{"_43":44,"_64":65,"_12":66},"properties",{"_45":46,"_52":53,"_55":56,"_58":59,"_61":62},"SUPABASE_REGION",{"_47":48,"_49":50,"_12":51},"default","us-east-1","description","Supabase region (e.g., us-east-1)","string","SUPABASE_DB_PASSWORD",{"_49":54,"_12":51},"Your database password","SUPABASE_PROJECT_REF",{"_49":57,"_12":51},"Your project reference (found in project URL)","SUPABASE_ACCESS_TOKEN",{"_49":60,"_12":51},"For Management API access","SUPABASE_SERVICE_ROLE_KEY",{"_49":63,"_12":51},"For Auth Admin SDK access","required",[],"object",[68,69,70,71,72,73,74],"category:databases","hosting:hybrid","language:python","security_grade:a","quality_grade:a","license_grade:a","author:claimed","descriptionMarkdown","This server enables interaction with Supabase PostgreSQL databases through the MCP protocol, allowing seamless integration with Cursor and Windsurf IDEs for secure and validated database management.","descriptionPlainText","githubProject",{"_80":81,"_82":83},"readme","# Query MCP (Supabase MCP Server)\n\n

\n \n \n \n $\"Supabase\"$ \n \n \n \n \n \n $\"MCP\"$ \n \n

\n\n

\n Enable your favorite IDE to safely execute SQL queries, manage your database end-to-end, access Management API, and handle user authentication with built-in safety controls.\n

\n\n

\n $\"Control$ \n

\n\n

\n $\"PyPI$ \n $\"CI$ \n $\"Code$ \n $\"Python$ \n $\"uv$ \n $\"PyPI$ \n $\"Smithery.ai$ \n $\"MCP$ \n $\"License\"$ \n

\n\n\n## 🎉 The Future of Supabase MCP Server -> Query MCP\n\n**I'm thrilled to announce that Supabase MCP Server is evolving into [thequery.dev](https://thequery.dev)!**\n\nWhile I have big plans for the future, I want to make these commitments super clear:\n- **The core tool will stay free forever** - free & open-source software is how I got into coding\n- **Premium features will be added on top** - enhancing capabilities without limiting existing functionality\n- **First 2,000 early adopters will get special perks** - join early for an exclusive treat!\n\n**🚀 BIG v4 Launch Coming Soon!**\n\n[**👉 Join Early Access at thequery.dev**](https://thequery.dev)\n\n## Table of contents\n

\n Getting started •\n Feature overview •\n Troubleshooting •\n Changelog\n

\n\n## ✨ Key features\n- 💻 Compatible with Cursor, Windsurf, Cline and other MCP clients supporting `stdio` protocol\n- 🔐 Control read-only and read-write modes of SQL query execution\n- 🔍 Runtime SQL query validation with risk level assessment\n- 🛡️ Three-tier safety system for SQL operations: safe, write, and destructive\n- 🔄 Robust transaction handling for both direct and pooled database connections\n- 📝 Automatic versioning of database schema changes\n- 💻 Manage your Supabase projects with Supabase Management API\n- 🧑‍💻 Manage users with Supabase Auth Admin methods via Python SDK\n- 🔨 Pre-built tools to help Cursor & Windsurf work with MCP more effectively\n- 📦 Dead-simple install & setup via package manager (uv, pipx, etc.)\n\n\n## Getting Started\n\n### Prerequisites\nInstalling the server requires the following on your system:\n- Python 3.12+\n\nIf you plan to install via `uv`, ensure it's [installed](https://docs.astral.sh/uv/getting-started/installation/#__tabbed_1_1).\n\n### PostgreSQL Installation\nPostgreSQL installation is no longer required for the MCP server itself, as it now uses asyncpg which doesn't depend on PostgreSQL development libraries.\n\nHowever, you'll still need PostgreSQL if you're running a local Supabase instance:\n\n**MacOS**\n```bash\nbrew install postgresql@16\n```\n\n**Windows**\n - Download and install PostgreSQL 16+ from https://www.postgresql.org/download/windows/\n - Ensure \"PostgreSQL Server\" and \"Command Line Tools\" are selected during installation\n\n### Step 1. Installation\n\nSince v0.2.0 I introduced support for package installation. You can use your favorite Python package manager to install the server via:\n\n```bash\n# if pipx is installed (recommended)\npipx install supabase-mcp-server\n\n# if uv is installed\nuv pip install supabase-mcp-server\n```\n\n`pipx` is recommended because it creates isolated environments for each package.\n\nYou can also install the server manually by cloning the repository and running `pipx install -e .` from the root directory.\n\n#### Installing from source\nIf you would like to install from source, for example for local development:\n```bash\nuv venv\n# On Mac\nsource .venv/bin/activate\n# On Windows\n.venv\\Scripts\\activate\n# Install package in editable mode\nuv pip install -e .\n```\n\n#### Installing via Smithery.ai\n\nYou can find the full instructions on how to use Smithery.ai to connect to this MCP server [here](https://smithery.ai/server/@alexander-zuev/supabase-mcp-server).\n\n\n### Step 2. Configuration\n\nThe Supabase MCP server requires configuration to connect to your Supabase database, access the Management API, and use the Auth Admin SDK. This section explains all available configuration options and how to set them up.\n\n#### Environment Variables\n\nThe server uses the following environment variables:\n\n| Variable | Required | Default | Description |\n|----------|----------|---------|-------------|\n| `SUPABASE_PROJECT_REF` | Yes | `127.0.0.1:54322` | Your Supabase project reference ID (or local host:port) |\n| `SUPABASE_DB_PASSWORD` | Yes | `postgres` | Your database password |\n| `SUPABASE_REGION` | Yes* | `us-east-1` | AWS region where your Supabase project is hosted |\n| `SUPABASE_ACCESS_TOKEN` | No | None | Personal access token for Supabase Management API |\n| `SUPABASE_SERVICE_ROLE_KEY` | No | None | Service role key for Auth Admin SDK |\n\n> **Note**: The default values are configured for local Supabase development. For remote Supabase projects, you must provide your own values for `SUPABASE_PROJECT_REF` and `SUPABASE_DB_PASSWORD`.\n\n> 🚨 **CRITICAL CONFIGURATION NOTE**: For remote Supabase projects, you MUST specify the correct region where your project is hosted using `SUPABASE_REGION`. If you encounter a \"Tenant or user not found\" error, this is almost certainly because your region setting doesn't match your project's actual region. You can find your project's region in the Supabase dashboard under Project Settings.\n\n#### Connection Types\n\n##### Database Connection\n- The server connects to your Supabase PostgreSQL database using the transaction pooler endpoint\n- Local development uses a direct connection to `127.0.0.1:54322`\n- Remote projects use the format: `postgresql://postgres.[project_ref]:[password]@aws-0-[region].pooler.supabase.com:6543/postgres`\n\n> ⚠️ **Important**: Session pooling connections are not supported. The server exclusively uses transaction pooling for better compatibility with the MCP server architecture.\n\n##### Management API Connection\n- Requires `SUPABASE_ACCESS_TOKEN` to be set\n- Connects to the Supabase Management API at `https://api.supabase.com`\n- Only works with remote Supabase projects (not local development)\n\n##### Auth Admin SDK Connection\n- Requires `SUPABASE_SERVICE_ROLE_KEY` to be set\n- For local development, connects to `http://127.0.0.1:54321`\n- For remote projects, connects to `https://[project_ref].supabase.co`\n\n#### Configuration Methods\n\nThe server looks for configuration in this order (highest to lowest priority):\n\n1. **Environment Variables**: Values set directly in your environment\n2. **Local `.env` File**: A `.env` file in your current working directory (only works when running from source)\n3. **Global Config File**:\n - Windows: `%APPDATA%\\supabase-mcp\\.env`\n - macOS/Linux: `~/.config/supabase-mcp/.env`\n4. **Default Settings**: Local development defaults (if no other config is found)\n\n> ⚠️ **Important**: When using the package installed via pipx or uv, local `.env` files in your project directory are **not** detected. You must use either environment variables or the global config file.\n\n#### Setting Up Configuration\n\n##### Option 1: Client-Specific Configuration (Recommended)\n\nSet environment variables directly in your MCP client configuration (see client-specific setup instructions in Step 3). Most MCP clients support this approach, which keeps your configuration with your client settings.\n\n##### Option 2: Global Configuration\n\nCreate a global `.env` configuration file that will be used for all MCP server instances:\n\n```bash\n# Create config directory\n# On macOS/Linux\nmkdir -p ~/.config/supabase-mcp\n# On Windows (PowerShell)\nmkdir -Force \"$env:APPDATA\\supabase-mcp\"\n\n# Create and edit .env file\n# On macOS/Linux\nnano ~/.config/supabase-mcp/.env\n# On Windows (PowerShell)\nnotepad \"$env:APPDATA\\supabase-mcp\\.env\"\n```\n\nAdd your configuration values to the file:\n\n```\nSUPABASE_PROJECT_REF=your-project-ref\nSUPABASE_DB_PASSWORD=your-db-password\nSUPABASE_REGION=us-east-1\nSUPABASE_ACCESS_TOKEN=your-access-token\nSUPABASE_SERVICE_ROLE_KEY=your-service-role-key\n```\n\n##### Option 3: Project-Specific Configuration (Source Installation Only)\n\nIf you're running the server from source (not via package), you can create a `.env` file in your project directory with the same format as above.\n\n#### Finding Your Supabase Project Information\n\n- **Project Reference**: Found in your Supabase project URL: `https://supabase.com/dashboard/project/`\n- **Database Password**: Set during project creation or found in Project Settings → Database\n- **Access Token**: Generate at https://supabase.com/dashboard/account/tokens\n- **Service Role Key**: Found in Project Settings → API → Project API keys\n\n#### Supported Regions\n\nThe server supports all Supabase regions:\n\n- `us-west-1` - West US (North California)\n- `us-east-1` - East US (North Virginia) - default\n- `us-east-2` - East US (Ohio)\n- `ca-central-1` - Canada (Central)\n- `eu-west-1` - West EU (Ireland)\n- `eu-west-2` - West Europe (London)\n- `eu-west-3` - West EU (Paris)\n- `eu-central-1` - Central EU (Frankfurt)\n- `eu-central-2` - Central Europe (Zurich)\n- `eu-north-1` - North EU (Stockholm)\n- `ap-south-1` - South Asia (Mumbai)\n- `ap-southeast-1` - Southeast Asia (Singapore)\n- `ap-northeast-1` - Northeast Asia (Tokyo)\n- `ap-northeast-2` - Northeast Asia (Seoul)\n- `ap-southeast-2` - Oceania (Sydney)\n- `sa-east-1` - South America (São Paulo)\n\n#### Limitations\n\n- **No Self-Hosted Support**: The server only supports official Supabase.com hosted projects and local development\n- **No Connection String Support**: Custom connection strings are not supported\n- **No Session Pooling**: Only transaction pooling is supported for database connections\n- **API and SDK Features**: Management API and Auth Admin SDK features only work with remote Supabase projects, not local development\n\n### Step 3. Usage\n\nIn general, any MCP client that supports `stdio` protocol should work with this MCP server. This server was explicitly tested to work with:\n- Cursor\n- Windsurf\n- Cline\n- Claude Desktop\n\nAdditionally, you can also use smithery.ai to install this server a number of clients, including the ones above.\n\nFollow the guides below to install this MCP server in your client.\n\n#### Cursor\nGo to Settings -> Features -> MCP Servers and add a new server with this configuration:\n```bash\n# can be set to any name\nname: supabase\ntype: command\n# if you installed with pipx\ncommand: supabase-mcp-server\n# if you installed with uv\ncommand: uv run supabase-mcp-server\n# if the above doesn't work, use the full path (recommended)\ncommand: /full/path/to/supabase-mcp-server # Find with 'which supabase-mcp-server' (macOS/Linux) or 'where supabase-mcp-server' (Windows)\n```\n\nIf configuration is correct, you should see a green dot indicator and the number of tools exposed by the server.\n![How successful Cursor config looks like](https://github.com/user-attachments/assets/45df080a-8199-4aca-b59c-a84dc7fe2c09)\n\n#### Windsurf\nGo to Cascade -> Click on the hammer icon -> Configure -> Fill in the configuration:\n```json\n{\n \"mcpServers\": {\n \"supabase\": {\n \"command\": \"/Users/username/.local/bin/supabase-mcp-server\", // update path\n \"env\": {\n \"SUPABASE_PROJECT_REF\": \"your-project-ref\",\n \"SUPABASE_DB_PASSWORD\": \"your-db-password\",\n \"SUPABASE_REGION\": \"us-east-1\", // optional, defaults to us-east-1\n \"SUPABASE_ACCESS_TOKEN\": \"your-access-token\", // optional, for management API\n \"SUPABASE_SERVICE_ROLE_KEY\": \"your-service-role-key\" // optional, for Auth Admin SDK\n }\n }\n }\n}\n```\nIf configuration is correct, you should see green dot indicator and clickable supabase server in the list of available servers.\n\n![How successful Windsurf config looks like](https://github.com/user-attachments/assets/322b7423-8c71-410b-bcab-aff1b143faa4)\n\n#### Claude Desktop\nClaude Desktop also supports MCP servers through a JSON configuration. Follow these steps to set up the Supabase MCP server:\n\n1. **Find the full path to the executable** (this step is critical):\n ```bash\n # On macOS/Linux\n which supabase-mcp-server\n\n # On Windows\n where supabase-mcp-server\n ```\n Copy the full path that is returned (e.g., `/Users/username/.local/bin/supabase-mcp-server`).\n\n2. **Configure the MCP server** in Claude Desktop:\n - Open Claude Desktop\n - Go to Settings → Developer -> Edit Config MCP Servers\n - Add a new configuration with the following JSON:\n\n ```json\n {\n \"mcpServers\": {\n \"supabase\": {\n \"command\": \"/full/path/to/supabase-mcp-server\", // Replace with the actual path from step 1\n \"env\": {\n \"SUPABASE_PROJECT_REF\": \"your-project-ref\",\n \"SUPABASE_DB_PASSWORD\": \"your-db-password\",\n \"SUPABASE_REGION\": \"us-east-1\", // optional, defaults to us-east-1\n \"SUPABASE_ACCESS_TOKEN\": \"your-access-token\", // optional, for management API\n \"SUPABASE_SERVICE_ROLE_KEY\": \"your-service-role-key\" // optional, for Auth Admin SDK\n }\n }\n }\n }\n ```\n\n> ⚠️ **Important**: Unlike Windsurf and Cursor, Claude Desktop requires the **full absolute path** to the executable. Using just the command name (`supabase-mcp-server`) will result in a \"spawn ENOENT\" error.\n\nIf configuration is correct, you should see the Supabase MCP server listed as available in Claude Desktop.\n\n![How successful Windsurf config looks like](https://github.com/user-attachments/assets/500bcd40-6245-40a7-b23b-189827ed2923)\n\n#### Cline\nCline also supports MCP servers through a similar JSON configuration. Follow these steps to set up the Supabase MCP server:\n\n1. **Find the full path to the executable** (this step is critical):\n ```bash\n # On macOS/Linux\n which supabase-mcp-server\n\n # On Windows\n where supabase-mcp-server\n ```\n Copy the full path that is returned (e.g., `/Users/username/.local/bin/supabase-mcp-server`).\n\n2. **Configure the MCP server** in Cline:\n - Open Cline in VS Code\n - Click on the \"MCP Servers\" tab in the Cline sidebar\n - Click \"Configure MCP Servers\"\n - This will open the `cline_mcp_settings.json` file\n - Add the following configuration:\n\n ```json\n {\n \"mcpServers\": {\n \"supabase\": {\n \"command\": \"/full/path/to/supabase-mcp-server\", // Replace with the actual path from step 1\n \"env\": {\n \"SUPABASE_PROJECT_REF\": \"your-project-ref\",\n \"SUPABASE_DB_PASSWORD\": \"your-db-password\",\n \"SUPABASE_REGION\": \"us-east-1\", // optional, defaults to us-east-1\n \"SUPABASE_ACCESS_TOKEN\": \"your-access-token\", // optional, for management API\n \"SUPABASE_SERVICE_ROLE_KEY\": \"your-service-role-key\" // optional, for Auth Admin SDK\n }\n }\n }\n }\n ```\n\nIf configuration is correct, you should see a green indicator next to the Supabase MCP server in the Cline MCP Servers list, and a message confirming \"supabase MCP server connected\" at the bottom of the panel.\n\n![How successful configuration in Cline looks like](https://github.com/user-attachments/assets/6c4446ad-7a58-44c6-bf12-6c82222bbe59)\n\n### Troubleshooting\n\nHere are some tips & tricks that might help you:\n- **Debug installation** - run `supabase-mcp-server` directly from the terminal to see if it works. If it doesn't, there might be an issue with the installation.\n- **MCP Server configuration** - if the above step works, it means the server is installed and configured correctly. As long as you provided the right command, IDE should be able to connect. Make sure to provide the right path to the server executable.\n- **\"No tools found\" error** - If you see \"Client closed - no tools available\" in Cursor despite the package being installed:\n - Find the full path to the executable by running `which supabase-mcp-server` (macOS/Linux) or `where supabase-mcp-server` (Windows)\n - Use the full path in your MCP server configuration instead of just `supabase-mcp-server`\n - For example: `/Users/username/.local/bin/supabase-mcp-server` or `C:\\Users\\username\\.local\\bin\\supabase-mcp-server.exe`\n- **Environment variables** - to connect to the right database, make sure you either set env variables in `mcp_config.json` or in `.env` file placed in a global config directory (`~/.config/supabase-mcp/.env` on macOS/Linux or `%APPDATA%\\supabase-mcp\\.env` on Windows).\n- **Accessing logs** - The MCP server writes detailed logs to a file:\n - Log file location:\n - macOS/Linux: `~/.local/share/supabase-mcp/mcp_server.log`\n - Windows: `%USERPROFILE%\\.local\\share\\supabase-mcp\\mcp_server.log`\n - Logs include connection status, configuration details, and operation results\n - View logs using any text editor or terminal commands:\n ```bash\n # On macOS/Linux\n cat ~/.local/share/supabase-mcp/mcp_server.log\n\n # On Windows (PowerShell)\n Get-Content \"$env:USERPROFILE\\.local\\share\\supabase-mcp\\mcp_server.log\"\n ```\n\nIf you are stuck or any of the instructions above are incorrect, please raise an issue.\n\n### MCP Inspector\nA super useful tool to help debug MCP server issues is MCP Inspector. If you installed from source, you can run `supabase-mcp-inspector` from the project repo and it will run the inspector instance. Coupled with logs this will give you complete overview over what's happening in the server.\n> 📝 Running `supabase-mcp-inspector`, if installed from package, doesn't work properly - I will validate and fix in the coming release.\n\n## Feature Overview\n\n### Database query tools\n\nSince v0.3+ server provides comprehensive database management capabilities with built-in safety controls:\n\n- **SQL Query Execution**: Execute PostgreSQL queries with risk assessment\n - **Three-tier safety system**:\n - `safe`: Read-only operations (SELECT) - always allowed\n - `write`: Data modifications (INSERT, UPDATE, DELETE) - require unsafe mode\n - `destructive`: Schema changes (DROP, CREATE) - require unsafe mode + confirmation\n\n- **SQL Parsing and Validation**:\n - Uses PostgreSQL's parser (pglast) for accurate analysis and provides clear feedback on safety requirements\n\n- **Automatic Migration Versioning**:\n - Database-altering operations operations are automatically versioned\n - Generates descriptive names based on operation type and target\n\n\n- **Safety Controls**:\n - Default SAFE mode allows only read-only operations\n - All statements run in transaction mode via `asyncpg`\n - 2-step confirmation for high-risk operations\n\n- **Available Tools**:\n - `get_schemas`: Lists schemas with sizes and table counts\n - `get_tables`: Lists tables, foreign tables, and views with metadata\n - `get_table_schema`: Gets detailed table structure (columns, keys, relationships)\n - `execute_postgresql`: Executes SQL statements against your database\n - `confirm_destructive_operation`: Executes high-risk operations after confirmation\n - `retrieve_migrations`: Gets migrations with filtering and pagination options\n - `live_dangerously`: Toggles between safe and unsafe modes\n\n### Management API tools\n\nSince v0.3.0 server provides secure access to the Supabase Management API with built-in safety controls:\n\n- **Available Tools**:\n - `send_management_api_request`: Sends arbitrary requests to Supabase Management API with auto-injection of project ref\n - `get_management_api_spec`: Gets the enriched API specification with safety information\n - Supports multiple query modes: by domain, by specific path/method, or all paths\n - Includes risk assessment information for each endpoint\n - Provides detailed parameter requirements and response formats\n - Helps LLMs understand the full capabilities of the Supabase Management API\n - `get_management_api_safety_rules`: Gets all safety rules with human-readable explanations\n - `live_dangerously`: Toggles between safe and unsafe operation modes\n\n- **Safety Controls**:\n - Uses the same safety manager as database operations for consistent risk management\n - Operations categorized by risk level:\n - `safe`: Read-only operations (GET) - always allowed\n - `unsafe`: State-changing operations (POST, PUT, PATCH, DELETE) - require unsafe mode\n - `blocked`: Destructive operations (delete project, etc.) - never allowed\n - Default safe mode prevents accidental state changes\n - Path-based pattern matching for precise safety rules\n\n**Note**: Management API tools only work with remote Supabase instances and are not compatible with local Supabase development setups.\n\n### Auth Admin tools\n\nI was planning to add support for Python SDK methods to the MCP server. Upon consideration I decided to only add support for Auth admin methods as I often found myself manually creating test users which was prone to errors and time consuming. Now I can just ask Cursor to create a test user and it will be done seamlessly. Check out the full Auth Admin SDK method docs to know what it can do.\n\nSince v0.3.6 server supports direct access to Supabase Auth Admin methods via Python SDK:\n - Includes the following tools:\n - `get_auth_admin_methods_spec` to retrieve documentation for all available Auth Admin methods\n - `call_auth_admin_method` to directly invoke Auth Admin methods with proper parameter handling\n - Supported methods:\n - `get_user_by_id`: Retrieve a user by their ID\n - `list_users`: List all users with pagination\n - `create_user`: Create a new user\n - `delete_user`: Delete a user by their ID\n - `invite_user_by_email`: Send an invite link to a user's email\n - `generate_link`: Generate an email link for various authentication purposes\n - `update_user_by_id`: Update user attributes by ID\n - `delete_factor`: Delete a factor on a user (currently not implemented in SDK)\n\n#### Why use Auth Admin SDK instead of raw SQL queries?\n\nThe Auth Admin SDK provides several key advantages over direct SQL manipulation:\n- **Functionality**: Enables operations not possible with SQL alone (invites, magic links, MFA)\n- **Accuracy**: More reliable then creating and executing raw SQL queries on auth schemas\n- **Simplicity**: Offers clear methods with proper validation and error handling\n\n - Response format:\n - All methods return structured Python objects instead of raw dictionaries\n - Object attributes can be accessed using dot notation (e.g., `user.id` instead of `user[\"id\"]`)\n - Edge cases and limitations:\n - UUID validation: Many methods require valid UUID format for user IDs and will return specific validation errors\n - Email configuration: Methods like `invite_user_by_email` and `generate_link` require email sending to be configured in your Supabase project\n - Link types: When generating links, different link types have different requirements:\n - `signup` links don't require the user to exist\n - `magiclink` and `recovery` links require the user to already exist in the system\n - Error handling: The server provides detailed error messages from the Supabase API, which may differ from the dashboard interface\n - Method availability: Some methods like `delete_factor` are exposed in the API but not fully implemented in the SDK\n\n### Logs & Analytics\n\nThe server provides access to Supabase logs and analytics data, making it easier to monitor and troubleshoot your applications:\n\n- **Available Tool**: `retrieve_logs` - Access logs from any Supabase service\n\n- **Log Collections**:\n - `postgres`: Database server logs\n - `api_gateway`: API gateway requests\n - `auth`: Authentication events\n - `postgrest`: RESTful API service logs\n - `pooler`: Connection pooling logs\n - `storage`: Object storage operations\n - `realtime`: WebSocket subscription logs\n - `edge_functions`: Serverless function executions\n - `cron`: Scheduled job logs\n - `pgbouncer`: Connection pooler logs\n\n- **Features**: Filter by time, search text, apply field filters, or use custom SQL queries\n\nSimplifies debugging across your Supabase stack without switching between interfaces or writing complex queries.\n\n### Automatic Versioning of Database Changes\n\n\"With great power comes great responsibility.\" While `execute_postgresql` tool coupled with aptly named `live_dangerously` tool provide a powerful and simple way to manage your Supabase database, it also means that dropping a table or modifying one is one chat message away. In order to reduce the risk of irreversible changes, since v0.3.8 the server supports:\n- automatic creation of migration scripts for all write & destructive sql operations executed on the database\n- improved safety mode of query execution, in which all queries are categorized in:\n - `safe` type: always allowed. Includes all read-only ops.\n - `write`type: requires `write` mode to be enabled by the user.\n - `destructive` type: requires `write` mode to be enabled by the user AND a 2-step confirmation of query execution for clients that do not execute tools automatically.\n\n### Universal Safety Mode\nSince v0.3.8 Safety Mode has been 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.\n\nAll operations (SQL queries, API requests, SDK methods) are categorized into risk levels:\n- `Low` risk: Read-only operations that don't modify data or structure (SELECT queries, GET API requests)\n- `Medium` risk: Write operations that modify data but not structure (INSERT/UPDATE/DELETE, most POST/PUT API requests)\n- `High` risk: Destructive operations that modify database structure or could cause data loss (DROP/TRUNCATE, DELETE API endpoints)\n- `Extreme` risk: Operations with severe consequences that are blocked entirely (deleting projects)\n\nSafety controls are applied based on risk level:\n- Low risk operations are always allowed\n- Medium risk operations require unsafe mode to be enabled\n- High risk operations require unsafe mode AND explicit confirmation\n- Extreme risk operations are never allowed\n\n#### How confirmation flow works\n\nAny high-risk operations (be it a postgresql or api request) will be blocked even in `unsafe` mode.\n![Every high-risk operation is blocked](https://github.com/user-attachments/assets/c0df79c2-a879-4b1f-a39d-250f9965c36a)\nYou will have to confirm and approve every high-risk operation explicitly in order for it to be executed.\n![Explicit approval is always required](https://github.com/user-attachments/assets/5cd7a308-ec2a-414e-abe2-ff2f3836dd8b)\n\n\n## Changelog\n\n- 📦 Simplified installation via package manager - ✅ (v0.2.0)\n- 🌎 Support for different Supabase regions - ✅ (v0.2.2)\n- 🎮 Programmatic access to Supabase management API with safety controls - ✅ (v0.3.0)\n- 👷‍♂️ Read and read-write database SQL queries with safety controls - ✅ (v0.3.0)\n- 🔄 Robust transaction handling for both direct and pooled connections - ✅ (v0.3.2)\n- 🐍 Support methods and objects available in native Python SDK - ✅ (v0.3.6)\n- 🔍 Stronger SQL query validation ✅ (v0.3.8)\n- 📝 Automatic versioning of database changes ✅ (v0.3.8)\n- 📖 Radically improved knowledge and tools of api spec ✅ (v0.3.8)\n- ✍️ Improved consistency of migration-related tools for a more organized database vcs ✅ (v0.3.10)\n\n\nFor a more detailed roadmap, please see this [discussion](https://github.com/alexander-zuev/supabase-mcp-server/discussions/46) on GitHub.\n\n\n## Star History\n\n[![Star History Chart](https://api.star-history.com/svg?repos=alexander-zuev/supabase-mcp-server&type=Date)](https://star-history.com/#alexander-zuev/supabase-mcp-server&Date)\n\n---\n\nEnjoy! ☺️\n","url","https://github.com/alexander-zuev/supabase-mcp-server","githubRepository",{"_86":87,"_88":89,"_90":91,"_92":93,"_94":95,"_96":97,"_101":102,"_103":104,"_106":107},"defaultBranch","main","fullName","alexander-zuev/supabase-mcp-server","githubTreeId",75037,"language","Python","name","supabase-mcp-server","owner",{"_98":99,"_8":100},"login","alexander-zuev","98dm4eydqp","recentStargazers",56,"spdxLicense",{"_94":105},"Apache 2.0","stargazers",438,"glamaJson","id",987,"inspectable",true,"integrations",[115,125],{"_116":117,"_49":123,"_8":124},"brand",{"_118":119,"_94":120,"_121":122},"logoSvgPath","M23.5594 14.7228a.5269.5269 0 0 0-.0563-.1191c-.139-.2632-.4768-.3418-1.0074-.2321-1.6533.3411-2.2935.1312-2.5256-.0191 1.342-2.0482 2.445-4.522 3.0411-6.8297.2714-1.0507.7982-3.5237.1222-4.7316a1.5641 1.5641 0 0 0-.1509-.235C21.6931.9086 19.8007.0248 17.5099.0005c-1.4947-.0158-2.7705.3461-3.1161.4794a9.449 9.449 0 0 0-.5159-.0816 8.044 8.044 0 0 0-1.3114-.1278c-1.1822-.0184-2.2038.2642-3.0498.8406-.8573-.3211-4.7888-1.645-7.2219.0788C.9359 2.1526.3086 3.8733.4302 6.3043c.0409.818.5069 3.334 1.2423 5.7436.4598 1.5065.9387 2.7019 1.4334 3.582.553.9942 1.1259 1.5933 1.7143 1.7895.4474.1491 1.1327.1441 1.8581-.7279.8012-.9635 1.5903-1.8258 1.9446-2.2069.4351.2355.9064.3625 1.39.3772a.0569.0569 0 0 0 .0004.0041 11.0312 11.0312 0 0 0-.2472.3054c-.3389.4302-.4094.5197-1.5002.7443-.3102.064-1.1344.2339-1.1464.8115-.0025.1224.0329.2309.0919.3268.2269.4231.9216.6097 1.015.6331 1.3345.3335 2.5044.092 3.3714-.6787-.017 2.231.0775 4.4174.3454 5.0874.2212.5529.7618 1.9045 2.4692 1.9043.2505 0 .5263-.0291.8296-.0941 1.7819-.3821 2.5557-1.1696 2.855-2.9059.1503-.8707.4016-2.8753.5388-4.1012.0169-.0703.0357-.1207.057-.1362.0007-.0005.0697-.0471.4272.0307a.3673.3673 0 0 0 .0443.0068l.2539.0223.0149.001c.8468.0384 1.9114-.1426 2.5312-.4308.6438-.2988 1.8057-1.0323 1.5951-1.6698zM2.371 11.8765c-.7435-2.4358-1.1779-4.8851-1.2123-5.5719-.1086-2.1714.4171-3.6829 1.5623-4.4927 1.8367-1.2986 4.8398-.5408 6.108-.13-.0032.0032-.0066.0061-.0098.0094-2.0238 2.044-1.9758 5.536-1.9708 5.7495-.0002.0823.0066.1989.0162.3593.0348.5873.0996 1.6804-.0735 2.9184-.1609 1.1504.1937 2.2764.9728 3.0892.0806.0841.1648.1631.2518.2374-.3468.3714-1.1004 1.1926-1.9025 2.1576-.5677.6825-.9597.5517-1.0886.5087-.3919-.1307-.813-.5871-1.2381-1.3223-.4796-.839-.9635-2.0317-1.4155-3.5126zm6.0072 5.0871c-.1711-.0428-.3271-.1132-.4322-.1772.0889-.0394.2374-.0902.4833-.1409 1.2833-.2641 1.4815-.4506 1.9143-1.0002.0992-.126.2116-.2687.3673-.4426a.3549.3549 0 0 0 .0737-.1298c.1708-.1513.2724-.1099.4369-.0417.156.0646.3078.26.3695.4752.0291.1016.0619.2945-.0452.4444-.9043 1.2658-2.2216 1.2494-3.1676 1.0128zm2.094-3.988-.0525.141c-.133.3566-.2567.6881-.3334 1.003-.6674-.0021-1.3168-.2872-1.8105-.8024-.6279-.6551-.9131-1.5664-.7825-2.5004.1828-1.3079.1153-2.4468.079-3.0586-.005-.0857-.0095-.1607-.0122-.2199.2957-.2621 1.6659-.9962 2.6429-.7724.4459.1022.7176.4057.8305.928.5846 2.7038.0774 3.8307-.3302 4.7363-.084.1866-.1633.3629-.2311.5454zm7.3637 4.5725c-.0169.1768-.0358.376-.0618.5959l-.146.4383a.3547.3547 0 0 0-.0182.1077c-.0059.4747-.054.6489-.115.8693-.0634.2292-.1353.4891-.1794 1.0575-.11 1.4143-.8782 2.2267-2.4172 2.5565-1.5155.3251-1.7843-.4968-2.0212-1.2217a6.5824 6.5824 0 0 0-.0769-.2266c-.2154-.5858-.1911-1.4119-.1574-2.5551.0165-.5612-.0249-1.9013-.3302-2.6462.0044-.2932.0106-.5909.019-.8918a.3529.3529 0 0 0-.0153-.1126 1.4927 1.4927 0 0 0-.0439-.208c-.1226-.4283-.4213-.7866-.7797-.9351-.1424-.059-.4038-.1672-.7178-.0869.067-.276.1831-.5875.309-.9249l.0529-.142c.0595-.16.134-.3257.213-.5012.4265-.9476 1.0106-2.2453.3766-5.1772-.2374-1.0981-1.0304-1.6343-2.2324-1.5098-.7207.0746-1.3799.3654-1.7088.5321a5.6716 5.6716 0 0 0-.1958.1041c.0918-1.1064.4386-3.1741 1.7357-4.4823a4.0306 4.0306 0 0 1 .3033-.276.3532.3532 0 0 0 .1447-.0644c.7524-.5706 1.6945-.8506 2.802-.8325.4091.0067.8017.0339 1.1742.081 1.939.3544 3.2439 1.4468 4.0359 2.3827.8143.9623 1.2552 1.9315 1.4312 2.4543-1.3232-.1346-2.2234.1268-2.6797.779-.9926 1.4189.543 4.1729 1.2811 5.4964.1353.2426.2522.4522.2889.5413.2403.5825.5515.9713.7787 1.2552.0696.087.1372.1714.1885.245-.4008.1155-1.1208.3825-1.0552 1.717-.0123.1563-.0423.4469-.0834.8148-.0461.2077-.0702.4603-.0994.7662zm.8905-1.6211c-.0405-.8316.2691-.9185.5967-1.0105a2.8566 2.8566 0 0 0 .135-.0406 1.202 1.202 0 0 0 .1342.103c.5703.3765 1.5823.4213 3.0068.1344-.2016.1769-.5189.3994-.9533.6011-.4098.1903-1.0957.333-1.7473.3636-.7197.0336-1.0859-.0807-1.1721-.151zm.5695-9.2712c-.0059.3508-.0542.6692-.1054 1.0017-.055.3576-.112.7274-.1264 1.1762-.0142.4368.0404.8909.0932 1.3301.1066.887.216 1.8003-.2075 2.7014a3.5272 3.5272 0 0 1-.1876-.3856c-.0527-.1276-.1669-.3326-.3251-.6162-.6156-1.1041-2.0574-3.6896-1.3193-4.7446.3795-.5427 1.3408-.5661 2.1781-.463zm.2284 7.0137a12.3762 12.3762 0 0 0-.0853-.1074l-.0355-.0444c.7262-1.1995.5842-2.3862.4578-3.4385-.0519-.4318-.1009-.8396-.0885-1.2226.0129-.4061.0666-.7543.1185-1.0911.0639-.415.1288-.8443.1109-1.3505.0134-.0531.0188-.1158.0118-.1902-.0457-.4855-.5999-1.938-1.7294-3.253-.6076-.7073-1.4896-1.4972-2.6889-2.0395.5251-.1066 1.2328-.2035 2.0244-.1859 2.0515.0456 3.6746.8135 4.8242 2.2824a.908.908 0 0 1 .0667.1002c.7231 1.3556-.2762 6.2751-2.9867 10.5405zm-8.8166-6.1162c-.025.1794-.3089.4225-.6211.4225a.5821.5821 0 0 1-.0809-.0056c-.1873-.026-.3765-.144-.5059-.3156-.0458-.0605-.1203-.178-.1055-.2844.0055-.0401.0261-.0985.0925-.1488.1182-.0894.3518-.1226.6096-.0867.3163.0441.6426.1938.6113.4186zm7.9305-.4114c.0111.0792-.049.201-.1531.3102-.0683.0717-.212.1961-.4079.2232a.5456.5456 0 0 1-.075.0052c-.2935 0-.5414-.2344-.5607-.3717-.024-.1765.2641-.3106.5611-.352.297-.0414.6111.0088.6356.1851z","PostgreSQL","slug","postgresql","Provides tools for executing PostgreSQL queries against Supabase databases with risk assessment, parsing, and validation. Includes automatic migration versioning for database-altering operations.","z7d917si7z",{"_116":126,"_49":130,"_8":131},{"_118":127,"_94":128,"_121":129},"M11.9 1.036c-.015-.986-1.26-1.41-1.874-.637L.764 12.05C-.33 13.427.65 15.455 2.409 15.455h9.579l.113 7.51c.014.985 1.259 1.408 1.873.636l9.262-11.653c1.093-1.375.113-3.403-1.645-3.403h-9.642z","Supabase","supabase","Enables safely interacting with Supabase databases, executing SQL queries, managing database schemas, accessing the Supabase Management API, and using the Supabase Auth Admin SDK for user management. Includes safety controls for different risk levels of operations.","vf0xvodlse","Supabase MCP Server","namespace","npmPackage","prompts","redditPostForeignId","1iqfhch","relatedMcpServerIds",[140,141,142,143,144,145],257,623,802,967,637,639,"resources","scores",{"_149":150,"_151":150,"_152":150},"license",100,"quality","security","simpleIcon","supportedPlatforms",[156,157,158],"MACOS","WINDOWS","LINUX","tools",[161,168,178,189,203,225,249,259,265,274,291],{"_94":162,"_49":163,"_164":165},"get_schemas","List all database schemas with their sizes and table counts.","inputSchema",{"_12":66,"_10":166,"_43":167},"get_schemasArguments",{},{"_94":169,"_49":170,"_164":171},"get_tables","List all tables, foreign tables, and views in a schema with their sizes, row counts, and metadata.\n\nProvides detailed information about all database objects in the specified schema:\n- Table/view names\n- Object types (table, view, foreign table)\n- Row counts\n- Size on disk\n- Column counts\n- Index information\n- Last vacuum/analyze times\n\nParameters:\n- schema_name: Name of the schema to inspect (e.g., 'public', 'auth', etc.)\n\nSAFETY: This is a low-risk read operation that can be executed in SAFE mode.\n",{"_12":66,"_10":172,"_64":173,"_43":175},"get_tablesArguments",[174],"schema_name",{"_174":176},{"_12":51,"_10":177},"Schema Name",{"_94":179,"_49":180,"_164":181},"get_table_schema","Get detailed table structure including columns, keys, and relationships.\n\nReturns comprehensive information about a specific table's structure:\n- Column definitions (names, types, constraints)\n- Primary key information\n- Foreign key relationships\n- Indexes\n- Constraints\n- Triggers\n\nParameters:\n- schema_name: Name of the schema (e.g., 'public', 'auth')\n- table: Name of the table to inspect\n\nSAFETY: This is a low-risk read operation that can be executed in SAFE mode.\n",{"_12":66,"_10":182,"_64":183,"_43":185},"get_table_schemaArguments",[174,184],"table",{"_184":186,"_174":188},{"_12":51,"_10":187},"Table",{"_12":51,"_10":177},{"_94":190,"_49":191,"_164":192},"execute_postgresql","Execute PostgreSQL statements against your Supabase database.\n\nIMPORTANT: All SQL statements must end with a semicolon (;).\n\nOPERATION TYPES AND REQUIREMENTS:\n1. READ Operations (SELECT, EXPLAIN, etc.):\n - Can be executed directly without special requirements\n - Example: SELECT * FROM public.users LIMIT 10;\n\n2. WRITE Operations (INSERT, UPDATE, DELETE):\n - Require UNSAFE mode (use live_dangerously('database', True) first)\n - Example:\n INSERT INTO public.users (email) VALUES ('user@example.com');\n\n3. SCHEMA Operations (CREATE, ALTER, DROP):\n - Require UNSAFE mode (use live_dangerously('database', True) first)\n - Destructive operations (DROP, TRUNCATE) require additional confirmation\n - Example:\n CREATE TABLE public.test_table (id SERIAL PRIMARY KEY, name TEXT);\n\nMIGRATION HANDLING:\nAll queries that modify the database will be automatically version controlled by the server. You can provide optional migration name, if you want to name the migration.\n - Respect the following format: verb_noun_detail. Be descriptive and concise.\n - Examples:\n - create_users_table\n - add_email_to_profiles\n - enable_rls_on_users\n - If you don't provide a migration name, the server will generate one based on the SQL statement\n - The system will sanitize your provided name to ensure compatibility with database systems\n - Migration names are prefixed with a timestamp in the format YYYYMMDDHHMMSS\n\nSAFETY SYSTEM:\nOperations are categorized by risk level:\n- LOW RISK: Read operations (SELECT, EXPLAIN) - allowed in SAFE mode\n- MEDIUM RISK: Write operations (INSERT, UPDATE, DELETE) - require UNSAFE mode\n- HIGH RISK: Schema operations (CREATE, ALTER) - require UNSAFE mode\n- EXTREME RISK: Destructive operations (DROP, TRUNCATE) - require UNSAFE mode and confirmation\n\nTRANSACTION HANDLING:\n- DO NOT use transaction control statements (BEGIN, COMMIT, ROLLBACK)\n- The database client automatically wraps queries in transactions\n- The SQL validator will reject queries containing transaction control statements\n- This ensures atomicity and provides rollback capability for data modifications\n\nMULTIPLE STATEMENTS:\n- You can send multiple SQL statements in a single query\n- Each statement will be executed in order within the same transaction\n- Example:\n CREATE TABLE public.test_table (id SERIAL PRIMARY KEY, name TEXT);\n INSERT INTO public.test_table (name) VALUES ('test');\n\nCONFIRMATION FLOW FOR HIGH-RISK OPERATIONS:\n- High-risk operations (DROP TABLE, TRUNCATE, etc.) will be rejected with a confirmation ID\n- The error message will explain what happened and provide a confirmation ID\n- Review the risks with the user before proceeding\n- Use the confirm_destructive_operation tool with the provided ID to execute the operation\n\nIMPORTANT GUIDELINES:\n- The database client starts in SAFE mode by default for safety\n- Only enable UNSAFE mode when you need to modify data or schema\n- Never mix READ and WRITE operations in the same transaction\n- For destructive operations, be prepared to confirm with the confirm_destructive_operation tool\n\nWHEN TO USE OTHER TOOLS INSTEAD:\n- For Auth operations (users, authentication, etc.): Use call_auth_admin_method instead of direct SQL\n The Auth Admin SDK provides safer, validated methods for user management\n- For project configuration, functions, storage, etc.: Use send_management_api_request\n The Management API handles Supabase platform features that aren't directly in the database\n\nNote: This tool operates on the PostgreSQL database only. API operations use separate safety controls.\n",{"_12":66,"_10":193,"_64":194,"_43":196},"execute_postgresqlArguments",[195],"query",{"_195":197,"_199":200},{"_12":51,"_10":198},"Query","migration_name",{"_12":51,"_10":201,"_47":202},"Migration Name","",{"_94":204,"_49":205,"_164":206},"retrieve_migrations","Retrieve a list of all migrations a user has from Supabase.\n\nReturns a list of migrations with the following information:\n- Version (timestamp)\n- Name\n- SQL statements (if requested)\n- Statement count\n- Version type (named or numbered)\n\nParameters:\n- limit: Maximum number of migrations to return (default: 50, max: 100)\n- offset: Number of migrations to skip for pagination (default: 0)\n- name_pattern: Optional pattern to filter migrations by name. Uses SQL ILIKE pattern matching (case-insensitive).\n The pattern is automatically wrapped with '%' wildcards, so \"users\" will match \"create_users_table\",\n \"add_email_to_users\", etc. To search for an exact match, use the complete name.\n- include_full_queries: Whether to include the full SQL statements in the result (default: false)\n\nSAFETY: This is a low-risk read operation that can be executed in SAFE mode.\n",{"_12":66,"_10":207,"_43":208},"retrieve_migrationsArguments",{"_209":210,"_214":215,"_218":219,"_221":222},"limit",{"_12":211,"_10":212,"_47":213},"integer","Limit",50,"offset",{"_12":211,"_10":216,"_47":217},"Offset",0,"name_pattern",{"_12":51,"_10":220,"_47":202},"Name Pattern","include_full_queries",{"_12":223,"_10":224,"_47":36},"boolean","Include Full Queries",{"_94":226,"_49":227,"_164":228},"send_management_api_request","Execute a Supabase Management API request.\n\nThis tool allows you to make direct calls to the Supabase Management API, which provides\nprogrammatic access to manage your Supabase project settings, resources, and configurations.\n\nREQUEST FORMATTING:\n- Use paths exactly as defined in the API specification\n- The {ref} parameter will be automatically injected from settings\n- Format request bodies according to the API specification\n\nPARAMETERS:\n- method: HTTP method (GET, POST, PUT, PATCH, DELETE)\n- path: API path (e.g. /v1/projects/{ref}/functions)\n- path_params: Path parameters as dict (e.g. {\"function_slug\": \"my-function\"}) - use empty dict {} if not needed\n- request_params: Query parameters as dict (e.g. {\"key\": \"value\"}) - use empty dict {} if not needed\n- request_body: Request body as dict (e.g. {\"name\": \"test\"}) - use empty dict {} if not needed\n\nPATH PARAMETERS HANDLING:\n- The {ref} placeholder (project reference) is automatically injected - you don't need to provide it\n- All other path placeholders must be provided in the path_params dictionary\n- Common placeholders include:\n * {function_slug}: For Edge Functions operations\n * {id}: For operations on specific resources (API keys, auth providers, etc.)\n * {slug}: For organization operations\n * {branch_id}: For database branch operations\n * {provider_id}: For SSO provider operations\n * {tpa_id}: For third-party auth operations\n\nEXAMPLES:\n1. GET request with path and query parameters:\n method: \"GET\"\n path: \"/v1/projects/{ref}/functions/{function_slug}\"\n path_params: {\"function_slug\": \"my-function\"}\n request_params: {\"version\": \"1\"}\n request_body: {}\n\n2. POST request with body:\n method: \"POST\"\n path: \"/v1/projects/{ref}/functions\"\n path_params: {}\n request_params: {}\n request_body: {\"name\": \"test-function\", \"slug\": \"test-function\"}\n\nSAFETY SYSTEM:\nAPI operations are categorized by risk level:\n- LOW RISK: Read operations (GET) - allowed in SAFE mode\n- MEDIUM/HIGH RISK: Write operations (POST, PUT, PATCH, DELETE) - require UNSAFE mode\n- EXTREME RISK: Destructive operations - require UNSAFE mode and confirmation\n- BLOCKED: Some operations are completely blocked for safety reasons\n\nSAFETY CONSIDERATIONS:\n- By default, the API client starts in SAFE mode, allowing only read operations\n- To perform write operations, first use live_dangerously(service=\"api\", enable=True)\n- High-risk operations will be rejected with a confirmation ID\n- Use confirm_destructive_operation with the provided ID after reviewing risks\n- Some operations may be completely blocked for safety reasons\n\nFor a complete list of available API endpoints and their parameters, use the get_management_api_spec tool.\nFor details on safety rules, use the get_management_api_safety_rules tool.\n",{"_12":66,"_10":229,"_64":230,"_43":236},"send_management_api_requestArguments",[231,232,233,234,235],"method","path","path_params","request_params","request_body",{"_232":237,"_231":239,"_233":241,"_235":245,"_234":247},{"_12":51,"_10":238},"Path",{"_12":51,"_10":240},"Method",{"_12":66,"_10":242,"_243":244},"Path Params","additionalProperties",{"_12":51},{"_12":66,"_10":246},"Request Body",{"_12":66,"_10":248},"Request Params",{"_94":250,"_49":251,"_164":252},"get_management_api_spec","Get the complete Supabase Management API specification.\n\nReturns the full OpenAPI specification for the Supabase Management API, including:\n- All available endpoints and operations\n- Required and optional parameters for each operation\n- Request and response schemas\n- Authentication requirements\n- Safety information for each operation\n\nThis tool can be used in four different ways:\n1. Without parameters: Returns all domains (default)\n2. With path and method: Returns the full specification for a specific API endpoint\n3. With domain only: Returns all paths and methods within that domain\n4. With all_paths=True: Returns all paths and methods\n\nParameters:\n- params: Dictionary containing optional parameters:\n - path: Optional API path (e.g., \"/v1/projects/{ref}/functions\")\n - method: Optional HTTP method (e.g., \"GET\", \"POST\")\n - domain: Optional domain/tag name (e.g., \"Auth\", \"Storage\")\n - all_paths: Optional boolean, if True returns all paths and methods\n\nAvailable domains:\n- Analytics: Analytics-related endpoints\n- Auth: Authentication and authorization endpoints\n- Database: Database management endpoints\n- Domains: Custom domain configuration endpoints\n- Edge Functions: Serverless function management endpoints\n- Environments: Environment configuration endpoints\n- OAuth: OAuth integration endpoints\n- Organizations: Organization management endpoints\n- Projects: Project management endpoints\n- Rest: RESTful API endpoints\n- Secrets: Secret management endpoints\n- Storage: Storage management endpoints\n\nThis specification is useful for understanding:\n- What operations are available through the Management API\n- How to properly format requests for each endpoint\n- Which operations require unsafe mode\n- What data structures to expect in responses\n\nSAFETY: This is a low-risk read operation that can be executed in SAFE mode.\n",{"_12":66,"_10":253,"_43":254},"get_management_api_specArguments",{"_255":256},"params",{"_12":66,"_10":257,"_47":258},"Params",{},{"_94":260,"_49":261,"_164":262},"get_auth_admin_methods_spec","Get Python SDK methods specification for Auth Admin.\n\nReturns a comprehensive dictionary of all Auth Admin methods available in the Supabase Python SDK, including:\n- Method names and descriptions\n- Required and optional parameters for each method\n- Parameter types and constraints\n- Return value information\n\nThis tool is useful for exploring the capabilities of the Auth Admin SDK and understanding\nhow to properly format parameters for the call_auth_admin_method tool.\n\nNo parameters required.\n",{"_12":66,"_10":263,"_43":264},"get_auth_admin_methods_specArguments",{},{"_94":266,"_49":267,"_164":268},"call_auth_admin_method","Call an Auth Admin method from Supabase Python SDK.\n\nThis tool provides a safe, validated interface to the Supabase Auth Admin SDK, allowing you to:\n- Manage users (create, update, delete)\n- List and search users\n- Generate authentication links\n- Manage multi-factor authentication\n- And more\n\nIMPORTANT NOTES:\n- Request bodies must adhere to the Python SDK specification\n- Some methods may have nested parameter structures\n- The tool validates all parameters against Pydantic models\n- Extra fields not defined in the models will be rejected\n\nAVAILABLE METHODS:\n- get_user_by_id: Retrieve a user by their ID\n- list_users: List all users with pagination\n- create_user: Create a new user\n- delete_user: Delete a user by their ID\n- invite_user_by_email: Send an invite link to a user's email\n- generate_link: Generate an email link for various authentication purposes\n- update_user_by_id: Update user attributes by ID\n- delete_factor: Delete a factor on a user\n\nEXAMPLES:\n1. Get user by ID:\n method: \"get_user_by_id\"\n params: {\"uid\": \"user-uuid-here\"}\n\n2. Create user:\n method: \"create_user\"\n params: {\n \"email\": \"user@example.com\",\n \"password\": \"secure-password\"\n }\n\n3. Update user by ID:\n method: \"update_user_by_id\"\n params: {\n \"uid\": \"user-uuid-here\",\n \"attributes\": {\n \"email\": \"new@email.com\"\n }\n }\n\nFor complete documentation of all methods and their parameters, use the get_auth_admin_methods_spec tool.\n",{"_12":66,"_10":269,"_64":270,"_43":271},"call_auth_admin_methodArguments",[231,255],{"_231":272,"_255":273},{"_12":51,"_10":240},{"_12":66,"_10":257},{"_94":275,"_49":276,"_164":277},"live_dangerously","Toggle unsafe mode for either Management API or Database operations.\n\nWHAT THIS TOOL DOES:\nThis tool switches between safe (default) and unsafe operation modes for either the Management API or Database operations.\n\nSAFETY MODES EXPLAINED:\n1. Database Safety Modes:\n - SAFE mode (default): Only low-risk operations like SELECT queries are allowed\n - UNSAFE mode: Higher-risk operations including INSERT, UPDATE, DELETE, and schema changes are permitted\n\n2. API Safety Modes:\n - SAFE mode (default): Only low-risk operations that don't modify state are allowed\n - UNSAFE mode: Higher-risk state-changing operations are permitted (except those explicitly blocked for safety)\n\nOPERATION RISK LEVELS:\nThe system categorizes operations by risk level:\n- LOW: Safe read operations with minimal impact\n- MEDIUM: Write operations that modify data but don't change structure\n- HIGH: Operations that modify database structure or important system settings\n- EXTREME: Destructive operations that could cause data loss or service disruption\n\nWHEN TO USE THIS TOOL:\n- Use this tool BEFORE attempting write operations or schema changes\n- Enable unsafe mode only when you need to perform data modifications\n- Always return to safe mode after completing write operations\n\nUSAGE GUIDELINES:\n- Start in safe mode by default for exploration and analysis\n- Switch to unsafe mode only when you need to make changes\n- Be specific about which service you're enabling unsafe mode for\n- Consider the risks before enabling unsafe mode, especially for database operations\n- For database operations requiring schema changes, you'll need to enable unsafe mode first\n\nParameters:\n- service: Which service to toggle (\"api\" or \"database\")\n- enable_unsafe_mode: True to enable unsafe mode, False for safe mode (default: False)\n\nExamples:\n1. Enable database unsafe mode:\n live_dangerously(service=\"database\", enable_unsafe_mode=True)\n\n2. Return to safe mode after operations:\n live_dangerously(service=\"database\", enable_unsafe_mode=False)\n\n3. Enable API unsafe mode:\n live_dangerously(service=\"api\", enable_unsafe_mode=True)\n\nNote: This tool affects ALL subsequent operations for the specified service until changed again.\n",{"_12":66,"_10":278,"_64":279,"_43":281},"live_dangerouslyArguments",[280],"service",{"_280":282,"_288":289},{"_283":284,"_12":51,"_10":287},"enum",[285,286],"api","database","Service","enable_unsafe_mode",{"_12":223,"_10":290,"_47":36},"Enable Unsafe Mode",{"_94":292,"_49":293,"_164":294},"confirm_destructive_operation","Execute a destructive database or API operation after confirmation. Use this only after reviewing the risks with the user.\n\nHOW IT WORKS:\n- This tool executes a previously rejected high-risk operation using its confirmation ID\n- The operation will be exactly the same as the one that generated the ID\n- No need to retype the query or api request params - the system remembers it\n\nSTEPS:\n1. Explain the risks to the user and get their approval\n2. Use this tool with the confirmation ID from the error message\n3. The original query will be executed as-is\n\nPARAMETERS:\n- operation_type: Type of operation (\"api\" or \"database\")\n- confirmation_id: The ID provided in the error message (required)\n- user_confirmation: Set to true to confirm execution (default: false)\n\nNOTE: Confirmation IDs expire after 5 minutes for security\n",{"_12":66,"_10":295,"_64":296,"_43":299},"confirm_destructive_operationArguments",[297,298],"operation_type","confirmation_id",{"_297":300,"_298":303,"_305":306},{"_283":301,"_12":51,"_10":302},[285,286],"Operation Type",{"_12":51,"_10":304},"Confirmation Id","user_confirmation",{"_12":223,"_10":307,"_47":36},"User Confirmation","cyeeqagb81","updatedAt",["D",1742492301022],"meta",[313,315,317,324,327,329,332,335,338,341,344,346,349,352,354,356,358,360,362],{"_10":314},"Supabase MCP Server | Glama",{"_316":76,"_94":49},"content",{"_318":319,"_320":321,"_322":323},"href","https://glama.ai/mcp/servers/@alexander-zuev/supabase-mcp-server","rel","canonical","tagName","link",{"_316":132,"_325":326},"property","og:title",{"_316":76,"_325":328},"og:description",{"_316":330,"_325":331},"https://glama.ai/logo.png","og:logo",{"_316":333,"_325":334},"https://glama.ai/mcp/servers/@alexander-zuev/supabase-mcp-server/og-image","og:image",{"_316":336,"_325":337},"630","og:image:height",{"_316":339,"_325":340},"1200","og:image:width",{"_316":342,"_325":343},"website","og:type",{"_316":319,"_325":345},"og:url",{"_316":347,"_325":348},"ChatGPT alternative for power users","og:site_name",{"_316":350,"_94":351},"summary_large_image","twitter:card",{"_316":347,"_94":353},"twitter:title",{"_316":76,"_94":355},"twitter:description",{"_316":333,"_94":357},"twitter:image",{"_316":336,"_94":359},"twitter:image:height",{"_316":339,"_94":361},"twitter:image:width",{"_363":364},"script:ld+json",{"_365":366,"_367":368},"@context","http://schema.org","@graph",[369],{"_365":370,"_371":372,"_373":374},"https://schema.org","@type","BreadcrumbList","itemListElement",[375,382,386,390],{"_371":376,"_377":378,"_94":379,"_380":381},"ListItem","item","https://glama.ai/","Glama","position",1,{"_371":376,"_377":383,"_94":384,"_380":385},"https://glama.ai/mcp","MCP",2,{"_371":376,"_377":387,"_94":388,"_380":389},"https://glama.ai/mcp/servers","Servers",3,{"_371":376,"_377":319,"_94":132,"_380":391},4,"routes/_public/mcp/servers/~namespace/~slug/_pages/_explorer/blob/~branch/~/_route",{"_394":395,"_399":87,"_37":400,"_232":202,"_491":492},"blob",{"_316":396,"_397":398},"3.12.9\n","fileName",".python-version","branch",{"_39":401,"_41":402,"_22":410,"_75":76,"_77":76,"_78":411,"_84":412,"_108":-5,"_109":110,"_111":112,"_113":415,"_94":132,"_133":99,"_134":-5,"_135":-5,"_136":137,"_138":420,"_146":-5,"_147":421,"_153":-5,"_121":95,"_154":422,"_159":423,"_8":308,"_309":490},["D",1739664017660],{"_43":403,"_64":409,"_12":66},{"_45":404,"_52":405,"_55":406,"_58":407,"_61":408},{"_47":48,"_49":50,"_12":51},{"_49":54,"_12":51},{"_49":57,"_12":51},{"_49":60,"_12":51},{"_49":63,"_12":51},[],[68,69,70,71,72,73,74],{"_80":81,"_82":83},{"_86":87,"_88":89,"_90":91,"_92":93,"_94":95,"_96":413,"_101":102,"_103":414,"_106":107},{"_98":99,"_8":100},{"_94":105},[416,418],{"_116":417,"_49":123,"_8":124},{"_118":119,"_94":120,"_121":122},{"_116":419,"_49":130,"_8":131},{"_118":127,"_94":128,"_121":129},[140,141,142,143,144,145],{"_149":150,"_151":150,"_152":150},[156,157,158],[424,427,432,438,444,451,461,466,469,475,482],{"_94":162,"_49":163,"_164":425},{"_12":66,"_10":166,"_43":426},{},{"_94":169,"_49":170,"_164":428},{"_12":66,"_10":172,"_64":429,"_43":430},[174],{"_174":431},{"_12":51,"_10":177},{"_94":179,"_49":180,"_164":433},{"_12":66,"_10":182,"_64":434,"_43":435},[174,184],{"_184":436,"_174":437},{"_12":51,"_10":187},{"_12":51,"_10":177},{"_94":190,"_49":191,"_164":439},{"_12":66,"_10":193,"_64":440,"_43":441},[195],{"_195":442,"_199":443},{"_12":51,"_10":198},{"_12":51,"_10":201,"_47":202},{"_94":204,"_49":205,"_164":445},{"_12":66,"_10":207,"_43":446},{"_209":447,"_214":448,"_218":449,"_221":450},{"_12":211,"_10":212,"_47":213},{"_12":211,"_10":216,"_47":217},{"_12":51,"_10":220,"_47":202},{"_12":223,"_10":224,"_47":36},{"_94":226,"_49":227,"_164":452},{"_12":66,"_10":229,"_64":453,"_43":454},[231,232,233,234,235],{"_232":455,"_231":456,"_233":457,"_235":459,"_234":460},{"_12":51,"_10":238},{"_12":51,"_10":240},{"_12":66,"_10":242,"_243":458},{"_12":51},{"_12":66,"_10":246},{"_12":66,"_10":248},{"_94":250,"_49":251,"_164":462},{"_12":66,"_10":253,"_43":463},{"_255":464},{"_12":66,"_10":257,"_47":465},{},{"_94":260,"_49":261,"_164":467},{"_12":66,"_10":263,"_43":468},{},{"_94":266,"_49":267,"_164":470},{"_12":66,"_10":269,"_64":471,"_43":472},[231,255],{"_231":473,"_255":474},{"_12":51,"_10":240},{"_12":66,"_10":257},{"_94":275,"_49":276,"_164":476},{"_12":66,"_10":278,"_64":477,"_43":478},[280],{"_280":479,"_288":481},{"_283":480,"_12":51,"_10":287},[285,286],{"_12":223,"_10":290,"_47":36},{"_94":292,"_49":293,"_164":483},{"_12":66,"_10":295,"_64":484,"_43":485},[297,298],{"_297":486,"_298":488,"_305":489},{"_283":487,"_12":51,"_10":302},[285,286],{"_12":51,"_10":304},{"_12":223,"_10":307,"_47":36},["D",1742492301022],"treeMembers",[493,496,498,500,502,504,506,508,510,512,514,516,518,520,522,524,525,527,529],{"_232":494,"_12":495},".github","tree",{"_232":497,"_12":495},"supabase_mcp",{"_232":499,"_12":495},"tests",{"_232":501,"_12":394},"CHANGELOG.MD",{"_232":503,"_12":394},"codecov.yml",{"_232":505,"_12":394},"CONTRIBUTING.MD",{"_232":507,"_12":394},"Dockerfile",{"_232":509,"_12":394},".dockerignore",{"_232":511,"_12":394},".env.example",{"_232":513,"_12":394},".env.test.example",{"_232":515,"_12":394},".gitignore",{"_232":517,"_12":394},"LICENSE",{"_232":519,"_12":394},"llms-full.txt",{"_232":521,"_12":394},".pre-commit-config.yaml",{"_232":523,"_12":394},"pyproject.toml",{"_232":398,"_12":394},{"_232":526,"_12":394},"README.md",{"_232":528,"_12":394},"smithery.yaml",{"_232":530,"_12":394},"uv.lock","actionData","errors"]