Kysely Query Architect

What problem does it solve?

This Skill guides writing type-safe Kysely queries following project patterns, ensuring explicit column selection, type inference, and centralized query reuse across classes.

Core Features & Use Cases

• Explicit columns: prefer .select([...]) over selectAll().
• Type inference: let Kysely infer return types; avoid manual typings.
• Query reuse across classes: inject and compose query classes for shared dashboards and modules.
• Performance patterns: use CTEs, joins, and parallelization with Promise.all.

Quick Start

Create a new query class in @packages/db/src/queries/*.ts, e.g., SalesQueries, with a constructor taking a Kysely<Database> and implementing methods like getSales(organizationId) that return .execute() results.