스킬 검색.../

Database Rules | Skills Pool

스킬 파일

Database Rules

Entity Framework Core migrations, database design, and query patterns for this project.

mschodin0 스타2026. 2. 17.

직업: 데이터베이스 관리자
카테고리: 데이터 엔지니어링

스킬 내용

Migrations

All schema changes via EF Core migrations: dotnet ef migrations add <Name>
Apply with dotnet ef database update
Review generated migration code before committing — EF sometimes generates unnecessary changes
Never modify existing migrations that have been applied — create new ones for changes
Use dotnet ef migrations remove to undo the last unapplied migration

Entity Framework Core

DbContext

One DbContext per bounded context (for most projects, one is fine)
Register with AddDbContext<AppDbContext>() in DI
Configure entities in OnModelCreating using IEntityTypeConfiguration<T> per entity
Keep configuration close to the entity — co-locate in the same feature folder when using Vertical Slice

Queries

Use for read-only queries (better performance)

관련 스킬

빠른 설치

Database Rules

npx skills add mschodin/event_registration_api

Skill 다운로드 저장소 열기

작성자: mschodin
스타: 0
업데이트: 2026. 2. 17.
직업

이 페이지의 내용

AsNoTracking()

Avoid N+1: use .Include() / .ThenInclude() for eager loading

Use Select() projections to fetch only needed columns

Prefer FirstOrDefaultAsync + null check over SingleAsync when item may not exist

Use AnyAsync() instead of CountAsync() > 0

Always pass CancellationToken to async EF methods

Writes

Use await dbContext.SaveChangesAsync(cancellationToken)
Add entities: dbContext.Events.Add(entity) then SaveChangesAsync
Update: fetch → modify → SaveChangesAsync (change tracking handles it)
Delete: dbContext.Events.Remove(entity) then SaveChangesAsync
Use transactions for multi-step operations: await using var tx = await dbContext.Database.BeginTransactionAsync()

Schema Design

Use int or Guid for primary keys (match project convention)
Include audit columns: CreatedAt (DateTimeOffset), UpdatedAt (DateTimeOffset)
Use enums mapped to strings: .HasConversion<string>()
Configure indexes for frequently queried columns
Use proper cascade delete behavior: .OnDelete(DeleteBehavior.Cascade) or .Restrict

Connection Strings

Store in appsettings.json for default, override per environment
Use dotnet user-secrets for local development database credentials
Never commit connection strings with real credentials
Use IConfiguration to resolve: builder.Configuration.GetConnectionString("DefaultConnection")

02

Entity Framework Core

06Schema Design

07Connection Strings

데이터 엔지니어링

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

데이터 엔지니어링

Clickhouse Io

고성능 분석 워크로드를 위한 ClickHouse 데이터베이스 패턴, 쿼리 최적화, 분석 및 데이터 엔지니어링 모범 사례.

데이터 엔지니어링

Claude Devfleet

通过Claude DevFleet协调多智能体编码任务——规划项目、在隔离的工作树中并行调度智能体、监控进度并读取结构化报告。

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

Ai First Engineering

团队中人工智能代理生成大部分实施输出的工程运营模型。

데이터 엔지니어링

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

데이터베이스 관리자