fix-slow-queries
利用 Cloud 和 Neon 证据、本地复现、性能与结果比较、回归测试,以及检查通过的 PR,诊断并修复缓慢的 Paperclip PostgreSQL 查询。用于高成本查询、重复数据库工作,或疑似数据库导致的慢请求。
译文已校对查看英文原文
Diagnose and fix slow Paperclip PostgreSQL queries using Cloud and Neon evidence, local reproduction, performance and result comparisons, regression tests, and a PR with passing checks. Use for costly queries, repeated database work, or slow requests with a suspected database cause.
适用对象:数据库。自动收录 · 待核查。
原作者说明节选
从固定版本的 SKILL.md 提取,保留原文语言。以下内容属于作者说明,本站尚未验证安装、兼容或运行结果。
查看英文原文
原文涵盖的主题
- Fix Slow Queries
- 1. Establish the target and finish line
- 2. Find the actual database and rank the work
- 3. Trace each candidate to its behavior
- 4. Reproduce the baseline locally
- 5. Implement and prove both kinds of green
- 6. Verify the blast radius
- 7. Create the PR and carry it through checks
Deliver a measured improvement with preserved behavior and a reviewable PR whose latest commit passes checks. A list of suspicious SQL or an unverified rewrite is an intermediate result. Respect a narrower request for diagnosis only. Resolve the reported URL, environment, company/workspace, deployed revision, owning repository, and local checkout. Read its AGENTS.md and scoped rules. Paperclip and the private paperclip-cloud control plane have different rules. Work in a dedicated branch/worktree. Reuse suitable existing work; keep the checkout running a live server out of branch switching and benchmark setup. Select a bounded batch, usually the top two or three query families. Record deferred candidates so discovery does not turn into an unbounded rewrite. The finish line is: reproducible baseline, faster treatment, output/behavior proof, relevant regression coverage, and green checks on each final PR head. A concrete access or infrastructure blocker must be reported as incomplete. Read Cloud discovery when starting from a hosted workspace. Follow the chain from Paperclip Cloud fleet admin to the stack's Neon project, branch, endpoint, database, and runtime role. Record the corresp
这里只展示节选,请以完整原文和当前要求为准。
- 来源仓库
- paperclipai/paperclip
- 源文件
- .agents/skills/fix-slow-queries/SKILL.md
- 固定版本
- 1ca3e8ea2a759e511ab2d2659339c6c770a7a2ba
准备条件
- 本条仅收录原作者的技能元数据;请阅读完整说明,确认依赖、许可与使用条件。
第一件可以尝试的小事
先阅读原作者说明,再决定是否在自己的 AI 工具中使用。
对应 AI 工具说明
作者有说明不等于本站实机验证。没有证据时,不自动标为兼容、安全或免费。
来源与内容状态
本条为自动发现的元数据,尚未完成人工文档核查;适用性与运行结果待核查。
原作者:paperclipai/paperclip · 原作者仓库元数据。文档核查:未核查。最近来源检查:2026-11-10T02:01:27.163Z。
分类由名称、说明与路径规则生成,分类不代表已核实适配。
许可与权利归属
MIT。第三方内容及版权归原作者,使用条件以原文为准。
许可原文 ↗本站没有因同步、复制或用户自报成功而将资源标为运行验证通过。
限制与注意事项
- 元数据收录不代表本站已经安装、适配、实测或进行安全审查。