# Multi Tenant Guard

> Verifies multi-tenant data isolation in DataPilot. Use proactively when writing database queries, services, or any code that accesses data to ensure tenant_id isolation is correctly implemented. Use when this capability is needed.

- Skill: `tomevault-io/multi-tenant-guard` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add tomevault-io/multi-tenant-guard`
- Raw SKILL.md: https://api.skillmd.com/api/skills/tomevault-io/multi-tenant-guard/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: tomevault-io (https://skillmd.com/u/tomevault-io)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/tomevault-io/multi-tenant-guard

---


# Multi-Tenant Guard — DataPilot

## Règle fondamentale
CHAQUE accès à la base de données DOIT filtrer par `tenant_id`.
Une faille = fuite de données client = mort du produit.

## Checklist à vérifier sur chaque service
```python
# CORRECT
db.query(Dashboard).filter(
    Dashboard.id == id,
    Dashboard.tenant_id == current_user.tenant_id  # ✔️
).first()

# DANGEREUX - ne jamais faire
db.query(Dashboard).filter(Dashboard.id == id).first()  # ❌ pas de tenant check
```

## Commande de vérification
Recherche les queries sans tenant_id :
```bash
grep -r ".query(" backend/app/services/ | grep -v "tenant_id"
```
Si une ligne apparaît → faille potentielle à corriger.

---
> Converted and distributed by [TomeVault](https://tomevault.io/claim/lucaszub) — claim your Tome and manage your conversions.
<!-- tomevault:4.0:skill_md:2026-04-15 -->