Postgresql Table Design

What it does

This skill assists in designing PostgreSQL tables, including defining columns with appropriate data types and constraints. It can generate SQL CREATE TABLE statements based on provided descriptions of desired table structure and intended use. The skill aims to produce efficient and well-structured database schemas suitable for various applications.

When to use it

• You need to create a new PostgreSQL table but are unsure about the optimal column types or constraints.
• You have a description of data you want to store (e.g., "a list of customers with names, addresses and order history") and want SQL code generated for that.
• You're refactoring an existing database schema and need help designing new tables to fit evolving requirements.
• You are prototyping a new application and require initial database table structures.

Key capabilities

• Generates CREATE TABLE statements.
• Suggests appropriate PostgreSQL data types for columns.
• Incorporates constraints (e.g., primary keys, foreign keys) into the schema design.
• Designs tables based on textual descriptions of requirements.

Example prompts

• "Create a table to store product information with fields for name, description, price and category."
• "Design a PostgreSQL table for users including username, email address, password hash and registration date."
• “I need a table to track orders in an e-commerce system. It should include customer ID, order date, total amount and shipping address.”

Tips & gotchas

The skill's output is based on the provided description; be as clear and detailed as possible for best results. Review generated SQL carefully before deploying it to a production database.