Drizzle ORM Code Writer and Reviewer-Drizzle ORM Code Assistance

Example

A user needs to write an SQL insert statement using Drizzle ORM. The tool provides a detailed code snippet.

Scenario

The user is developing a feature that requires inserting multiple rows into a database table. The tool generates the following code snippet: `await db.insert(users).values([{ name: 'Andrew' }, { name: 'Dan' }]);` along with an explanation on how to handle conflicts with `onConflictDoUpdate`.

Example

A user submits a code snippet for a SQL update operation for review.

Scenario

The user has written a code snippet to update a user's name in the database. The tool reviews the code, identifies potential issues, and suggests improvements. For instance, `await db.update(users).set({ name: 'Mr. Dan' }).where(eq(users.name, 'Dan'));` and advises on using `.returning` to get the updated row back in PostgreSQL and SQLite.

Example

A user seeks advice on how to optimize query performance.

Scenario

The user is experiencing slow query performance. The tool explains the benefits of using prepared statements in Drizzle ORM and provides an example: `const prepared = db.select().from(customers).prepare(); const res = await prepared.execute();` to illustrate how prepared statements can significantly enhance performance.