backend-persistence-skills

A platform-neutral backend persistence skill pack for data modelling, repository design, schema review, ORM decisions, transaction boundaries, query analysis, and migration planning.

Included skills

• api-contract-writer
• api-error-model-designer
• crud-surface-reviewer
• dao-pattern-builder
• data-migration-planner
• entity-model-designer
• index-suggestion-writer
• jdbc-vs-jpa-selector
• orm-mapping-reviewer
• persistence-test-planner
• query-complexity-reviewer
• repository-layer-designer
• schema-normalizer
• transaction-boundary-checker

Features

• Preserves the original skills/, templates/, and examples/ source material
• Mirrors packaged skills into both .claude/skills/ and .agents/skills/
• Covers persistence design from entity modelling through testing and migration

Install

Option A: Install globally

git clone https://github.com/45ck/backend-persistence-skills.git
cd backend-persistence-skills
bash install.sh

This installs every packaged skill into both:

• ~/.claude/skills/
• ~/.agents/skills/

Option B: Copy into a project

cp -R .claude /path/to/your-project/
cp -R .agents /path/to/your-project/

Uninstall

bash uninstall.sh

Usage

/entity-model-designer subscription billing data model
/schema-normalizer audit current relational schema
/repository-layer-designer order processing module
/transaction-boundary-checker checkout and payment capture workflow
/query-complexity-reviewer reporting query hotspots
/data-migration-planner move users from legacy auth schema

Repo structure

skills/                              original source skills
templates/                           reusable templates
examples/                            sample flow material
.claude/skills/<skill>/SKILL.md      packaged skill format
.agents/skills/<skill>/SKILL.md      mirrored packaged skill format
install.sh                           global installer
uninstall.sh                         global uninstaller
LICENSE                              MIT

Related workflow agents

• backend-engineer - Own entities, repositories, transactions, and API contracts
• test-designer - Design high-value tests around backend behavior
• qa-automation-engineer - Translate backend behavior into maintainable automation

Related skill packs

• business-analysis-skills - Business analysis techniques, workflows, and quality checks
• marketing-product-skills - Product strategy, growth, positioning, launch, SEO, and pricing skills
• hci-review-skill - Structured HCI and UX review skills
• fagan-inspection-skill - Formal inspection and defect-review skills
• software-architecture-skills - Architecture options, views, risks, and tradeoff writing
• data-structures-algorithmic-reasoning-skills - Data structure selection and algorithmic reasoning skills
• oop-code-structure-skills - Object-oriented design and class-structure review skills
• web-engineering-skills - Web request handling, MVC, validation, routing, and navigation skills
• enterprise-architecture-integration-skills - Enterprise topology, integration, messaging, and cloud skills
• uml-analysis-modelling-skills - UML analysis and modelling skills
• verification-test-design-skills - Verification, coverage, decision-table, and oracle design skills
• automation-testing-skills - Unit, integration, API, UI, regression, and flaky-test skills
• non-functional-testing-skills - Performance, resilience, scalability, soak, stress, and NFR testing skills
• software-quality-skills - Quality models, technical debt, maintainability, and reliability skills
• code-review-inspection-skills - Formal inspection, checklist-driven review, metrics, and rework planning skills
• refactoring-code-smells-skills - Refactoring, anti-pattern, duplication, and code smell review skills
• design-for-testability-skills - Seams, DI, determinism, hidden I/O, and testability design skills
• security-engineering-skills - Threat modeling, boundaries, least privilege, and secure defaults skills
• authentication-cryptography-skills - Authentication, token, certificate, revocation, and MITM review skills
• pentest-security-testing-skills - Pentest scoping, recon, attack-surface mapping, OWASP, and finding-report skills
• llm-agent-security-skills - Prompt injection, agent permissions, retrieval trust, memory, and tool-chain security skills
• deployment-release-skills - Deployment strategy, go-live readiness, rollback, and release operations skills
• maintenance-evolution-skills - Maintenance triage, change impact, migration, regression, and deprecation skills
• project-management-skills - Project chartering, scope, WBS, milestones, estimation, and closure skills
• agile-delivery-skills - Backlog shaping, sprint goals, retrospectives, blockers, and delivery discipline skills
• cloud-platform-operations-skills - Cloud placement, rollout readiness, patching, migration waves, and lifecycle operations skills
• documentation-evidence-skills - Specifications, rationale, reports, traceability, plans, and evidence quality skills
• research-literature-review-skills - Search strategy, screening, synthesis, evidence strength, and gap-analysis skills

License

MIT