.claude/skills/gen-repository/SKILL.md
Use when adding a new repository to a feature. Generates an IRepository interface and EF Core implementation with AsNoTracking read methods, write methods, and unit/integration test stubs. Also invoke when the user mentions: new repository, add data access, EF repository, create repository class. Domain: Code Generation, Data Access. Level: Intermediate.
npx skillsauth add klod68/littlerae gen-repositoryInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
Generate a repository for entity: ${1:EntityName}.
${2:MyApp}${3:AppDbContext}${4|GetById,GetAll,Add,Update,Delete,GetById+GetAll,GetById+Add+Update+Delete,Full CRUD|}${5|Yes,No|}${2}.Domain.Repositories.I${1}Repository.cs
Task<T>.CancellationToken cancellationToken.GetByIdAsync, FindAllAsync, AddAsync, DeleteAsync.IQueryable<T>.PagedResult<T> (define the record here if not already present).${2}.Infrastructure.Repositories.${1}Repository.cs
internal sealed class implementing I${1}Repository.${3} via constructor.AsNoTracking().Select() at query level — never maps full entities in memory.Show the IServiceCollection extension line to register I${1}Repository → ${1}Repository as Scoped.
${2}.Infrastructure.Tests.Repositories.${1}RepositoryTests.cs
internal sealed in the Infrastructure layer.AsNoTracking() — no exceptions.Select() at query level — never load full entities then map in memory.IQueryable<T> from a repository — always materialize results.SaveChangesAsync is never called inside the repository — that is the handler's responsibility.GetByIdAsync (query), AddAsync (command), DeleteAsync (command).ef-core.instructions.md.internal sealed on the implementation class.I${1}Repository is public (it is a domain interface).DbContext never crosses the Infrastructure boundary.tools
Use when cross-cutting concerns (logging, metrics, validation, authorization) are tangled into command handlers or service methods, when building database command pipelines with reorderable concerns, or when HTTP client pipelines or message handlers need composable, independently-replaceable processing stages. Covers ICommandInterceptor interface, InterceptorPipeline with reverse-chain construction, zero-cost Empty sentinel to skip overhead when no interceptors are registered, and ConfigureAwait(false) discipline for library code. Domain: Architecture, Cross-Cutting Concerns. Level: Intermediate. Tags: interceptor, pipeline, middleware, decorator, cross-cutting-concerns.
development
Use when writing integration tests for Razor Pages, MVC, or Minimal API applications to validate routing, middleware, page rendering, and HTTP behavior without a browser or live server, or when adding fast smoke tests to a CI pipeline. Covers WebApplicationFactory<Program> setup with public partial class Program, in-memory test server, AngleSharp HTML parsing, CSS selector assertions, redirect and status code testing, and a shared static fixture pattern for minimal per-test startup overhead. Domain: Testing, ASP.NET Core. Level: Intermediate. Tags: integration-testing, webapplicationfactory, razor-pages, anglesharp, http-testing.
development
Use when designing indexes for new tables, diagnosing slow queries that are not using indexes efficiently, reviewing index fragmentation and maintenance, or when the current indexing strategy results in key lookups, table scans, or missing index warnings. Covers clustered index key selection (narrow, unique, ever-increasing), non-clustered index design for query patterns, covering indexes with INCLUDE columns, filtered indexes for subset queries, composite index column ordering, DMV-based monitoring for missing and unused indexes, and rebuild vs reorganize maintenance thresholds. Domain: Database, Performance. Level: Intermediate. Tags: index, sql-server, covering-index, filtered-index, performance, dmv, maintenance.
development
Use when building a searchable in-memory catalog or registry for documentation sites, admin panels, or type/API browsers where you need keyword matching, fuzzy search, and ranked results without an external search engine or database. Covers RegistryService with weighted scoring across name, description, keywords, and method names; Levenshtein fuzzy matching; synonym expansion; category and subcategory filtering; and singleton DI registration for datasets of hundreds to low thousands of items. Domain: Search, Data Access Patterns. Level: Intermediate. Tags: search, registry, fuzzy-matching, in-memory, catalog, filtering.