Database Schema Designer

Use when the user asks to create ERD diagrams, normalize database schemas, design table relationships, or plan schema migrations.

Development / Engineeringdevelopmentengineering
by AgentVoltv1.0.0Published 1y ago1 install
Free to sign up · every skill included with AgentVolt Pro

Before & after

Same prompt, same agent — the only difference is the skill.

PromptDesign a database schema for a podcast platform with creators and listeners
Beforegeneric AI agent
A database schema for a podcast platform would need to handle users, episodes, subscriptions, and that kind of thing. Normalization is important so you don't have data redundancy. You'll probably want separate tables for different entities and then think about relationships between them. There are different approaches you could take depending on how you want to query the data.
Afterwith Database Schema Designer
PODCAST PLATFORM SCHEMA

TABLE: users
• id (PK)
• email (unique)
• role (creator | listener)
• created_at

TABLE: shows
• id (PK)
• creator_id (FK→users)
• title
• description
• cover_url
• created_at

TABLE: episodes
• id (PK)
• show_id (FK→shows)
• title
• description
• audio_url
• duration_seconds
• published_at
• created_at

TABLE: subscriptions
• id (PK)
• listener_id (FK→users)
• show_id (FK→shows)
• subscribed_at
• (composite index: listener_id, show_id)

TABLE: listens
• id (PK)
• listener_id (FK→users)
• episode_id (FK→episodes)
• position_seconds
• completed_at (nullable)
• created_at

KEY RELATIONSHIPS
• One creator has many shows
• One show has many episodes
• Listeners subscribe to shows
• Listeners generate listen records per episode

INDEXES: (show_id, published_at), (listener_id, subscribed_at)

About this skill


name: database-schema-designer description: Use when Use when the user asks to create ERD diagrams, normalize database schemas, design table relationships, or plan schema migrations.

Database Schema Designer

Use when the user asks to create ERD diagrams, normalize database schemas, design table relationships, or plan schema migrations.

What you get

  • Public GitHub repo (alirezarezvani/claude-skills)
  • the database-schema-designer skill folder with SKILL.md. Part of a 337-skill / 30-agent / 70-command install.

Customize your output

  • Fork the repo and adapt the skill's instructions and references to your workflow.

Example output

Activates automatically when your request matches Database Schema Designer; chains with the other skills, agents, and commands in the collection.

Best for

Creators, builders, and teams using Claude Code.

SKILL.md preview

SKILL.md
---
name: database-schema-designer
description: Use when creating ERD diagrams, normalizing database schemas, designing table relationships, or planning schema migrations.
version: 1.0.0
category: Development / Engineering
author: AgentVolt
license: proprietary
tags:
  - development
  - engineering
---

# Database Schema Designer

Designs normalized relational schemas covering entities, relationships, and keys, and produces the ERD and migration plan needed to implement them safely.

## When to use
- Starting a new feature that needs new tables and relationships designed from scratch

… (sign up to view the full skill)
Sign up to view, copy, and install the full skill

More development skills

View all Development skills →