Migrate to PostgreSQL in a single command!
This report summarizes scanner evidence for dimitri/pgloader, a Common Lisp project with 6,544 GitHub stars. SynthScan examined 9,280 lines of code across 270 source files, recording 41 pattern matches distributed across 5 syntactic categories. The legacy adjusted pattern signal is 12.6 (Moderate pattern signal); it is not an authorship estimate.
Use the findings to ask whether maintainers can explain intent, verify dependencies, simplify unnecessary scaffolding, and focus review effort. Risk Payload v1 adds ownership, supply-chain, over-engineering, and review-effort vectors when available. These are prompts for human verification, not probabilities, security findings, or measured maintenance costs.
Use each vector to guide manual verification of the underlying findings.
Can maintainers explain intent, assumptions, and trade-offs? 5 finding(s).
Are imports declared and package/API names verified? 8 finding(s).
Are wrappers, guards, and repeated structures necessary? 28 finding(s).
Which changes need focused human review? 41 finding(s).
Run additional scans to build a history of the legacy pattern signal. Score changes are not a measure of AI adoption or code quality.
Groups findings by configured severity weight. Severity is not a confidence estimate, security rating, or proof that a package is missing. Verify imports against the project's manifests and inspect each finding in its local design context.
This horizontal bar chart shows where configured pattern scores accumulate across directories. Treat the bars as locations to inspect, not as evidence of authorship or code quality. Use the file-level findings to decide whether a directory needs a focused ownership, dependency, complexity, or review check.
The scanner identified 41 distinct pattern matches across 5 syntactic categories. Each entry below represents a discrete location in the source code where the engine recorded a detector match to inspect in context. Expand any category row to inspect the individual file paths, line numbers, code snippets, and the lexical context (CODE, COMMENT, or STRING) in which each match was detected.
Reading the findings table: The Severity column indicates the configured finding weight (CRITICAL / HIGH / MEDIUM / LOW). The Context column identifies whether the match occurred inside executable code, an inline comment, or a string literal — legacy comment-context matches receive a ×1.5 score weight. The ⚡ bolt icon marks clustered matches: three or more patterns within a 10-line window, each receiving an additional ×1.5 density multiplier under the legacy scoring model.
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | clojure/tests/bench/docker-compose.yml | 2 | # ── Source: MariaDB with employees pre-seeded ───────────────────────────── | COMMENT |
| MEDIUM | clojure/tests/bench/docker-compose.yml | 29 | # ── Target: PostgreSQL ──────────────────────────────────────────────────── | COMMENT |
| MEDIUM | clojure/tests/bench/docker-compose.yml | 42 | # ── Test runner ─────────────────────────────────────────────────────────── | COMMENT |
| MEDIUM | clojure/tests/bench/report.py | 38 | # ── parsers ─────────────────────────────────────────────────────────────────── | COMMENT |
| MEDIUM | clojure/tests/bench/report.py | 92 | # ── field accessors (index into 5-tuple) ────────────────────────────────────── | COMMENT |
| MEDIUM | clojure/tests/bench/report.py | 101 | # ── formatting helpers ───────────────────────────────────────────────────────── | COMMENT |
| MEDIUM | clojure/tests/bench/report.py | 149 | # ── table builder ───────────────────────────────────────────────────────────── | COMMENT |
| MEDIUM | clojure/tests/bench/report.py | 172 | # ── header ──────────────────────────────────────────────────────────────── | COMMENT |
| MEDIUM | clojure/tests/bench/report.py | 187 | # ── per-dataset blocks ──────────────────────────────────────────────────── | COMMENT |
| MEDIUM | clojure/tests/bench/report.py | 259 | # ── entry point ─────────────────────────────────────────────────────────────── | COMMENT |
| MEDIUM | .github/workflows/clojure-integration-tests.yml | 18 | # ── Unit tests ───────────────────────────────────────────────────────────── | COMMENT |
| MEDIUM | .github/workflows/clojure-integration-tests.yml | 93 | # ── Build test-runner Docker image (contains v3 pgloader binary) ─────────── | COMMENT |
| MEDIUM | .github/workflows/clojure-integration-tests.yml | 131 | # ── Build pgloader v4 JAR ────────────────────────────────────────────────── | COMMENT |
| MEDIUM⚡ | .github/workflows/clojure-integration-tests.yml | 177 | # ── Integration test matrix ──────────────────────────────────────────────── | COMMENT |
| MEDIUM⚡ | .github/workflows/clojure-integration-tests.yml | 187 | # ── CSV ──────────────────────────────────────────────────────────── | COMMENT |
| MEDIUM⚡ | .github/workflows/clojure-integration-tests.yml | 195 | # ── COPY ─────────────────────────────────────────────────────────── | COMMENT |
| MEDIUM⚡ | .github/workflows/clojure-integration-tests.yml | 203 | # ── FIXED ────────────────────────────────────────────────────────── | COMMENT |
| MEDIUM⚡ | .github/workflows/clojure-integration-tests.yml | 211 | # ── DBF ──────────────────────────────────────────────────────────── | COMMENT |
| MEDIUM⚡ | .github/workflows/clojure-integration-tests.yml | 219 | # ── SQLite ───────────────────────────────────────────────────────── | COMMENT |
| MEDIUM⚡ | .github/workflows/clojure-integration-tests.yml | 227 | # ── MySQL 8.0 ────────────────────────────────────────────────────── | COMMENT |
| MEDIUM⚡ | .github/workflows/clojure-integration-tests.yml | 237 | # ── MariaDB ──────────────────────────────────────────────────────── | COMMENT |
| MEDIUM⚡ | .github/workflows/clojure-integration-tests.yml | 247 | # ── PostgreSQL → PostgreSQL ───────────────────────────────────────── | COMMENT |
| MEDIUM⚡ | .github/workflows/clojure-integration-tests.yml | 255 | # ── SQL Server ───────────────────────────────────────────────────── | COMMENT |
| MEDIUM⚡ | .github/workflows/clojure-integration-tests.yml | 263 | # ── Citus (distributed PostgreSQL) ───────────────────────────────── | COMMENT |
| MEDIUM | .github/workflows/clojure-integration-tests.yml | 299 | # ── Build bench MariaDB source image ────────────────────────────────────── | COMMENT |
| MEDIUM | .github/workflows/clojure-integration-tests.yml | 337 | # ── Bench: employees + lahman timing comparison (v4 vs v3) ──────────────── | COMMENT |
| MEDIUM | .github/workflows/clojure-integration-tests.yml | 438 | # ── Bench report: aggregate timing JSON from all four bench jobs ─────────── | COMMENT |
| MEDIUM | .github/workflows/clojure-integration-tests.yml | 461 | # ── Publish evergreen dev release ───────────────────────────────────────── | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW⚡ | test/mysql/my.sql | 202 | values('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque vulputate nisl sapien, vel posuere ex pulv | CODE |
| LOW⚡ | test/mysql/my.sql | 202 | values('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque vulputate nisl sapien, vel posuere ex pulv | CODE |
| LOW⚡ | test/mysql/my.sql | 212 | Curabitur fermentum rutrum mauris. Cras vestibulum odio ornare ante consequat aliquet. Suspendisse elit lorem, gravida n | CODE |
| LOW | test/mysql/my.sql | 268 | In hac habitasse platea dictumst. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla in facilisis metus, ut | CODE |
| LOW | test/mysql/my.sql | 268 | In hac habitasse platea dictumst. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla in facilisis metus, ut | CODE |
| LOW | clojure/tests/citus/source.sql | 63 | (1, 'Acme Corp', 'https://example.com/acme.png', '2017-06-13 16:41:52', '2017-06-13 16:41:52'), | CODE |
| LOW | clojure/tests/mysql/mytest/mytest.sql | 198 | 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.', | CODE |
| LOW | clojure/tests/mysql/mytest/mytest.sql | 198 | 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.', | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | clojure/tests/mysql/data/load-datasets.sh | 21 | echo "pgloader_mytest loaded successfully" | COMMENT |
| LOW | docs/conf.py | 1 | #!/usr/bin/env python3 | COMMENT |
| LOW | docs/conf.py | 61 | # Add any paths that contain custom static files (such as style sheets) here, | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | docs/conf.py | 7 | # This file is execfile()d with the current directory set to its | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | clojure/tests/bench/report.py | 56 | CODE |