The Collection

SQL Database Administrator (DBA)

Optimize queries and schema design.

Persona: Efficiency obsession. Tasks: Vectorization, LazyFrames.

Python Polars Expert

Optimize data interaction with Polars.

Audit, Images, JS, Caching.

Web Performance Optimization

Systematic speed improvement.

Identify, Quantify, Negotiate, Execute.

Technical Debt Paydown

Managing debt without halting features.

Severity, Reproducibility, Assignment.

Bug Triage Process

Prioritizing incoming issues.

Backwards compatibility, expanding, contracting.

Database Migration safety

Running risky DDL changes in production.

S3 Trigger, FFmpeg layer, m3u8 playlist.

Video Transcoder Service

Convert uploads to HLS.

AES-256, Master Password, Clipboard.

Password Manager (CLI)

Secure local credential store.

BeautifulSoup, Selenium, filters.

Remote Job Scraper

Aggregate listings from RSS/HTML.

Geospatial queries, State machine, Assignment.

Food Delivery API

Backend for UberEats clone.

Markdown parsing, Templating, Parallel processing.

Static Site Generator (Rust)

Build a fast blog engine.

Key extraction, Machine Translation, Approval.

Translation Management System (TMS)

Localization for software teams.

Base62 encoding, Caching, Analytics.

URL Shortener Service

High-scale link redirection.

RSS XML, ID3 Tagging, CDN.

Podcast Hosting Platform

RSS feed generation and analytics.

Smart Contract, Indexer, Wallet Connect.

Web3 NFT Marketplace

Decentralized trading platform.

Inbound parse, Sanitization, Reader View.

Newsletter Aggregator App

Reader for multiple subscriptions.

MDX, Sidebar, Search, Versioning.

Documentation Site (Starlight/Docusaurus)

Knowledge base for a product.

Manifest v3, Content Script, Popup UI.

Chrome Extension: Productivity

Browser tool to block distractions.

Storefront API, Cart Context, Checkout Redirect.

E-commerce Storefront (Headless)

Custom shopping experience with Shopify backend.

Transaction isolation, Locking order.

Sussing Out Deadlocks

Debugging database concurrency issues.

Injection, Broken Auth, XSS.

Code Review Checklist (Security)

OWASP Top 10 focus.

Bool query, Must/Should/Filter, Aggregations.

Elasticsearch Query Builder

Construct complex JSON DSL queries.

Email, Phone, Date, Password strength.

Regex Generator & Explainer

Design regular expressions for data validation.

O(n), O(log n), Recursion depth.

Algorithmic Complexity Analyzer

Determine Big O time and space complexity.

Input fuzzing, Error-based, Boolean-based.

SQL Injection Penetration Test

Educational guide to spotting SQLi vulnerabilities.

Handle nulls, normalize dates, strict typing.

Python Data Cleaning Agent

Pandas workflow for messy CSV/Excel files.

Rootless, Multi-stage, Distroless, Secret scanning.

Docker Container Hardening

Security best practices for Dockerfiles.

Analyze Explain Plans, Suggest Indexes, Detect N+1.

PostgreSQL Indexing Strategist

Optimize SQL queries and schema performance.

Overview, prerequisites, steps, examples, troubleshooting.

Technical Writing Prompts

API docs, runbooks, and how-to guides. Consistent structure and tone for technical audiences.

Parse commits → categorize → draft → review.

Release Notes Workflow

Turn changelog entries into user-facing release notes. Group by feature, fix, breaking change.

{"title":"","steps":[],"owners":[],"escalation":""}

Runbook Generator (JSON)

Incident runbooks and ops procedures in JSON: steps, owners, escalation, rollback.

{"issues":[{"type":"","element":"","suggestion":""}],"summary":""}

Accessibility Review (JSON)

Accessibility checks and remediation suggestions in JSON for dev and QA.

{"openapi":"3.0","paths":{},"schemas":{}}

API & Schema Prompts (JSON)

Generate OpenAPI snippets, request/response examples, and schema docs in JSON for developers.

{"output":"json","sections":["issues","suggestions","summary"],"severity_levels":["critical","major","minor"]}

Code Review Prompts (JSON)

Structured prompts that return review comments and severity in JSON. Works with CI/CD and dev tools.

Logic, style, tests, security.

Code Review Checklist

Consistent code review criteria.

When to write, where, review.

Documentation Workflow

Keep docs up to date.

Detect, triage, communicate, postmortem.

Incident Response Playbook

Agent-assisted incident response.

What went well, what did not, actions.

Sprint Retro Prompts

Better retros with AI.

Resource naming, status codes, versioning.

API Design Prompts

Design RESTful APIs with AI.