🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.
This report summarizes scanner evidence for launchbadge/sqlx, a Rust project with 17,614 GitHub stars. SynthScan examined 126,312 lines of code across 609 source files, recording 486 pattern matches distributed across 7 syntactic categories. The legacy adjusted pattern signal is 3.8 (Low 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.
Payload schema: 1.0.0 · Engine: 2.0.0 · Scoring: heuristic-density-v1 · Scan date: 2026-10-31.
Can maintainers explain intent, assumptions, and trade-offs? 467 finding(s).
Are imports declared and package/API names verified? 19 finding(s).
Are wrappers, guards, and repeated structures necessary? 2 finding(s).
Which changes need focused human review? 486 finding(s).
This chart tracks the legacy adjusted pattern score across scan runs. Changes can reflect source changes, scan coverage, or detector/scoring versions; they do not measure AI adoption or prove that a team refactored code. Compare runs only when their scoring versions are compatible. The dashed line tracks the raw pattern-hit count.
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 486 distinct pattern matches across 7 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 |
|---|---|---|---|---|
| LOW | sqlx-postgres/src/copy.rs | 21 | /// Issue a `COPY FROM STDIN` statement and transition the connection to streaming data | COMMENT |
| LOW | sqlx-postgres/src/copy.rs | 41 | /// | COMMENT |
| LOW | sqlx-postgres/src/copy.rs | 61 | ) -> Result<BoxStream<'c, Result<Bytes>>> { | COMMENT |
| LOW | sqlx-postgres/src/copy.rs | 81 | /// <https://www.postgresql.org/docs/current/sql-copy.html> | COMMENT |
| LOW | sqlx-postgres/src/copy.rs | 201 | .inner | COMMENT |
| LOW | sqlx-postgres/src/arguments.rs | 21 | // backtrack and update the prefixed-len, then write until the next patch offset | COMMENT |
| LOW | sqlx-postgres/src/statement.rs | 61 | // impl<'q> From<PgStatement<'q>> for crate::any::AnyStatement<'q> { | COMMENT |
| LOW | sqlx-postgres/src/statement.rs | 81 | // } | COMMENT |
| LOW | sqlx-postgres/src/type_info.rs | 21 | /// if one was constructed with [`Self::with_oid()`] and the other with [`Self::with_name()`] or | COMMENT |
| LOW | sqlx-postgres/src/type_info.rs | 201 | /// Returns the _kind_ (simple, array, enum, etc.) for this type. | COMMENT |
| LOW | sqlx-postgres/src/type_info.rs | 261 | Some("mac_address") | COMMENT |
| LOW | sqlx-postgres/src/type_info.rs | 281 | /// | COMMENT |
| LOW | sqlx-postgres/src/type_info.rs | 301 | /// // Will prevent SQLx from inferring `_foo` as an array type. | COMMENT |
| LOW | sqlx-postgres/src/type_info.rs | 321 | elem_name: elem_name.into(), | COMMENT |
| LOW | sqlx-postgres/src/advisory_lock.rs | 21 | /// | COMMENT |
| LOW | sqlx-postgres/src/advisory_lock.rs | 41 | key: PgAdvisoryLockKey, | COMMENT |
| LOW | sqlx-postgres/src/advisory_lock.rs | 61 | /// The keyspace designated by a single 64-bit integer. | COMMENT |
| LOW | sqlx-postgres/src/advisory_lock.rs | 81 | /// This means the lock is not actually released as soon as the guard is dropped. To ensure the | COMMENT |
| LOW | sqlx-postgres/src/advisory_lock.rs | 101 | /// [hkdf]: https://datatracker.ietf.org/doc/html/rfc5869 | COMMENT |
| LOW | sqlx-postgres/src/advisory_lock.rs | 121 | // | COMMENT |
| LOW | sqlx-postgres/src/advisory_lock.rs | 141 | // This is specified by RFC 5869 but not elaborated upon: | COMMENT |
| LOW | sqlx-postgres/src/advisory_lock.rs | 181 | // It has something to do with how lifetimes work on the `Acquire` trait, I couldn't | COMMENT |
| LOW | sqlx-postgres/src/advisory_lock.rs | 241 | /// A connection-like type is required to execute the call. Allowed types include `PgConnection`, | COMMENT |
| LOW | sqlx-postgres/src/advisory_lock.rs | 281 | COMMENT | |
| LOW | sqlx-postgres/src/bind_iter.rs | 21 | /// iterating over them again to encode. | COMMENT |
| LOW | sqlx-postgres/src/bind_iter.rs | 41 | /// birthdate: DateTime<Utc>, | COMMENT |
| LOW | sqlx-postgres/src/listener.rs | 81 | /// while [`Self::recv()`] or [`Self::try_recv()`] are waiting for a message, the wait is | COMMENT |
| LOW | sqlx-postgres/src/listener.rs | 101 | /// Set whether a lost connection in `try_recv()` should be re-established before it returns | COMMENT |
| LOW | sqlx-postgres/src/listener.rs | 201 | /// If the connection to PostgreSQL is lost, it is automatically reconnected on the next | COMMENT |
| LOW | sqlx-postgres/src/listener.rs | 221 | /// } | COMMENT |
| LOW | sqlx-postgres/src/listener.rs | 241 | /// ```rust,no_run | COMMENT |
| LOW | sqlx-postgres/src/column.rs | 21 | } | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 121 | ); | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 141 | /// .host("localhost"); | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 161 | self | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 181 | /// # use sqlx_postgres::PgConnectOptions; | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 221 | &mut self.ssl_options | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 241 | self | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 261 | } | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 281 | /// | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 301 | pub fn ssl_client_cert_from_pem(mut self, cert: impl AsRef<[u8]>) -> Self { | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 321 | self | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 341 | /// // Providing a CA certificate with less than VerifyCa is pointless | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 381 | /// | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 401 | /// The nominal range for this value is `-15` to `3`, where negative values for this option | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 421 | /// * [Postgres manual, 20.11.2: Client Connection Defaults; Locale and Formatting][20.11.2] | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 441 | self.extra_float_digits = extra_float_digits.into().map(|it| it.to_string().into()); | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 501 | /// .host("127.0.0.1"); | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 521 | COMMENT | |
| LOW | sqlx-postgres/src/options/mod.rs | 541 | /// # use sqlx_postgres::PgConnectOptions; | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 561 | self.database.as_deref() | COMMENT |
| LOW | sqlx-postgres/src/options/mod.rs | 581 | /// ```rust | COMMENT |
| LOW | sqlx-postgres/src/types/money.rs | 21 | /// Reading `MONEY` value in text format is not supported and will cause an error. | COMMENT |
| LOW | sqlx-postgres/src/types/money.rs | 41 | /// ``` | COMMENT |
| LOW | sqlx-postgres/src/types/money.rs | 81 | /// See the type-level docs for an explanation of `locale_frac_digits`. | COMMENT |
| LOW | sqlx-postgres/src/types/ltree.rs | 61 | impl Display for PgLTreeLabel { | COMMENT |
| LOW | sqlx-postgres/src/types/lquery.rs | 21 | UnexpectedCharacter, | COMMENT |
| LOW | sqlx-postgres/src/types/lquery.rs | 41 | /// Ideally, SQLx's Postgres driver should support falling back to text format for types | COMMENT |
| LOW | sqlx-postgres/src/types/mod.rs | 1 | //! Conversions between Rust and **Postgres** types. | COMMENT |
| LOW | sqlx-postgres/src/types/mod.rs | 21 | //! | [`PgLQuery`] | LQUERY | | COMMENT |
| 401 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | README.md | 337 | .bind("user@example.com") | CODE |
| LOW | README.md | 361 | .bind("user@example.com") | CODE |
| LOW | tests/sqlite/sqlite.rs | 1237 | sqlx::query("insert into foo(bar, baz) values (1234, 'Lorem ipsum'), (5678, 'dolor sit amet')") | CODE |
| LOW | tests/sqlite/sqlite.rs | 1237 | sqlx::query("insert into foo(bar, baz) values (1234, 'Lorem ipsum'), (5678, 'dolor sit amet')") | CODE |
| LOW | tests/sqlite/sqlite.rs | 1256 | assert_eq!(rows[0].1, "Lorem ipsum"); | CODE |
| LOW | tests/sqlite/sqlite.rs | 1259 | assert_eq!(rows[1].1, "dolor sit amet"); | CODE |
| LOW | tests/sqlite/sqlite.rs | 1274 | "insert into foo.foo(bar, baz) values (1234, 'Lorem ipsum'), (5678, 'dolor sit amet')", | CODE |
| LOW | tests/sqlite/sqlite.rs | 1274 | "insert into foo.foo(bar, baz) values (1234, 'Lorem ipsum'), (5678, 'dolor sit amet')", | CODE |
| LOW | tests/sqlite/sqlite.rs | 1299 | assert_eq!(rows[0].1, "Lorem ipsum"); | CODE |
| LOW | tests/sqlite/sqlite.rs | 1302 | assert_eq!(rows[1].1, "dolor sit amet"); | CODE |
| LOW | tests/mysql/mysql.rs | 654 | SET @myvar := 'test@test.com'; | CODE |
| LOW | tests/mysql/mysql.rs | 717 | VALUES (1, 'Hello, world!', 'Lorem ipsum dolor sit amet', X'01020304DEADBEEF'); | CODE |
| LOW | tests/mysql/mysql.rs | 717 | VALUES (1, 'Hello, world!', 'Lorem ipsum dolor sit amet', X'01020304DEADBEEF'); | CODE |
| LOW | tests/mysql/mysql.rs | 744 | "Lorem ipsum dolor sit amet" | CODE |
| LOW | tests/mysql/mysql.rs | 744 | "Lorem ipsum dolor sit amet" | CODE |
| LOW | examples/postgres/json/README.md | 28 | echo '{ "name": "John Doe", "age": 30 }' | cargo run -- add | CODE |
| LOW | examples/postgres/json/README.md | 34 | echo '{ "name": "Jane Doe", "age": 25, "array": ["string", true, 0] }' | cargo run -- add | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | sqlx-core/src/from_row.rs | 216 | /// If your database supports a JSON type, you can leverage `#[sqlx(json)]` | COMMENT |
| MEDIUM | sqlx-core/src/pool/options.rs | 15 | /// Essentially, because it's impossible to write generic bounds that describe a closure | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | tests/x.py | 38 | def maybe_fetch_sqlite_extension(): | CODE |
| LOW | tests/x.py | 68 | def required_feature_for_test(test_name): | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | tests/x.py | 6 | CODE | |
| LOW | examples/x.py | 18 | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | gen-changelog.sh | 86 | # Check if the entry already exists in the changelog or in our list of new authors. | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | tests/x.py | 93 | CODE |