What problem does it solve?
This Skill eliminates the tedious, error-prone work of manually writing and maintaining raw SQL string helpers in Go projects, reducing runtime database errors and boilerplate code for data access layers.
Core Features & Use Cases
- Typed Query DSL: Compose SQL queries using a fluent, compile-time type-safe API that catches invalid column references and query structure errors before runtime.
- Automated Code Generation: Generate table metadata, CRUD helpers, pagination, and search utilities directly from annotated Go structs using @TABLE or @RESULT annotations.
- Use Case: A Go service managing e-commerce order data can annotate Order and Product structs, generate all required database helpers, and build complex paginated, filtered queries with joins and transactions without writing raw SQL.
Quick Start
Use the tsq skill to add type-safe SQL querying to your Go project by annotating your database structs with @TABLE, running the tsq fmt and tsq gen commands, and building queries with the fluent TSQ DSL.