Supabase MCP Server
Connect to the Supabase MCP server to query your database, inspect your schema, run migrations, and deploy edge functions using AI agents on Gumloop, Claude, or Cursor.
Try Supabase now
Type what you want done. Sign in and run it live with an AI agent.
|
Supabase
Installation
Set up the Supabase MCP server in Gumloop
Do this once to provision your hosted server URL.
Create a Gumloop account
To use this MCP, you need a Gumloop account. If you don't have one yet, sign up and start a 14-day free trial.
Add and authorize the Supabase server
In Gumloop, open Connectors and add Supabase. You'll be sent to Supabase's sign-in screen to grant access. The credential is stored securely in Gumloop.
Then use it in your client
Use in GumloopUse Supabase in an agent
Once Supabase is set up, just open any Gumloop agent, add Supabase as a connector, and start chatting with the agent.
Tools (29)
Search Docs
Search the Supabase documentation using GraphQL. Must be a valid GraphQL query. You should default to calling this even if you think you already know the answer, since the documentation is always being updated. Below is the GraphQL schema for this tool: schema{query:RootQueryType}type Guide implements SearchResult{title:String href:String content:String subsections:SubsectionCollection}interface SearchResult{title:String href:String content:String}type SubsectionCollection{edges:[SubsectionEdge!]! nodes:[Subsection!]! totalCount:Int!}type SubsectionEdge{node:Subsection!}type Subsection{title:String href:String content:String}type CLICommandReference implements SearchResult{title:String href:String content:String}type ManagementApiReference implements SearchResult{title:String href:String content:String}type ClientLibraryFunctionReference implements SearchResult{title:String href:String content:String language:Language! methodName:String}enum Language{JAVASCRIPT SWIFT DART CSHARP KOTLIN PYTHON}type TroubleshootingGuide implements SearchResult{title:String href:String content:String}type RootQueryType{schema:String! searchDocs(query:String!,limit:Int):SearchResultCollection error(code:String!,service:Service!):Error errors(first:Int after:String last:Int before:String service:Service code:String):ErrorCollection}type SearchResultCollection{edges:[SearchResultEdge!]! nodes:[SearchResult!]! totalCount:Int!}type SearchResultEdge{node:SearchResult!}type Error{code:String! service:Service! httpStatusCode:Int message:String}enum Service{AUTH REALTIME STORAGE}type ErrorCollection{edges:[ErrorEdge!]! nodes:[Error!]! pageInfo:PageInfo! totalCount:Int!}type ErrorEdge{node:Error! cursor:String!}type PageInfo{hasNextPage:Boolean! hasPreviousPage:Boolean! startCursor:String endCursor:String}
List Organizations
Lists all organizations that the user is a member of.
Get Organization
Gets details for an organization. Includes subscription plan.
List Projects
Lists all Supabase projects for the user. Use this to help discover the project ID of the project that the user is working on.
Get Project
Gets details for a Supabase project.
Get Cost
Gets the cost of creating a new project or branch. Never assume organization as costs can be different for each. Always repeat the cost to the user and confirm their understanding before proceeding.
Confirm Cost
Ask the user to confirm their understanding of the cost of creating a new project or branch. Call `get_cost` first. Returns a unique ID for this confirmation which should be passed to `create_project` or `create_branch`.
Create Project
Creates a new Supabase project. Always ask the user which organization to create the project in. The project can take a few minutes to initialize - use `get_project` to check the status.
Pause Project
Pauses a Supabase project.
Restore Project
Restores a Supabase project.
List Tables
Lists all tables in one or more schemas. By default returns a compact summary. Set verbose to true to include column details, primary keys, and foreign key constraints.
List Extensions
Lists all extensions in the database.
What is Supabase MCP?
The Supabase MCP Server lets your AI agent reach into your Supabase backend to run SQL, list tables and extensions, apply migrations, pull service logs, and deploy edge functions. It gives the agent a safe, structured way to work with your Postgres database, auth, storage, and functions without you leaving the chat. Supabase is a Postgres backend-as-a-service, and the Supabase MCP Server turns that backend into something your agent can operate directly.
If you spend your day switching between the Supabase dashboard, the SQL editor, and your terminal to check a table, trace a bug, or run a migration, that context switching adds up. Instead, with AI agents, you can describe what you need, and your AI agent will find the slow query, list the tables in a schema, or check the security advisors for you, and return the answer where you’re already working.
MCP stands for Model Context Protocol, an open standard that connects AI agents to real tools. The Supabase MCP Server authenticates through a secure OAuth connection by default, so you authorize once instead of copying keys around, and Supabase also supports a personal access token for CI setups. Once connected, you can run SQL, inspect your schema, and deploy functions just by chatting with your AI agent.
Related MCP servers
PostgreSQL MCP Server
Query and manage PostgreSQL databases with schema exploration, SQL execution, and query analysis
Google BigQuery MCP Server
Query and manage BigQuery datasets, tables, and execute SQL
ClickHouse MCP Server
Query ClickHouse Cloud services via SQL, manage services, backups, ClickPipes and costs, and manage ClickStack observability (dashboards, alerts, sources)
Databricks MCP Server
Manage Databricks clusters, jobs, and job runs
Snowflake MCP Server
Interact with Snowflake data warehouse for executing SQL queries, managing tables/databases, and accessing data
Google Sheets MCP Server
Read, write and update your Google Sheets
What you can do with Supabase MCP on Gumloop
Run SQL against your database
Ask your agent to execute execute_sql queries to pull, filter, and shape data across your Postgres tables and return the results in plain language.
Explore tables, extensions, and schema
Have your agent list every table, check installed Postgres extensions, and generate TypeScript types straight from your live schema.
Apply and track migrations
Tell your agent to list existing migrations and apply a new one so your schema changes stay version controlled.
Debug with logs and advisors
Ask for service logs across API, Postgres, Auth, Storage, Realtime, and Edge Functions, and pull the security and performance advisors to catch issues early.
Deploy and inspect edge functions
Have your agent list your edge functions, read a specific function, and deploy a new one without opening the CLI.
Manage projects and organizations
Ask your agent to list projects, get project details and API URLs, fetch publishable keys, and handle organization and cost information when you run in account mode.
Work with database branches
On a paid plan, direct your agent to create, list, merge, reset, or rebase experimental branches so you can test schema changes safely.
Search the Supabase docs
Ask a question and let your agent pull the answer from official Supabase documentation with search_docs.
How to connect the Gumloop Supabase MCP Server
- 1
Create a Gumloop account
Sign up at gumloop.com. Every new account starts with a 14-day free trial.
- 2
Add the Supabase MCP server
Copy your MCP server URL from Gumloop and add it to your preferred client (Claude, Cursor, or Gumloop workflows). You'll authorize on first use.
- 3
Start using Supabase in your AI workflows
That's it. Your AI agent can now query a table, run a migration, or deploy an edge function on your behalf. Use it inside a Gumloop automation, in Claude Desktop, or in Cursor.
Supabase MCP use cases
Ship features faster as a full-stack developer with Supabase MCP
Ask your agent to draft and apply a migration, generate fresh TypeScript types from the new schema, and confirm the change with a quick query, all before you switch back to your editor.
Debug production issues as a backend engineer with Supabase MCP
When something breaks, tell your agent to pull the recent Postgres and Edge Function logs, run the security and performance advisors, and surface the query that is dragging response times down.
Explore data as a data analyst with Supabase MCP
Ask questions in plain language and let your agent translate them into SQL, list the relevant tables first, and return clean results you can act on, with read-only mode on so nothing changes.
Manage environments as a platform engineer with Supabase MCP
Have your agent list projects and organizations, check project URLs and keys, review cost details, and spin up experimental branches to test schema changes before they reach main.
Onboard to a new codebase as a new engineer with Supabase MCP
Ask your agent to map out the schema, list tables and extensions, search the Supabase docs for anything unfamiliar, and explain how the pieces fit together so you get productive on day one.
Why use Gumloop for Supabase MCP
Skip the setup friction
Authorize your Supabase account once through a secure OAuth connection and Gumloop stores it safely. No env vars, token juggling, or coding against the Supabase API necessary.
Use it from your favorite client
Connect the Supabase MCP Server through Gumloop, Claude, or Cursor and work the way you already do.
Chain Supabase into bigger agents
Chain Supabase with any other MCP integrations in a single agent, so your agent can query the database, then post to Slack, update a sheet, or open a ticket in one flow.
Enterprise-grade and transparent
Gumloop is built for teams that care about security and reliability, and you can review our posture at trust.gumloop.com.
Start with a free trial
Gumloop offers a 14-day free trial with access to MCP integrations, including Supabase. Paid pricing starts at $37/month.
Frequently asked questions
Ship Supabase agents in minutes
Connect any AI agent to 100+ MCP servers, zero setup.