Agent skill

Efcore Patterns

by atherio-danp in atherio-danp/cde-dotnetcc

Add or change EF Core (Npgsql/PostgreSQL) persistence in the .NET backend — entities, EF configurations, repositories, queries, migrations.

No licenceAuto-check: notesDatabases

Install Efcore Patterns

skills CLI
$ npx skills add atherio-danp/cde-dotnetcc --skill efcore-patterns -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install atherio-danp/cde-dotnetcc efcore-patterns --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/atherio-danp/cde-dotnetcc.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/efcore-patterns .claude/skills/efcore-patterns && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
efcore-patterns
GitHub stars
109
Token cost
~1k tokens
SKILL.md length
350 words
Files
1
Skills in repo
13
Repo updated
First seen
Licence
None found

At a glance

Add or change EF Core (Npgsql/PostgreSQL) persistence in the .NET backend — entities, EF configurations, repositories, queries, migrations.

  • Works in 5 steps: Classify — entity + EF config /… → Locate the feature slice — entity in… → Generate (C# via Serena create_text_file… → …
  • Adding a table/entity
  • SKILL.md covers Steps and Hard rules (non-negotiable —…
  • Calls dotnet

What it does

Efcore Patterns is an agent skill from atherio-danp/cde-dotnetcc. Add or change EF Core (Npgsql/PostgreSQL) persistence in the .NET backend — entities, EF configurations, repositories, queries, migrations. Use when adding a table/entity, a query, a repository, or a migration under apps/api.

Its SKILL.md is about 1k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases. It works with PostgreSQL and .NET. The repository describes itself as: Claude Code harness for .NET developers.

When your agent uses it

  • Adding a table/entity
  • A migration under apps/api

Example prompts

  • “/efcore-patterns”

Requirements

  • Pre-approved tools (allowed-tools): Read, Glob, Grep, Bash, mcp__serena__initial_instructions, mcp__serena__get_symbols_overview, mcp__serena__find_symbol, mcp__serena__find_referencing_symbols, mcp__serena__find_declaration, mcp__serena__find_implementations, mcp__serena__search_for_pattern, mcp__serena__get_diagnostics_for_file, mcp__serena__list_dir, mcp__serena__find_file, mcp__serena__create_text_file, mcp__serena__replace_symbol_body, mcp__serena__insert_after_symbol, mcp__serena__insert_before_symbol, mcp__serena__replace_content, mcp__serena__rename_symbol, mcp__serena__safe_delete_symbol

Workflow steps

5 steps, taken from the first numbered list in SKILL.md.

  1. Classify — entity + EF config / repository (write side, per aggregate root) / query (read side,
  2. Locate the feature slice — entity in {{ProjectName}}.Domain/; EF config + repo in
  3. Generate (C# via Serena create_text_file / symbol edits — native .cs edits are blocked)
  4. Migration — dotnet ef migrations add ; review the generated Postgres DDL; never edit an
  5. Validate — dotnet build zero warnings; tests via the testing-expert per the plan.

What it can do on your machine

Read from SKILL.md and the folder at commit c72a3f9. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves these tools, so the agent can use them without asking each time:

    • Read
    • Glob
    • Grep
    • Bash
    • mcp__serena__initial_instructions
    • mcp__serena__get_symbols_overview
    • mcp__serena__find_symbol
    • mcp__serena__find_referencing_symbols
    • mcp__serena__find_declaration
    • mcp__serena__find_implementations

    …and 11 more on the same allowed-tools line.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • dotnet

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Efcore Patterns loads about 1k tokens when it runs. Until then it costs about 60 tokens; SKILL.md has 350 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~60
When it runs · the whole SKILL.md, loaded when a task matches
~1k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check: notes

The automated check noted patterns worth knowing about, such as sudo or a known installer.

  • NotePre-approves every shell command (allowed-tools: Bash)SKILL.md
    allowed-tools: Read, Glob, Grep, Bash, mcp__serena__initial_instructions, mcp__serena__get_symbols_overview, mcp__s

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Without a licence we can't republish the file, so here is its outline and opening line. It has 350 words (~1,013 tokens).

“Source of truth (read it; do not duplicate): .claude/rules/backend/persistence.md and docs/projectStandards/backend-architecture.md §7–§8. We use EF Core with the Npgsql provider — yes EF Core, just not SQL Server.”

— opening of SKILL.md by atherio-danp
name
efcore-patterns
allowed-tools
Read, Glob, Grep, Bash, mcp__serena__initial_instructions, mcp__serena__get_symbols_overview, mcp__serena__find_symbol, mcp__serena__find_referencing_symbols, mcp__serena__find_declaration, mcp__serena__find_implementations, mcp__serena__search_for_pattern, mcp__serena__get_diagnostics_for_file, mcp__serena__list_dir, mcp__serena__find_file, mcp__serena__create_text_file, mcp__serena__replace_symbol_body, mcp__serena__insert_after_symbol, mcp__serena__insert_before_symbol, mcp__serena__replace_content, mcp__serena__rename_symbol, mcp__serena__safe_delete_symbol
argument-hint
<entity or feature name>

Read the full SKILL.md on GitHub

Files

Just SKILL.md in .claude/skills/efcore-patterns of atherio-danp/cde-dotnetcc.

Open the folder on GitHubat commit c72a3f9

Compare with similar skills

Efcore Patterns next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Efcore Patterns compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Efcore Patterns this skillatherio-danp/cde-dotnetcc109—~1kAutomated safety check: NotesNone
Aspire DevchainNethereum/Nethereum2.3k—~1kAutomated safety check: PassMIT
Blockchain IndexingNethereum/Nethereum2.3k—~4.8kAutomated safety check: PassMIT
Creating Oracle To Postgres Master Migration Plangithub/awesome-copilot40k1 repos~862Automated safety check: PassMIT
Migrating Oracle To Postgres Data Access Codegithub/awesome-copilot40k—~2kAutomated safety check: PassMIT
Event Store Designwshobson/agents40k9 repos~828Automated safety check: PassMIT

Similar skills

  • Aspire Devchain

    Nethereum/Nethereum

    Help users create and run a local Ethereum development environment with .NET Aspire — DevChain node, blockchain indexer, Blazor explorer, and PostgreSQL.

    2.3k GitHub stars~1k tokensUpdated 3 days ago
    DatabasesAuto-check passed
  • Blockchain Indexing

    Nethereum/Nethereum

    Index blockchain data (blocks, transactions, logs, tokens) to PostgreSQL/SqlServer/SQLite with progress tracking, reorg handling, and hosted services (.NET/C).

    2.3k GitHub stars~4.8k tokensUpdated 3 days ago
    DatabasesAuto-check passed
  • Discovers all projects in a .NET solution, classifies each for Oracle-to-PostgreSQL migration eligibility, and produces a persistent master migration plan.

    40k GitHub starsUsed in 1 repo~862 tokens
    DatabasesAuto-check passed
  • Event Store Design

    wshobson/agents

    Designs event stores for event-sourced systems: requirements, a comparison of EventStoreDB, PostgreSQL, Kafka, DynamoDB and Marten, and stream and versioning practices.

    40k GitHub starsUsed in 9 repos~828 tokens
    Backend & APIsAuto-check passed
  • Azure PostgreSQL Flexible Server SDK for .NET. An agent skill from microsoft/skills.

    3.1k GitHub starsUsed in 6 repos~4k tokens
    DevOps & CloudAuto-check passed

More from atherio-danp/cde-dotnetcc

All 13 skills in this repo
  • MCP Csharp

    atherio-danp/cde-dotnetcc

    Create, debug, test, and publish MCP (Model Context Protocol) servers in C using the official ModelContextProtocol SDK — tools/prompts/resources, stdio vs HTTP transport, MapMcp hosting.

    109 GitHub stars~1.2k tokensUpdated 2 mo ago
    Auto-check: notes
  • Microbenchmarking

    atherio-danp/cde-dotnetcc

    Create, run, configure, and interpret BenchmarkDotNet microbenchmarks in the .NET API — measure and compare approaches, runtime configs, or package versions.

    109 GitHub stars~979 tokensUpdated 2 mo ago
    Auto-check: notes
  • Otel Instrumentation

    atherio-danp/cde-dotnetcc

    Add or change OpenTelemetry tracing, metrics, and structured logging in the .NET API (apps/api) — OTLP exporter setup, custom ActivitySource spans, IMeterFactory metrics, log/trace correlation.

    109 GitHub stars~1.3k tokensUpdated 2 mo ago
    Auto-check: notes
  • Dotnet AI Stack

    atherio-danp/cde-dotnetcc

    Choose and wire AI features in the .NET backend — LLM calls, agentic tool-calling/multi-step workflows, RAG/vector search, structured output, streaming.

    109 GitHub stars~1.2k tokensUpdated 2 mo ago
    Auto-check: notes
  • Dotnet Performance Review

    atherio-danp/cde-dotnetcc

    Scan .NET/C code for performance anti-patterns (async, memory/strings, collections/LINQ, regex, serialization, I/O) with tiered severity, reporting findings without editing.

    109 GitHub stars~1k tokensUpdated 2 mo ago
    Auto-check: notes
  • Efcore Query Performance

    atherio-danp/cde-dotnetcc

    Optimize EF Core (Npgsql/PostgreSQL) queries in the .NET API — fix N+1, choose tracking modes, use compiled queries, split queries, and avoid translation traps.

    109 GitHub stars~1.1k tokensUpdated 2 mo ago
    Auto-check: notes

Works with

Categories

Questions about Efcore Patterns

What does Efcore Patterns do?

Add or change EF Core (Npgsql/PostgreSQL) persistence in the .NET backend — entities, EF configurations, repositories, queries, migrations. Efcore Patterns is an agent skill from atherio-danp/cde-dotnetcc.NET backend — entities, EF configurations, repositories, queries, migrations.

When should I use Efcore Patterns?

Efcore Patterns fits situations like: adding a table/entity; A migration under apps/api.

How do I install Efcore Patterns in Claude Code?

Run `npx skills add atherio-danp/cde-dotnetcc --skill efcore-patterns -a claude-code`. Or copy the skill folder (.claude/skills/efcore-patterns in atherio-danp/cde-dotnetcc) into .claude/skills/efcore-patterns in your project. Claude Code loads it when a task matches its description.

How do I install Efcore Patterns in Codex?

Run `npx skills add atherio-danp/cde-dotnetcc --skill efcore-patterns -a codex`. Or copy the skill folder (.claude/skills/efcore-patterns in atherio-danp/cde-dotnetcc) into .agents/skills/efcore-patterns in your project. Codex loads it when a task matches its description.

Can I use Efcore Patterns in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add atherio-danp/cde-dotnetcc --skill efcore-patterns -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/efcore-patterns, .gemini/skills/efcore-patterns, .github/skills/efcore-patterns and .opencode/skills/efcore-patterns in your project.

What does Efcore Patterns need to run?

Going by SKILL.md and its folder, Efcore Patterns needs the command-line tools its instructions call (dotnet). Its frontmatter pre-approves these tools: Read, Glob, Grep, Bash, mcp__serena__initial_instructions, mcp__serena__get_symbols_overview, mcp__serena__find_symbol, mcp__serena__find_referencing_symbols, mcp__serena__find_declaration, mcp__serena__find_implementations, mcp__serena__search_for_pattern, mcp__serena__get_diagnostics_for_file, mcp__serena__list_dir, mcp__serena__find_file, mcp__serena__create_text_file, mcp__serena__replace_symbol_body, mcp__serena__insert_after_symbol, mcp__serena__insert_before_symbol, mcp__serena__replace_content, mcp__serena__rename_symbol, mcp__serena__safe_delete_symbol.

Does Efcore Patterns access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Efcore Patterns safe to install?

Our automated static check of SKILL.md found notes only (pre-approves every shell command (allowed-tools: bash)), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.

What licence does Efcore Patterns use?

No licence was found for Efcore Patterns or its repository. Without one, default copyright applies: ask the author before reusing or redistributing it.

How many tokens does Efcore Patterns use?

About 1k tokens (SKILL.md is roughly 4.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Efcore Patterns?

Skills that share tags, products or a category with Efcore Patterns: Aspire Devchain (Nethereum/Nethereum, 2.3k stars), Blockchain Indexing (Nethereum/Nethereum, 2.3k stars), Creating Oracle To Postgres Master Migration Plan (github/awesome-copilot, 40k stars) and Migrating Oracle To Postgres Data Access Code (github/awesome-copilot, 40k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Efcore Patterns?

atherio-danp (a GitHub user) maintains it in atherio-danp/cde-dotnetcc, which has 109 GitHub stars. The repository holds 13 skills in this directory. The repository was last updated on July 26, 2026.

Source: atherio-danp/cde-dotnetcc on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.