multi-tenant-data-partitioner

REVIEW · 60
Registry indexed

Architects database multi-tenancy models (Shared DB/Schema vs Separate Schema vs Separate Database) and tenant routing.

Verified installs0
Stars21
Version1.0.0
Quality60/100 · Promising
Trust60/100 · Sandbox only
Audit74/100 · Needs review

Supply asset profile

Data, BI, and analytics

CSV, SQL, notebooks, dashboards, data pipelines, BI, ETL, and spreadsheet analysis.

Browse track

Scenario

Database and SQL

I need my agent to inspect database schemas, write SQL, and explain query results.

Agent fit

Claude Code + CLI + Codex

Codex, Claude Code, Cursor, CLI, or custom agents.

Install

Ready

npx skills add codebygarv/Ai-skills --skill multi-tenant-data-partitioner

Maintenance

fresh

3d since push

Risk

Needs review

Example middleware code uses string interpolation for tenantId in SQL, which could be vulnerable to SQL injection if tenantId is not properly sanitized.

GitHub quality

21

60/100 Quality · 68/100 Trust

Coverage tags

DataDatabase and SQLdata-analysisagent-skill

Review notes

Example middleware code uses string interpolation for tenantId in SQL, which could be vulnerable to SQL injection if tenantId is not properly sanitized. · Low GitHub adoption signal

Agent adoption scorecard

Trust, audit, and install readiness at a glance

These scores combine public repository metadata, OpenAgentSkill review signals, maintenance freshness, and install readiness. They are a shortlist signal, not a replacement for human review.

Quality

Promising
60

Useful candidate, but compare it with alternatives before adopting.

Trust

Sandbox only
60

Useful candidate with missing or mixed trust signals. Keep it in an isolated workspace until the outcome loop proves task fit.

Audit

Needs review
74

A machine-readable review of install readiness, security metadata, maintenance, and adoption risk.

OpenAgentSkill Trust Score v5

Human review before install

Run only in a sandbox and compare close alternatives before using it for real work.

CodexClaude CodeCursorOpenAgentSkill CLI

Stars

21 GitHub stars

Repo activity

21 stars, 1 forks

Maintenance

3d since push

License

MIT

Install

npx skills add codebygarv/Ai-skills --skill multi-tenant-data-partitioner

Install safety

standard package or runtime install path

Permission surface

network or browser access, database access

Agent outcomes

No agent outcome data yet

Docs

Usable metadata, review docs

Risk summary

Review before production

  • Example middleware code uses string interpolation for tenantId in SQL, which could be vulnerable to SQL injection if tenantId is not properly sanitized.
  • Low GitHub adoption signal
  • Quality score needs review
  • GitHub adoption: 21 GitHub stars

Install readiness

Install path available

  • Install path is available
  • Repository evidence is available
  • License is declared
  • No Agent Proven outcome evidence yet

Agent-readable metadata

Machine-readable decision data for this skill.

Use this block or the embedded JSON to decide whether an agent should install this skill, choose an alternative, or ask for human review first.

Open JSON

Suited tasks

  • Database and SQL workflows
  • Claude Code teams
  • builders willing to evaluate younger projects
  • Understand table relationships

Suited agents

CodexClaude CodeCursorOpenAgentSkill CLICLI

Install decision

Command
npx skills add codebygarv/Ai-skills --skill multi-tenant-data-partitioner
Policy
review
Human review
yes

Trust and risk

Trust
60/100
Audit
74/100
Risk level
Needs review

Outcome loop

Endpoint
/api/agent/outcome
Event ID
resolve
Outcomes
5

Install command

npx skills add codebygarv/Ai-skills --skill multi-tenant-data-partitioner

Do not use when

  • teams that need a vendor-supported SLA
  • production agents without a repository review
  • Low GitHub adoption signal
  • Example middleware code uses string interpolation for tenantId in SQL, which could be vulnerable to SQL injection if tenantId is not properly sanitized.
  • Quality score needs review

Agent safety v2

58/100 · Review before install

Reviewed with permission notesreview

Usable candidate, but the agent should surface permission and audit notes before installation.

Require human approval before installing into a real workspace.

Resolve via API

medium

Network access

Skill likely fetches remote pages, APIs, repositories, or external services.

medium

Database access

Skill may inspect schemas, query databases, or work with persistent stores.

  • Example middleware code uses string interpolation for tenantId in SQL, which could be vulnerable to SQL injection if tenantId is not properly sanitized.

Install targets

Install this skill in your agent workflow

