---
title: "Database Performance Patterns - Air Market"
description: "Slow screens are often slow because the code asks the database far more often, or for far more data, than it needs. This covers the access patterns that avoid that. Reach for it when a page or endpoi…"
canonical: "https://airmarket.ai/app/database-performance"
---

[Air Market](/) / [Data & Analytics](/category/data) / Database Performance Patterns

Skill by [Aaron Stannard](/@aaronontheweb)

# Database Performance Patterns

Stop your data layer from making a hundred trips

## What this does

Slow screens are often slow because the code asks the database far more often, or for far more data, than it needs. This covers the access patterns that avoid that. Reach for it when a page or endpoint drags and you suspect the data layer.

### Top 3 things it does for you

- Find and fix N+1 query patterns
- Split my reads from my writes
- Trim queries that pull back too much

## Information

**Database Performance Patterns at a glance**

|  |  |
| --- | --- |
| Kind | Skill |
| Publisher | [Aaron Stannard](/@aaronontheweb) |
| Category | [Data & Analytics](/category/data) |
| Works with | Agent Skills - an open standard supported by 40+ agents |
| Size | 14 KB |
| Licence | MIT |
| Repository | [Aaronontheweb/dotnet-skills](https://github.com/Aaronontheweb/dotnet-skills/tree/316756fb309b9ee42d86d5db0d70504d62f3b0c3/skills/database-performance) |
| GitHub stars | 1,123 (as of Nov 2026) |

## Security report

**Verified.** AIR scanned this exact version of Database Performance Patterns and flagged nothing. AIR's verdict: **safe**.

**What Database Performance Patterns's check was run against**

|  |  |
| --- | --- |
| Commit | 316756fb309b9ee42d86d5db0d70504d62f3b0c3 |
| Content hash | 7e72f5ee6fd100b0c4504d61718fb32704deaebb3cba2704dd933f35afeafc59 |
| Files read | [Browse the files at this exact commit](https://github.com/Aaronontheweb/dotnet-skills/blob/316756fb309b9ee42d86d5db0d70504d62f3b0c3/skills/database-performance/SKILL.md) |

A scan is named by the exact content it read, not by a version number. A different version is a different artifact, and nothing here applies to a version AIR has not scanned.

[Read the full security report for Database Performance Patterns](/security/database-performance)

## About Database Performance Patterns

This skill collects database access patterns aimed at performance: separating read and write models, avoiding N+1 queries, using AsNoTracking, applying row limits, and never doing joins on the application side.

The guidance applies whether your data access goes through EF Core or Dapper.

## What's inside

- SKILL.md - instructions

## Questions

### Is Database Performance Patterns safe to install?

AIR scanned this exact version of Database Performance Patterns and flagged nothing. AIR's verdict: safe. The verdict is named by the content that was read, at commit 316756fb309b, so it cannot drift onto a version nobody scanned. The full report is at https://airmarket.ai/security/database-performance.

### How do I install Database Performance Patterns?

Open https://airmarket.ai/app/database-performance on Air Market and use the install action: Air Market hands Claude a prompt naming this exact skill, and Claude sets it up. Source, pinned to the exact commit this listing describes: https://github.com/Aaronontheweb/dotnet-skills/tree/316756fb309b9ee42d86d5db0d70504d62f3b0c3/skills/database-performance. Install from that link, not the branch.

## Related on Air Market

- [More Data & Analytics listings](/category/data)
- [Everything by Aaron Stannard](/@aaronontheweb)

---

Canonical URL: <https://airmarket.ai/app/database-performance>