digirati-co-uk/repository-patterns
.agents/skills/repository-patterns/SKILL.md
Work on Madoc TS repository classes and data access patterns. Use when adding repository methods, refactoring DB access, or updating repository/query boundaries in services/madoc-ts.
$ install --global
skillsauthnpx skillsauth add digirati-co-uk/madoc-platform repository-patternsInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 16, 2026, 3:52 PM4.5s2 files scanned
SKILL.md
- name:
- repository-patterns
- description:
- Work on Madoc TS repository classes and data access patterns. Use when adding repository methods, refactoring DB access, or updating repository/query boundaries in services/madoc-ts.
Repository Patterns (Madoc TS)
Goal
Describe repository structure and usage so data access changes follow existing patterns and mappings.
Scope
- Repository classes under
src/repository - Query reuse from
src/database/queries - Mapping rows to domain models
Non-scope
- Route handlers and API controllers
- Migration scripts
- Frontend data fetching
Key Entry Points
services/madoc-ts/src/repository/services/madoc-ts/src/repository/base-repository.tsservices/madoc-ts/src/repository/project-repository.tsservices/madoc-ts/src/database/queries/
Architecture Summary (Based on Source)
- Repositories extend
BaseRepositoryto share a Slonik connection and optional flags. - Repositories group
queriesandmutationsas static helpers and expose instance methods that map results to domain models. - Query helpers from
src/database/queriesare reused for common SQL fragments.
Quick Start Workflow
- Review the target repository file under
services/madoc-ts/src/repository/. - Check for existing static
queries/mutationshelpers to reuse. - Use mapping helpers (e.g.,
mapProjectUpdate) to normalize result shapes.
Common Tasks
- Add a repository method for a new feature
- Refactor queries into shared
queries/mutations - Adjust mapping logic for new columns
Pitfalls
- Bypassing repository mappers and returning raw rows
- Changing query column names without updating mapping functions
- Adding DB access outside repositories when a repository already exists
Suggested Checks
- Run a repository method against a dev database
- Verify mapped models match expected API shapes
Related Skills
digirati-co-uk/utility-core
tools
VerifiedTrustedCommunity
Work on Madoc TS shared utility helpers (JWT, metadata, errors, IIIF helpers, auth helpers). Use when changing core utility functions or shared helpers in services/madoc-ts.
56SKILL.mdUpdated Apr 16, 2026
digirati-co-uk/types-schemas
development
VerifiedTrustedCommunity
Work on Madoc TS shared type definitions and schema contracts. Use when updating TypeScript types, JSON schema shapes, or cross-layer data contracts in services/madoc-ts.
56SKILL.mdUpdated Apr 16, 2026
digirati-co-uk/tasks-automation
tools
VerifiedTrustedCommunity
Understand and extend Madoc TS task automation, including bots and task-related extensions. Use when adding task automation, bot behavior, or task metadata resolution in services/madoc-ts.
56SKILL.mdUpdated Apr 16, 2026
digirati-co-uk/ssr-site
development
VerifiedTrustedCommunity
Work on Madoc TS site SSR pipeline, HTML template injection, and site render data wiring. Use when changing site SSR behavior, template tokens, or site SSR data wiring in services/madoc-ts.
56SKILL.mdUpdated Apr 16, 2026