LiorCohen/sdd / plugin/fullstack-typescript/skills/components/database/database-scaffolding
database-scaffolding
VerifiedScaffolds PostgreSQL database component with migrations, seeds, and management scripts.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 6.0 KB |
| schemas/input.schema.json | config | 519 B |
| schemas/output.schema.json | config | 1.4 KB |
| templates/README.md | markdown | 2.6 KB |
| templates/migrations/001_initial_schema.sql | other | 910 B |
| templates/package.json | manifest | 62 B |
| templates/seeds/001_seed_data.sql | other | 711 B |
templates/README.md
View on GitHub# Database Component
PostgreSQL database migrations, seeds, and management scripts. Deployed to local Kubernetes cluster.
## Prerequisites
- Local Kubernetes cluster (Docker Desktop, minikube, or kind)
- kubectl configured and connected
- Helm 3 installed
- psql client (for direct database access)
## Quick Start
Database operations are performed via SDD commands in your Claude Code session:
```
/sdd set up the database # Deploy PostgreSQL to k8s
/sdd forward the database port # Forward port (run in separate terminal)
/sdd run database migrations # Run migrations
/sdd seed the database # (Optional) Load seed data
```
## Available Operations
| Prompt | Description |
|--------|-------------|
| `/sdd set up the database` | Deploy PostgreSQL to local Kubernetes cluster |
| `/sdd tear down the database` | Remove PostgreSQL from cluster |
| `/sdd forward the database port` | Forward localhost:5432 to database pod |
| `/sdd connect to the database` | Connect to database via psql |
| `/sdd run database migrations` | Run all pending migrations |
| `/sdd seed the database` | Load seed data |
| `/sdd reset the database` | Drop, recreate, migrate, and seed |
## Adding Migrations
Create numbered SQL files in `migrations/`:
```
migrations/
├── 001_initial_schema.sql
├── 002_add_users.sql
└── 003_add_orders.sql
```
Migration files run in alphabetical order. Each migration should:
- Use a transaction (`BEGIN`/`COMMIT`)
- Be idempotent where possible
- Include rollback comments for reference
## Adding Seeds
Create numbered SQL files in `seeds/`:
```
seeds/
├── 001_reference_data.sql
└── 002_test_users.sql
```
Seed files should use `ON CONFLICT` for idempotency:
```sql
INSERT INTO users (id, email) VALUES (1, 'admin@example.com')
ON CONFLICT (id) DO UPDATE SET email = EXCLUDED.email;
```
## Default Connection Settings
When using port-forward, connections default to:
| Setting | Value |
|---------|-------|
| Host | localhost |
| Port | 5432 |
| Database | {{PROJECT_NAME}} |
| Username | {{PROJECT_NAME}} |
| Password | {{PROJECT_NAME}}-local |
Override with environment variables:
```bash
export PGHOST=localhost
export PGPORT=5432
export PGDATABASE={{PROJECT_NAME}}
export PGUSER={{PROJECT_NAME}}
export PGPASSWORD=your_password
```
## Configuration
Customize deployment with environment variables:
| Variable | Default | Description |
|----------|---------|-------------|
| `DB_NAMESPACE` | default | Kubernetes namespace |
| `DB_RELEASE_NAME` | {{PROJECT_NAME}}-db | Helm release name |
| `DB_LOCAL_PORT` | 5432 | Local port for port-forward |
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |