Supabase access rules and React front ends

Freelance work for teams building with React, TypeScript and Supabase.

  1. 1. Access rules check

    I test your tables as every role. You get a written report of what leaks and a plan to fix it. Up to 5 tables, 3 days.

  2. 2. Permissions implementation

    Two sizes:

    • Fix and test. I write or fix the RLS rules for 2–3 roles on up to 8 tables, with pgTAP tests proving each role sees and changes only what it should. 7 days.
    • Permission system. Roles, organisations, and a page where your admins change permissions themselves, capped so no one grants more than a role allows. Built in React and TypeScript. Tests run on every push. 21 days.

    Both include a plain-English access matrix with the test results.

    GradeBook’s rules and tests are this work, written by hand. At Sigma Software I led the move from per-user permissions to group-based access: database schema, APIs and admin UI.

  3. 3. React front end for data-heavy apps

    Tables, bulk editing and admin screens: built from scratch, or made fast when they’re slow.

    At Sigma Software, switching a data grid of 20–30 rows by 20+ columns into edit mode took about 10 seconds. I got it under 1 second. I also built a bulk-edit table with server-side filtering and sorting on JSON fields in PostgreSQL.

How it works: check, then fix

Scope and price are fixed before I start.

  1. Check. A schema-only dump is enough. You get the report and the fix plan.
  2. Fix. I work on a local copy or a staging project and hand you migrations, tests and the access matrix.
  • I split the work into small milestones with clear deliverables.
  • You see progress regularly: short updates and demos, not silence until the deadline.
  • You get readable code and a short handover, so another developer can pick it up. You’re never locked in.

What the permission work doesn’t cover

  • I don’t need your live data. Your production database stays untouched. I’ll sign an NDA.
  • I cover one layer: who can read and change which rows in your tables, views and functions. Storage buckets are not included.
  • This isn’t a certification. You get an access matrix and test results to show an auditor.

Questions

Will turning on RLS break my app?
The tests prove each role gets exactly the access we agreed on. If any of your app’s queries relied on the old, open access, I list them before you apply anything, so nothing changes without your say.
Do I need to know SQL to maintain this?
No. The access matrix explains who can do what in plain English, and the tests run with one command. If you add a table later, it shows which pattern to copy.

Working hours

I’m in Tashkent (UTC+5). I take calls until 22:00 my time (17:00 UTC). That’s until 12:00 on the US East Coast and gives a full overlap with Europe.

Looking for someone long-term instead? Here is my CV.

Prefer to order through Upwork? The same packages are listed there.