Limit non unique indexes in PostgreSQL

postgresqldrizzlemigrations
Limit non-unique indexes to a maximum of three columns in PostgreSQL databases:
Bad:
```sql
CREATE INDEX index_users_on_multiple_columns ON users (column_a, column_b, column_c, column_d);
```
Good:

Install this rule for wispbit

Quick Install

Recommended
View install script

Run this one command to automatically install the rule:

curl -fsSL https://wispbit.com/api/install?rule=postgresql-limit-non-unique-index | bash

Manual install

1

Copy the rule

---
include: *.sql
---
Limit non-unique indexes to a maximum of three columns in PostgreSQL databases:
Bad:
```sql
CREATE INDEX index_users_on_multiple_columns ON users (column_a, column_b, column_c, column_d);
```
Good:
```sql
CREATE INDEX CONCURRENTLY index_users_on_selective_columns ON users (column_d, column_b);
```
2

Add the rule into your project

Save the copied content as: .wispbit/rules/postgresql-limit-non-unique-index.md

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: |
                
        Limit non-unique indexes to a maximum of three columns in PostgreSQL databases:
        
        Bad:
        
        ```sql
        CREATE INDEX index_users_on_multiple_columns ON users (column_a, column_b, column_c, column_d);
        ```
        
        Good:
        
        ```sql
        CREATE INDEX CONCURRENTLY index_users_on_selective_columns ON users (column_d, column_b);
        ```

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.

Limit non-unique indexes to a maximum of three columns in PostgreSQL databases:
Bad:
```sql
CREATE INDEX index_users_on_multiple_columns ON users (column_a, column_b, column_c, column_d);
```
Good:
```sql
CREATE INDEX CONCURRENTLY index_users_on_selective_columns ON users (column_d, column_b);
```

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.

Limit non-unique indexes to a maximum of three columns in PostgreSQL databases:
Bad:
```sql
CREATE INDEX index_users_on_multiple_columns ON users (column_a, column_b, column_c, column_d);
```
Good:
```sql
CREATE INDEX CONCURRENTLY index_users_on_selective_columns ON users (column_d, column_b);
```

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.

Limit non-unique indexes to a maximum of three columns in PostgreSQL databases:
Bad:
```sql
CREATE INDEX index_users_on_multiple_columns ON users (column_a, column_b, column_c, column_d);
```
Good:
```sql
CREATE INDEX CONCURRENTLY index_users_on_selective_columns ON users (column_d, column_b);
```

File Path Patterns:

*.sql