QualityC#

Optimizing EF Core Queries

by dotnet

Optimizing EF Core Queries is a Quality skill for Claude Code, published by dotnet in skills.

5.2K stars384 forkson dotnet/skillsAdded 2026/08/16Repository updated 2026/08/15
agent-skills
Install in seconds
Install Optimizing EF Core Queries
Copy Optimizing EF Core Queries into your Claude Code skills folder. Run the command in your terminal, or review the source on GitHub before installing.
terminal
npx degit https://github.com/dotnet/skills/tree/main/plugins/dotnet-data/skills/optimizing-ef-core-queries ~/.claude/skills/optimizing-ef-core-queries

Requires Node.js. Downloads this skill only — not the rest of the repository — into your Claude Code skills folder.

Without Node.js

git clone https://github.com/dotnet/skills.git

Clones the whole repository, then copy the skill’s own directory into your skills folder yourself.

In this catalog

Source file
plugins/dotnet-data/skills/optimizing-ef-core-queries/SKILL.md in dotnet/skills
Installs to
~/.claude/skills/optimizing-ef-core-queries
Collection
One of 25 skills cataloged from this repository
Category
Quality1354 skills

What Optimizing EF Core Queries does

Optimizing EF Core Queries diagnoses and fixes slow Entity Framework Core queries by reducing generated SQL, database round-trips, and per-call translation cost. Use it when an EF Core query or data-access path is slow, emits N+1 statements, or pays LINQ translation overhead on every call.

Optimizing EF Core Queries is cataloged under Quality on DirSkills. Optimizing EF Core Queries comes from a repository tagged agent-skills.

Documentation

README

Optimizing EF Core Queries

Diagnose and fix slow Entity Framework Core (EF Core) queries. Start from the generated SQL/logs, apply the smallest change that removes the bottleneck, and confirm the fix by re-reading the SQL and the query count. Prefer changes that reduce round-trips, duplicated rows, scans, or per-call translation cost over micro-optimizations. Apply one change at a time and re-measure.

When to Use

This is the opening of the README. Read the full README on GitHub.

Commands Optimizing EF Core Queries provides

Slash commands named in this skill’s SKILL.md, listed in the order they first appear.

  • /arithmetic

Frequently asked about Optimizing EF Core Queries

  • What else does dotnet publish alongside Optimizing EF Core Queries?

    Optimizing EF Core Queries is one of 25 skills that DirSkills catalogs from dotnet/skills, the repository it ships in. Its siblings there include .NET P/Invoke, ASP.NET Core Web API and Agentic Workflows. Each one is a separate skill with its own page in this directory, installs the same way Optimizing EF Core Queries does, and is maintained by dotnet in that same repository. The rest of the collection is listed on the dotnet/skills page.

  • How does Optimizing EF Core Queries compare to other Quality skills?

    Optimizing EF Core Queries ranks #290 by stars among the 1354 Quality skills in this catalog. The most-starred ones next to it are Benchmark, Benchmark Optimization Loop and API Design Patterns. DirSkills ranks by the star count of the repository each skill ships in, so that order reflects how popular those repositories are rather than any review of Optimizing EF Core Queries against them. Open each page to compare what they document and how they install.

More from dotnet/skills

Optimizing EF Core Queries is one of 25 skills cataloged on DirSkills from dotnet/skills.

See all 25 skills
🔌
2w ago

.NET P/Invoke

.NET P/Invoke correctly calls native C/C++ libraries from .NET using DllImport and LibraryImport, covering signatures, strings, memory, SafeHandle, and cross-platform patterns. Use it for writing, reviewing, or debugging native interop code in .NET.
Quality
5.2K384
🌐
2w ago

ASP.NET Core Web API

ASP.NET Core Web API guides the creation and modification of ASP.NET Core Web API endpoints with correct HTTP semantics, OpenAPI metadata, and error handling. Use it when adding controllers or minimal APIs, defining DTOs, wiring up OpenAPI/Swagger, or configuring global error handling middleware.
DevOps
5.2K384
🔀
2w ago

Agentic Workflows

Agentic Workflows routes requests to design, create, update, debug, or upgrade agentic workflows to the correct prompt files. Use it when a user asks to build or modify agentic workflows in a repository, and follow the matching prompt or skill.
AI Engineering
5.2K384
🧩
2w ago

Author Blazor Component

Author Blazor Component creates or reviews Blazor components (.razor files) with correct architecture for parameters, EventCallback, RenderFragment slots, lifecycle, async patterns, and disposal. Use it when writing new Blazor components that do not involve JavaScript interop, forms, prerendering, or HTTP data fetching.
Frontend
5.2K384
🔗
2w ago

Blazor JS Interop

Blazor JS Interop provides patterns for adding, reviewing, and fixing JavaScript interop in Blazor components. Use it for collocated .razor.js modules, IJSRuntime lifecycle, DotNetObjectReference callbacks, and batching interop calls.
Frontend
5.2K384
💻
2w ago

C# Scripts

C# Scripts runs file-based C# apps with the .NET CLI when the user wants C#/.NET code without creating a project. Use for C# language/API experiments, one-file C# apps, and small multi-file C# apps using #:include/#:exclude or #:ref.
Automation
5.2K384