Can it help with complex SQL features like CTEs?

Absolutely, it includes specific implementation patterns for Common Table Expressions, recursive CTEs, and complex subquery joins.

Does it support conditional query building?

Yes, it covers patterns for building dynamic filters and conditional WHERE clauses using arrays of expressions.

Why use the ExpressionBuilder (eb) pattern?

The ExpressionBuilder is the foundation of Kysely's type safety; this skill prioritizes it to ensure your queries are validated against your schema at compile-time.

Does this skill handle JSONB and array columns?

Yes, it provides patterns for native PostgreSQL JSONB and array handling, allowing you to pass objects and arrays directly without manual stringification.

Kysely PostgreSQL Query Builder

Name: Kysely PostgreSQL Query Builder
Author: gallop-systems

bygallop-systems

データベース管理

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.

主な機能

Implementation of complex Common Table Expressions (CTEs) and recursive queries
0 GitHub stars
Native JSONB and PostgreSQL array handling without manual serialization
Advanced join patterns including subquery joins and composite keys
Guidance on type-safe database migrations and type generation
Type-safe PostgreSQL query generation using the Kysely ExpressionBuilder (eb)

ユースケース

Optimizing PostgreSQL query performance through idiomatic Kysely expressions
Building complex TypeScript backends with highly reliable database layers
Refactoring raw SQL or legacy ORM queries into type-safe Kysely patterns

概要

主な機能

Implementation of complex Common Table Expressions (CTEs) and recursive queries
0 GitHub stars
Native JSONB and PostgreSQL array handling without manual serialization
Advanced join patterns including subquery joins and composite keys
Guidance on type-safe database migrations and type generation
Type-safe PostgreSQL query generation using the Kysely ExpressionBuilder (eb)

ユースケース

Optimizing PostgreSQL query performance through idiomatic Kysely expressions
Building complex TypeScript backends with highly reliable database layers
Refactoring raw SQL or legacy ORM queries into type-safe Kysely patterns