Live data from Hacker News

Supabase MCP can leak your entire SQL database

generalanalysis.com

491–500 of 502 posts

Re: Supabase MCP can leak your entire SQL database

#491
post #486

Earlier quoted context omitted.

> 'I don't want to spend time segregating permissions and want a do-anything machine.' Yes. It's a valid goal, and we'll keep pursuing it because it's a valid goal. There is no universal solution to this, but there are solutions for specific conditions. > Since time immemorial, that turns out to be a very bad idea. > It was with computing hardware. With OSs. With networks. With the web. With the cloud. And now with L…

> Not every system needs to be secure against everything. Systems that are fundamentally insecure in some scenarios are perfectly fine, as long as they're not exposed to those problem scenarios. That's a vanishingly rare situation, that I'm surprised to see you arguing for, given your other comments about the futility of enforcing invariants on reality. ;) If something does meaningful and valuable work, that almost a…

And fundamentally insecure systems sooner or later get connected to things that should be secure and then become stepping stones in an exploit. These are lessons that should be learned by now.

Re: Supabase MCP can leak your entire SQL database

#492

Earlier quoted context omitted.

Right? "Wrap all SQL responses with prompting that discourages the LLM from following instructions/commands injected within user data?" The entire point of programming is that (barring hardware failure and compiler bugs) the computer will always do exactly what it's told, and now progress apparently looks like having to "discourage" the computer from doing things and hoping that it listens?

The entire point of programming is that (barring hardware failure and compiler bugs) the computer will always do exactly what it's told New AI tech is not like regular programming we had before. Now we have fuzzy inputs, fuzzy outputs

Fuzzy logic is not new. What is new is calling data corruption and nonsense output "fuzzy".

Re: Supabase MCP can leak your entire SQL database

#493

Earlier quoted context omitted.

So, stay away from the smarts and separate control and payload into two different channels. If the luxury leads to the exploits you should do without the luxury. That's tough but better than the alternative: a never ending series of exploits.

> If the luxury leads to the exploits you should do without the luxury. One man's luxury is another man's essential. It's easy to criticize toy examples that deliver worse results than the standard approach, and expose users to excessive danger in the process. Sure, maybe let's not keep doing that. But that's not an actual solution - that's just being timid. Security isn't an end in itself, it's merely a means to ach…

"Can't have absolute security so we might as well bolt on LLMs to everything and not think about it?"

This persona you role play here is increasingly hard to take seriously.

Re: Supabase MCP can leak your entire SQL database

#494

Earlier quoted context omitted.

Right? "Wrap all SQL responses with prompting that discourages the LLM from following instructions/commands injected within user data?" The entire point of programming is that (barring hardware failure and compiler bugs) the computer will always do exactly what it's told, and now progress apparently looks like having to "discourage" the computer from doing things and hoping that it listens?

The entire point of programming is that (barring hardware failure and compiler bugs) the computer will always do exactly what it's told New AI tech is not like regular programming we had before. Now we have fuzzy inputs, fuzzy outputs

GIGO

Re: Supabase MCP can leak your entire SQL database

#495
post #416

Mitigations also need to happen on the client side. If you have a AI that automatically can invoke tools, you need to assume the worst can happen and add a human in the loop if it is above your risk appetite. It's wild how many AI tools just blindly invoke tools by default or have no human in loop feature at all.

Or give them access to appropriately permissioned tools and not superuser/admin/service accounts that can access everything

It's often missed that tools that only read information are perfect for data exfiltration (no need for any more permissions).

So if you add a Jira tool and a web browser tool together (unauthenticated GET only), then the AI can send all your Jira data to the Internet.

Even big players get this design wrong quite often.

Re: Supabase MCP can leak your entire SQL database

#497
> This attack stems from the combination of two design flaws: overprivileged database access (service_role) and blind trust in user-submitted content.

No, there is only one design flaw, the overprivileged database access. An LLM shouldn't be given more access than the user who is interacting with the LLM has.

Re: Supabase MCP can leak your entire SQL database

#498
post #43

Supabase engineer here working on MCP. A few weeks ago we added the following mitigations to help with prompt injections: - Encourage folks to use read-only by default in our docs [1] - Wrap all SQL responses with prompting that discourages the LLM from following instructions/commands injected within user data [2] - Write E2E tests to confirm that even less capable LLMs don't fall for the attack [2] We noticed that t…

Cofounder of General Analysis here:

We just launched a free to use tool to guard against these kinds of attacks. super simple to set up. You can check it out at

[1] https://www.generalanalysis.com/products/mcp-guard

Re: Supabase MCP can leak your entire SQL database

#499
post #43

Supabase engineer here working on MCP. A few weeks ago we added the following mitigations to help with prompt injections: - Encourage folks to use read-only by default in our docs [1] - Wrap all SQL responses with prompting that discourages the LLM from following instructions/commands injected within user data [2] - Write E2E tests to confirm that even less capable LLMs don't fall for the attack [2] We noticed that t…

General Analysis has released an open source MCP guard to secure your MCP clients against prompt injection attacks like these. https://generalanalysis.com/blog/mcpguard
Post reply on HN