# Plan Complete Database Workflows

Database projects often span disconnected design, migration, optimization, and operations tasks. This skill organizes those tasks into one phased workflow with focused specialist prompts.

## Install

```bash
npx skillstore add sickn33/database
```

## Metadata

- Status: approved
- Slug: sickn33-database
- Skillstore revision: r2
- Version status: missing
- Tree hash: 77da6ee6e67e49241eb55cddb4c2a98c42620d593e2525aea18bf183b8e27609
- Author: sickn33
- GitHub username: sickn33
- License: MIT
- Repository: https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/database
- Ref: f9e2c34b4f19c7f3e6b0a1e93227b5f77cc12526
- Supported tools: Claude, Codex, Claude Code
- Audit status: complete
- Agent install advisory: allowed
- Manual install advisory: allowed
- Artifact signature: available
- Audit attestation: unavailable
- Human verification: not\_verified
- Risk factors: external\_commands
- Quality score: 78
- Quality tier: bronze
- Public page: https://skillstore.pages.dev/skills/sickn33-database
- Manifest: https://skillstore.pages.dev/api/skills/sickn33-database/manifest

## Capabilities

- Organizes database work into seven phases from schema design through operations.
- Routes tasks to named specialist skills for PostgreSQL, NoSQL, Prisma, Airflow, dbt, and other platforms.
- Provides reusable prompts for design, implementation, optimization, migration, pipeline, quality, and administration tasks.
- Defines action checklists for each database workflow phase.
- Supplies quality gates for migrations, performance, backups, monitoring, and documentation.

## Use Cases

- Design a New Data Store: Structure requirements, schema relationships, indexing, and scalability decisions before implementation.
- Plan a Controlled Migration: Coordinate migration strategy, scripts, testing, execution, and integrity verification.
- Improve Data Operations: Review backups, replication, monitoring, capacity, quality checks, and operational security.

## Prompt Templates

### Choose a Workflow Phase

```
My database task is [task]. Identify the relevant workflow phase, required inputs, recommended specialist skill, actions, and quality gates.
```

### Plan a Database Schema

```
Plan a [SQL or NoSQL] schema for [application]. Cover entities, relationships, indexing, scalability, constraints, open questions, and review checkpoints.
```

### Prepare a Migration

```
Create a migration plan from [source] to [target]. Include dependencies, test stages, rollback criteria, integrity checks, downtime risks, and responsible roles.
```

### Coordinate an End-to-End Program

```
Build a phased database program for [system]. Coordinate design, implementation, optimization, migration, pipelines, quality, and operations with dependencies and acceptance gates.
```

## Limitations

- Does not connect to databases, run queries, or execute migrations.
- Depends on separately available specialist skills named in the workflow.
- Does not provide environment-specific SQL, credentials, or deployment configuration.
- Requires users to validate generated plans against production requirements and access controls.

## Best Practices

- Provide the database platform, workload, scale, constraints, and success criteria before selecting specialist skills.
- Review each phase output before starting dependent implementation or operational work.
- Test migrations, backups, and recovery procedures in a representative non-production environment.

## Anti Patterns

- Do not execute generated migration guidance directly against production systems.
- Do not skip integrity, rollback, backup, or monitoring gates to accelerate delivery.
- Do not assume every referenced specialist skill is installed or appropriate for the environment.

## Security Audit

- Audited at: 2026-07-23T22:26:12.435\+00:00
- Summary: All 53 static findings are false positives caused by Markdown backticks used for inline names and fenced plain-language examples. SKILL.md contains no executable code, command invocation, prompt injection, network behavior, or data-exfiltration intent.

## Stats

- Views: 135
- Downloads: 9
- Favorites: 0
- Popularity score: 0