fix-slow-queries
A maintainer skill in the Paperclip repository for finding and fixing slow PostgreSQL queries in Paperclip, ending in a pull request with passing checks.
What the skill teaches
A maintainer skill in the Paperclip repository for finding and fixing slow PostgreSQL queries in Paperclip, ending in a pull request with passing checks. The agent traces a hosted workspace through Paperclip Cloud to its Neon database and ranks query families by call counts, time and I/O, keeping apart whether a query is costly, whether it causes a slow request and whether more capacity would help. It follows each query from route to generated SQL, reproduces the baseline on a throwaway local PostgreSQL with synthetic data and saved EXPLAIN plans, makes the smallest change, and proves both the speed gain and identical results. Migrations are a last resort and must be timed on production-size data.
Capabilities
- Rank costly query families from Neon statistics
- Trace a query from route to generated SQL
- Benchmark a fix against a local baseline
- Check that results stay identical after a fix
- Open and follow a pull request to passing checks
About
- Publisher
- Paperclip Labs
- Tool
- PostgreSQL
Install
The project doesn't document install steps that we could confirm. See the project's own instructions
What's inside
- agents/openai.yaml
- references/cloud-discovery.md
- references/local-proof.md
MCP servers and skills can run code on your computer and act on your data. Review the source before installing.
Details
| Fact | Value | Source |
|---|---|---|
| Type | Skill | |
| Tools | PostgreSQL, Neon | |
| Publisher | Paperclip Labs | source |
| Official status | Community (not published by the tool's vendor) | source |
| Needs an API key or sign-in | Not stated in its documentation | |
| Includes scripts | No | source |
| Platforms | Not stated in its documentation | |
| AI clients | Not stated in its documentation | |
| Licence | MIT | source |
| Pricing | Not stated in its documentation | |
| Activity | Last commit Nov 18, 2026114,604 GitHub starsDownload data not available (not on npm or PyPI) | source |
| Links | Repository Website |
Sources
- Skill file (SKILL.md)github.com/paperclipai/paperclipNov 18, 2026
- GitHub repositorygithub.com/paperclipai/paperclip · Backs: Licence, Official status, Publisher, ActivityNov 18, 2026
- Folder in the repository (fix-slow-queries)github.com/paperclipai/paperclip · Backs: Includes scriptsNov 18, 2026