multi-tenant-data-partitioner

multi-tenant-data-partitioner is a skill for Claude Code, Codex from codebygarv/Ai-skills. It costs 30 tokens per session (414 once invoked), scanned A, original, MIT.

A guide for choosing how a database stores and separates each customer’s data in a multi-tenant B2B SaaS application. It covers shared databases, separate schemas, and separate databases, plus ways to identify the current customer.

In plain words
What is it for?
Use it to design tenant isolation, route requests to the right data, prevent cross-tenant queries, and choose backup and disaster-recovery arrangements.
Why use it?
It helps balance cost, growth, compliance, and protection against one customer seeing another customer’s data. It also addresses connection limits and resource-heavy customers.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one.

Good fit Use it to design tenant isolation, route requests to the right data, prevent cross-tenant queries, and choose backup and disaster-recovery arrangements.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/codebygarv/ai-skills/multi-tenant-data-partitioner
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add codebygarv/Ai-skills --skill multi-tenant-data-partitioner
Clone the repo
git clone --depth 1 https://github.com/codebygarv/Ai-skills

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for multi-tenant-data-partitioner

README.md
[![agentmods](https://agentmods.dev/badge/skills/codebygarv/ai-skills/multi-tenant-data-partitioner.svg)](https://agentmods.dev/skills/codebygarv/ai-skills/multi-tenant-data-partitioner)
Your own site
<a href="https://agentmods.dev/skills/codebygarv/ai-skills/multi-tenant-data-partitioner"><img src="https://agentmods.dev/badge/skills/codebygarv/ai-skills/multi-tenant-data-partitioner.svg" alt="Measured on agentmods" height="20"></a>
Per session 30 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 414 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00030 $0.00414
Opus 5 $0.00015 $0.00207
Sonnet 5 $0.00006 $0.00083
Haiku 4.5 $0.00003 $0.00041

Measured 8d ago against content hash 26e3c74dab12, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-08, from the pricing page.

Security

Grade A, and why

multi-tenant-data-partitioner scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 8d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/architecture/multi-tenant-data-partitioner/SKILL.md · 37 lines

What it actually says

Purpose

Architect secure, cost-effective, and scalable database multi-tenancy models (Shared Database/Shared Schema with Row-Level Security, Database-per-Tenant, Schema-per-Tenant) tailored to compliance, isolation, and cost constraints.

When to Use

  • Designing the data architecture for a B2B SaaS application.
  • Enterprise customers requesting strict physical data isolation or custom backup schedules.
  • Evaluating database costs vs cross-tenant data leakage risks.

What to Analyze

  1. Isolation Model Selection:
    • Shared Database, Shared Schema (Pool): Highest resource efficiency, lowest cost, enforced via Postgres RLS.
    • Separate Schema (Bridge): Logical isolation, schema migration overhead at 1,000+ tenants.
    • Separate Database (Silo): Complete physical isolation, highest cost, individual tenant disaster recovery.
  2. Tenant Context Resolution: Subdomain (tenant.app.com), JWT claim, or custom HTTP header routing.
  3. Connection Pool Management: Dynamic connection routing without exhausting database connection limits.
  4. Cross-Tenant Leakage Prevention: Automated query filters and database-enforced Row-Level Security (RLS).
  5. Noisy Neighbor Defense: Per-tenant query rate limits and compute quotas.

Output Format

  • Multi-Tenancy Tradeoff Matrix: Comparison of Pool vs Bridge vs Silo for your specific scale.
  • Postgres Row-Level Security (RLS) Policy: SQL script enforcing tenant_id session boundaries.
  • Tenant Routing Middleware: Code extracting and injecting tenant context into database queries.

Avoid

  • Relying solely on application-level WHERE tenant_id = :id queries without database-level RLS enforcement.
  • Creating 10,000 PostgreSQL schemas on a single instance (causes heavy catalog metadata lock contention).
Files

What ships with it

2 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 8d ago First seen · 37 lines · 30 tokens per session scan A 26e3c74dab12

Subscribe to this mod's changes

multi-tenant-data-partitioner is a skill published in the GitHub repository codebygarv/Ai-skills (25 stars, last pushed 19d ago), licensed MIT. It adds 30 tokens to every session and 414 once invoked, about $0.0002 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

bun-api

Bun runtime API reference for TypeScript scripts. Covers Bun.serve() HTTP/HTTP/2 server with routes and WebSockets, fetch() transport options, Bun.file(), Bun.write(), Bun.$() shell, Bun.spawn(), Bun.Glob, Bun.env, bun:sqlite, Bun.sql() for PostgreSQL/MySQL via DATABASEURL, Bun.s3 for S3-compatible storage, Bun.redis…

dmythro/agent-skills · 250 tokens

bun-cli

Bun CLI reference for package management, script running, testing, bundling, and compilation. Covers bun install/add/remove/update, bun run, bun test, bun build, bunx, bun patch, bun audit fix, bun dedupe, bun prune, bun why, bun pm, bun repl, bunfig.toml, bun.lock, workspace catalogs, isolated installs and the global…

dmythro/agent-skills · 179 tokens

deps-upgrade

Validate JavaScript/TypeScript dependency upgrades after an interactive or manual update. Establish the real delta from git, detect peer/engine/type conflicts, extract breaking changes, migrations and adoptable features from release notes, assess held-back or seemingly unused packages, and run verification gates.…

dmythro/agent-skills · 134 tokens

git-pr

PR and MR workflows for GitHub (gh) and GitLab (glab). Creation, review comment handling, thread resolution, review state queries, merging, cost-aware bot review rounds (GitHub: Copilot, CodeRabbit), and Copilot code review configuration (rulesets, custom instructions, billing). Use when creating PRs/MRs, addressing…

dmythro/agent-skills · 138 tokens

git-project

GitHub Projects (v2) setup and management via gh CLI + GraphQL: organize a repo's issues into epics with native sub-issues, drive a board Status flow (Todo -> In Progress -> Done), set Project Priority, classify with native issue Types (Task/Bug/Feature) instead of labels, scope work with milestones (incl. resolving…

dmythro/agent-skills · 176 tokens

git-ci

CI/CD status queries for GitHub Actions (gh) and GitLab CI (glab). Check pipeline status, failing jobs, workflow runs, job logs, and merge readiness. Use when checking CI status, debugging build failures, viewing job logs, watching pipeline progress, or configuring gh/glab CI read-only allowlists. Not for PR workflows…

dmythro/agent-skills · 88 tokens