database

Configure EF Core entity models, migrations, and PostgreSQL Row-Level Security policies.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/satish-krishna/sigil --skill database-satish-krishna
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/satish-krishna/sigil/tree/main/.claude/skills/database
Command: npx skills add https://github.com/satish-krishna/sigil --skill database-satish-krishna

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

EF Core schema management, migrations, and PostgreSQL Row-Level Security (RLS) patterns are critical for secure, auditable data stores but are error-prone without standardized guidance.

Core Features & Use Cases

  • Entity modeling patterns with Fluent API configurations and audit fields.
  • Migrations as the source of truth for schema changes, with RLS policies and indexing.
  • Soft deletes and query filters to preserve data integrity and auditability.
  • Use Case: Apply these patterns to build robust backends that enforce secure data access controls and scalable schema evolution.

Quick Start

Follow the patterns in this skill to model an EF Core entity, configure RLS, and generate the initial migration for your backend database.

Frequently Asked Questions about database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I configure PostgreSQL Row-Level Security policies with EF Core migrations?

PostgreSQL Row-Level Security policies with EF Core migrations are configured by treating migrations as the source of truth for schema changes, enabling you to define RLS policies alongside standard entity modeling and indexing to enforce secure data access controls.

What is the best way to implement soft deletes and audit fields in an EF Core backend?

Soft deletes and audit fields in an EF Core backend are implemented using Fluent API configurations and query filters to preserve data integrity, automatically tracking CreatedAt, UpdatedAt, and CreatedBy fields for strict auditability.

How do I enforce data integrity when applying versioned schema migrations in EF Core?

Data integrity during versioned schema migrations in EF Core is enforced by applying Fluent API configurations, audit fields, and startup configuration checks, ensuring scalable schema evolution without losing prior data structure constraints.

Does EF Core query filtering work automatically with PostgreSQL Row-Level Security?

EF Core query filtering works alongside PostgreSQL Row-Level Security by applying global query filters for soft deletes, while RLS policies add database-level security to ensure secure, auditable data access controls across backend services.

When should I use Fluent API configurations for entity modeling in EF Core?

Fluent API configurations for entity modeling in EF Core should be used to define schema patterns, configure audit fields, and establish RLS policies, ensuring your backend services maintain strict data integrity and secure access controls.