<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Solvion</title>
    <description>The latest articles on DEV Community by Solvion (@solvionsolutions).</description>
    <link>https://dev.to/solvionsolutions</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3906210%2F8c40fa1b-3898-463a-b271-bc56a3d7ec92.png</url>
      <title>DEV Community: Solvion</title>
      <link>https://dev.to/solvionsolutions</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/solvionsolutions"/>
    <language>en</language>
    <item>
      <title>We read the SQL of 844 Supabase apps. Here's what we found</title>
      <dc:creator>Solvion</dc:creator>
      <pubDate>Sun, 22 Nov 2026 00:10:37 +0000</pubDate>
      <link>https://dev.to/solvionsolutions/we-read-the-sql-of-844-supabase-apps-heres-what-we-found-38hp</link>
      <guid>https://dev.to/solvionsolutions/we-read-the-sql-of-844-supabase-apps-heres-what-we-found-38hp</guid>
      <description>&lt;p&gt;&lt;em&gt;Originally published on &lt;a href="https://www.guardlayer.io/blog/supabase-security-study-2026" rel="noopener noreferrer"&gt;guardlayer.io&lt;/a&gt;.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;We read the committed SQL of 844 public Supabase projects in November 2026. 17% create at least one table without turning on row level security. 28% have a policy whose condition is simply &lt;code&gt;true&lt;/code&gt; on a table that is written to or holds personal data. 19% expose a &lt;code&gt;SECURITY DEFINER&lt;/code&gt; function that the API roles can call and that never checks who is calling. 12% let a user give themselves more rights, most often by editing their own &lt;code&gt;role&lt;/code&gt; or plan. Half the projects have at least one of these patterns.&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;None of this is a flaw in Supabase. Every pattern below is a project setting, and each has a fix of a few lines. We publish the numbers because the same few mistakes keep coming back, and they are easier to avoid once you know what they look like.&lt;/p&gt;

&lt;h2&gt;
  
  
  How we did it
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;What we read:&lt;/strong&gt; public GitHub repositories of Supabase apps, found through GitHub searches across app categories (bookings, clinics, shops, schools, dating, internal tools) and languages. We kept the 844 that commit SQL: migrations, a &lt;code&gt;schema.sql&lt;/code&gt; or a &lt;code&gt;pg_dump&lt;/code&gt; snapshot.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;How we read it:&lt;/strong&gt; each project's SQL was run through GuardLayer's static scanner (the same engine as the product), with all files read together in order. A table that gets RLS in a later migration, or a function revoked further down, doesn't count against the project.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;What counts:&lt;/strong&gt; a project counts once per pattern, however many tables or functions match. We count warning and critical findings only. Informational ones, such as a public read on a table of blog posts, aren't counted.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;What we left out:&lt;/strong&gt; public storage buckets (22% of projects). Most are avatars and product images that are meant to be public, and the SQL alone can't tell which ones aren't.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Separately, between November 7 and 18 we checked 50 projects by hand (43 of them are in this sample), traced each problem through the app's own code, and reported it privately to the owners. That's the high-confidence half of this study. The rest of it is what a careful read of the SQL shows, not proof that every match can be exploited.&lt;/p&gt;

