# drizzle

> Drizzle: no update or delete without `where`, raw SQL only at paths the settings allow, and migrations that match the schema.

Drizzle: no update or delete without `where`, raw SQL only at paths the settings allow, and migrations that match the schema. It requires [`javascript`](/reference/configurations/javascript/).

## Checks

| Check                                                                     | Stage  | Level         | What it does                                                       |
| ------------------------------------------------------------------------- | ------ | ------------- | ------------------------------------------------------------------ |
| [`drizzle/stale-migrations`](/reference/checks/drizzle/stale-migrations/) | `push` | `recommended` | Runs `drizzle-kit generate` and fails when it creates a migration. |

## Settings

| Setting                                                               | What it sets                                                                                    |
| --------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------- |
| [`drizzle.client_names`](/reference/gspot-toml/#drizzle.client_names) | The Drizzle client identifiers checked for update and delete operations without a where clause. |

## Selected when

gspot selects it in a scope with dependencies `drizzle-orm`.

## Rules for coding agents

| Rule file                                                | Installed when                                    |
| -------------------------------------------------------- | ------------------------------------------------- |
| `.gspot/configurations/library/drizzle/rules/DRIZZLE.md` | The repository has dependencies `pg`, `postgres`. |

## Tools and versions

| Tool                  | Version |
| --------------------- | ------- |
| eslint-plugin-drizzle | `0.2.3` |
| drizzle-kit           | Any     |