fix-slow-queries SKILL.md skillA

fix-slow-queries from paperclipai/paperclip is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add paperclipai/paperclip/fix-slow-queries@git:20261014.739f9e4

Pins git:20261014.739f9e4 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
paperclipai/paperclip
Path
.agents/skills/fix-slow-queries/SKILL.md
Versions recorded
1
Latest version
git:20261014.739f9e4, committed Oct 14, 2026
Size
11,371 bytes
Repository stars
105,684
License
MIT

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.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Fix Slow Queries

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.

## 1. Establish the target and finish line

- 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.

## 2. Find the actual database and rank the work
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add paperclipai/paperclip/fix-slow-queries@sha256:0904852076325a41

The line at the top of this page pins the label git:20261014.739f9e4, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_ocqzq3p4wzyakn4k.svg)](https://markdownregistry.com/a/art_ocqzq3p4wzyakn4k)

1 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on Oct 14, 2026.

versioncommittedcommitsizeaudit
git:20261014.739f9e4 latest2026-10-14 739f9e4 11,371 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (11371 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

paperclipai/paperclip · 105,684 stars · license MIT · pushed 2026-10-22 · branch master

API

GET https://markdownregistry.com/api/v1/artifacts/art_ocqzq3p4wzyakn4k
GET https://markdownregistry.com/api/v1/resolve?ref=paperclipai/paperclip/fix-slow-queries
GET https://markdownregistry.com/api/v1/blob/0904852076325a4148a2020dd171ddec2fe06bccac77889320e78c6d497d4ccd

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from paperclipai/paperclip

add-product-e2e-eval SKILL.md skill
paperclipai/paperclip · .agents/skills/add-product-e2e-eval/SKILL.md · Add or extend a Paperclip full-stack runner E2E workflow, fixture, matcher, or report evidence path for local or…
git:20260916.18989a9 · audit A · 105,684 stars
add-runner-eval SKILL.md skill
paperclipai/paperclip · .agents/skills/add-runner-eval/SKILL.md · Add or extend a Paperclip Runner protocol evaluation definition, roster, assertion, or report fixture with provenance…
git:20260916.18989a9 · audit A · 105,684 stars
check-pr SKILL.md skill
paperclipai/paperclip · .agents/skills/check-pr/SKILL.md · Check a GitHub, GitLab, or Perforce PR/MR/CL for review comments, failing checks, and PR-body gaps. Use when asked to…
v1.3 · audit A · 105,684 stars
company-creator SKILL.md skill
paperclipai/paperclip · .agents/skills/company-creator/SKILL.md · Create agent company packages that conform to agentcompanies/v1. Use when asked to create a company, scaffold an agent…
git:20260710.953b315 · audit A · 105,684 stars
create-agent-adapter SKILL.md skill
paperclipai/paperclip · .agents/skills/create-agent-adapter/SKILL.md · Create or modify Paperclip agent adapters across server, UI, and CLI surfaces. Use when adding support for a new CLI…
git:20260914.f1d5786 · audit A · 105,684 stars
create-external-bot-integration SKILL.md skill
paperclipai/paperclip · .agents/skills/create-external-bot-integration/SKILL.md · Build and qualify external bots such as Dot in Paperclip. Use for two-way work, invitation, identity, wakeup, Runner…
git:20261013.69f4bfc · audit A · 105,684 stars
create-issue-interaction-ui SKILL.md skill
paperclipai/paperclip · .agents/skills/create-issue-interaction-ui/SKILL.md · Add a new Paperclip issue-thread interaction kind end-to-end. Use when repo work introduces or extends interaction…
git:20261012.88bf4c6 · audit A · 105,684 stars
create-paperclip-bundled-skill SKILL.md skill
paperclipai/paperclip · .agents/skills/create-paperclip-bundled-skill/SKILL.md · Turn an idea, tweet, or task into a skill in the Paperclip skills catalog (packages/skills-catalog). Use when asked to…
git:20260730.c62fa8d · audit A · 105,684 stars
create-verification-skill SKILL.md skill
paperclipai/paperclip · .agents/skills/create-verification-skill/SKILL.md · Generate a project-local verification skill that drives your app the way a user does — any language, framework, or…
git:20261012.7d9b93a · audit A · 105,684 stars
deal-with-security-advisory SKILL.md skill
paperclipai/paperclip · .agents/skills/deal-with-security-advisory/SKILL.md · Handle confidential GitHub Security Advisory response for Paperclip. Use when coordinating advisory triage…
git:20260710.953b315 · audit A · 105,684 stars
diagnose-why-work-stopped SKILL.md skill
paperclipai/paperclip · .agents/skills/diagnose-why-work-stopped/SKILL.md · Diagnose stalled, looping, or over-recovered Paperclip issue trees and propose a no-code product-rule plan. Use when…
git:20260710.953b315 · audit A · 105,684 stars
doc-maintenance SKILL.md skill
paperclipai/paperclip · .agents/skills/doc-maintenance/SKILL.md · Audit README, SPEC, and PRODUCT docs against recent git history for drift and make minimal PR-ready edits. Use when…
git:20260710.953b315 · audit A · 105,684 stars

Every file in paperclipai/paperclip

Browse by kind, by grade A, or by owner.