Database Schema Designer

What it does

This skill designs database schemas based on textual descriptions of data requirements. It can generate SQL code to create tables, define relationships (primary keys, foreign keys), and specify data types for columns. The resulting schema is intended to be a functional blueprint for building a relational database.

When to use it

• You need to design a database but lack the expertise or time to do so manually.
• You have a clear understanding of your data requirements expressed in natural language.
• You're prototyping a new application and require a quick database schema for development purposes.
• You want to explore different schema designs based on varying data constraints.

Key capabilities

• Generates SQL CREATE TABLE statements.
• Defines primary keys.
• Establishes foreign key relationships between tables.
• Specifies appropriate data types for columns.

Example prompts

• "Design a database schema for an online bookstore, including tables for books, authors, and customers."
• "Create a database to track student grades in different courses, with fields for student ID, course name, and grade."
• “I need a database schema for managing inventory of a small electronics store. Include tables for products, suppliers, and orders.”

Tips & gotchas

The quality of the generated schema depends heavily on the clarity and completeness of your prompt. Be as specific as possible about the data you want to store and any relationships between them.