Db Generate

What it does

The medusajs-db-generate skill allows you to generate database schemas and migrations based on natural language descriptions. It can create tables, define relationships between them, and produce SQL migration files ready for execution. This simplifies the process of setting up a MedusaJS project's database structure.

When to use it

• Rapid prototyping: Quickly establish a basic database schema for a new MedusaJS application without manual coding.
• Database migrations: Generate initial or subsequent SQL migration files based on evolving data model requirements.
• Schema definition from documentation: Translate existing database design documents into executable SQL code.
• Learning and experimentation: Explore different database structures and relationships with ease, generating schemas to test ideas.

Key capabilities

• Generates SQL schema definitions.
• Creates SQL migration files.
• Supports defining table relationships (e.g., foreign keys).
• Designed for use within MedusaJS projects.

Example prompts

• "Create a database with tables for 'products', 'categories', and 'users'."
• "Generate a migration to add an index on the 'email' column of the 'users' table."
• “Define a product table with attributes: name, description, price, and category_id (foreign key referencing categories).”

Tips & gotchas

• This skill is specifically designed for MedusaJS projects. Ensure your AI agent has access to the necessary MedusaJS context or libraries.
• The quality of generated SQL depends heavily on the clarity and completeness of the natural language description provided in the prompt.