Database Schema Architect

What it does

This skill designs database schemas based on provided requirements. It can generate table structures, define data types for columns, and establish relationships between tables to create a functional and efficient database design. The resulting schema is suitable for relational databases like PostgreSQL or MySQL.

When to use it

• You need a database designed from scratch for a new application.
• You want to refactor an existing database schema to improve performance or scalability.
• You're prototyping a data model and require a quick, structured design.
• You have complex business rules that need to be represented in a relational database.

Key capabilities

• Table creation with column definitions
• Data type selection for columns
• Relationship definition (one-to-many, many-to-many)
• Schema generation suitable for relational databases

Example prompts

• "Design a database schema for an online bookstore, including tables for books, authors, and customers."
• "Create a database schema to track inventory levels for a retail store. Include tables for products, categories, and suppliers."
• “Generate a database schema for managing student enrollment in courses, with relationships between students, courses, and instructors.”

Tips & gotchas

The quality of the generated schema depends heavily on the clarity and completeness of your initial requirements. Providing detailed information about entities, attributes, and relationships will yield better results.