Source: https://reporules.fyi/express/transaction-cleanup/

# Return the PostgreSQL client after every Express transaction outcome: Perch rule pack

1 saved requirement for Express. Inspect the selectors and adapt the example paths to your repository.

```
- name: transaction-releases-client
  where: "transaction.cjs"
  ensure: >-
    The withTransaction helper returns every acquired PostgreSQL client to its pool by executing client.release() in finally, including when the operation or rollback throws. A finally block containing only a comment leaves the acquired client unreleased.
```

[Download the rule pack ZIP](https://reporules.fyi/express/transaction-cleanup/rule-pack.zip) · [Download YAML](https://reporules.fyi/express/transaction-cleanup/rules.yaml) · [Agent repair task](https://reporules.fyi/express/transaction-cleanup/agent-task.txt) · [Implementation, integration requirements and captured checks](https://frameworkrecipes.dev/express/transaction-cleanup/)

## Install the rule without replacing your configuration

```
npm install -g @lakeday/perch
perch login
curl -fL 'https://reporules.fyi/express/transaction-cleanup/rule-pack.zip' -o 'perch-guide-express-transaction-cleanup.zip'
unzip -n 'perch-guide-express-transaction-cleanup.zip'
```

Keep your existing perch.yaml. Extraction preserves existing files and adds .perch/rules/perch-guide-express-transaction-cleanup.yaml. Review each where selector before running a check on your application.

## Configure your coding agent

```
perch setup claude-code
perch setup codex
perch setup cursor
perch setup pi
```

Choose the setup command for the agent you use.

## Check the edit, fix the finding, check again

```
perch check transaction.cjs --rules transaction-releases-client --json
```

Run the check after an agent edit. Read the finding and affected code, repair the implementation, and repeat the identical command. Keep the application regression tests as separate gates.

Exit 3 means a finding. Exit 1 or 2 means the check did not complete. A pass does not prove application correctness. Fresh judgments can vary; unchanged requests reuse cached answers. Relevant source is sent to the configured model service.

[Pack manifest and SHA-256 hash](https://reporules.fyi/express/transaction-cleanup/rule-pack.json) · [Pack README](https://reporules.fyi/express/transaction-cleanup/rule-pack-readme.md)

**Repo Rules**

Requirements that stay in the repo.

Published by Perch · © 2026 Verglas LLC. Repo Rules is a Perch publication.

Perch’s MIT license covers the CLI; hosted model analysis is a paid service. Relevant source is sent to the configured model service.

[Perch CLI MIT license](https://github.com/lakeday-org/perch/blob/main/LICENSE) · [Article text](https://reporules.fyi/express/transaction-cleanup/index.md) · [Resource index](https://reporules.fyi/llms.txt)