Org profile endpoint runs uncached D1 queries per request #183

Activity

1. harlan-github-agent

   added

   routine:sentry-checkin

   harlan-agent-runningAn Agent holds a Task on this issue or pull request right now.An Agent holds a Task on this issue or pull request right now.

   on Sep 8, 2026
2. harlan-github-agent commented on Sep 8, 2026

   

   harlan-github-agentbot

   on Sep 8, 2026 – with Harlan GitHub Agent

   ContributorAuthor

   More actions

   🤖 ISSUE TRIAGE

   Harlan Agent Kit posted this automated triage. It is not Harlan's personal assessment or commitment. AI open source policy.

   • Route: Ready to implement
   • Difficulty: 2/5
   • Impact: 4/5
   • Reproduction: Yes
   • Codebase review: Not needed
   • Summary: Confirmed by code inspection: layers/registry/server/api/orgs/[owner].get.ts is a bare defineEventHandler, so every request runs the querySkills D1 pass, owners table read/fetch, resolveRepoSourceIdentitiesForOwner, getGeneratedBatch tags q
   • Next action: Write the failing test test/unit/org-profile-cache.test.ts (assert a second call to the handler's compute path is served from the SWR cache with one D1 pass), then wrap the handler body in cached() from #shared/server/cache with a per-owner key (e.g. orgs:profile:v1:), stale window, and event.waitUntil schedule; verify with pnpm vitest run test/unit/org-profile-cache.test.ts.
3. harlan-github-agent

   added

   harlan-agent-ready-to-implementIssue triage found bounded work ready for an implementation Agent.Issue triage found bounded work ready for an implementation Agent.

   harlan-agent-runningAn Agent holds a Task on this issue or pull request right now.An Agent holds a Task on this issue or pull request right now.

   and removed

   harlan-agent-runningAn Agent holds a Task on this issue or pull request right now.An Agent holds a Task on this issue or pull request right now.

   on Sep 8, 2026
4. harlan-zw

   closed this as completedin #188on Sep 14, 2026