Read 2026-10-23
ottermind/chat2db: technical due diligence, read from its repository
What Borehole read in ottermind/chat2db's code and history at 53f4174: its licence, security advisories, releases, review practice, tests, dependencies and operations. Every finding cites the file and line it rests on. The full report also covers the team and asks the questions the code cannot answer.
| Dimension | Rating |
|---|---|
| Architecture & Codebase — including AI provenance | strong |
| Engineering Process & SDLC Maturity | strong |
| Product & Engineering Maturity | strong |
| Security & Reliability Posture | adequate |
| Observability & Operations | adequate |
| Fit with the Acquirer | not assessable |
What the repository says
- Releases are cut from another branch than the one surveyed
.github/pull_request_template.md:64: states a policy on AI-generated contributions
Architecture & Codebase — including AI provenance
strongCommit messages are templated rather than written
adequate66% of commit subjects are exact repeats of another subject, and subject length varies by only 22.6 characters. A log written by someone explaining their reasoning to a future reader does not look like this. The log is therefore weak evidence of intent, whatever the code is like.
| 80× 'Update README.md' |
| 46× 'test release' |
| 46× 'Update README_CN.md' |
chat2db-community-server/chat2db-community-plugins/chat2db-community-dm/src/main/antlr4/ai/chat2db/plugin/dm/parser/base/DMParser.g4 is 9,730 lines, 211× this codebase's median file
adequateThe median source file here is 46 lines. 46 files exceed 1,000 lines, the largest being 9,730. Size is not a defect on its own — some problems genuinely live in one place — but these are where merge conflicts, review fatigue and single-owner knowledge concentrate, and they are the first thing that slows an inheriting engineer down.
Engineering Process & SDLC Maturity
strongNo finding.
Product & Engineering Maturity
strongReleases are cut from another branch than the one surveyed
adequateThe newest pre-release, v5.4.0-beta.1, is not on the branch this survey read; the newest release on it is v5.3.8. The shipped product may differ from what this report describes. Survey the release branch too.
| tag v5.4.0-beta.1 |
Security & Reliability Posture
adequate1 Dockerfile runs the application as root
adequateNo USER instruction switches away from root, so the process runs with full privileges inside the container. It is a one-line fix and an ordinary expectation, which is why its absence is worth asking about: it usually says more about whether anyone has reviewed the deployment than about this container specifically.
docker/Dockerfile — runs as root |
17 SQL statements built from strings
adequate17 places in product code build SQL by formatting or joining strings rather than passing parameters. 2 of them put a value into the string; in the rest, what the code shows going in is a table or column name, a constant, or something the line does not show. Ask whether any value reaches these strings, rather than a parameter.
chat2db-community-server/chat2db-community-spi/src/main/java/ai/chat2db/spi/util/SqlGenerateUtil.java:91 — SQL built from a string |
chat2db-community-server/chat2db-community-spi/src/main/java/ai/chat2db/spi/util/SqlUtils.java:525 — SQL built from a string |
chat2db-community-client/src/blocks/AI/index.tsx:1742 — SQL built from a string |
67 locked dependencies have published vulnerabilities, 72 high or critical
adequate67 of 2,026 locked dependencies match 154 published advisories in OSV, 72 of them rated high or critical. A lockfile says which version is installed, not whether the flawed code is reachable from this product, so each needs a look. Most are fixed by an upgrade, and the advisory names the version. This lockfile pins development tools alongside what ships and does not say which is which, so some of these may never reach a user.
chat2db-community-client/yarn.lock — dompurify 3.4.12: GHSA-cg2g-xh64-v4q7 (critical), fixed in 3.4.17 |
chat2db-community-client/yarn.lock — form-data 4.0.2: GHSA-fjxv-7rqg-78g4 (critical), fixed in 4.0.4 |
chat2db-community-client/yarn.lock — immer 8.0.4: GHSA-33f9-j839-rf8h (critical), fixed in 9.0.6 |
6 places insert HTML from a variable without sanitising it
adequate6 places set HTML from a value that is neither a literal nor passed through a sanitiser. Where the value can come from a user, that is stored cross-site scripting, and it is the first thing a buyer's security review looks for in a frontend.
chat2db-community-client/public/iconfont/iconfont.js:1 — HTML from a variable |
chat2db-community-client/src/assets/fonts/new-chat2db-colourful-iconfont.js:1 — HTML from a variable |
chat2db-community-client/src/assets/fonts/new-chat2db-iconfont.js:1 — HTML from a variable |
1 vendored component with no licence
adequateThird-party code is committed into this repository without any statement of the terms it arrived under. Unknown terms are harder to deal with than inconvenient ones: an awkward licence can be complied with, an absent one cannot. Each of these needs its origin established before the code changes hands.
node_modules/.vite — 1 tracked files, no licence file |
Licence text does not match a standard licence
adequateLICENSE exists but its text does not match any standard licence. A bespoke or hand-edited licence is not wrong, but it cannot be cleared by recognising its name: counsel has to read it, and until they do neither side knows precisely what rights transfer with the code.
LICENSE:1 — 179 lines, unrecognised |
1 advisory against this project in the last 24 months, 1 high or critical
adequateThe newest was published on 2026-07-17. A project that publishes advisories is telling its users about its fixes, and the count and pace say how much security work it carries. Whether 1 of them are fixed in the code you ship could not be told from this history: its version is only known to be at least 5.3.8. Answer lives in: the release you run, set against each fixed version. The record is incomplete: NVD: 4 records name Chat2DB with nothing tying them to this repository (CVE-2024-55081, CVE-2025-9148, CVE-2026-4173, …).
| 2026-07-17: CVE-2026-63307 (high): Chat2DB before 5.3.0 contains an insecure direct object reference vulnerability in the GET /api/connection/datasource/{id} endpoint. The handler calls dataSourc |
Observability & Operations
adequateNo structured logging library is in use
adequateNothing references a structured logging library. Logs that are written to be read by a person are not searchable by a machine, which means incident response here is proportional to how well someone remembers the codebase rather than to what the tooling can find.
| searched 4,074 files for 10 structured logging libraries; 0 matched |
No error reporter is wired in
adequateNothing in the service initialises an error reporter (Sentry, Rollbar, Bugsnag, Honeybadger or an APM agent). An exception in production reaches a person only if someone is reading the logs, which usually means a customer reports it first.
| no error reporter initialised |
Fit with the Acquirer
not assessableNot rated: structurally not assessable from a repository.
Read more, or read your own
The full report on ottermind/chat2db: every dimension, the questions for the room, and the audit log.
Survey a repository: free on public repositories. Private code is read on your own machine by a collector whose source you can read first.