What SQL dialects does the Kysely Converter support?

The skill is optimized for PostgreSQL and MySQL dialects, ensuring that syntax specific to these databases is correctly mapped to Kysely's API.

Can it handle complex window functions?

Yes, it can convert advanced SQL features like ROW_NUMBER, RANK, and aggregate windows into the proper Kysely expression builder (eb.fn.agg) syntax.

Does this skill help with TypeScript type safety?

Absolutely. The generated code is designed to leverage Kysely's powerful type inference, helping you catch database errors at compile time.

What happens if a SQL fragment is too complex to convert?

When the converter encounters unsupported or highly specific raw SQL fragments, it intelligently utilizes the 'sql' template tag to ensure the query remains functional.

Kysely SQL Converter

Name: Kysely SQL Converter
Author: buYoung

bybuYoung

•

Database Management

Converts raw SQL queries into type-safe Kysely TypeScript code to streamline database layer development.

About

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.

Key Features

Automatic SQL to Kysely API mapping
Dialect-specific handling for PostgreSQL and MySQL
Support for complex joins, CTEs, and subqueries
4 GitHub stars
Advanced Window Function and CASE statement conversion
Type-safe CRUD operation generation

Use Cases

Refactoring legacy raw SQL strings into type-safe Kysely queries
Learning Kysely syntax by converting familiar SQL patterns
Rapidly prototyping complex analytical queries for TypeScript backends

About

Key Features

Automatic SQL to Kysely API mapping
Dialect-specific handling for PostgreSQL and MySQL
Support for complex joins, CTEs, and subqueries
4 GitHub stars
Advanced Window Function and CASE statement conversion
Type-safe CRUD operation generation

Use Cases

Refactoring legacy raw SQL strings into type-safe Kysely queries
Learning Kysely syntax by converting familiar SQL patterns
Rapidly prototyping complex analytical queries for TypeScript backends