Transforms raw SQL queries into type-safe Kysely TypeScript code for streamlined database management.
The Kysely Query Converter skill bridges the gap between raw SQL and type-safe TypeScript by automatically translating complex queries into idiomatic Kysely syntax. It handles a wide range of database operations—including intricate joins, window functions, and common table expressions (CTEs)—while ensuring the output leverages Kysely's powerful type inference. Whether you are migrating legacy code or prototyping in SQL, this skill ensures your database layer remains type-safe and maintainable across PostgreSQL and MySQL dialects.
Key Features
01Provides dialect-specific mapping for PostgreSQL and MySQL
02Supports advanced Window Functions like RANK, LEAD, and OVER clauses
03Converts raw SQL syntax into idiomatic Kysely TypeScript methods
044 GitHub stars
05Automatically identifies when to use raw sql template tags for complex fragments
06Handles complex SELECT, INSERT, UPDATE, and DELETE operations
Use Cases
01Translating complex analytical SQL queries into Kysely query builder logic
02Accelerating backend development by prototyping queries in SQL and converting them instantly
03Migrating legacy raw SQL strings into a type-safe TypeScript codebase
