schema-designer

What it does

This skill enables AI agents to generate, modify, and validate database schemas based on natural language descriptions or specific requirements. It automates the structural design of data models, ensuring consistency and adherence to defined constraints without manual SQL drafting.

When to use it

• Rapidly prototyping new database structures during the initial planning phase of a project.
• Converting complex business logic or domain concepts into normalized relational tables.
• Refactoring existing schemas to improve performance or support new feature requirements.
• Validating proposed data models against specific integrity rules before implementation.

Key capabilities

• Generates complete SQL CREATE TABLE statements from text prompts.
• Defines primary keys, foreign keys, and column data types automatically.
• Supports iterative schema evolution based on feedback or changing requirements.
• Validates schema definitions for logical consistency and standard compliance.

Example prompts

• "Create a PostgreSQL schema for an e-commerce platform with users, products, orders, and order items."
• "Modify the existing user table to include a new 'subscription_tier' column with a default value of 'free'."
• "Generate a normalized schema for a library management system that tracks books, authors, and borrowing history."

Tips & gotchas

Ensure you specify the target database dialect (e.g., PostgreSQL, MySQL) in your prompts to receive syntax-appropriate output. While the skill automates structure generation, always review generated foreign key relationships to ensure they accurately reflect your application's data flow logic.