# NousResearch/hermes-agent · FTS5 trigram index bloat from tool_calls JSON

## Open now

- Nothing open on GitHub.

These items address excessive database size caused by trigram full-text search indexing of structured JSON tool_calls data. Proposed fixes include excluding tool_calls from the trigram index and restructuring FTS layout to reduce storage expansion.

## TL;DR

- 3 member(s): 0 open issue(s), 1 closed issue(s), 0 open PR(s), 1 merged PR(s), 1 PR(s) closed without merging.
- A fix was merged to main in PR #65798. Verify it addresses your case.
- **Recommended:** read PR #65798 (and any competing PRs below) before filing. Confirm the merged change covers your symptom.

## Maintainer resolution verdict

- Internal-tracker verdict over this cluster's issue members: `resolved` · deciding PR(s): `pr-65798`. This is distinct from the fix status above. Weigh it yourself.

## How this cluster was grouped

- Link evidence (`STRUCTURAL_SPANNING`): every member is connected by structural evidence: shared changed files, or a closing/superseded reference.
- Pairwise link density `0.67`: the share of member pairs that carry a link, counting a structural link in full and a relevance-only link at 0.36. `1.00` means every pair is linked.

## Closed / duplicate issues

- #43690: FTS5 Trigram Index Bloat: 18.3x Expansion on Structured JSON Data (tool_calls)

## Prior & competing PRs

- **#65798: perf(state): compact v23 FTS layout — external-content indexes, tool-row-free trigram, opt-in \`hermes sessions optimize-storage\`**. merged to main · fix tier `verified`
  - maintainer direction: category `merged`
  - files: `.github/actions/detect-changes/action.yml`, `.github/actions/get-app-token/action.yml`, `.github/workflows/ci.yml`, `.github/workflows/contributor-check.yml`, `.github/workflows/deploy-site.yml`, `.github/workflows/e2e-desktop.yml`, `.github/workflows/history-check.yml`, `.github/workflows/js-autofix.yml`, `.github/workflows/label-rerun.yml`, `.github/workflows/lint.yml`, `.github/workflows/lockfile-diff.yml`, `.github/workflows/osv-scanner.yml`, `.github/workflows/review-labels.yml`, `.github/workflows/skills-index-freshness.yml`, `.github/workflows/skills-index.yml`, `.github/workflows/supply-chain-audit.yml`, `.github/workflows/upload_to_pypi.yml`, `.github/workflows/uv-lockfile-check.yml`, `.gitignore`, `Dockerfile` (+1196 more)
- **#43701: fix(db): exclude tool_calls JSON from trigram FTS5 index to reduce bloat**. closed without merge
  - maintainer direction: category `implemented_elsewhere`; implication `superseded`; refs `#65798`

## Fix status

- Merged to main in PR #65798 (cited above). No release data is tracked. Verify downstream.
- Fix last verified (merged) `2026-07-22`.
- Subsystem: `agent`