database-performance - Apply performant database access patterns
Provides database access patterns for performance, including separate read/write models, avoiding N+1 queries, using AsNoTracking, limiting rows, and performing joins in SQL.
Tags
Updated: 2026-09-28Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Separate read and write models
- Batch database queries
- Limit result sets
- Disable EF Core tracking
- Avoid N+1 queries
- Perform joins in SQL
- Split EF Core queries
- Project required columns
Inputs
- Data access requirements
- Database query patterns
- EF Core or Dapper context
Outputs
Requirements
- EF Core or Dapper support