sqlc

Original：🇺🇸 English

Translated

Working with sqlc and database queries

2installs

Sourcekalbasit/ncps

Added on2026-02-21

NPX Install

npx skill4agent add kalbasit/ncps sqlc

SKILL.md Content

View Translation Comparison →

SQLC Skill

This skill provides instructions for working with

sqlc

and database queries in the NCPS repository. NCPS supports multiple database engines (SQLite, PostgreSQL, MySQL), and

sqlc

is used to generate type-safe Go code from SQL queries for each engine.

Configuration

SQLC Config:
```
sqlc.yml
```

Queries:

SQLite:
```
db/query.sqlite.sql
```
PostgreSQL:
```
db/query.postgres.sql
```
MySQL:
```
db/query.mysql.sql
```

Output:

SQLite:
```
pkg/database/sqlitedb
```
PostgreSQL:
```
pkg/database/postgresdb
```
MySQL:
```
pkg/database/mysqldb
```

Workflow for Query Changes

Any time a query file (

db/query.<engine>.sql

) is updated, you MUST follow these steps:

1. Generate SQLC Code

Run the

sqlc generate

command to update the generated Go files for all engines.

bash

sqlc generate

2. Regenerate Database Wrappers and Models

Run

go generate

for the

pkg/database

package. This command uses

gen-db-wrappers

to automatically:

Extract the
```
Querier
```
interface from the
```
postgresdb
```
backend.
Generate the common
```
Querier
```
interface in
```
pkg/database/querier.go
```
.
Generate common domain models in
```
pkg/database/models.go
```
.

Generate database wrappers (

wrapper_sqlite.go

,

wrapper_postgres.go

,

wrapper_mysql.go

).

bash

go generate ./pkg/database

[!IMPORTANT] Do NOT manually edit
pkg/database/querier.go
or
pkg/database/models.go
. They are fully automated.

Best Practices

Consistency: Ensure that equivalent queries exist for all supported engines unless the feature is engine-specific.

Linting: Use

sqlfluff

to lint and format SQL files before running

sqlc generate

.

bash

sqlfluff lint db/query.*.sql
sqlfluff format db/query.*.sql

sqlc

NPX Install

Tags

SKILL.md Content

SQLC Skill

Configuration

Workflow for Query Changes

1. Generate SQLC Code

2. Regenerate Database Wrappers and Models

Best Practices