Postgresql Table Design

What it does

This skill assists in designing PostgreSQL database tables. It can generate SQL CREATE TABLE statements based on a description of the data to be stored, including specifying column names, data types, and constraints like primary keys and foreign keys. The goal is to produce efficient and well-structured table schemas for various applications.

When to use it

• You need to create a new database table but aren't sure how to define its structure.
• You have a description of the data you want to store, and you need help translating that into SQL code.
• You’re prototyping a database schema and want to quickly generate initial CREATE TABLE statements.
• You are refactoring an existing table design for improved performance or clarity.

Key capabilities

• Generates CREATE TABLE SQL statements.
• Suggests appropriate data types based on descriptions.
• Handles primary key and foreign key constraints.
• Supports column name suggestions.

Example prompts

• "Create a table to store customer information, including name, email, and address."
• "Design a table for products with columns for product ID, name, price, and category."
• “Generate SQL for an orders table linked to a customers table.”

Tips & gotchas

The quality of the generated SQL depends heavily on the clarity and detail provided in your prompt. Be as specific as possible when describing the data you want to store.