skills.rest
ciandt-fulvio
ciandt-fulvioCOMMUNITY
Explore all skills by this author →
GitHub

impl-repository

Implement repository data access with parameterized SQL and JSON handling.

Updated Dec 14, 2025
Search Tags:#repository#sql#pagination#data-access#json_extract
One-click install
npx skills add https://github.com/ciandt-fulvio/synth-lab --skill impl-repository
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: impl-repository
Source: https://github.com/ciandt-fulvio/synth-lab/tree/main/.claude/skills/impl-repository
Command: npx skills add https://github.com/ciandt-fulvio/synth-lab --skill impl-repository

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It provides a data access layer with properly parameterized SQL, JSON handling, and domain-specific exceptions, keeping data operations separate from business logic.

Core Features & Use Cases

  • Parameterized Queries: All SQL uses placeholders to prevent injection.
  • Pagination & JSON: Handles paging and JSON fields with JSON1 and json_extract.
  • Domain Exceptions: Throws domain-specific errors for not-found or invalid operations.

Quick Start

Implement a repository in src/synth_lab/repositories/{entity}_repository.py inheriting from BaseRepository. Implement list_{entities}, get_by_id, create, update, and delete methods using parameterized SQL and JSON handling. Add a small usage example or test demonstrating safe data access.