SKILL

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。第三方内容及版权归原作者,使用条件以原文为准。

许可原文 ↗

本站没有因同步、复制或用户自报成功而将资源标为运行验证通过。

限制与注意事项

  • 元数据收录不代表本站已经安装、适配、实测或进行安全审查。