test-rls

Execute Row-Level Security integration tests to verify tenant data isolation.

Updated Feb 10, 2026

Search Tags:#testing #security #database #integration tests #rls #tenant isolation

Ready to run

npx skills add https://github.com/wordshepherd/colophony --skill test-rls

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: test-rls
Source: https://github.com/wordshepherd/colophony/tree/main/.claude/skills/test-rls
Command: npx skills add https://github.com/wordshepherd/colophony --skill test-rls

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires @colophony/api.

What problem does it solve?

This Skill ensures that sensitive data is correctly isolated between different tenants (organizations) in the system, preventing unauthorized data access and maintaining security.

Core Features & Use Cases

Row-Level Security (RLS) Testing: Executes integration tests specifically designed to validate RLS policies.
Tenant Isolation Verification: Confirms that users from one organization cannot access or modify data belonging to another.
Use Case: Before deploying a new feature that modifies data access, run this skill to guarantee that existing tenant data segregation remains intact and no security vulnerabilities are introduced.

Quick Start

Run the RLS integration tests to verify tenant isolation.

Frequently Asked Questions about test-rls

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I test row-level security policies for tenant isolation?▼

To test row-level security for tenant isolation, execute integration tests that validate users from one organization cannot access or modify data belonging to another, confirming your RLS policies are correctly applied to all tenant tables.

How do I verify that users cannot access data from another organization?▼

You verify users cannot access another organization's data by running RLS integration tests that attempt cross-tenant data access and creation. These tests confirm your database security policies successfully block unauthorized queries and modifications across tenants.

Do I need to set up a test database before validating RLS policies?▼

Yes, you need a correctly set up test database with RLS policies applied to all tenant tables before validating. This environment is required to accurately execute integration tests and confirm tenant data isolation without affecting production data.

What is tenant data isolation in database security?▼

Tenant data isolation in database security ensures sensitive data is correctly segregated between different organizations. It prevents unauthorized data access by enforcing that users in one tenant cannot access or create data belonging to another tenant.