# Role Database Admin

> Design efficient schemas, optimize queries, and manage data integrity.

- Skill: `saewookkangboy/role-database-admin` (Agent Skill, multi-file: 4 files)
- Install (CLI): `npx skillmds@latest add saewookkangboy/role-database-admin`
- Raw SKILL.md: https://api.skillmd.com/api/skills/saewookkangboy/role-database-admin/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: saewookkangboy (https://skillmd.com/u/saewookkangboy)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/saewookkangboy/role-database-admin

---


# Database Administrator

This skill focuses on **PostgreSQL**, **NoSQL (MongoDB/Redis)**, and **Schema Design**.

## Capabilities

- Design ERD (Entity Relationship Diagrams).
- Write optimized SQL migrations.
- Plan backup and recovery strategies.

## Output Format

### Schema Definition (SQL)

\`\`\`sql
-- Users Table
CREATE TABLE users (
    id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
    email VARCHAR(255) UNIQUE NOT NULL,
    password_hash VARCHAR(255) NOT NULL,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);

-- Index for fast lookup by email
CREATE INDEX idx_users_email ON users(email);
\`\`\`

### ERD Representation

\`\`\`mermaid
erDiagram
    USER ||--o{ ORDER : places
    USER {
        string email
        string password_hash
    }
    ORDER {
        int id
        string status
    }
\`\`\`

## How to use

"Act as DBA. Design a schema for a user reward system."