General Relational Database Principles

This skill provides core guidelines for designing and interacting with relational databases (MySQL, PostgreSQL, etc.).

When to use this skill

• Designing new database schemas (DDL).
• Reviewing or refactoring existing tables.
• Writing complex SQL queries that involve joins or transactions.
• troubleshooting data integrity issues.

1. Naming Conventions

• Tables: Plural_snake_case (e.g., users, order_items).
• Columns: snake_case (e.g., is_active, created_at).
• Primary Keys: id (or product_id if strictly required by convention, but id preferred for simplicity).
• Foreign Keys: singular_table_name_id (e.g., user_id references users.id).
• Indexes: idx_table_columns; Unique: uniq_table_columns.