Skills
.Work. You
Rest

tenant-aware-query-design

Community

Enforce tenant isolation with automatic filters.

Software Engineering#security#multi-tenant#sql#orm#data-isolation#tenant-filtering
Authormarquesfelip
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Ensure all queries against tenant-scoped tables include a tenant_id filter to prevent cross-tenant data access.

Core Features & Use Cases

  • Enforced core rule: Every SELECT, UPDATE, and DELETE on tenant-scoped tables must include a WHERE tenant_id = ?
  • ORM/global scope: Apply tenant filters at the repository/ORM level so developers cannot forget
  • Audit & tests: Provide automated checks and tests to verify tenant isolation in PRs and CI
  • Migration guidance: Strategies to retrofit existing code to enforce tenant scope

Quick Start

Audit your repository to apply a global tenant filter to all queries on tenant-scoped tables.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 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: tenant-aware-query-design
Download link: https://github.com/marquesfelip/agents-and-skills/archive/main.zip#tenant-aware-query-design

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.