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: