Converts raw SQL queries into type-safe Kysely TypeScript code to streamline database layer development.
The Kysely SQL Converter skill empowers developers to bridge the gap between raw SQL and type-safe TypeScript by automating the translation of complex database queries into idiomatic Kysely code. It intelligently parses SQL syntax—including joins, subqueries, and advanced window functions—and maps them to the corresponding Kysely query builder methods for PostgreSQL and MySQL. This utility is essential for teams migrating legacy codebases or developers who prefer drafting logic in SQL before implementing it in a type-safe environment, ensuring robust data access with full IDE support.
主要功能
01Automatic SQL to Kysely API mapping
02Dialect-specific handling for PostgreSQL and MySQL
03Support for complex joins, CTEs, and subqueries
044 GitHub stars
05Advanced Window Function and CASE statement conversion
06Type-safe CRUD operation generation
使用场景
01Refactoring legacy raw SQL strings into type-safe Kysely queries
02Learning Kysely syntax by converting familiar SQL patterns
03Rapidly prototyping complex analytical queries for TypeScript backends
