Database Designer

What it does

The aidotnet-database-designer skill allows AI agents to design relational databases based on textual descriptions. It can generate SQL scripts, including table schemas with appropriate data types and constraints. The tool aims to automate the initial database creation process, reducing manual effort for developers.

When to use it

• You need a database schema created from a natural language description of requirements.
• You're prototyping a new application and want to quickly generate an initial database structure.
• You’re refactoring existing data models and require assistance in translating changes into SQL.
• You are teaching students about relational databases and want a tool to demonstrate schema creation.

Key capabilities

• Generates SQL scripts for creating tables.
• Defines table schemas with appropriate data types.
• Creates constraints (e.g., primary keys, foreign keys).
• Designs based on textual descriptions of database requirements.

Example prompts

• "Create a database schema for an online bookstore with tables for books, authors, and customers."
• "Design a relational database to manage student enrollment in courses, including tables for students, courses, and enrollments."
• “Generate SQL to create a database for tracking inventory of products in a warehouse.”

Tips & gotchas

The quality of the generated schema depends heavily on the clarity and completeness of the input description. Provide detailed information about entities, attributes, and relationships for optimal results.