- Home
- Skills
- Data & Databases
- .NET EF Core Query Detective
Works with the AI Agents you already use
.NET EF Core Query Detective
Investigate slow EF Core queries with evidence, identify likely causes, and plan safe, measurable fixes without inventing performance results.
Free
About this skill
Slow database calls can make an otherwise healthy application feel broken. .NET EF Core Query Detective helps your coding agent trace a slow query from request to database and prepare a focused investigation.
What it reviews
- Potential N+1 round trips and lazy-loading loops.
- Premature materialization, over-fetching, tracking and pagination.
- SQL, plans, existing indexes and supplied measurements when available.
- Whether a proposed query change preserves results and update behavior.
How it works
Give your agent an affected endpoint, query or trace. It inspects the relevant code and available evidence, distinguishes observed findings from hypotheses, and proposes focused next steps. Ask for a fix or tests if desired.
Limitations
This is an agent instruction skill, not an automatic profiler or database scanner. Source review cannot establish runtime bottlenecks or speedups. Accurate measurement requires a representative isolated environment. It does not connect to production or apply migrations by default. Artwork is illustrative.
Source-only findings are hypotheses. No performance improvement is guaranteed; benchmark results depend on the provider, workload and data. No independent behavioral benchmark has been run. Cover artwork is an illustration.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Free forever
No account required to browse
Trust & safety
Security scan
Security scan passed 3 days ago
- Free with an Agensi account
Permissions
Reads the relevant project and provided evidence. Shell, file writes and network are conditional on the requested tests, fixes or documentation lookup. No production access is assumed.