Database Design

What it does

This skill assists in designing relational databases. It can generate SQL schema definitions, including table structures and relationships based on a textual description of requirements. The agent will produce optimized designs considering data types and indexing strategies to ensure efficient querying.

When to use it

• You need to design a database for a new application or system.
• You want to optimize an existing database schema for better performance.
• You're prototyping a data model before full implementation.
• You require assistance in translating business requirements into a relational database structure.

Key capabilities

• Generates SQL schema definitions.
• Creates table structures with appropriate columns and data types.
• Defines relationships between tables (e.g., foreign keys).
• Suggests indexing strategies for improved query performance.

Example prompts

• "Design a database to store customer order information, including customer details, products, and order items."
• "Create a relational schema for managing a library's books, authors, and borrowers."
• “I need a database design for tracking inventory in a warehouse.”

Tips & gotchas

The quality of the generated schema depends heavily on the clarity and completeness of your initial requirements. Providing detailed descriptions will yield more accurate and useful results.