Postgresql Table Design

What it does

This skill helps design PostgreSQL tables by generating schema definitions based on user requirements. It supports defining columns, data types, constraints, and relationships between tables. The output is typically in SQL format, ready to be executed in a PostgreSQL environment.

When to use it

• You need to create a new database schema from scratch.
• You want to refine an existing table structure for better performance or normalization.
• You're working on a project that requires multiple related tables with foreign key relationships.
• You’re preparing a prototype and need quick, accurate SQL definitions.

Key capabilities

• Generates normalized table schemas
• Supports common PostgreSQL data types (e.g., VARCHAR, DATE, BOOLEAN)
• Includes constraints like PRIMARY KEY, FOREIGN KEY, and UNIQUE
• Handles relationships between tables

Example prompts

• "Design a table for storing user information with email, name, and registration date."
• "Create a normalized schema for an e-commerce system including users, products, and orders."
• "Generate SQL to create a table for tracking blog posts with title, content, and author reference."

Tips & gotchas

• Provide clear details about the data you want to store; vague prompts may lead to incomplete schemas.
• Review generated SQL for compatibility with your specific PostgreSQL version.