Turn spaghetti SQL into readable, documented code
Paste any monster SQL query — 400 lines of nested CTEs with no comments — and get back a documented version with plain-English explanations, a dependency diagram, and suggestions for modularization.
Create a skill called "Query Decoder". When I paste a SQL query, analyze it thoroughly and produce: (1) A one-paragraph plain-English summary of what the query calculates or produces. (2) The same query with inline comments explaining each CTE, subquery, JOIN, and non-obvious WHERE clause. (3) A list of all tables and columns referenced, with their apparent purpose. (4) A text-based dependency diagram showing how CTEs feed into each other. (5) Any implicit business rules found (e.g., "only includes orders where status != 'cancelled' and created_date > '2023-01-01'"). (6) Suggestions for breaking the query into smaller, reusable pieces (as dbt models or database views). If I provide business context, incorporate it into the documentation.
Legacy SQL queries are terrifying. The senior analyst who wrote them left
two years ago, there are no comments, and touching anything might break
downstream reports. This skill reverse-engineers the logic, adds documentation,
and shows you what's actually happening.
Documentation that updates itself when the data changes
Auto-generates and maintains documentation for your data models, SQL queries, and warehouse schemas. When the schema changes, the docs update. When a query is modified, the description stays current. No more stale Confluence pages.
From repo access to first merged PR, fast
Onboard new engineers, QA, DevOps, and PMs without tribal knowledge. Standardize access, environment setup, architecture orientation, and a first safe change.
Verify, reduce, and resolve medical bills
A step-by-step playbook for medical bill errors, insurance confusion, and negotiating discounts or payment plans — including scripts for every call.
Fix credit report errors without guesswork
Generate dispute letters, evidence checklists, and follow-up timelines to correct credit report mistakes. Covers bureaus, furnishers, and identity theft.