# Supabase MCP for AI Agents AI Agent Connect > Supabase MCP lets you manage your entire backend infrastructure through your AI agent. You can create projects, configure Postgres, manage branches, and handle secrets without leaving your workspace. It connects your Supabase account directly to your tools, making backend maintenance a conversation. ## Overview - **Category:** loved-by-devs - **Price:** Free - **Endpoint:** https://edge.vinkius.com/vk_preview_1yqJRB687wGnT0yDa9WG5Rvl1dh6u5Mg2RCACLvF/ai-agent-connect - **Tags:** postgres, backend-as-a-service, database-management, secret-management, branching, cloud-deployment ## Description Supabase MCP lets you manage your entire backend infrastructure through your AI agent. Instead of jumping back and forth between tabs to check database statuses or rotate API keys, you just tell your AI client what needs doing. This Connector gives your agent the hands it needs to interact with your Supabase account directly. You can spin up new projects, set up isolated environments for your team, and tweak your Postgres configurations on the fly. It's about moving away from manual dashboard clicking and toward a workflow where you just describe the desired state of your backend. When you find this in the Vinkius catalog, you're getting a way to turn your AI into a functional member of your DevOps team. It handles the repetitive stuff like secret rotation or branch creation so you can stay focused on shipping features instead of babysitting infrastructure. You no longer have to worry about the tedious navigation of a web dashboard or the risk of making a manual error in a configuration file. If you need to pause a project to save on costs, create a new branch for a preview environment, or audit your organization's projects, it happens in a single turn of conversation. It turns complex infrastructure tasks into simple, actionable commands that keep your momentum going and your backend running smoothly. ## Tools ### create_branch Make a new branch with an isolated copy of your database for preview environments. ### create_project Provision a new project with Postgres, Auth, and Storage services in your preferred region. ### create_secret Add a new encrypted secret to your project for API keys or other credentials. ### delete_secret Remove a secret from a specific project. This action is permanent and cannot be undone. ### get_user Fetch the authenticated user's ID, email, and metadata. This helps verify that your connection tokens are working correctly. ### get_postgres_config View the current configuration settings for your PostgreSQL database. ### get_project Get the full details for a specific project using its unique reference. ### list_branches See all development branches and their current statuses for a project. ### list_organizations List all of your Supabase organizations and their associated projects. ### list_projects View all your projects, including their regions and current status. ### list_secrets See the environment secrets for a project, with an optional filter for specific branches. ### pause_project Stop a project to halt compute usage and save costs while keeping your data safe. ### restore_project Bring a paused project back online with all your data intact. ### update_postgres_config Update settings like max_connections or work_mem for your database. This helps you fine-tune performance without manually editing config files. ## Prompt Examples **Prompt:** ``` List all my projects and tell me which ones are currently paused. ``` **Response:** ``` I found 4 projects in your organization: | Project Name | Region | Status | | :--- | :--- | :--- | | **prod-api** | us-east-1 | Active | | **staging-api** | us-east-1 | Active | | **dev-sandbox** | eu-west-2 | Active | | **analytics-db** | ap-southeast-1 | **Paused** | Would you like me to restore the `analytics-db` project for you? ``` **Prompt:** ``` I need to create a new dev branch for the 'auth-fix' feature on my staging-api project. ``` **Response:** ``` Done! I've created a new branch called `auth-fix` for your `staging-api` project. * **Branch Name**: auth-fix * **Status**: Creating * **Database**: Isolated copy created It should be ready for use in a few minutes. Let me know if you need anything else! ``` **Prompt:** ``` Show me the current Postgres config for my production database. ``` **Response:** ``` Here are the current PostgreSQL configuration settings for your `prod-api` project: * **max_connections**: 200 * **work_mem**: 16MB * **shared_buffers**: 512MB * **maintenance_work_mem**: 128MB Would you like to update any of these values? ``` ## Capabilities ### Create new backend projects Spin up new Supabase projects with Postgres, Auth, and Storage in your preferred region. ### Spin up isolated dev branches Create separate database copies for preview environments and independent development. ### Manage project secrets List, create, and delete API keys and credentials securely across different branches. ### Update Postgres configurations Modify database settings like max connections and memory limits through natural language. ### List organization projects Get a full overview of all projects and member details across your entire organization. ### Pause projects to save costs Stop compute resources on unused projects while keeping your data fully intact. ### Verify user authentication Check user IDs and account metadata to ensure your auth tokens are working correctly. ## Use Cases ### Provisioning a new staging environment A developer needs a mirror of production. They ask the agent to use `create_project` in a specific region and then `create_branch` to set up a preview. ### Cost management A DevOps lead notices high bills. They ask the agent to use `pause_project` on all projects that haven't been active in a week. ### Secret rotation A security engineer needs to update an API key. They ask the agent to use `delete_secret` and `create_secret` to ensure the new key is active. ### Database tuning A backend dev notices slow queries. They ask the agent to use `get_postgres_config` to check limits and then `update_postgres_config` to increase `work_mem`. ## Benefits - Stop switching tabs by using `create_project` to spin up new environments directly from your IDE. - Reduce costs by using `pause_project` to shut down dev environments when the team isn't working. - Keep secrets safe and organized by using `list_secrets` and `create_secret` to manage keys without manual entry. - Isolate your development work by using `create_branch` to give every feature its own database copy. - Audit your infrastructure quickly by using `list_organizations` to see every project across your team. - Fine-tune performance by using `update_postgres_config` to change database limits on the fly. ## How It Works The bottom line is you get a conversational interface for your entire Supabase backend infrastructure. 1. Subscribe to the Supabase MCP in the Vinkius marketplace. 2. Enter your Supabase Personal Access Token to authorize the connection. 3. Start managing your projects and database settings via your AI client. ## Frequently Asked Questions **Can I use the Supabase MCP to manage my secrets?** Yes, you can use it to list, create, and delete secrets like API keys and credentials. This makes it much easier to manage sensitive information without having to manually copy and paste them into a dashboard. **How does the Supabase MCP help with cost management?** It allows you to pause projects that aren't being used. When you pause a project, you stop the compute resources from running, which helps you avoid unnecessary costs while keeping your data safe. **Can I create new projects using the Supabase MCP?** Yes, you can ask your agent to provision a new Supabase project. You just need to specify the name, organization ID, and your preferred region. **Does the Supabase MCP support multiple organizations?** Yes, the Connector can discover and list all organizations and their member projects, giving you a bird's-eye view of your entire backend footprint. **Can I use the Supabase MCP to update my database settings?** Yes, you can view and update PostgreSQL configurations like memory limits and connection counts. This lets you tune your database performance through simple conversation. **Is it possible to create isolated branches with the Supabase MCP?** Absolutely. You can create development branches that provide isolated copies of your database. This is perfect for creating preview environments for your team. **How do I create a Supabase Personal Access Token?** Log in to the [**Supabase Dashboard**](https://supabase.com/dashboard/account/tokens), go to **Account Settings > Access Tokens**, click **Generate Token**, give it a name and copy it immediately — it won't be shown again. The token starts with `sbp_`. **What happens when I pause a project?** Pausing a project stops all compute resources (API, Auth, Edge Functions) to reduce costs. Your database and all stored data are preserved. You can restore the project at any time with `restore_project` and all services will come back online with data intact. **Can I manage environment secrets via the agent?** Yes! Use `list_secrets` to see all secret names (values are hidden for security), `create_secret` to add new ones with name and value, and `delete_secret` to remove them. You can scope secrets to specific branches using the slug parameter. **Can I update PostgreSQL settings programmatically?** Yes! Use `get_postgres_config` to view current settings and `update_postgres_config` with a JSON object of settings to change (e.g. {"max_connections":200,"work_mem":"16MB"}). Some changes may require a database restart to take effect.