&lt;h2&gt;
  
  
  The results
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Pattern&lt;/th&gt;
&lt;th&gt;Projects&lt;/th&gt;
&lt;th&gt;Share&lt;/th&gt;
&lt;th&gt;95% CI&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Policy lets any signed-in user read or change every row&lt;/td&gt;
&lt;td&gt;352&lt;/td&gt;
&lt;td&gt;41.7%&lt;/td&gt;
&lt;td&gt;38.4–45.1%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Policy condition is just &lt;code&gt;true&lt;/code&gt; (write or sensitive table)&lt;/td&gt;
&lt;td&gt;232&lt;/td&gt;
&lt;td&gt;27.5%&lt;/td&gt;
&lt;td&gt;24.6–30.6%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;
&lt;code&gt;SECURITY DEFINER&lt;/code&gt; function the API can call, no caller check&lt;/td&gt;
&lt;td&gt;158&lt;/td&gt;
&lt;td&gt;18.7%&lt;/td&gt;
&lt;td&gt;16.2–21.5%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Table created without RLS&lt;/td&gt;
&lt;td&gt;142&lt;/td&gt;
&lt;td&gt;16.8%&lt;/td&gt;
&lt;td&gt;14.5–19.5%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Users can raise their own rights&lt;/td&gt;
&lt;td&gt;99&lt;/td&gt;
&lt;td&gt;11.7%&lt;/td&gt;
&lt;td&gt;9.7–14.1%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Table granted directly to &lt;code&gt;anon&lt;/code&gt;
&lt;/td&gt;
&lt;td&gt;62&lt;/td&gt;
&lt;td&gt;7.3%&lt;/td&gt;
&lt;td&gt;5.8–9.3%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;strong&gt;At least one of the above, apart from the signed-in row&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;433&lt;/td&gt;
&lt;td&gt;51.3%&lt;/td&gt;
&lt;td&gt;47.9–54.7%&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Size doesn't help. Among the 685 projects with three or more SQL files, the share with at least one of these patterns is slightly higher, 54.6%, than across all 844.&lt;/p&gt;

&lt;h3&gt;
  
  
  1. "Signed in" treated as "allowed"
&lt;/h3&gt;

&lt;p&gt;The most common pattern, in 42% of projects, is a policy like &lt;code&gt;using (auth.role() = 'authenticated')&lt;/code&gt; or &lt;code&gt;to authenticated using (true)&lt;/code&gt; on a table that holds other people's data. It reads as "only logged-in users", but sign-ups on Supabase are open by default, so "logged in" means anyone who has made an account. Some of these are deliberate, like a shared team table in an app with closed sign-ups. Many are not. The fix is to scope the rows: &lt;code&gt;using (user_id = auth.uid())&lt;/code&gt;, or a membership check for team data. More on this in &lt;a href="https://www.guardlayer.io/blog/supabase-row-level-security-complete-guide" rel="noopener noreferrer"&gt;the Supabase RLS guide&lt;/a&gt;.&lt;/p&gt;

&lt;h3&gt;
  
  
  2. Policies that say &lt;code&gt;true&lt;/code&gt;
&lt;/h3&gt;

&lt;p&gt;&lt;code&gt;create policy ... using (true) with check (true)&lt;/code&gt; lets everyone the policy applies to do what it allows, on every row: anyone holding the public anon key, or every signed-in user when it's written &lt;code&gt;to authenticated&lt;/code&gt;. We only count it on tables that are written to or that hold personal data: a &lt;code&gt;profiles&lt;/code&gt; table readable by anyone, emails included, or a table any visitor can update. Not every match is a leak. A public waitlist form is meant to accept inserts from anyone. But this is the pattern behind more of our reports than any other. &lt;a href="https://www.guardlayer.io/blog/supabase-rls-using-true-trap" rel="noopener noreferrer"&gt;Why &lt;code&gt;using (true)&lt;/code&gt; is a trap&lt;/a&gt; covers when it's fine.&lt;/p&gt;

&lt;h3&gt;
  
  
  3. Definer functions anyone can call
&lt;/h3&gt;

&lt;p&gt;A &lt;code&gt;SECURITY DEFINER&lt;/code&gt; function runs with its owner's rights and skips RLS. On Supabase, new functions in &lt;code&gt;public&lt;/code&gt; can be executed by &lt;code&gt;anon&lt;/code&gt; and &lt;code&gt;authenticated&lt;/code&gt; by default, so a definer function that takes an id from the caller and never checks &lt;code&gt;auth.uid()&lt;/code&gt; hands that id's data, or that id's write access, to anyone. 19% of projects have at least one. The impact varies a lot: a function that bumps a view counter is a nuisance, one that changes another user's plan is not. A common reason they stay open is that &lt;code&gt;revoke execute ... from public&lt;/code&gt; alone doesn't remove the direct grants to &lt;code&gt;anon&lt;/code&gt; and &lt;code&gt;authenticated&lt;/code&gt;; &lt;a href="https://www.guardlayer.io/blog/supabase-revoke-from-public-case-study" rel="noopener noreferrer"&gt;the Kagelin case study&lt;/a&gt; shows how that plays out.&lt;/p&gt;

