Write, optimize, and debug SQL queries. Analyze query plans, suggest indexes, and translate between SQL dialects.
Generate changelogs from git history using conventional commits. Produces Keep a Changelog format entries grouped by type and version.
Perform thorough code reviews focusing on correctness, security, performance, and maintainability. Provide actionable feedback with specific line references and suggested fixes.
Write and update technical documentation including API docs, README files, architecture decision records, and inline code comments.
Guide safe, incremental refactoring of existing code. Identify refactoring opportunities, suggest patterns, and ensure behavior is preserved through the process.
Inspect Figma designs, extract tokens, generate component code, and sync design decisions to your codebase.
Manage GitHub issues, pull requests, milestones, and projects. Create, update, label, and query issues across repositories.
Manage Jira issues, sprints, epics, and projects. Create, update, transition, and query issues. Link issues to pull requests and track project progress across boards.