NextSQL is a modern, type-safe DSL compatible with SQL, designed for method-chained queries and mutations that generate Rust code.

Why does the clause order matter in NextSQL?

NextSQL enforces a strict grammar where filtering clauses (like .where) must appear before projection clauses (like .select), ensuring predictable and valid query compilation.

How do auto-joins work in NextSQL?

By defining relations in your .nsql files, NextSQL allows you to access columns from related tables using simple dot notation, automatically generating the necessary JOIN logic.

Can this skill help with database migrations?

Yes, it provides guidance on using the NextSQL CLI to initialize, generate, and run migrations against your database while maintaining schema integrity.

NextSQL DSL Expert

Name: NextSQL DSL Expert
Author: shirakawayohane

byshirakawayohane

0•

数据库管理

Generates and manages type-safe NextSQL queries, mutations, and migrations with strict DSL compliance for Rust-based projects.

This skill empowers Claude to act as a specialized NextSQL architect, providing comprehensive support for writing queries, mutations, and schema relations using the NextSQL Domain Specific Language. It ensures strict adherence to the language's specific clause ordering and type system, enabling developers to generate valid .nsql files, convert standard SQL to NextSQL, and manage database migrations efficiently. Whether you're defining complex auto-joins or setting up multi-row inserts, this skill provides the domain-specific logic needed to leverage NextSQL's type safety and method-chained syntax effectively.

主要功能

01Automatic JOIN logic using relation-based dot-access syntax

02Support for advanced mutations including UPSERT (onConflict) and RETURNING

03Type-safe parameter handling with custom input types and valtypes

040 GitHub stars

05Strict clause ordering enforcement for valid NextSQL query generation

06Migration management and CLI command assistance for Rust integration

使用场景

01Converting existing raw SQL queries into type-safe NextSQL DSL structures

02Designing complex database relations with automated join navigation

03Scaffolding database migrations and managing schema changes via the nsql CLI

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add shirakawayohane/next-sql learn-next-sql

For use in Claude.ai and ChatGPT

主要功能

01Automatic JOIN logic using relation-based dot-access syntax

02Support for advanced mutations including UPSERT (onConflict) and RETURNING

03Type-safe parameter handling with custom input types and valtypes

040 GitHub stars

05Strict clause ordering enforcement for valid NextSQL query generation

06Migration management and CLI command assistance for Rust integration

使用场景

01Converting existing raw SQL queries into type-safe NextSQL DSL structures

02Designing complex database relations with automated join navigation

03Scaffolding database migrations and managing schema changes via the nsql CLI

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add shirakawayohane/next-sql learn-next-sql

For use in Claude.ai and ChatGPT