Drizzle ORM Code Writer and Reviewer-Drizzle ORM code assistance

Example

A developer uses `db.select().from(users).where(eq(users.id, 1))` to fetch a specific user by ID. The tool reviews the query and suggests adding `prepare()` for performance optimization in cases where the same query is executed multiple times.

Scenario

A developer building an API wants to optimize query performance in a user management system. The tool helps ensure that queries are written with correct SQL syntax, as well as suggests using prepared statements for frequent queries.

Example

A developer defines a table schema with `pgTable('users', {...})` in a PostgreSQL database. The tool checks the schema for completeness, ensuring that constraints such as `primaryKey` or `uniqueIndex` are correctly applied.

Scenario

When setting up a new database schema, the developer wants to ensure proper structure and relationships between tables. The tool validates the schema and flags missing or incorrect relationships, such as unindexed columns in a foreign key relationship.

Example

The tool reviews a batch operation where a developer runs multiple queries, like `db.batch([...])`, and ensures that transactions are properly configured and handled.

Scenario

In scenarios where bulk database operations are required, such as batch inserts or updates, the tool helps the developer optimize these operations and provides feedback on handling potential errors or rollbacks.

Example

A developer sets up a transaction using `db.transaction(...)`, and the tool suggests adding appropriate `isolationLevel` settings to prevent issues like dirty reads in concurrent environments.

Scenario

In a financial application where consistency is critical, the tool helps ensure that all updates within a transaction are applied atomically, and advises on using nested transactions and savepoints.

Example

The tool helps in constructing complex conditional queries using operators like `eq`, `ne`, `lt`, and `inArray` in `where` clauses, ensuring they are SQL-compliant and well-optimized.

Scenario

In a search functionality, the developer wants to filter records based on multiple conditions. The tool assists in writing the conditions efficiently and ensures that the query logic is sound.