&lt;h3&gt;
  
  
  4. Tables without RLS
&lt;/h3&gt;

&lt;p&gt;17% of projects create at least one table and never enable RLS on it anywhere in their SQL. Tables made in the Supabase dashboard get RLS by default; tables made with SQL, which is how AI coding tools make them, don't. Since October 30, 2026 Supabase no longer grants brand-new tables to the API roles automatically, which closes this for new projects. Older projects keep the automatic grants, and the usual fix for the resulting &lt;code&gt;permission denied&lt;/code&gt; error is a &lt;code&gt;grant&lt;/code&gt;, which reopens the table. See &lt;a href="https://www.guardlayer.io/blog/supabase-data-api-grant-2026" rel="noopener noreferrer"&gt;what changed with the Data API grants&lt;/a&gt;.&lt;/p&gt;

&lt;h3&gt;
  
  
  5. Users who can raise their own rights
&lt;/h3&gt;

&lt;p&gt;This is the most damaging pattern, in 12% of projects, and the hardest to see, because the policy looks right. Three variants:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Editing their own role or plan (8.6%).&lt;/strong&gt; &lt;code&gt;create policy ... for update using (auth.uid() = id)&lt;/code&gt; on &lt;code&gt;profiles&lt;/code&gt;, where the row also holds &lt;code&gt;role&lt;/code&gt;, &lt;code&gt;is_admin&lt;/code&gt;, &lt;code&gt;plan&lt;/code&gt;, &lt;code&gt;credits&lt;/code&gt; or &lt;code&gt;balance&lt;/code&gt;. RLS picks rows, not columns, so the user can set any column on their own row. &lt;a href="https://www.guardlayer.io/blog/vivtrack-free-pro-case-study" rel="noopener noreferrer"&gt;The VivTrack case study&lt;/a&gt; is a real example: any user could give themselves Pro.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Choosing their role at sign-up (1.8%).&lt;/strong&gt; A &lt;code&gt;handle_new_user&lt;/code&gt; trigger that copies &lt;code&gt;raw_user_meta_data-&amp;gt;&amp;gt;'role'&lt;/code&gt; into &lt;code&gt;profiles&lt;/code&gt;. The browser sets that metadata.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Adding themselves to a team (3.0%).&lt;/strong&gt; An insert policy on a &lt;code&gt;*_members&lt;/code&gt; table that only checks &lt;code&gt;user_id = auth.uid()&lt;/code&gt;, so anyone can join any team, often with any role.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;The fix is a column grant (&lt;code&gt;revoke update on public.profiles from authenticated; grant update (display_name, avatar_url) on public.profiles to authenticated;&lt;/code&gt;), a guard trigger, or moving the column to a table only the server writes.&lt;/p&gt;

&lt;h2&gt;
  
  
  What happened when we told people
&lt;/h2&gt;

&lt;p&gt;We reported 50 of these projects privately, with the exact file, line and fix, between November 7 and 18. As of November 21:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;5&lt;/strong&gt; have shipped a fix, the fastest about an hour and a half after the report.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;2&lt;/strong&gt; have confirmed and are fixing.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;2&lt;/strong&gt; have replied and plan to fix.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;2&lt;/strong&gt; made their repository private.&lt;/li&gt;
&lt;li&gt;The rest haven't replied yet. Most reports are less than two weeks old.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;One reply is worth passing on. A team had already fixed the problem in their live database in August, but never committed the migration. Their production database was safe, while a rebuild from the repository would have reopened the hole. If you fix something in the SQL editor, put the same SQL in a migration the same day.&lt;/p&gt;

