multi-tenant-data-partitioner
Architects database multi-tenancy models (Shared DB/Schema vs Separate Schema vs Separate Database) and tenant routing.
Supply asset profile
Data, BI, and analytics
CSV, SQL, notebooks, dashboards, data pipelines, BI, ETL, and spreadsheet analysis.
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
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
PromisingUseful candidate, but compare it with alternatives before adopting.
Trust
Sandbox onlyUseful candidate with missing or mixed trust signals. Keep it in an isolated workspace until the outcome loop proves task fit.
Audit
Needs reviewA 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.
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.
Suited tasks
- Database and SQL workflows
- Claude Code teams
- builders willing to evaluate younger projects
- Understand table relationships
Suited agents
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-partitionerDo 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
Usable candidate, but the agent should surface permission and audit notes before installation.
Require human approval before installing into a real workspace.
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.
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-partitionerAgent 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 JSON
/api/agent/resolve?task=Use%20multi-tenant-data-partitioner%20for%20an%20agent%20workflow&agent=codex&max_risk=medium
Resolve text
/api/agent/resolve?task=Use%20multi-tenant-data-partitioner%20for%20an%20agent%20workflow&agent=codex&max_risk=medium&format=text
Install handoff
/api/skills/codebygarv-multi-tenant-data-partitioner/install
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.
Install handoff
/api/skills/codebygarv-multi-tenant-data-partitioner/install
LLM text format
/api/skills/codebygarv-multi-tenant-data-partitioner/install?format=text
Find alternatives
/api/skills/search?q=multi-tenant-data-partitioner&limit=3
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-partitionerRegistry 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.
Manifest
/api/registry/manifest/codebygarv-multi-tenant-data-partitioner
LLM text
/api/registry/manifest/codebygarv-multi-tenant-data-partitioner?format=text
Install alias
/api/registry/install/codebygarv-multi-tenant-data-partitioner
Recommend
/api/registry/recommend?task=Use%20multi-tenant-data-partitioner%20in%20an%20agent%20workflow&limit=3
Agent fit
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.
Agent decision cockpit
Fallback candidate for Database and SQL
Prototype with this skill first; keep a fallback candidate ready.
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
- 1Install it in a sandbox agent and run one Database and SQL task end to end.
- 2Compare output quality, latency, and failure behavior against at least one alternative.
- 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.
GitHub adoption
FIX21 GitHub stars
Stars/forks activity
FIX21 stars, 1 forks; issue activity unavailable in current metadata
Recent maintenance
PASS3d since push
License clarity
PASSMIT
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.
Workflow fit
Use this skill in these scenarios
Work with data stores
Database and SQL
I need my agent to inspect database schemas, write SQL, and explain query results.
Reduce risk
Security and compliance
I need my agent to scan a project for security risks and summarize what needs attention.
Investigate faster
Research agents
I need my agent to research a topic, compare sources, and produce a concise report.
Workflow fit
Add it to a complete workflow
Find, compare, and synthesize
Research report agent
A workflow for agents that gather sources, compare claims, summarize long material, and draft useful research briefs.
Scrape, clean, and reuse web data
Web data pipeline
A practical workflow for agents that crawl public pages, extract clean content, normalize data, and hand it to downstream research or RAG workflows.
Turn skills into distribution
Content growth agent
A workflow for turning newly indexed skills into SEO briefs, social drafts, comparison pages, and reusable publishing workflows.
Alternative shortlist
Compare before you install
Similar skills that may fit this task.
D3
Bring data to life with SVG, Canvas and HTML. :bar_chart::chart_with_upwards_trend::tada:
Echarts
Apache ECharts is a powerful, interactive charting and data visualization library for browser
Data Science For Beginners
10 Weeks, 20 Lessons, Data Science for All!
Sequelize
Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB, DB2 and DB2 for IBM i.
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
recent repository activity
Audit
Install review
Install and adoption review
- Security
- 77/100
- Maintenance
- 100/100
- Install
- 92/100
Agent-proven evidence
Agent-proven evidence
Outcome reports after resolve, review, install, and one narrow run.
- 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
Scenario-led draft for multi-tenant-data-partitioner, ready for a manual X post.
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
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
This listing was indexed from public sources and is not marked official until a maintainer claim is approved.
- Creator
- codebygarv
- Source
- codebygarv/Ai-skills
- 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 skillOwner 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.
[](https://www.openagentskill.com/skills/codebygarv-multi-tenant-data-partitioner)
[](https://www.openagentskill.com/skills/codebygarv-multi-tenant-data-partitioner)
[](https://www.openagentskill.com/skills/codebygarv-multi-tenant-data-partitioner/audit)
[](https://www.openagentskill.com/skills/codebygarv-multi-tenant-data-partitioner)Author
codebygarv
@codebygarv
Tags
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
- 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
Related skills
D3
Bring data to life with SVG, Canvas and HTML. :bar_chart::chart_with_upwards_trend::tada:
113.1K StarsEcharts
Apache ECharts is a powerful, interactive charting and data visualization library for browser
66.6K StarsData Science For Beginners
10 Weeks, 20 Lessons, Data Science for All!
35.6K StarsSequelize
Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB, DB2 and DB2 for IBM i.
30.4K Stars