The table your coding agent created does not have row level security on it.
Dashboard-created tables get row level security by default now. API-created tables do not, and API is how your coding agent works.
- Research
- UpGuard, dated 1 October 2026
- Scanned
- About 300,000 domains with indicators of Supabase usage
- Found
- 16,326 databases exposing readable tables
- PII
- Over half showed indicators of some PII
- Named cause
- Tables created through the API do not enable RLS by default
- Not a product flaw
- UpGuard attributes exposure to application-side configuration
What the research says, and what it does not
UpGuard published a census rather than an incident report. It says it "gathered ~300,000 unique domains with indicators of Supabase usage" and, across that candidate set, "identified 16,326 databases exposing readable tables". Over half showed indicators of some PII, and a smaller share included passwords or authentication tokens.
It is worth being precise about whose problem this is, because the aggregator headlines were not. UpGuard attributes the exposure to how application owners configured their own projects, not to a flaw in Supabase. It also credits Supabase with having "made product changes to implement RLS by default for tables created in the Table Editor UI". Supabase's chief information security officer told TechCrunch that the company provides "secure defaults and tooling, and customers control how their own projects are configured".
So this is not a breach of Supabase, and nobody should read it that way. It is a measurement of how often a particular configuration mistake occurs in the wild, and the number is large enough to be worth ten minutes of your time.
The specific gap
The sentence in the research that should make you check your own projects is this one: "Tables created programmatically through the API, which is how coding agents interact with Supabase, do not enable RLS by default."
Read that twice. Supabase closed this for tables you create by hand in the dashboard. It remains open for tables created through the API. And creating tables through the API is exactly what happens when you ask a coding agent to add a feature that needs a new table.
That produces an uncomfortable asymmetry: the tables you made deliberately, while thinking about the schema, are protected. The tables that appeared because you asked for a feature, which you may not have reviewed line by line, are not. The second category is growing much faster than the first.
UpGuard names two further causes worth checking at the same time: policies that exist but do not adequately restrict access, and public keys used in client-side code as though they were secret keys.
RLS enabled is not the same as protected
There are three states, and only one of them is safe. Teams routinely confuse the middle one with the last.
Row level security disabled means the table is readable by whatever role reaches it. Row level security enabled with no policy means Postgres denies everything, which is safe but usually means the feature is quietly broken rather than correctly locked down. Row level security enabled with a policy that correctly scopes rows to the requesting user is the state you want.
The failure mode that produces exposure is a fourth case: RLS enabled with a policy that looks restrictive but is not, for example one that checks that a user is authenticated without checking that the row belongs to them. Every authenticated user, including one who just signed themselves up, then reads everything.
So an audit that only asks "is RLS on" will give you a clean bill of health you have not earned. You need to look at the policies.
The audit
Run this against every project, including the staging one and the prototype nobody uses, because exposure does not care how seriously you take the environment.
- List every table in the public schema with its RLS state, by querying pg_class joined to pg_namespace for relname and relrowsecurity where nspname is public
- For every table where RLS is off, decide whether it should be exposed at all, then either enable RLS with a policy or remove it from the API surface
- For every table where RLS is on, read the policy and confirm it scopes rows to the requesting user, not merely to any authenticated user
- Pay particular attention to tables you did not create by hand. Check your migration history for tables added by an agent or a code generator
- Grep your web bundles and mobile builds for a service_role key. The anon key is designed to be public. The service role key bypasses RLS entirely, and if it shipped to clients, rotate it
- Check your Supabase logs for high-volume anonymous reads against tables holding user records, which is what exploitation looks like
One more thing lands on 30 October
There is a related change already scheduled, and it will turn some of these quiet exposures into loud breakages. Supabase has said that new tables in the public schema will no longer be exposed to the Data API by default, "enforced on all projects on 2026-10-30". The dashboard control is called "Automatically expose new tables and functions".
Crucially, the mechanism is grants rather than RLS. The changelog is explicit: "Without an explicit GRANT, a role will not have access to the created table." That means a migration which creates a table and enables RLS and adds a policy, which is the responsible thing to do, will still produce a table your client cannot read after 30 October unless you also grant.
The failure will present as an empty result rather than a permissions error, which is the worst kind. Add the grant statements to your migration boilerplate now, alongside the RLS and policy statements, and if you create tables at runtime, that code path needs an explicit exposure step.
The underlying lesson about agents and schemas
This is not really a story about Supabase. It is a story about what happens when the thing that writes your schema is not the thing that thinks about your threat model.
A coding agent asked to add a feature will create the table the feature needs, and it will be right about the columns. Whether that table should be readable by an unauthenticated visitor is not a question the feature request contains, so it does not get answered.
The durable fix is to make the safe thing the default in your own repository rather than relying on remembering: a migration template that includes RLS, a policy and a grant; a test that fails if any table in the public schema has RLS disabled; a review step on schema changes specifically. Any of those three turns this from a recurring risk into a solved one.
What to do
- 1Query pg_class for relrowsecurity across the public schema in every project, including staging and prototypes.
- 2Read the policies, not just the RLS flag. A policy that only checks authentication exposes every row to every signed-up user.
- 3Check which tables were created by an agent or code generator rather than by hand.
- 4Grep client bundles and mobile builds for a service_role key, and rotate it if you find one.
- 5Add GRANT statements to your migration template before the 30 October Data API change.
- 6Add a test that fails when any public-schema table has RLS disabled, so this stays fixed.
Common questions
Was Supabase breached?
No. UpGuard published research measuring how many Supabase-backed applications expose readable tables, and attributes the exposure to application-side configuration rather than a Supabase product flaw. It credits Supabase with having enabled RLS by default for tables created in the Table Editor UI.
Why do agent-created tables lack row level security?
UpGuard notes that tables created programmatically through the API do not enable RLS by default, and that the API is how coding agents interact with Supabase. The default applies to tables created in the dashboard Table Editor.
Is enabling RLS enough?
No. RLS with no policy denies everything, which usually means a broken feature. RLS with a policy that only checks that the requester is authenticated exposes every row to any user who signs up. The policy has to scope rows to the requesting user.
Is the anon key meant to be public?
Yes, the anon key is designed to be used in client code and is protected by row level security. The service_role key bypasses RLS and must never ship to a client. If it has, rotate it.
What changes on 30 October 2026?
Supabase will stop exposing new public-schema tables to the Data API by default on all projects. The mechanism is grants, not RLS: without an explicit GRANT a role has no access, so migrations need grant statements alongside their RLS and policy statements.
How would I know if a table was read?
Check Supabase logs for high-volume anonymous reads against tables holding user records. Exposure through a missing policy looks like ordinary API traffic, not like an attack.
Sources
- UpGuard: systemic data exposure in Supabase apps
- Supabase changelog: tables not exposed to the Data API automatically
Read against the primary documentation rather than secondary coverage. Where a figure comes from a provider's own docs, it is quoted as published on 2026-10-02.
Related
More from Signals
Open the tool.
Ten production categories, three minutes, and a ranked list of what to fix first.
Check your own stack