Column naming standards in PostgreSQL

postgresqlprismasupabasedrizzlemigrations
Maintain consistent naming conventions for new columns.
Bad
```sql
-- Bad: Column named uuid instead of id
ALTER TABLE users ADD COLUMN uuid UUID PRIMARY KEY DEFAULT gen_random_uuid();
```

Install this rule for wispbit

Add this rule to wispbit and it will run when you open a pull request

Install this rule for Coderabbit

Copy the configuration below and add it to your repository as .coderabbit.yml in your project root.

reviews:
  path_instructions:
    - path: "*.sql"
      instructions: |
                
        Maintain consistent naming conventions for new columns.
        
        Bad
        
        ```sql
        -- Bad: Column named uuid instead of id
        ALTER TABLE users ADD COLUMN uuid UUID PRIMARY KEY DEFAULT gen_random_uuid();
        ```
        
        ```sql
        -- Bad: Column named camelCase instead of snake_case
        ALTER TABLE users ADD COLUMN firstName VARCHAR(255);
        ```
        
        ```sql
        -- Bad: Column foreign key ends with uuid instead of id
        ALTER TABLE orders ADD COLUMN user_uuid UUID REFERENCES users(id);
        ```
        
        ## Good
        
        ```sql
        -- Good: Consistent naming
        ALTER TABLE users ADD COLUMN id UUID PRIMARY KEY DEFAULT gen_random_uuid();
        ALTER TABLE users ADD COLUMN first_name VARCHAR(255);
        ALTER TABLE orders ADD COLUMN user_id UUID REFERENCES users(uuid);
        ```

Install this rule for Greptile

Greptile rules can be added through the web interface. Please see this documentation for details on how to add custom rules and context.

Maintain consistent naming conventions for new columns.
Bad
```sql
-- Bad: Column named uuid instead of id
ALTER TABLE users ADD COLUMN uuid UUID PRIMARY KEY DEFAULT gen_random_uuid();
```
```sql
-- Bad: Column named camelCase instead of snake_case
ALTER TABLE users ADD COLUMN firstName VARCHAR(255);
```
```sql
-- Bad: Column foreign key ends with uuid instead of id
ALTER TABLE orders ADD COLUMN user_uuid UUID REFERENCES users(id);
```
## Good
```sql
-- Good: Consistent naming
ALTER TABLE users ADD COLUMN id UUID PRIMARY KEY DEFAULT gen_random_uuid();
ALTER TABLE users ADD COLUMN first_name VARCHAR(255);
ALTER TABLE orders ADD COLUMN user_id UUID REFERENCES users(uuid);
```

File Path Patterns:

*.sql

Install this rule for GitHub Copilot

Copilot instructions can be added through the interface. See the documentation for details on how to create coding guidelines.

Maintain consistent naming conventions for new columns.
Bad
```sql
-- Bad: Column named uuid instead of id
ALTER TABLE users ADD COLUMN uuid UUID PRIMARY KEY DEFAULT gen_random_uuid();
```
```sql
-- Bad: Column named camelCase instead of snake_case
ALTER TABLE users ADD COLUMN firstName VARCHAR(255);
```
```sql
-- Bad: Column foreign key ends with uuid instead of id
ALTER TABLE orders ADD COLUMN user_uuid UUID REFERENCES users(id);
```
## Good
```sql
-- Good: Consistent naming
ALTER TABLE users ADD COLUMN id UUID PRIMARY KEY DEFAULT gen_random_uuid();
ALTER TABLE users ADD COLUMN first_name VARCHAR(255);
ALTER TABLE orders ADD COLUMN user_id UUID REFERENCES users(uuid);
```

File Path Patterns:

*.sql

Install this rule for Graphite Diamond

Diamond custom rules can be added through the interface. See the documentation for details on how to create custom rules.

Maintain consistent naming conventions for new columns.
Bad
```sql
-- Bad: Column named uuid instead of id
ALTER TABLE users ADD COLUMN uuid UUID PRIMARY KEY DEFAULT gen_random_uuid();
```
```sql
-- Bad: Column named camelCase instead of snake_case
ALTER TABLE users ADD COLUMN firstName VARCHAR(255);
```
```sql
-- Bad: Column foreign key ends with uuid instead of id
ALTER TABLE orders ADD COLUMN user_uuid UUID REFERENCES users(id);
```
## Good
```sql
-- Good: Consistent naming
ALTER TABLE users ADD COLUMN id UUID PRIMARY KEY DEFAULT gen_random_uuid();
ALTER TABLE users ADD COLUMN first_name VARCHAR(255);
ALTER TABLE orders ADD COLUMN user_id UUID REFERENCES users(uuid);
```

File Path Patterns:

*.sql

Use with Cline

Copy the rule below and ask Cline to review your code using this rule

