digirati-co-uk/db-queries
.agents/skills/db-queries/SKILL.md
Work on Madoc TS SQL query modules and shared query helpers. Use when adding or modifying queries in services/madoc-ts/src/database/queries or related SQL helper usage.
$ install --global
skillsauthnpx skillsauth add digirati-co-uk/madoc-platform db-queriesInstall 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 25, 2026, 9:34 PM1.9s1 file scanned
SKILL.md
- name:
- db-queries
- description:
- Work on Madoc TS SQL query modules and shared query helpers. Use when adding or modifying queries in services/madoc-ts/src/database/queries or related SQL helper usage.
Database Queries (Madoc TS)
Goal
Document the query module structure so SQL changes follow existing patterns and helper usage.
Scope
- Query modules in
src/database/queries - Slonik SQL tag usage and helper tags
- Query composition conventions
Non-scope
- Repository layer behavior
- Migration scripts
- Route handlers
Key Entry Points
services/madoc-ts/src/database/queries/services/madoc-ts/src/utility/postgres-tags.tsservices/madoc-ts/src/database/create-postgres-pool.ts
Architecture Summary (Based on Source)
- Query modules export Slonik
sqltemplate strings with typed results. - Conditional SQL composition uses helper tags like
SQL_EMPTY,SQL_COMMA, and typed array helpers. - Queries are imported into repositories or handlers for execution via Slonik connections.
Quick Start Workflow
- Review the relevant query file in
services/madoc-ts/src/database/queries/. - Use the
sqltag and helper tags fromservices/madoc-ts/src/utility/postgres-tags.tsfor composition. - Update any repository or handler that consumes the query.
Common Tasks
- Add a new query module
- Extend a query with optional filters
- Adjust query return shapes and typings
Pitfalls
- Building SQL strings without helper tags, risking invalid SQL
- Mismatching expected row types in callers
- Returning different column names without updating mappers
Suggested Checks
- Run the query against a dev database
- Verify downstream mapping code still aligns with the query
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