Which SQL dialects does this skill support?

The Kysely Converter primarily supports PostgreSQL and MySQL dialects, adapting its conversion strategies to match the specific nuances of each system.

Does it support batch insert operations?

Absolutely. It can transform both single-row and multi-row value insertions into idiomatic Kysely code, including handling RETURNING clauses.

What happens if a SQL fragment is too complex for Kysely?

The skill is designed to identify fragments that require raw SQL and will automatically wrap them in Kysely's `sql` template tags to ensure functionality.

Is the generated code fully type-safe?

Yes, the skill focuses on generating code that utilizes Kysely's type inference capabilities to ensure your database interactions are as safe as possible.

Can it handle complex window functions?

Yes, it can convert advanced window functions including ranking, value functions, and aggregate windows using the Kysely expression builder.

Kysely Query Converter

Name: Kysely Query Converter
Author: buYoung

bybuYoung

•

数据库管理

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.

主要功能

Provides dialect-specific mapping for PostgreSQL and MySQL
Supports advanced Window Functions like RANK, LEAD, and OVER clauses
Converts raw SQL syntax into idiomatic Kysely TypeScript methods
4 GitHub stars
Automatically identifies when to use raw sql template tags for complex fragments
Handles complex SELECT, INSERT, UPDATE, and DELETE operations

使用场景

Translating complex analytical SQL queries into Kysely query builder logic
Accelerating backend development by prototyping queries in SQL and converting them instantly
Migrating legacy raw SQL strings into a type-safe TypeScript codebase

关于

主要功能

Provides dialect-specific mapping for PostgreSQL and MySQL
Supports advanced Window Functions like RANK, LEAD, and OVER clauses
Converts raw SQL syntax into idiomatic Kysely TypeScript methods
4 GitHub stars
Automatically identifies when to use raw sql template tags for complex fragments
Handles complex SELECT, INSERT, UPDATE, and DELETE operations

使用场景

Translating complex analytical SQL queries into Kysely query builder logic
Accelerating backend development by prototyping queries in SQL and converting them instantly
Migrating legacy raw SQL strings into a type-safe TypeScript codebase