skills.rest
bradtaylorsf
bradtaylorsfCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

schema-design

Design normalized database schemas with SQL and Prisma patterns.

8|2|Updated Jan 15, 2026
Search Tags:#schema design#database#multi-tenancy#sql#normalization#prisma#relationships
One-click install
npx skills add https://github.com/bradtaylorsf/alphaagent-team --skill schema-design-bradtaylorsf
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: schema-design
Source: https://github.com/bradtaylorsf/alphaagent-team/tree/main/plugins/aai-dev-database/skills/schema-design
Command: npx skills add https://github.com/bradtaylorsf/alphaagent-team --skill schema-design-bradtaylorsf

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides guidance and best practices for designing efficient, normalized, and maintainable database schemas, preventing common pitfalls and ensuring data integrity.

Core Features & Use Cases

  • Normalization Guidance: Explains and demonstrates 1NF, 2NF, and 3NF.
  • Key & Relationship Design: Offers patterns for primary keys, foreign keys, and various relationship types (one-to-one, one-to-many, many-to-many).
  • Data Type Selection: Recommends appropriate SQL and Prisma data types for different kinds of information.
  • Common Patterns: Illustrates polymorphic relations, self-referential relations, and enum vs. lookup table choices.
  • Multi-Tenancy: Shows column-based and schema-based isolation patterns.
  • Use Case: A developer needs to design a new PostgreSQL database for an e-commerce platform and wants to ensure the schema is well-structured and scalable.

Quick Start

Use the schema-design skill to understand how to implement a many-to-many relationship in Prisma.

Frequently Asked Questions about schema-design

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

FAQPage Schema
How do I design a database schema for multi-tenancy?▼

Database schema multi-tenancy can be implemented using column-based or schema-based isolation patterns, allowing scalable data separation for different tenants within a single database structure.

What are the best practices for database normalization?▼

Database normalization best practices involve structuring data into 1NF, 2NF, and 3NF to reduce redundancy and ensure data integrity, creating efficient and maintainable relational database structures.

How do I implement many-to-many relationships in Prisma?▼

To implement many-to-many relationships in Prisma, use specific ORM patterns for join tables and foreign keys, ensuring proper data type selection and relationship mapping for scalable database structures.

When should I use enums vs lookup tables in SQL?▼

Use enums for fixed, small sets of values, while lookup tables offer greater flexibility for data that may expand, a common database design pattern choice for maintaining data integrity.

How do you design polymorphic relations in a relational database?▼

Designing polymorphic relations in a relational database involves using specific structural patterns to allow a single table to reference multiple other tables, solving complex data modeling challenges.

Can this skill help with data type selection for an e-commerce database?▼

Yes, this skill recommends appropriate SQL and Prisma data types for different kinds of information, supporting developers in creating well-structured and scalable e-commerce database schemas.

Related Skills

Explore More Software Engineering Skills→
R2W1csR2W1cs
1

prisma-expert

Optimize Prisma ORM schemas, migrations, queries, connections, and transactions.

Community
Advanced
inbharataiinbharatai
22

db-schema-designer

Design normalized relational database schemas with ERDs, indexes, constraints, and migration scripts.

Community
Intermediate
marquesfelipmarquesfelip

sql-injection-prevention

Identify and fix SQL injection vulnerabilities in data access layers.

Community
Advanced
Arnutt-NArnutt-N

Database Design & ER Diagram

Designs normalized relational databases and creates Mermaid ER diagrams.

Community
Advanced