Supabase access rules and React front ends
Freelance work for teams building with React, TypeScript and Supabase.
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. 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. 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.
- Check. A schema-only dump is enough. You get the report and the fix plan.
- 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.