sqg-devsqg-devOfficialยท1 Agent Skills Included

sqg

Type-safe database code generation from annotated SQL files

Generates type-safe TypeScript, Java, and Python database access code directly from annotated SQL files. Introspects queries against real SQLite, DuckDB, or PostgreSQL engines to infer accurate column types automatically. Eliminates hand-written query wrappers, untyped result rows, and manual migration tracking. Supports bulk insert appenders, schema baselines, and Postgres attachments for faster data workflows.
npx skills add sqg-dev/sqg --all -g -y
Available:

Explains the SQG project structure, SQL annotation syntax, configuration format, and build commands so the agent can correctly write, validate, and generate type-safe database code.

All Skills in This Repository (1)

Pure Emerald Level Indicators

Frequently Asked Questions

FAQPage Schema
How to install SQG?โ–ผ

Run `npx skills add sqg-dev/sqg --all -g -y` in your terminal to install the skill globally for your coding agent.

How to generate type-safe code from SQL?โ–ผ

Write your queries in a .sql file with annotations like -- QUERY and -- MIGRATE, then run sqg with a sqg.yaml config to emit fully typed TypeScript, Java, or Python wrappers.

Which databases and languages does SQG support?โ–ผ

SQG works with SQLite, DuckDB, and PostgreSQL, and generates code for TypeScript, Java (JDBC and Arrow), and Python.

Does SQG work with Claude Code and Cursor?โ–ผ

Yes. The skill follows the universal SKILL.md standard and SQG also ships an MCP server, so it runs smoothly in Claude Code, Cursor, Codex, and similar agents.

Can SQG handle bulk inserts and migrations?โ–ผ

Yes. The -- TABLE :appender annotation generates high-performance bulk insert appenders, and -- MIGRATE blocks manage schema migrations in source order.

Related Repositories in Software Engineering

View All in Software Engineeringโ†’