A friendly playground for building and validating InsForge Row-Level Security (RLS). It includes real-world examples, migrations, and a comprehensive test suite you can run locally.
Built with insforge-test — an InsForge-optimized version of pgsql-test for instant, isolated Postgres test databases with automatic rollbacks and InsForge defaults.
docker-compose up -d
pnpm install
make roles
cd packages/hello-world
pnpm test:watchNote: Unlike Supabase (where
supabase startpre-creates roles), the InsForge Docker image is vanilla Postgres.make rolesrunspgpm admin-users bootstrapto create theanon,authenticated, andproject_adminNOLOGIN roles before seeding test users.
InsForge uses three built-in PostgreSQL roles:
| Role | Description | Use Case |
|---|---|---|
anon |
Unauthenticated users | Public read access |
authenticated |
Logged-in users | Standard user operations |
project_admin |
System administrators | Full access to all resources |
These roles are mapped in pgpm.json and used by insforge-test for RLS testing.
Built by Constructive — creators of modular Postgres tooling for secure, composable backends. If you like our work, contribute on GitHub.
AS DESCRIBED IN THE LICENSES, THE SOFTWARE IS PROVIDED "AS IS", AT YOUR OWN RISK, AND WITHOUT WARRANTIES OF ANY KIND.
No developer or entity involved in creating this software will be liable for any claims or damages whatsoever associated with your use, inability to use, or your interaction with other users of the code, including any direct, indirect, incidental, special, exemplary, punitive or consequential damages, or loss of profits, cryptocurrencies, tokens, or anything else of value.