Functionality with Self Hosted Supabase Instances (non-local[?]).

[rootacc3ss]

Feature request

Describe the solution you'd like

Functionality to connect with self-hosted instances of Supabase that are out of network, non-local instances. My case is I need to push updates to a database on my dedicated Supabase server that is not in my network.

Looking at the documentation for selfhosted Supabase docs it looks like it is definitely possible, one way or another.

Additional context

@gregnr had mentioned https://supabase.com/docs/guides/getting-started/mcp#mcp-for-local-supabase-instances ; this does not fit my usecase, it doesn't seem. Maybe I could run Cursor and the MCP on my server and make it local (or use a VPN), but I need to connect to a selfhosted instance on an entirely network. This is a dedicated server for Supabase ONLY, nothing else runs on it.

[gregnr]

Hey @rootacc3ss, assuming the Postgres server within your self hosted Supabase instance is accessible, you can still use the Postgres MCP server to connect to it remotely. If you can share some more information about your self hosted setup I can help point you in the right direction.

[HenkDz]

I have created this and was super useful when I needed to migrate or do other operations to my VPS Hosted Supabase.
https://github.com/HenkDz/postgresql-mcp-server
use this till we get a supabase specific one.

[rootacc3ss]

Hey @rootacc3ss, assuming the Postgres server within your self hosted Supabase instance is accessible, you can still use the Postgres MCP server to connect to it remotely. If you can share some more information about your self hosted setup I can help point you in the right direction.

Hey @gregnr! Thanks for your response and temporary fix. I do really like this idea, but I am hosting multiple projects on my Supabase instance and need the ability like we currently have in this MCP server to bounce back and fourth with a prompt (your MCP for Supabase can easily do this). That MCP is missing some specific tools that are important

I have downloaded the latest of this Supabase MCP and made my own private repository for testing implementations for this problem. If you have any suggestions, I am all ears. I would be willing to either make it open source or help integrate it over here.

Thank you!

[rootacc3ss]

I have created this and was super useful when I needed to migrate or do other operations to my VPS Hosted Supabase. https://github.com/HenkDz/postgresql-mcp-server use this till we get a supabase specific one.

Wow @HenkDz! This is an amazing tool. It isn't a total solution for me, but I will absolutely be using this on my other pSQL deployments. Please, get this listed on Awesome MCP Servers and MCP.so! Would've saved me a lot of time

[HenkDz]

I have created this and was super useful when I needed to migrate or do other operations to my VPS Hosted Supabase. https://github.com/HenkDz/postgresql-mcp-server use this till we get a supabase specific one.

Wow @HenkDz! This is an amazing tool. It isn't a total solution for me, but I will absolutely be using this on my other pSQL deployments. Please, get this listed on Awesome MCP Servers and MCP.so! Would've saved me a lot of time

I have just built this yesterday since no one did it for some reason:
https://github.com/HenkDz/selfhosted-supabase-mcp

[rootacc3ss]

I have created this and was super useful when I needed to migrate or do other operations to my VPS Hosted Supabase. https://github.com/HenkDz/postgresql-mcp-server use this till we get a supabase specific one.

Wow @HenkDz! This is an amazing tool. It isn't a total solution for me, but I will absolutely be using this on my other pSQL deployments. Please, get this listed on Awesome MCP Servers and MCP.so! Would've saved me a lot of time

I have just built this yesterday since no one did it for some reason:
https://github.com/HenkDz/selfhosted-supabase-mcp

WOW! beat me to it, amazing! i'll give it a try, thank you so much @HenkDz! @gregnr, you should audit this and maybe push this as a change in the official repo with him!

[rootacc3ss]

I have created this and was super useful when I needed to migrate or do other operations to my VPS Hosted Supabase. https://github.com/HenkDz/postgresql-mcp-server use this till we get a supabase specific one.

Wow @HenkDz! This is an amazing tool. It isn't a total solution for me, but I will absolutely be using this on my other pSQL deployments. Please, get this listed on Awesome MCP Servers and MCP.so! Would've saved me a lot of time

I have just built this yesterday since no one did it for some reason:
https://github.com/HenkDz/selfhosted-supabase-mcp

WOW! beat me to it, amazing! i'll give it a try, thank you so much @HenkDz! @gregnr, you should audit this and maybe push this as a change in the official repo with him!

@gregnr still waiting to test this out as i haven't had time to look through the code and audit it. still urging you or a maintainer to make this a main functionality in the mcp as the lovely user above has shown it is possible <3