Skip to content
Agentmart
Submit a tool

data-access

Production data-access playbook for the N+1 query problem.

Skill by sshdkeyu

IndexedMIT
Write a review

Install

Works with Claude Code, Claude apps, Codex, Cursor, Gemini CLI, GitHub Copilot, VS Code, OpenCode, Goose, Windsurf. Read the repository before you give any tool access to your data.

npx agentmarket install skill/sshdkeyu-data-access

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

We use your email only for this newsletter. Privacy

About

Production data-access playbook for the N+1 query problem. Use when code queries a database inside a loop, an ORM lazy-loads a relation per row, or a list endpoint is fast at 5 rows and slow at 50. Worked cases are in references/bad-vs-good.md. Do not use for HTTP contract design or for Go/JavaScript language style.

Use cases: documents, design, backend, data

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this skill can do and what it asks for, from its SKILL.md. Checked Oct 25, 2026.

Tools
No tools found
Secrets
None asked for
Install scripts
None found

Network hosts it talks to 1

  • codeload.github.com · found in install command

Files it touches

  • ~/.claude/skills/data-access

What's inside

Skill name
data-access
Description
Production data-access playbook for the N+1 query problem. Use when code queries a database inside a loop, an ORM lazy-loads a relation per row, or a list endpoint is fast at 5 rows and slow at 50. Worked cases are in references/bad-vs-good.md. Do not use for HTTP contract design or for Go/JavaScript language style.
License
MIT
Instructions
13 lines in SKILL.md · view on GitHub

Files (3)

  • README.md
  • SKILL.md
  • bad-vs-good.md · references/

SKILL.md (first lines)

# Data access

Rule `03` is the floor: no N+1, no `SELECT *` on a hot path, queries index-backed, large lists paginated. This skill is how that rule fails when an ORM or a loop hides the round trips.

Read [references/bad-vs-good.md](references/bad-vs-good.md) before loading a relation from a collection, marking a mapping eager, or joining a one-to-many into a paged list.

## Done when

- A list of N parents does not issue N queries for the same relation.
- The query log or a trace shows a fixed number of statements (1 or 2, or 1 + N/batch), not one per row.
- A page of parents returns the number of parents you asked for, not a page of joined rows.

From sshdkeyu/skill-prod-cursor, MIT.

Signals

Stars
0
Forks
0
Open issues
0
Last commit (this folder)
Oct 17, 2026 (11 days ago)

From GitHub (fetched Oct 24, 2026).

Details

License
MIT
First seen
Oct 24, 2026
Last checked
Oct 24, 2026

More from sshdkeyu

Cite this page

data-access skill. Agent Mart. https://agentmart.dev/skills/sshdkeyu-data-access (last updated 2026-10-24)