Supabase Schema From Requirements

What it does

This skill generates Supabase schema definitions (SQL CREATE TABLE statements) based on natural language requirements. It translates user-provided descriptions of data structures into functional database schemas, including table names, column types, and constraints. The generated SQL is ready to be executed within a Supabase project.

When to use it

• You need to quickly prototype a new application's database structure without writing SQL manually.
• You have a clear understanding of the data you need to store but lack experience with database schema design.
• You want to automate the creation of database tables based on evolving business requirements.
• You’re iterating rapidly and need to adjust your database schema frequently.

Key capabilities

• Generates SQL CREATE TABLE statements.
• Translates natural language descriptions into table structures.
• Includes column types and constraints in the generated schema.
• Designed for use with Supabase projects.

Example prompts

• "Create a table to store customer data, including name, email, and order history."
• "Generate a database schema for a blog application with posts, authors, and comments."
• “I need a table to track inventory levels of products in my online store.”

Tips & gotchas

The quality of the generated schema depends heavily on the clarity and detail provided in the input requirements. Be as specific as possible when describing your data structures for best results.