Riligar dev database

Skill riligar/agents-kit/.agent/skills/riligar-dev-database

database patterns for RiLiGar using Drizzle ORM + bun:sqlite. Use when setting up database connections, defining schemas, creating migrations, or writing queries. Covers SQLite on Fly.io volumes with the drizzle-kit workflow.From its SKILL.md

Install

npx -y skills add riligar/agents-kit --skill riligar-dev-database

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

0 stars0 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

2.0 KB, 412 tokens by cl100k_base, as published. Nobody here has run it

database — Drizzle + bun:sqlite

SQLite nativo no Bun. Zero drivers externos. Base de dados no volume do Fly.io (/app/data).

Referências

Arquivo	Quando usar
connection.md	Setup inicial: instalação, db.js, drizzle.config
schema.md	Definir tabelas, tipos de colunas, relações
migrations.md	Criar e executar migrations com drizzle-kit
queries.md	Select, insert, update, delete, queries com relações

Quick Start

// database/db.js
import { drizzle } from 'drizzle-orm/bun-sqlite'
import database from 'bun:sqlite'

const sqlite = new database(process.env.DB_PATH ?? './database/database.db')
const db = drizzle({ client: sqlite })

export { db }

Regras

Caminho do banco: /app/data/database.db em produção (volume Fly.io). ./database/database.db em desenvolvimento.
Migrations sempre: Use drizzle-kit generate + drizzle-kit migrate. Nunca edite migrations à mão.
Schema único: Todas as tabelas em database/schema.js.
Migrations no startup: Use migrate() no index.js antes de .listen().

Related Skills

Need	Skill
Backend (Elysia)	@[.agent/skills/riligar-dev-manager]
Payments (Stripe)	@[.agent/skills/riligar-infra-stripe]
Infrastructure	@[.agent/skills/riligar-infra-fly]

What ships with it: 4 files

9.8 KB alongside SKILL.md