database

name	database
description	Database development and operations workflow covering SQL, NoSQL, database design, migrations, optimization, and data engineering.
type	skill
created	2026-02-27T00:00:00.000Z
domain	software-development
category	database
risk	safe
source	personal
tags	["skill","software-development","database"]

Database Workflow Bundle

Overview

Comprehensive database workflow for database design, development, optimization, migrations, and data engineering. Covers SQL, NoSQL, and modern data platforms.

When to Use This Workflow

Use this workflow when:

• Designing database schemas
• Implementing database migrations
• Optimizing query performance
• Setting up data pipelines
• Managing database operations
• Implementing data quality

Workflow Phases

Phase 1: Database Design

Skills to Invoke

• database-architect - Database architecture
• database-design - Schema design
• postgresql - PostgreSQL design
• nosql-expert - NoSQL design

Actions

1. Gather requirements
2. Design schema
3. Define relationships
4. Plan indexing strategy
5. Design for scalability

Copy-Paste Prompts

Use @database-architect to design database schema

Use @postgresql to design PostgreSQL schema

Phase 2: Database Implementation

Skills to Invoke

• prisma-expert - Prisma ORM
• database-migrations-sql-migrations - SQL migrations
• neon-postgres - Serverless Postgres

Actions

1. Set up database connection
2. Configure ORM
3. Create migrations
4. Implement models
5. Set up seed data

Copy-Paste Prompts

Use @prisma-expert to set up Prisma ORM

Use @database-migrations-sql-migrations to create migrations

Phase 3: Query Optimization

Skills to Invoke

• database-optimizer - Database optimization
• sql-optimization-patterns - SQL optimization
• postgres-best-practices - PostgreSQL optimization

Actions

1. Analyze slow queries
2. Review execution plans
3. Optimize indexes
4. Refactor queries
5. Implement caching