Self-host access to the MCP on Supabase ?

[goldwizardcode]

Hello, I would like to know how to connect my Supabase self-hosted instance with the MCP. Can you provide me with the necessary steps or documentation for this integration? Thanks in advance.

I noticed that the “Connect” feature for connecting the MCP is available on the hosted version of Supabase, but does not appear on the self-hosted version. Could you tell me if this functionality is intended for self-hosting or if there is an alternative method of connecting the MCP?

Personally, I have the Supabase version installed on Coolify.

Do you know how I can get the MCP for my Supabase? 🙂 Please

[daraeowl]

if anyone got info on this I would really appreciate it

[DwareLab]

The open source version of supabase is a joke. They just do it for the name and to make people feel like they have the control. Most of the developers are trapped.

[adlternative]

The lack of unified API documentation between open-source and commercial versions is a terrible developer experience.

[Daraujo26]

Circling back to this and checked back. It seems that they have added support for MCPs to supabase cli which is pretty great because I can just pull my schema and data from my production self-hosted version.

supabase cli - v2.48.3

MCP option shows

I use cursor

and it works

Not sure if this is helpful to anyone, but i'll definitely be using this

[adlternative]

Circling back to this and checked back. It seems that they have added support for MCPs to supabase cli which is pretty great because I can just pull my schema and data from my production self-hosted version.

supabase cli - v2.48.3

MCP option shows I use cursor and it works Not sure if this is helpful to anyone, but i'll definitely be using this

Hi, do you add some authentication headers? like "Authorization: ${SERVICE_ROLE_KEY}"? I've tried several different authentication methods, but I still can't connect.

[Daraujo26]

Circling back to this and checked back. It seems that they have added support for MCPs to supabase cli which is pretty great because I can just pull my schema and data from my production self-hosted version.
supabase cli - v2.48.3

MCP option shows

I use cursor

and it works

Not sure if this is helpful to anyone, but i'll definitely be using this

Hi, do you add some authentication headers? like "Authorization: ${SERVICE_ROLE_KEY}"? I've tried several different authentication methods, but I still can't connect.

No I don't have any. I think with supabase cli it uses its own local creds with a privileged direct connection (at 127.0.0.1:54321) so I'm able to even query tables like auth.users

[aantti]

There have been some updates to this. First, the MCP server has been largely switching to the "remote MCP" option, with dynamic client registration. The PAT-based auth is being phased out. Secondly, yes, it is available for CLI/local-development. Last but not least, I've just added some instructions on how to enable it safely for self-hosted Supabase. Sadly, outside of the managed platform it doesn't come with OAuth 2.1 yet, so you have to make extra care to not expose it to the Internet.

More here:

• https://supabase.com/docs/guides/self-hosting/enable-mcp (make sure to update volumes/api/kong.yml first)

Related:

• https://supabase.com/docs/guides/getting-started/mcp
• https://github.com/supabase-community/supabase-mcp