&lt;p&gt;Three teams let us write up their cases: &lt;a href="https://www.guardlayer.io/blog/supabase-rls-own-row-policy-case-study" rel="noopener noreferrer"&gt;LabStock&lt;/a&gt;, &lt;a href="https://www.guardlayer.io/blog/supabase-revoke-from-public-case-study" rel="noopener noreferrer"&gt;Kagelin&lt;/a&gt; and &lt;a href="https://www.guardlayer.io/blog/vivtrack-free-pro-case-study" rel="noopener noreferrer"&gt;VivTrack&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  Check your own project
&lt;/h2&gt;

&lt;p&gt;Run these in the SQL Editor. Each returns nothing on a project without the pattern.&lt;/p&gt;

&lt;p&gt;Tables in &lt;code&gt;public&lt;/code&gt; with RLS off:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;select&lt;/span&gt; &lt;span class="n"&gt;c&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;relname&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;table_name&lt;/span&gt;
&lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="n"&gt;pg_class&lt;/span&gt; &lt;span class="n"&gt;c&lt;/span&gt;
&lt;span class="k"&gt;join&lt;/span&gt; &lt;span class="n"&gt;pg_namespace&lt;/span&gt; &lt;span class="n"&gt;n&lt;/span&gt; &lt;span class="k"&gt;on&lt;/span&gt; &lt;span class="n"&gt;n&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;oid&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;c&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;relnamespace&lt;/span&gt;
&lt;span class="k"&gt;where&lt;/span&gt; &lt;span class="n"&gt;n&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;nspname&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="s1"&gt;'public'&lt;/span&gt; &lt;span class="k"&gt;and&lt;/span&gt; &lt;span class="n"&gt;c&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;relkind&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="s1"&gt;'r'&lt;/span&gt; &lt;span class="k"&gt;and&lt;/span&gt; &lt;span class="k"&gt;not&lt;/span&gt; &lt;span class="n"&gt;c&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;relrowsecurity&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Policies whose condition is just &lt;code&gt;true&lt;/code&gt;, or that only check for a signed-in user:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;select&lt;/span&gt; &lt;span class="n"&gt;tablename&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;policyname&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;cmd&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;roles&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;qual&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;with_check&lt;/span&gt;
&lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="n"&gt;pg_policies&lt;/span&gt;
&lt;span class="k"&gt;where&lt;/span&gt; &lt;span class="n"&gt;schemaname&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="s1"&gt;'public'&lt;/span&gt;
  &lt;span class="k"&gt;and&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;qual&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="s1"&gt;'true'&lt;/span&gt; &lt;span class="k"&gt;or&lt;/span&gt; &lt;span class="n"&gt;with_check&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="s1"&gt;'true'&lt;/span&gt;
       &lt;span class="k"&gt;or&lt;/span&gt; &lt;span class="n"&gt;qual&lt;/span&gt; &lt;span class="k"&gt;ilike&lt;/span&gt; &lt;span class="s1"&gt;'%auth.role()%authenticated%'&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Definer functions the API roles can run:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;select&lt;/span&gt; &lt;span class="n"&gt;p&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;oid&lt;/span&gt;&lt;span class="o"&gt;::&lt;/span&gt;&lt;span class="n"&gt;regprocedure&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="k"&gt;function&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
       &lt;span class="nf"&gt;has_function_privilege&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s1"&gt;'anon'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;p&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;oid&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'execute'&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;anon_can_run&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
       &lt;span class="nf"&gt;has_function_privilege&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s1"&gt;'authenticated'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;p&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;oid&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'execute'&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;authenticated_can_run&lt;/span&gt;
&lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="n"&gt;pg_proc&lt;/span&gt; &lt;span class="n"&gt;p&lt;/span&gt;
&lt;span class="k"&gt;join&lt;/span&gt; &lt;span class="n"&gt;pg_namespace&lt;/span&gt; &lt;span class="n"&gt;n&lt;/span&gt; &lt;span class="k"&gt;on&lt;/span&gt; &lt;span class="n"&gt;n&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;oid&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;p&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;pronamespace&lt;/span&gt;
&lt;span class="k"&gt;where&lt;/span&gt; &lt;span class="n"&gt;n&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;nspname&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="s1"&gt;'public'&lt;/span&gt; &lt;span class="k"&gt;and&lt;/span&gt; &lt;span class="n"&gt;p&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;prosecdef&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Update policies on tables that hold a role, plan or balance are in the self-check of &lt;a href="https://www.guardlayer.io/blog/vivtrack-free-pro-case-study" rel="noopener noreferrer"&gt;the VivTrack case study&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  Does GuardLayer catch this?
&lt;/h2&gt;

