Choiry

Choiry is a generic-first, type-aware code generator that watches your schema and generates safe (SELECT-only by default), typed query utilities.

Requirements

• Node.js >= 18
• npm (or your preferred package manager)

Current status (MVP):

• Parse schema inputs (Prisma .prisma and Postgres-flavored .sql CREATE TABLE)
• Convert to canonical IR + analyze semantics/relations
• Compose deterministic SELECT-only query plans
• Generate a TypeScript SDK via ts-morph (Kysely or parameterized raw SQL)
• Atomic writes with no-op (hash) skipping
• watch mode (debounce + single-flight generation)
• validate mode (IR-only and optional Postgres EXPLAIN)

Install

Published to npm as @tachles/choiry.

• One-off CLI via npx: npx @tachles/choiry --help
• Or install locally: npm i -D @tachles/choiry

Dev

• Build: npm run build
• Typecheck: npm run typecheck
• Test: npm test

CLI (dev)

Output formats

Set output.queryFormat in choiry.config.ts:

• "kysely" (default): generated functions accept Kysely<DB>.
• "raw-sql": generated code exports *Prompt() helpers that return { sql, params } and functions that accept a tiny SqlExecutor interface (so you can use pg, better-sqlite3, mysql drivers, etc.). All values are passed as parameters (no string interpolation).

Published (recommended)

After publishing to npm as @tachles/choiry, you can run the CLI with npx:

• npx @tachles/choiry init
• npx @tachles/choiry generate --config ./choiry.config.ts
• npx @tachles/choiry watch
• npx @tachles/choiry inspect
• npx @tachles/choiry validate

If you prefer the command name choiry explicitly:

• npx -p @tachles/choiry choiry generate

Local dev (no publish)

After npm run build, you can run the local package via npx from the repo root:

• npx . init
• npx . generate --config ./choiry.config.ts

Direct node (also fine)

After npm run build, you can run:

• node dist/cli/main.js init
• node dist/cli/main.js generate
• node dist/cli/main.js watch
• node dist/cli/main.js inspect
• node dist/cli/main.js validate

Useful flags:

• generate --dry-run
• validate --json
• validate --strict

Note: the CLI loads choiry.config.ts at runtime using ts-node/register/transpile-only.

For validation.mode: "db-explain", set the env var named by validation.connectionStringEnv (default template uses DATABASE_URL).

Examples

• Prisma SQLite + Express: examples/prisma-sqlite-express/README.md

Contributing

See CONTRIBUTING.md.

Security

See SECURITY.md.

License

ISC — see LICENSE.