Skills

Helps process a busy inbox quickly. Categorizes messages by urgency and type, extracts action items and deadlines, drafts short reply options, and proposes an order to handle them. Summarizes long threads into the decision needed and flags anything sensitive or requiring escalation, so you can clear the inbox with fewer decisions.

Explains what a SQL query does in plain language and how it executes. Breaks down joins, subqueries, CTEs, and window functions step by step, describes the result set, reads EXPLAIN/EXPLAIN ANALYZE output to identify slow scans and missing indexes, and flags correctness pitfalls. Helps developers understand, review, and trust unfamiliar SQL.

Produces operational runbooks for services and common incidents. Documents prerequisites, step-by-step diagnosis and remediation, exact commands, verification checks, rollback steps, and escalation paths. Structures each runbook so an on-call engineer can follow it under pressure, and keeps destructive steps clearly flagged with safeguards.

Generates and refactors dbt models for analytics engineering. Writes staging, intermediate, and mart models following layered conventions, adds schema.yml tests and descriptions, applies incremental and materialization strategies, and structures sources and refs correctly. Produces SQL plus YAML that fits dbt best practices and is ready to run.

Produces production-ready nginx configuration for common scenarios: reverse proxy, load balancing, TLS termination, static file serving, HTTP/2, gzip/brotli, caching, rate limiting, and security headers. Explains each directive, warns about risky defaults, and includes a validation step so the config can be tested before reload.

Drafts long-form blog posts from a topic, outline, or set of notes. Handles title and hook generation, logical section structure, SEO-aware headings, tone matching, internal linking suggestions, and a clear call to action. Produces publish-ready Markdown with meta description and suggested tags.

Generates candidate names for products, features, projects, or companies against a clear brief. Explores naming styles (descriptive, evocative, coined, compound), checks each for pronounceability and unwanted meanings, and suggests domain and handle patterns to verify. Returns a shortlist with rationale rather than an undifferentiated list.

Generates platform-tailored social media posts from a single idea or announcement. Adapts length, tone, hashtags, and formatting for X, LinkedIn, Instagram, and threads. Produces hook-first copy, variant options for A/B testing, and a suggested posting cadence while respecting each platform's conventions and character limits.

Reviews and rewrites resumes and CVs to be clear, achievement-focused, and ATS-friendly. Rewrites bullet points using strong action verbs and quantified impact, aligns wording to a target job description, flags gaps and red flags, and checks formatting for applicant tracking system compatibility.

Decodes and reviews JSON Web Tokens and their surrounding auth flow for correctness and security. Explains header and claims, checks algorithm and key handling, validates expiration and audience/issuer claims, and flags common pitfalls such as the alg:none attack, weak secrets, missing validation, and over-long token lifetimes. Never treats token contents as trusted secrets to echo back.

Turns a messy list of tasks into a ranked, actionable plan. Applies a chosen framework (Eisenhower urgent/important, RICE, MoSCoW, or value/effort) consistently, surfaces dependencies and quick wins, groups work into a realistic today/this-week plan, and explains the ranking so the user can adjust the weighting.

Builds structured competitive analyses from public information. Maps competitors across positioning, pricing, features, target segments, and go-to-market motion; produces feature-comparison matrices and SWOT summaries; and highlights differentiation gaps and opportunities. Emphasizes citing sources and separating verified facts from inference.

Reviews claims in a document for accuracy and verifiability. Extracts discrete factual statements, rates each as supported, unsupported, or needs-verification, flags logical inconsistencies and unsourced numbers, and suggests what evidence would confirm or refute each claim. Designed to reduce hallucinated or outdated facts before publishing.

Inspects messy tabular data and produces a repeatable cleaning plan plus code. Detects and fixes common issues: inconsistent types, duplicate rows, missing values, malformed dates, mixed encodings, whitespace and casing problems, and outliers. Outputs pandas or Polars code, a summary of changes, and a validation checklist.

Sets up and maintains Git hooks for a repository. Recommends a manager (Husky, Lefthook, or pre-commit), wires up pre-commit and commit-msg hooks for linting, formatting, type checks, secret scanning, and conventional-commit validation, and keeps hooks fast with staged-file filtering. Produces config plus a short contributor guide.

Builds disaster recovery and business continuity plans for systems and data. Defines RTO and RPO targets, maps critical dependencies, chooses backup and replication strategies, documents failover and restore procedures, and designs a testing cadence with game days. Produces a plan that balances resilience against cost and operational complexity.

Translates requirements and user stories into behavior-driven development scenarios in Gherkin. Writes clear Given/When/Then steps, covers happy paths, edge cases, and negative cases, uses scenario outlines with examples for data-driven tests, and keeps steps declarative and reusable. Optionally scaffolds step definitions for Cucumber or Behave.

Drafts email newsletters that get opened and read. Writes subject lines and preview text, structures the issue with a clear lead, scannable sections, and a single primary call to action, and adapts tone to the audience. Can turn a list of updates or links into a cohesive issue and suggest send-time and segmentation tips.

Writes idempotent Ansible playbooks and roles from a described target state. Structures tasks with proper handlers, variables, and templates; favors modules over shell commands; applies role-based layout and inventory grouping; and adds check-mode safety and tags. Produces playbooks that are re-runnable without unintended side effects.

Reviews applications and data flows for common privacy-regulation obligations (GDPR, CCPA/CPRA). Maps what personal data is collected, where it flows, and how long it is retained; checks for lawful basis, consent handling, data-subject rights, and third-party sharing; and produces a prioritized remediation list. Provides engineering guidance, not legal advice.

Turns customer results into a persuasive, credible case study. Structures the story as challenge, solution, and measurable results, weaves in quotes and concrete metrics, keeps claims verifiable, and ends with a clear call to action. Produces a publish-ready draft plus a one-paragraph summary and pull-quote suggestions.