Engineering · Skill
Database Schema Designer
Use when asked for an ERD, table relationships, normalization or a schema migration plan. Produces the ERD and normalized DDL with migration steps.
Open in PhởWhat the skill covers
The sections of its instructions, in order.
- 01 Overview
- 02 Core Capabilities
- 03 When to Use
- 04 Schema Design Process
- Step 1: Requirements → Entities
- Step 2: Identify Relationships
- Step 3: Add Cross-cutting Concerns
- 05 Full Schema Example (Task Management SaaS)
- 06 Row-Level Security (RLS) Policies
- 07 Seed Data Generation
- 08 ERD Generation (Mermaid)
- 09 Common Pitfalls
- 10 Best Practices
Reference files
1 file Phở can open while it uses the skill.
- references/full-schema-examples.md
More in Engineering review
- PR Review Expert
Review a pull request or diff for bugs, security and quality, file by file. Use whenever the user asks to review a PR or look over their changes.
- Adversarial Code Reviewer
Tough, critical review of a diff or PR before merge, through hostile reviewer personas that catch shared blind spots. Use whenever the user wants a change torn apart, a harsh…
- API Test Suite Builder
Use when asked to write API, integration or contract tests for REST endpoints. Builds the suite from the routes: happy paths, auth, validation errors and edge cases per endpoint.
- Focused Fix — Deep-Dive Feature Repair
Use when a whole feature or module is broken and needs fixing end to end ('make X work', 'the Y module is broken'). Maps every file and dependency of the area before changing…
- Security Guidance Hook
Use when installing or tuning the PreToolUse security hook that warns before Claude writes command injection, XSS, SQL injection, unsafe deserialization, eval or GitHub Actions…
- Stripe Integration Expert
Use for any Stripe integration: subscriptions, trials, proration, checkout, usage billing, webhooks, customer portal or invoicing in Next.js, Express or Django. Writes idempotent…
- LLM Cost Optimizer
Use whenever an LLM feature is being built or its costs come up (model choice, prompt caching, token limits, per-feature spend). Sets routing, caching, max_tokens and cost…
- Prompt Governance
Use when prompts run in production and need versioning, a registry, A/B tests, regression checks or an eval pipeline. Sets up the release process for prompts; single-prompt…
- Zero-Hallucination Coder
Use before high-stakes or multi-file coding (auth, databases, migrations), or when asked to plan carefully and avoid invented APIs. Runs discuss, map, decompose, execute and…
- Embedded / IoT Mentor
Use for any embedded or IoT hardware project (ESP32, STM32, Arduino, Pico, firmware, PCB, MQTT, Home Assistant, sensor dashboards), before buying parts. Picks the MCU, board and…
Similar engineering skills
Frequently asked questions
What does Database Schema Designer do?
Use when asked for an ERD, table relationships, normalization or a schema migration plan. Produces the ERD and normalized DDL with migration steps.
Is Database Schema Designer free to use?
Yes. Database Schema Designer is published by Alireza Rezvani under the MIT licence, and you can use it with a free Phở account.
How do I use Database Schema Designer in Phở?
Press Open in Phở, then Try to apply it to your next message, or add the Engineering review set so Phở loads it whenever a request matches.
Does Database Schema Designer need other tools?
No. It works in a normal Phở chat with what you type or upload.
Copied unchanged from alirezarezvani/claude-skills at commit c85b17e and credited to Alireza Rezvani, who is not affiliated with Phở. The full instructions and licence text ship with the skill inside Phở.