From buyoung-skills
Converts raw SQL queries to type-safe Kysely TypeScript code. Handles dialects like PostgreSQL/MySQL, complex SELECT/INSERT/UPDATE/DELETE, joins, aggregations, window functions, CTEs.
npx claudepluginhub buyoung/skills --plugin backend-skillsThis skill uses the workspace's default tool permissions.
This agent is capable of transforming SQL queries into idiomatic Kysely TypeScript code. It understands SQL syntax and maps it to the corresponding Kysely query builder methods.
Creates isolated Git worktrees for feature branches with prioritized directory selection, gitignore safety checks, auto project setup for Node/Python/Rust/Go, and baseline verification.
Executes implementation plans in current session by dispatching fresh subagents per independent task, with two-stage reviews: spec compliance then code quality.
Dispatches parallel agents to independently tackle 2+ tasks like separate test failures or subsystems without shared state or dependencies.
This agent is capable of transforming SQL queries into idiomatic Kysely TypeScript code. It understands SQL syntax and maps it to the corresponding Kysely query builder methods.
SELECT -> .select(), WHERE -> .where()).*), and handling table prefixes.as syntax.DISTINCT and PostgreSQL-specific DISTINCT ON.INNER JOIN, LEFT JOIN, RIGHT JOIN, and other join types with complex ON conditions.=, >, <, etc.).AND, OR) using expression builders.NULL checks (IS NULL, IS NOT NULL).IN clauses and pattern matching (LIKE).GROUP BY and HAVING clauses with aggregate functions (COUNT, SUM, AVG, MAX, MIN).ORDER BY (asc/desc), LIMIT, and OFFSET.RETURNING clauses for PostgreSQL to return inserted data.SET assignments for simple values and expressions (e.g., incrementing a counter).WHERE conditions.DELETE FROM statements with conditions.RETURNING clauses for deleted rows (PostgreSQL).ROW_NUMBER, RANK, DENSE_RANK, NTILE, PERCENT_RANK, CUME_DIST.LAG, LEAD, FIRST_VALUE, LAST_VALUE, NTH_VALUE.AVG, COUNT, MAX, MIN, SUM.OVER clauses with PARTITION BY, ORDER BY, and frame specifications using the Kysely expression builder (eb.fn.agg).CASE WHEN ... THEN ... ELSE logic into Kysely's eb.case() chain.sql template tags are needed for unsupported or complex raw fragments.The agent applies specific patterns found in the references/ directory:
select.md: Query structure and clause mapping.insert.md: Insertion patterns and return value handling.update.md: Update logic and assignment expressions.delete.md: Deletion mapping.window_function.md: Complex window function construction using the expression builder.