Generates type-safe Kysely queries and PostgreSQL migrations for Node.js and TypeScript backends.
The Kysely PostgreSQL skill equips Claude with specialized knowledge to write efficient, type-safe database queries and migrations. It provides comprehensive patterns for complex SQL operations like Common Table Expressions (CTEs), JSONB manipulation, and advanced joins, ensuring that generated code follows Kysely best practices while avoiding common pitfalls such as literal type safety issues. This skill is essential for developers building robust data layers where TypeScript's type inference is critical for database integrity.
Características Principales
01Implementation of complex Common Table Expressions (CTEs) and recursive queries
020 GitHub stars
03Native JSONB and PostgreSQL array handling without manual serialization
04Advanced join patterns including subquery joins and composite keys
05Guidance on type-safe database migrations and type generation
06Type-safe PostgreSQL query generation using the Kysely ExpressionBuilder (eb)
Casos de Uso
01Optimizing PostgreSQL query performance through idiomatic Kysely expressions
02Building complex TypeScript backends with highly reliable database layers
03Refactoring raw SQL or legacy ORM queries into type-safe Kysely patterns
