row-level-security
CommunitySecure PostgreSQL data access.
Authordadbodgeoff
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill implements robust database-level data isolation for multi-tenant applications, ensuring users can only access their own data and preventing data leaks.
Core Features & Use Cases
- Database-Level Enforcement: Enforces data access policies directly within PostgreSQL, making them impossible to bypass at the application level.
- User-Based Policies: Restricts data visibility, insertion, updates, and deletions based on the logged-in user's ID.
- Organization-Based Multi-Tenancy: Isolates data across different organizations, ensuring users only see data relevant to their organization.
- Role-Based Access Control: Defines granular permissions (viewer, editor, admin) for users within organizations.
- Use Case: In a SaaS application where each company has its own set of projects, RLS ensures that users from Company A cannot view or modify projects belonging to Company B.
Quick Start
Enable Row Level Security on your 'projects' table and create a policy allowing users to view only their own projects.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: row-level-security Download link: https://github.com/dadbodgeoff/drift/archive/main.zip#row-level-security Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.