Audit and fix classic ADO.NET data-access code (SqlConnection / SqlCommand / SqlDataReader / DataSet) on .NET Framework. Use this skill whenever the user shares raw ADO.NET code, a DAL / repository built on SqlCommand, stored-proc calls, string-concatenated SQL, or mentions SQL injection, parameterized queries…
Audit C#/.NET code for async/await anti-patterns and concurrency bugs. Use this skill whenever the user shares async C# code or asks about deadlocks, async void, .Result/.Wait(), blocking calls, ConfigureAwait, sync-over-async, fire-and-forget tasks, CancellationToken usage, or "why does my async code hang/deadlock".…
Design ASP.NET Core authorization — policy-based, role-based, and claims/requirement-based with custom authorization handlers and resource-based checks. Use this skill whenever the user wants authorization policies, role/claim checks, custom AuthorizationHandler, resource-based authorization, permission checks, or…
Set up BenchmarkDotNet for a .NET project and interpret the results — proper benchmark classes, memory diagnostics, baselines, and reading ns/op + allocations. Use this skill whenever the user wants to benchmark code, measure performance, compare two implementations, set up BenchmarkDotNet, or asks "which is faster /…
Add the right caching to a .NET app — IMemoryCache, distributed cache, or HybridCache (.NET 9+) — with correct keys, expiration, stampede protection, and invalidation. Use this skill whenever the user wants caching, to cache a query/response, IMemoryCache, Redis/distributed cache, HybridCache, output caching, or asks…
Generate a CI/CD pipeline for a .NET app — GitHub Actions or Azure DevOps — with restore, build, test, coverage, vulnerability scan, container build, and deploy stages. Use this skill whenever the user wants a CI/CD pipeline, GitHub Actions workflow, Azure DevOps YAML, build/test automation, a release pipeline, or…
Scaffold a .NET solution using Clean Architecture or Vertical Slice Architecture. Use this skill whenever the user wants to start a new .NET project/solution, structure an existing one, add a new feature/use-case/slice, set up layers (Domain, Application, Infrastructure, API), wire up CQRS/MediatR, or asks "how should…
Run the whole toolkit against a .NET repo and produce a single scored "health dashboard" - an overall score plus per-category scores (security, architecture, EF/database, performance, observability, testing, dependencies, code quality), each with findings and the top fixes. Use this skill whenever the user wants a…
Add correlation-ID middleware to ASP.NET Core so every request has a traceable id flowing through logs, downstream HTTP calls, and messaging. Use this skill whenever the user wants a correlation id, request id, to trace a request across services in logs, propagate an id to downstream calls, or asks "how do I add a…
Set up CQRS with MediatR (or a thin custom dispatcher) in an ASP.NET Core project — commands, queries, handlers, and pipeline behaviors for validation, logging, and transactions. Use this skill whenever the user wants CQRS, MediatR, command/query handlers, a request pipeline, MediatR behaviors, or asks "how do I add…
Decide whether a .NET feature/aggregate should be built as CRUD, Event Sourcing, or an event-driven design — and give the concrete implementation path. Use this skill whenever the user describes a domain, feature, aggregate, table, or entity and asks "CRUD or event sourcing?", "should this be event-sourced?", "is…
Add database resiliency to EF Core — connection retry on transient failures, command timeouts, and safe retry with transactions/execution strategy. Use this skill whenever the user wants connection resiliency, retry on failure, transient fault handling, EnableRetryOnFailure, execution strategy, or asks "how do I…
Audit EF Core DbContext and entity configuration for correctness and performance pitfalls — tracking defaults, lazy loading, missing configuration, connection setup, sensitive data logging, and pooling. Use this skill whenever the user shares a DbContext, OnModelCreating, IEntityTypeConfiguration, AddDbContext setup…
Generate Domain-Driven Design building blocks in C# — aggregates, entities, value objects, domain events, and invariant-protecting factory methods. Use this skill whenever the user wants a DDD aggregate, value object, domain event, rich domain model, bounded context structure, encapsulated invariants, or asks "how do…
Scan a .NET project's NuGet dependencies for known vulnerabilities, deprecated/outdated packages, and transitive risks, then recommend safe upgrades. Use this skill whenever the user wants to check dependencies for CVEs, vulnerable packages, outdated NuGet, transitive vulnerabilities, supply-chain risk, or asks "are…
Diagnose and fix broken distributed traces in .NET — missing spans, broken context propagation across HTTP/messaging, orphaned traces, and missing instrumentation. Use this skill whenever the user has traces that don't connect across services, missing spans, broken trace context, propagation issues over HTTP/queues…
Generate an optimized multi-stage Dockerfile and .dockerignore for a .NET app — small final image, layer caching, non-root user, and best practices. Use this skill whenever the user wants a Dockerfile, to containerize a .NET app, a multi-stage build, smaller images, chiseled/distroless images, or asks "how do I…
Analyze and optimize Entity Framework Core queries in .NET code. Use this skill whenever the user shares EF Core / LINQ-to-Entities code, a DbContext, a repository, or a slow query and wants it reviewed or sped up — or mentions N+1, lazy loading, AsNoTracking, slow EF queries, cartesian explosion, projections, or "why…
Recommend database indexes for EF Core entities based on how they're actually queried — filters, joins, ordering, and uniqueness — and generate the HasIndex configuration. Use this skill whenever the user wants index recommendations, asks why a query is slow due to a missing index, wants to add indexes…
Review EF Core migrations for destructive or risky operations before they hit production — dropped columns/tables, non-nullable adds without defaults, renames that drop data, type changes, and long-locking operations. Use this skill whenever the user has an EF Core migration, a generated Migration.cs, a pending schema…
Diagnose garbage-collection pressure in a .NET service — Large Object Heap usage, Gen2 churn, allocation rate, server vs workstation GC, and config — and recommend fixes. Use this skill whenever the user reports GC pauses, high CPU in GC, memory growth, LOH fragmentation, Gen2 collections, or asks "why is the GC…
Add ASP.NET Core health checks with a liveness/readiness split and dependency checks (database, cache, message broker) for Kubernetes and load balancers. Use this skill whenever the user wants health checks, liveness/readiness probes, /health endpoints, dependency health, Kubernetes probes, or asks "how do I add…
Guide profiling a .NET app to find the real hot paths before optimizing — which tool to use (dotnet-trace, dotnet-counters, PerfView, VS Profiler), how to capture, and how to read the results. Use this skill whenever the user wants to profile, find bottlenecks, figure out what's slow, capture a trace, read a flame…
Set up integration tests for an ASP.NET Core app using WebApplicationFactory and Testcontainers. Use this skill whenever the user wants integration tests, end-to-end API tests, tests that hit a real database, WebApplicationFactory setup, Testcontainers, test fixtures with a real Postgres/SQL Server/Redis, or asks "how…