Use the public install endpoint to fetch the command, safety checklist, target prompts, and canonical links for this skill.

skill install

OpenAgentSkill CLI

Resolve policy, run the source installer safely, and report a verified install receipt.

$ npx --yes https://github.com/Leon-Drq/openagentskill/releases/download/cli-v0.2.1/openagentskill-0.2.1.tgz install codebygarv-multi-tenant-data-partitioner

Agent resolve plan

Let an agent verify fit before installing.

The Resolve API returns the selected skill, alternatives, safety policy, audit notes, install target, and copy-paste prompt an agent can follow without scraping this page.

Open text plan

Agent should check

  • Task fit and alternatives from Resolve API.
  • Audit score, trust score, and safety policy warnings.
  • Install target compatibility for Codex, Claude Code, Cursor, or CLI.

Copy prompt

Task: Use multi-tenant-data-partitioner in this workspace.
Resolve first: https://www.openagentskill.com/api/agent/resolve?task=Use%20multi-tenant-data-partitioner%20for%20an%20agent%20workflow&agent=codex&max_risk=medium
Review install handoff: https://www.openagentskill.com/api/skills/codebygarv-multi-tenant-data-partitioner/install
Install command: npx skills add codebygarv/Ai-skills --skill multi-tenant-data-partitioner
Before running it, summarize audit warnings, required permissions, and the fallback skill if install is risky.

Agent handoff

Give an agent the install path, not another directory page.

Use the public install endpoint to fetch the command, safety checklist, target prompts, and canonical links for this skill.

Open install API

Agent prompt

Use multi-tenant-data-partitioner for this task. Review https://www.openagentskill.com/api/skills/codebygarv-multi-tenant-data-partitioner/install, then install with: npx skills add codebygarv/Ai-skills --skill multi-tenant-data-partitioner

Registry metadata

Agent-readable profile for automatic skill selection.

This page exposes the same decision, trust, audit, use-case, and install signals through the Registry API, so agents can rank this skill without scraping the UI.

Open manifest

Agent fit

61/100

Database and SQL

Platforms

Claude Code

Audit report

Needs review · 74/100

A machine-readable review of install readiness, security metadata, maintenance, and adoption risk.

View audit reportView eval report

Agent decision cockpit

Fallback candidate for Database and SQL

Prototype with this skill first; keep a fallback candidate ready.

61
Readiness
Prototype
Stage

Role in stack

Fallback candidate

Primary fit

Database and SQL

Trust label

Prototype first

Install path

Command ready

Use when

  • Database and SQL workflows
  • Claude Code teams
  • builders willing to evaluate younger projects

Evidence

  • recent repository activity
  • install command or GitHub repo available
  • 60/100 quality profile
  • 6 OpenAgentSkill engagement events

review first

  • Low GitHub adoption signal
  • Example middleware code uses string interpolation for tenantId in SQL, which could be vulnerable to SQL injection if tenantId is not properly sanitized.

Implementation path

  1. 1Install it in a sandbox agent and run one Database and SQL task end to end.
  2. 2Compare output quality, latency, and failure behavior against at least one alternative.
  3. 3Promote it into production only after reviewing repository permissions, license, and maintenance signals.

Trust profile

Sandbox only

Useful candidate with missing or mixed trust signals. Keep it in an isolated workspace until the outcome loop proves task fit.

60
OpenAgentSkill Trust Score

GitHub adoption

FIX

21 GitHub stars

Stars/forks activity

FIX

21 stars, 1 forks; issue activity unavailable in current metadata

Recent maintenance

PASS

3d since push

License clarity

PASS

MIT

Good signals

  • AI review approved
  • Install path is available
  • Repository evidence is available
  • Recently maintained repository
  • Install command has no obvious high-risk pattern
  • Outcome loop is ready but needs first real agent run

Review before install

  • Example middleware code uses string interpolation for tenantId in SQL, which could be vulnerable to SQL injection if tenantId is not properly sanitized.
  • Low GitHub adoption signal
  • Quality score needs review
  • GitHub adoption: 21 GitHub stars
  • Stars/forks activity: 21 stars, 1 forks; issue activity unavailable in current metadata
  • No real agent outcome reports yet
  • Human review required before unattended installation

Recommended action

Run only in a sandbox and compare close alternatives before using it for real work.

Quality profile

Promising candidate for agent workflows

Useful candidate, but compare it with alternatives before adopting.

60
GitHub stars
21
Freshness
3d ago
Install ready
Yes
License
MIT
Review before install: Low GitHub adoption signal · Example middleware code uses string interpolation for tenantId in SQL, which could be vulnerable to SQL injection if tenantId is not properly sanitized.

