How do I install the Sw Boilerplate DB skill?

Run npx skillmds@latest add chfle/sw-boilerplate-db in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Sw Boilerplate DB safe to use?

This skill has not completed SkillMD's automated safety review yet. Capability flags: docs only. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Sw Boilerplate DB?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Sw Boilerplate DB free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Sw Boilerplate DB?

chfle (@chfle) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Sw Boilerplate DB by chfle — Agent Skill

Name: Sw Boilerplate DB
Rating: 4.2 (5 reviews)
Author: chfle

File contents

SW Boilerplate DB

Overview

Creates database schema, ORM config, and migration foundation files directly in the workspace root based on requirements/tech-stack.yaml. Silent – nothing is printed in chat except the completion line.

If database.primary is "None" in tech-stack.yaml, this skill does nothing and prints the completion line.

Required Input

requirements/tech-stack.yaml must exist. If missing, stop:

requirements/tech-stack.yaml not found. Run /sw-tech-stack-planner first.

Files to Create

Read database.primary, database.orm, database.migrations, and database.cache from tech-stack.yaml.

Prisma

Path	Content
`prisma/schema.prisma`	`datasource db` block (postgresql/mysql/sqlite from tech-stack.yaml), `generator client` block, placeholder `// Add models here` comment

TypeORM

Path	Content
`src/database/database.module.ts`	NestJS TypeOrmModule.forRootAsync() with ConfigService
`src/database/database.config.ts`	TypeORM DataSourceOptions from env vars

Hibernate / JPA (Spring Boot)

JPA config goes into src/main/resources/application.yml (already created by sw-boilerplate-structure). Add datasource and JPA sections if not already present. No extra files.

jOOQ + Flyway (Spring Boot)

Path	Content
`src/main/resources/db/migration/V1__init.sql`	Empty migration with header comment: `-- V1: initial schema`

SQLAlchemy + Alembic

Path	Content
`database.py`	SQLAlchemy engine + SessionLocal + Base setup from env DATABASE_URL
`models/__init__.py`	Empty (already created by sw-boilerplate-structure if FastAPI)
`alembic.ini`	Alembic config pointing to `alembic/` directory
`alembic/env.py`	Alembic env with target_metadata from Base
`alembic/versions/.gitkeep`	Placeholder

GORM (Go)

Path	Content
`internal/database/database.go`	GORM db init function with postgres/mysql DSN from env

Redis (cache)

If database.cache is set (Redis, Valkey, etc.), add:

Path	Content
`src/cache/cache.module.ts`	NestJS: CacheModule.registerAsync() – only if NestJS detected
`cache/redis.go`	Go: Redis client init – only if Go detected

Output Rules

Write all files silently to the workspace root.
Never output file content, code snippets, or file lists in chat.
At the end, print exactly one line:

✅ sw-boilerplate-db completed

---name: sw-boilerplate-dbdescription: Use when user wants to create database and ORM files (Prisma schema, Flyway migration, SQLAlchemy models, TypeORM config) based on requirements/tech-stack.yaml directly in the workspace root.---# SW Boilerplate DB## OverviewCreates database schema, ORM config, and migration foundation files directly in the workspace root based on `requirements/tech-stack.yaml`. Silent – nothing is printed in chat except the completion line.If `database.primary` is "None" in tech-stack.yaml, this skill does nothing and prints the completion line.---## Required Input`requirements/tech-stack.yaml` must exist. If missing, stop:> `requirements/tech-stack.yaml` not found. Run `/sw-tech-stack-planner` first.---## Files to CreateRead `database.primary`, `database.orm`, `database.migrations`, and `database.cache` from tech-stack.yaml.### Prisma| Path | Content ||------|---------|| `prisma/schema.prisma` | `datasource db` block (postgresql/mysql/sqlite from tech-stack.yaml), `generator client` block, placeholder `// Add models here` comment |### TypeORM| Path | Content ||------|---------|| `src/database/database.module.ts` | NestJS TypeOrmModule.forRootAsync() with ConfigService || `src/database/database.config.ts` | TypeORM DataSourceOptions from env vars |### Hibernate / JPA (Spring Boot)JPA config goes into `src/main/resources/application.yml` (already created by sw-boilerplate-structure). Add datasource and JPA sections if not already present. No extra files.### jOOQ + Flyway (Spring Boot)| Path | Content ||------|---------|| `src/main/resources/db/migration/V1__init.sql` | Empty migration with header comment: `-- V1: initial schema` |### SQLAlchemy + Alembic| Path | Content ||------|---------|| `database.py` | SQLAlchemy engine + SessionLocal + Base setup from env DATABASE_URL || `models/__init__.py` | Empty (already created by sw-boilerplate-structure if FastAPI) || `alembic.ini` | Alembic config pointing to `alembic/` directory || `alembic/env.py` | Alembic env with target_metadata from Base || `alembic/versions/.gitkeep` | Placeholder |### GORM (Go)| Path | Content ||------|---------|| `internal/database/database.go` | GORM db init function with postgres/mysql DSN from env |### Redis (cache)If `database.cache` is set (Redis, Valkey, etc.), add:| Path | Content ||------|---------|| `src/cache/cache.module.ts` | NestJS: CacheModule.registerAsync() – only if NestJS detected || `cache/redis.go` | Go: Redis client init – only if Go detected |---## Output Rules- Write all files silently to the workspace root.- Never output file content, code snippets, or file lists in chat.- At the end, print exactly one line:```✅ sw-boilerplate-db completed```

Frequently asked questions

Sw Boilerplate DB