db-design-agent

Design database schemas and data models for relational and NoSQL applications.

Updated Dec 3, 2025
One-click install
npx skills add https://github.com/Unicorn/Radium --skill db-design-agent
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db-design-agent
Source: https://github.com/Unicorn/Radium/tree/main/skills/design/db-design-agent
Command: npx skills add https://github.com/Unicorn/Radium --skill db-design-agent

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill reduces the time and risk of building database schemas by converting application requirements, data relationships, and query patterns into coherent, maintainable, and performance-oriented designs.

Core Features & Use Cases

  • Relational schema design: define tables, columns, constraints, and foreign-key relationships with normalization guidance.
  • NoSQL and denormalization guidance: propose document/column-family structures and when to denormalize for performance.
  • Indexing, partitioning & migrations: recommend index strategies, partitioning approaches, and migration scripts with rollout plans.
  • Use Case: generate a production-ready schema, ER diagram, and migration plan for an e-commerce or multi-tenant SaaS application.

Quick Start

Ask the agent to design a normalized relational schema for an e-commerce app including users, products, orders, and order_items.

Frequently Asked Questions about db-design-agent

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a normalized relational schema for an e-commerce application?

To design a normalized relational schema, define tables, columns, constraints, and foreign-key relationships. This process structures data relationships efficiently, producing table definitions and ER diagrams tailored to your application requirements and platform.

When should I use NoSQL denormalization instead of a relational schema?

NoSQL denormalization is recommended when query performance requires optimized document or column-family structures. It proposes when to denormalize data to reduce joins and improve read speeds, providing tailored structures for specific query patterns.

What's the best way to plan database migrations and indexing strategies?

The best way to plan database migrations and indexing is to generate index strategies, partitioning approaches, and migration scripts with rollout plans. This ensures performance tuning and safe schema evolution for enterprise applications.

Can I generate a schema and ER diagram for a multi-tenant SaaS application?

Yes, you can generate a production-ready schema and ER diagram for a multi-tenant SaaS application. The design process produces table definitions, indexing strategies, and performance recommendations tailored to platform preferences and query patterns.

Does database schema design work with both relational and NoSQL architectures?

Database schema design works with both relational and NoSQL architectures for web and enterprise applications. It covers schema normalization for relational databases and denormalization guidance for NoSQL structures based on query patterns.