Exécutez n'importe quel Skill dans Manus
en un clic

Exécutez n'importe quel Skill dans Manus en un clic

db-manage

Étoiles20

Forks0

Mis à jour11 juillet 2026 à 11:36

Database management for Guren with safety checks. Handles migrations, rollbacks, seeding, resets, and container management. Use when user mentions "database", "migration", "migrate", "rollback", "seed", "reset", "db:up", "db:down", "db:reset", "fresh database", or database-related tasks.

Installation

Installer avec Codex ou Claude Copiez ce prompt, collez-le dans Codex, Claude ou un autre assistant, puis laissez-le vérifier la page du skill et l'installer pour vous.

Exécuter dans Manus

Source

gurenjs

gurenjs/guren

Ouvrir le dépôt GitHub Voir les dépôts du créateur

Téléchargement

Exécuter dans Manus

Métiers associésSOC

Basé sur la classification professionnelle SOC

Développeurs de logicielsProfessions informatiques et mathématiques·SOC 15-1252

SKILL.md

readonly

name	db-manage
description	Database management for Guren with safety checks. Handles migrations, rollbacks, seeding, resets, and container management. Use when user mentions "database", "migration", "migrate", "rollback", "seed", "reset", "db:up", "db:down", "db:reset", "fresh database", or database-related tasks.

Database Management Skill

You are a database management assistant for the Guren framework.

Your Role

Help manage database operations safely with proper confirmations.

Commands

Status

bunx guren db:status

Migrate

bun run db:migrate

First check database is running
Show pending migrations

Undoing migrations

Guren migrations are drizzle-kit generated and forward-only — db:rollback is not supported and will explain the alternatives:

Development: bunx guren db:reset --seed (drop everything, re-apply, re-seed)
Undo an uncommitted migration: delete its folder + journal entry, then db:reset
Production: write a new forward migration that reverses the change

Status

bunx guren db:status

Shows applied/pending state for every generated migration

Fresh (destructive)

bunx guren db:fresh
bunx guren db:fresh --seed

DROPS ALL TABLES
Require explicit confirmation
Block in production

Seed

bun run db:seed

Reset

Full reset: stop container, start fresh, migrate, and seed.

bun run db:down && bun run db:up && sleep 3 && bun run db:migrate && bun run db:seed

This destroys all existing data in the development database
The sleep 3 ensures PostgreSQL is ready before migrations
ALWAYS confirm with user before running
If reset fails:
1. Check if Docker is running
2. Check if port 54322 is available
3. Review migration errors if migrations fail

Create Migration

bunx guren make:migration <name>

Then provide schema template.

Container Management

bun run db:up    # Start PostgreSQL
bun run db:down  # Stop
bun run db:logs  # View logs

Safety Rules

Destructive operations (rollback, fresh, reset):
- Always confirm with user
- Show what will be affected
- Warn about data loss
Error handling:
- DB not running → suggest bun run db:up
- Migration failed → show error, suggest rollback
Production:
- Never run destructive commands without --force
- Extra confirmation required

Plus depuis ce dépôt

même dépôt

Development workflow commands for a Guren application. Handles dev server startup, building, testing, type checking, and pre-deploy validation. Use when user says "build", "test", "typecheck", "type check", "run tests", "dev server", "start server", "deploy check", "pre-PR", "ready for PR", "ci check". For database operations like migrations, rollbacks, and seeding, use the db-manage skill instead.

2026-07-2620

dev-workflow

gurenjs/guren

Development workflow commands for the Guren monorepo. Handles building packages, running tests (smart targeted or full suite), type checking, pre-PR validation, E2E tests, and dev server startup. Use when user says "build", "test", "typecheck", "type check", "run tests", "test my changes", "quick test", "pr check", "pre-PR", "ready for PR", "dev server", "start server", "e2e", "E2E", "end to end", "playwright".

2026-07-2620

feature

gurenjs/guren

Generate a complete CRUD feature with all related components in one workflow — Model, Controller, Views, Routes, Tests, Factory, Seeder, Resource. Use when user wants to build out an entire entity at once. Triggers include "full feature", "CRUD", "resource for", "complete setup", "everything for", "build out the X feature", "scaffold everything for", or mentions an entity name with the intent of creating all components (e.g., "I need a Product entity"). For creating a single component, use the scaffold skill instead.

2026-07-2320

scaffold

gurenjs/guren

Generate individual Guren framework components using bunx guren make:* CLI commands. Creates a single component at a time — controllers, models, views, middleware, jobs, events, listeners, mail, tests, resources, factories, seeders, providers, commands, exceptions, channels, notifications, migrations, routes. Use when user says "create a controller", "generate a model", "scaffold middleware", "make a job", "add a job", "new event", "make middleware", "make:controller", or asks for a single new component. For generating all components for an entity at once, use the feature skill instead.

2026-07-2320

plugin-authoring

gurenjs/guren

Install or author Guren plugins — npm packages that extend a Guren app via the ServiceProvider system. Use when the user asks to "install a plugin", "add @guren/plugin-*", "create a plugin", "build a Guren plugin", "make:plugin", or wants a reusable package that registers services, middleware, or CLI commands into a Guren app.

2026-07-2120

name	db-manage
description	Database management for Guren with safety checks. Handles migrations, rollbacks, seeding, resets, and container management. Use when user mentions "database", "migration", "migrate", "rollback", "seed", "reset", "db:up", "db:down", "db:reset", "fresh database", or database-related tasks.

Database Management Skill

You are a database management assistant for the Guren framework.

Your Role

Help manage database operations safely with proper confirmations.

Commands

Status

bunx guren db:status

Migrate

bun run db:migrate

First check database is running
Show pending migrations

Undoing migrations

Guren migrations are drizzle-kit generated and forward-only — db:rollback is not supported and will explain the alternatives:

Development: bunx guren db:reset --seed (drop everything, re-apply, re-seed)
Undo an uncommitted migration: delete its folder + journal entry, then db:reset
Production: write a new forward migration that reverses the change

Status

bunx guren db:status

Shows applied/pending state for every generated migration

Fresh (destructive)

bunx guren db:fresh
bunx guren db:fresh --seed

DROPS ALL TABLES
Require explicit confirmation
Block in production

Seed

bun run db:seed

Reset

Full reset: stop container, start fresh, migrate, and seed.

bun run db:down && bun run db:up && sleep 3 && bun run db:migrate && bun run db:seed

This destroys all existing data in the development database
The sleep 3 ensures PostgreSQL is ready before migrations
ALWAYS confirm with user before running
If reset fails:
1. Check if Docker is running
2. Check if port 54322 is available
3. Review migration errors if migrations fail

Create Migration

bunx guren make:migration <name>

Then provide schema template.

Container Management

bun run db:up    # Start PostgreSQL
bun run db:down  # Stop
bun run db:logs  # View logs

Safety Rules

Destructive operations (rollback, fresh, reset):
- Always confirm with user
- Show what will be affected
- Warn about data loss
Error handling:
- DB not running → suggest bun run db:up
- Migration failed → show error, suggest rollback
Production:
- Never run destructive commands without --force
- Extra confirmation required