Maintain consistent naming conventions for new columns.
Bad
```sql
-- Bad: Column named uuid instead of id
ALTER TABLE users ADD COLUMN uuid UUID PRIMARY KEY DEFAULT gen_random_uuid();
```
```sql
-- Bad: Column named camelCase instead of snake_case
ALTER TABLE users ADD COLUMN firstName VARCHAR(255);
```
```sql
-- Bad: Column foreign key ends with uuid instead of id
ALTER TABLE orders ADD COLUMN user_uuid UUID REFERENCES users(id);
```
## Good
```sql
-- Good: Consistent naming
ALTER TABLE users ADD COLUMN id UUID PRIMARY KEY DEFAULT gen_random_uuid();
ALTER TABLE users ADD COLUMN first_name VARCHAR(255);
ALTER TABLE orders ADD COLUMN user_id UUID REFERENCES users(uuid);
```

Use with OpenAI Codex

Copy the rule below and ask OpenAI Codex to review your code using this rule

Maintain consistent naming conventions for new columns.
Bad
```sql
-- Bad: Column named uuid instead of id
ALTER TABLE users ADD COLUMN uuid UUID PRIMARY KEY DEFAULT gen_random_uuid();
```
```sql
-- Bad: Column named camelCase instead of snake_case
ALTER TABLE users ADD COLUMN firstName VARCHAR(255);
```
```sql
-- Bad: Column foreign key ends with uuid instead of id
ALTER TABLE orders ADD COLUMN user_uuid UUID REFERENCES users(id);
```
## Good
```sql
-- Good: Consistent naming
ALTER TABLE users ADD COLUMN id UUID PRIMARY KEY DEFAULT gen_random_uuid();
ALTER TABLE users ADD COLUMN first_name VARCHAR(255);
ALTER TABLE orders ADD COLUMN user_id UUID REFERENCES users(uuid);
```

Use with Cursor

Copy the rule below and ask Cursor to review your code using this rule

Maintain consistent naming conventions for new columns.
Bad
```sql
-- Bad: Column named uuid instead of id
ALTER TABLE users ADD COLUMN uuid UUID PRIMARY KEY DEFAULT gen_random_uuid();
```
```sql
-- Bad: Column named camelCase instead of snake_case
ALTER TABLE users ADD COLUMN firstName VARCHAR(255);
```
```sql
-- Bad: Column foreign key ends with uuid instead of id
ALTER TABLE orders ADD COLUMN user_uuid UUID REFERENCES users(id);
```
## Good
```sql
-- Good: Consistent naming
ALTER TABLE users ADD COLUMN id UUID PRIMARY KEY DEFAULT gen_random_uuid();
ALTER TABLE users ADD COLUMN first_name VARCHAR(255);
ALTER TABLE orders ADD COLUMN user_id UUID REFERENCES users(uuid);
```

Use with Claude Code

Copy the rule below and ask Claude Code to review your code using this rule

Maintain consistent naming conventions for new columns.
Bad
```sql
-- Bad: Column named uuid instead of id
ALTER TABLE users ADD COLUMN uuid UUID PRIMARY KEY DEFAULT gen_random_uuid();
```
```sql
-- Bad: Column named camelCase instead of snake_case
ALTER TABLE users ADD COLUMN firstName VARCHAR(255);
```
```sql
-- Bad: Column foreign key ends with uuid instead of id
ALTER TABLE orders ADD COLUMN user_uuid UUID REFERENCES users(id);
```
## Good
```sql
-- Good: Consistent naming
ALTER TABLE users ADD COLUMN id UUID PRIMARY KEY DEFAULT gen_random_uuid();
ALTER TABLE users ADD COLUMN first_name VARCHAR(255);
ALTER TABLE orders ADD COLUMN user_id UUID REFERENCES users(uuid);
```

Install this rule for Windsurf

To set up rules for Windsurf Reviews, please see this documentation 

Maintain consistent naming conventions for new columns.
Bad
```sql
-- Bad: Column named uuid instead of id
ALTER TABLE users ADD COLUMN uuid UUID PRIMARY KEY DEFAULT gen_random_uuid();
```
```sql
-- Bad: Column named camelCase instead of snake_case
ALTER TABLE users ADD COLUMN firstName VARCHAR(255);
```
```sql
-- Bad: Column foreign key ends with uuid instead of id
ALTER TABLE orders ADD COLUMN user_uuid UUID REFERENCES users(id);
```
## Good
```sql
-- Good: Consistent naming
ALTER TABLE users ADD COLUMN id UUID PRIMARY KEY DEFAULT gen_random_uuid();
ALTER TABLE users ADD COLUMN first_name VARCHAR(255);
ALTER TABLE orders ADD COLUMN user_id UUID REFERENCES users(uuid);
```