&lt;p&gt;Yes. Every number in this study comes from GuardLayer's scanner, so the code scan flags each of these patterns in your migrations on every push, with the file, the line and the fix. &lt;a href="https://www.guardlayer.io/check-supabase" rel="noopener noreferrer"&gt;Live check&lt;/a&gt; connects to the running project read-only and checks the real policies, grants and functions, which also covers anything you changed in the dashboard and never committed.&lt;/p&gt;

&lt;h2&gt;
  
  
  Limits
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;It's a sample, not a census.&lt;/strong&gt; Public repositories that commit their SQL lean towards solo developers, side projects and AI-built apps. The rates are not a measure of all Supabase projects.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;SQL isn't the whole picture.&lt;/strong&gt; A project can enable RLS or revoke a grant in the dashboard without committing it, which would make a finding here a false alarm, and the reverse is just as possible.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;A pattern isn't always a leak.&lt;/strong&gt; Some matches are deliberate. We counted them anyway, because the SQL can't tell intent, and said where that matters most.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Is Supabase insecure?&lt;/strong&gt;&lt;br&gt;
No. Supabase gives you RLS, grants and per-function permissions. Every pattern here is a project setting. See &lt;a href="https://www.guardlayer.io/blog/is-supabase-secure" rel="noopener noreferrer"&gt;is Supabase secure?&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;What's the most common Supabase security mistake?&lt;/strong&gt;&lt;br&gt;
In this sample, a policy that treats any signed-in user as allowed (42% of projects). The most damaging is letting users edit their own role or plan.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Why did you leave public buckets out?&lt;/strong&gt;&lt;br&gt;
Most are meant to be public (avatars, product images), and the SQL can't tell which aren't.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Can I get the data?&lt;/strong&gt;&lt;br&gt;
The aggregated numbers are in this post. We don't publish per-project results, because many of the issues are still open.&lt;/p&gt;

</description>
      <category>supabase</category>
      <category>security</category>
      <category>postgres</category>
      <category>webdev</category>
    </item>
    <item>
      <title>giving out free trials - competitive intelligence for founders</title>
      <dc:creator>Solvion</dc:creator>
      <pubDate>Thu, 30 Apr 2026 13:32:42 +0000</pubDate>
      <link>https://dev.to/solvionsolutions/giving-out-free-trials-competitive-intelligence-for-founders-1ial</link>
      <guid>https://dev.to/solvionsolutions/giving-out-free-trials-competitive-intelligence-for-founders-1ial</guid>
      <description>&lt;p&gt;just launched an MVP; Electa Labs - competitive intelligence for founders&lt;/p&gt;

&lt;p&gt;been manually tracking markets for months across crunchbase, job boards, &lt;br&gt;
github, linkedin... it was taking 2+ hours a week and i was still missing things. &lt;/p&gt;

&lt;p&gt;so i built it and now want to test the market. the dashboard tracks funding announcements, hirings, market signals, github activity, executive moves, product launches - then gives you a 60-second briefing every morning with what actually changed in the markets&lt;/p&gt;

&lt;p&gt;free 30-day trial: &lt;a href="https://electalabs.com/trial" rel="noopener noreferrer"&gt;https://electalabs.com/trial&lt;/a&gt;&lt;br&gt;
CODE: FOUNDER30&lt;/p&gt;

&lt;p&gt;honest question: what market signals matter most to you?&lt;/p&gt;

</description>
      <category>ai</category>
      <category>react</category>
      <category>startup</category>
      <category>learning</category>
    </item>
  </channel>
</rss>
