Supabase MCP 0.45.14

[pshushereba]

Hello all,

I’ve been trying to get Supabase MCP set up in my Cursor IDE. I’m on version 0.45.14 (I hesitate to update because I’ve been seeing all the chaos around 0.46.x)

I’ve followed the directions on the Supabase website:

Model context protocol (MCP) | Supabase Docs

My mcp.json file is setup as follows:

{
  "mcpServers": {
    "supabase": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://postgres.rxkrlohgdflnlryurbsk:[PASSWORD]@aws-0-us-east-1.pooler.supabase.com:5432/postgres"
      ]
    }
  }
}

But a connection isn’t being established. When I view the Cursor settings I don’t see any MCP connections. I’ve tried restarting Cursor a number of times. I asked Claude 3.7 thinking and it tried running the server in a separate terminal. But even then I can’t get any confirmation that it’s connected to Cursor.

How can I go about getting it set up so that Cursor can pick it up in the settings and I can try it out in Composer?

[Nickhug]

MCP is not a cursor issue, as the “MCP” feature works as anticipated here. MCPs are developed and maintained by other, external developers. Go look at a github readme.md and you will have better luck than asking here. Good luck, my friend.

[pshushereba]

I followed the docs from Supabase specifically that I linked. There’s only 4 steps.

This step: “You should see a green active status after the server is successfully connected” is not working. Supabase can’t tell me why Cursor isn’t picking up the server that I added. So I think this is the appropriate forum for the question. Or am I missing something?

[pshushereba]

I’m not having a hard time reading. Your suggestion isn’t addressing anything I’ve outlined. As I mentioned, I’ve followed the directions from the Supabase docs exactly. I can’t imagine there is a more authoritative source. In this case, “Go look at a github readme.md” would not benefit me more than what I’ve already done.

I’m simply asking to see if anyone has encountered a similar issue trying to set up Supabase MCP. The implementation is not hard and while it’s possible I’ve made a mistake somewhere, it doesn’t seem like that is the case.

[colesmcintosh]

Maybe it’s the location of mcp.json? Is it in the correct path?

[pshushereba]

I think it’s in the right spot. It should be fine that it’s next to my rules folder correct?

[derek-opdee]

If you’re trying to connect the MCP server within your Cursor install, I recommend to instead set up Supabase CLI(command line interface) and then create a rule for Cursor to use it.

The CLI is better than using the API or the MCP and it just works.

Link to the docs to install it on your computer (which is needed before cursor can use it) Supabase CLI | Supabase Docs

Then what I recommend doing is adding this link to your project docs CLI Reference | Supabase Docs

When you have added that link to the project docs, then reference it and ask the agent to create an extensive rule in .cursor/rules with an alwaysApply: true with the correct cli commands for accessing the database, edge functions, storage, authentication, secrets, and to view logs.

All shell commands for the agent that is reference Supabase for information should now start with supabase (command) --(flag). If you ever see the agent using npx supabase, stop the agent chat, and tell it to use supabase CLI, and then the shell command should then go back to using just suapbase.

[fusiondev]

I ran into the same issue. Make sure the password you entered is properly escaped; that was the issue for me. It was the password part. Remove the square brackets, and ensure your database password is correct. That’s probably what’s preventing it from working.

[fusiondev]

Hey is the project specific one in the project root directory? I stuck mine in cursor>rules>mc like this

[fusiondev]

i have two servers here for two different projects is this correct?

[Nickhug]

Smithery(dot)ai should help.

[Billy_Chai]

I am wondering, do “no resources available” means working Supabase MCP?

[T1000]

You got one global mcp.json Supabase (disabled) and one project based mcp.json (enabled) as the screenshot says. check out the docu Cursor – Model Context Protocol

DIdnt test all but saw that users can get project based mcp easier to work per forum here. Might be same for global mcp.

[fusiondev]

I must have got mixed up as I need two project mcp’s, seems they removed the delete icon.

[T1000]

delete icon is on the right side in your screenshot.

if you have trouble connecting sometimes a refresh (icon) helps.

[Ellisvelandia]

doesn’t work

[Billy_Chai]

Can you kindly share the json code, hide the password

[colesmcintosh]

Try move mcp.json one folder higher, right now the path is .cursor/rules/mcp.json and it needs to be .cursor/mcp.json per the docs