Workflow fit

Use this skill in these scenarios

Workflow fit

Add it to a complete workflow

Alternative shortlist

Compare before you install

Similar skills that may fit this task.

Compare all

Overview

--- name: multi-tenant-data-partitioner description: Architects database multi-tenancy models (Shared DB/Schema vs Separate Schema vs Separate Database) and tenant routing. ---

## 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).

Technical details

Version
1.0.0
License
MIT
Last updated
Aug 20, 2026
Published
Aug 20, 2026

Decision snapshot

Fallback candidate

61
Ready
Prototype
Stage

recent repository activity

Audit

Install review

Install and adoption review

74
Needs review
Security
77/100
Maintenance
100/100
Install
92/100
Open full auditView eval report

Agent-proven evidence

Agent-proven evidence

Outcome reports after resolve, review, install, and one narrow run.

0
Proven
Needs first agent runAuto-install: review firstLast: Unknown
Success rate
Recent failure
Outcomes
0
Output quality
Failed
0
Not relevant
0
Installs
0
Risk blocked
0
Setup needed
0
Production
0

No agent outcome data yet. The first agent run can report success, setup needs, risk blocks, failure, or not-relevant through /api/agent/outcome.

Install

Add to agent workflow

Free and open source. Review the report before installing into production agents.

Growth loop

Share kit

X

Scenario-led draft for multi-tenant-data-partitioner, ready for a manual X post.

Curator note
multi-tenant-data-partitioner: Architects database multi-tenancy models (Shared DB/Schema vs Separate Schema vs Separate Dat...

21 stars

https://www.openagentskill.com/skills/codebygarv-multi-tenant-data-partitioner?ref=x
Open X draft
Optional reply with install command
Listing + install path for multi-tenant-data-partitioner:
https://www.openagentskill.com/skills/codebygarv-multi-tenant-data-partitioner?ref=x

Install: npx skills add codebygarv/Ai-skills --skill multi-tenant-data-partitioner

Listing source

Registry indexed

Claimable

This listing was indexed from public sources and is not marked official until a maintainer claim is approved.

Creator
codebygarv
Indexed by
OpenAgentSkill community index

Attribution links to the public repository or creator profile. Creators can claim the listing to update ownership signals.

Claim this skill

Owner claim

Claim this skill listing

This Registry indexed listing is attributed to codebygarv but is not marked official yet. Claim it to add a verified owner signal and make future launch, install, and audit updates easier to trust.

Creator backlink kit

Add the evidence badges to your README

Show the canonical listing, current trust and audit signals, and real Agent-Proven evidence where developers evaluate the repository.

[![Listed on OpenAgentSkill](https://www.openagentskill.com/api/badge/codebygarv-multi-tenant-data-partitioner?metric=listed&label=Listed)](https://www.openagentskill.com/skills/codebygarv-multi-tenant-data-partitioner)
[![OpenAgentSkill Trust](https://www.openagentskill.com/api/badge/codebygarv-multi-tenant-data-partitioner?metric=trust&label=Trust)](https://www.openagentskill.com/skills/codebygarv-multi-tenant-data-partitioner)
[![OpenAgentSkill Audit](https://www.openagentskill.com/api/badge/codebygarv-multi-tenant-data-partitioner?metric=audit&label=Audit)](https://www.openagentskill.com/skills/codebygarv-multi-tenant-data-partitioner/audit)
[![Agent Proven](https://www.openagentskill.com/api/badge/codebygarv-multi-tenant-data-partitioner?metric=proven&label=Agent%20Proven)](https://www.openagentskill.com/skills/codebygarv-multi-tenant-data-partitioner)

Author

C

codebygarv

@codebygarv

Platform fit

Health signals

GitHub stars
21
Quality score
32/100
Last GitHub push
Aug 20, 2026
Framework hints
Unknown
OpenAgentSkill views
6
Install copies
0
Outbound clicks
0

Community signal

Share whether this skill looks useful for your agent workflow. Aggregated feedback improves rankings over time.

Trust & safety

Sandbox only

60
  • GitHub adoption21 GitHub starsFIX
  • Stars/forks activity21 stars, 1 forks; issue activity unavailable in current metadataFIX
  • Recent maintenance3d since pushPASS
  • License clarityMITPASS
  • README/SKILL.md completenessPublic metadata needs stronger README/SKILL.md contextINFO
  • Dependency/runtime risknetwork or browser surface, database surfaceINFO