AI Slop Code Risk Monitor

transact-rs/sqlx

SlopCodeMonitor badge for transact-rs/sqlx Adjusted legacy signal; badge bands: 25 / 50 / 75 (different from dashboard bands).

🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.

3.8 Low pattern signal View on GitHub

Open-Source Code Quality, Security and Technical Debt Review

This report summarizes scanner evidence for transact-rs/sqlx, a Rust project with 17,615 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.

3.8
Adjusted Signal
3.8
Raw Pattern Score
100%
Time Factor
2026-10-31
Last Push
17.6K
Stars
Rust
Language
126.3K
Lines of Code
609
Files
486
Pattern Hits
2026-10-31
Scan Date
0.00
HC Hit Rate

Risk Review · Payload v1

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.

Cognitive Ownership Risk 16.6/100 · LOW

Can maintainers explain intent, assumptions, and trade-offs? 467 finding(s).

Hallucinated Dependency & Supply Chain Risk 0.8/100 · LOW

Are imports declared and package/API names verified? 19 finding(s).

Agent Over-Engineering Ratio 0.1/100 · LOW

Are wrappers, guards, and repeated structures necessary? 2 finding(s).

PR Review Velocity Impact 17.6/100 · LOW

Which changes need focused human review? 486 finding(s).

What These Metrics Mean

Adjusted Signal
Legacy pattern score normalized per 1,000 scanned lines and multiplied by the repository-level time factor. It is not an estimate of AI authorship.
Raw Pattern Score
Sum of severity- and context-weighted pattern findings before applying the time factor.
Time Factor
A coarse multiplier based on repository last-push metadata. It does not identify when individual code was written.
Pattern Hits
Count of configured pattern findings. Review each location and surrounding code before acting.
HC Hit Rate
High- and critical-severity findings per scanned file. Severity is a configured detector weight, not proof of a vulnerability or authorship.
Lines / Files
Scan coverage denominators used by the legacy normalized score.

Pattern-Signal History

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.

Severity Breakdown

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.

CRITICAL 0HIGH 0MEDIUM 2LOW 484

Directory Score Breakdown

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.

Pattern Findings

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.

Over-Commented Block461 hits · 448 pts
SeverityFileLineSnippetContext
LOWsqlx-postgres/src/copy.rs21 /// Issue a `COPY FROM STDIN` statement and transition the connection to streaming dataCOMMENT
LOWsqlx-postgres/src/copy.rs41 ///COMMENT
LOWsqlx-postgres/src/copy.rs61 ) -> Result<BoxStream<'c, Result<Bytes>>> {COMMENT
LOWsqlx-postgres/src/copy.rs81 /// <https://www.postgresql.org/docs/current/sql-copy.html>COMMENT
LOWsqlx-postgres/src/copy.rs201 .innerCOMMENT
LOWsqlx-postgres/src/arguments.rs21// backtrack and update the prefixed-len, then write until the next patch offsetCOMMENT
LOWsqlx-postgres/src/statement.rs61// impl<'q> From<PgStatement<'q>> for crate::any::AnyStatement<'q> {COMMENT
LOWsqlx-postgres/src/statement.rs81// }COMMENT
LOWsqlx-postgres/src/type_info.rs21/// if one was constructed with [`Self::with_oid()`] and the other with [`Self::with_name()`] orCOMMENT
LOWsqlx-postgres/src/type_info.rs201 /// Returns the _kind_ (simple, array, enum, etc.) for this type.COMMENT
LOWsqlx-postgres/src/type_info.rs261 Some("mac_address")COMMENT
LOWsqlx-postgres/src/type_info.rs281 ///COMMENT
LOWsqlx-postgres/src/type_info.rs301 /// // Will prevent SQLx from inferring `_foo` as an array type.COMMENT
LOWsqlx-postgres/src/type_info.rs321 elem_name: elem_name.into(),COMMENT
LOWsqlx-postgres/src/advisory_lock.rs21///COMMENT
LOWsqlx-postgres/src/advisory_lock.rs41 key: PgAdvisoryLockKey,COMMENT
LOWsqlx-postgres/src/advisory_lock.rs61 /// The keyspace designated by a single 64-bit integer.COMMENT
LOWsqlx-postgres/src/advisory_lock.rs81/// This means the lock is not actually released as soon as the guard is dropped. To ensure theCOMMENT
LOWsqlx-postgres/src/advisory_lock.rs101 /// [hkdf]: https://datatracker.ietf.org/doc/html/rfc5869COMMENT
LOWsqlx-postgres/src/advisory_lock.rs121 //COMMENT
LOWsqlx-postgres/src/advisory_lock.rs141 // This is specified by RFC 5869 but not elaborated upon:COMMENT
LOWsqlx-postgres/src/advisory_lock.rs181 // It has something to do with how lifetimes work on the `Acquire` trait, I couldn'tCOMMENT
LOWsqlx-postgres/src/advisory_lock.rs241 /// A connection-like type is required to execute the call. Allowed types include `PgConnection`,COMMENT
LOWsqlx-postgres/src/advisory_lock.rs281COMMENT
LOWsqlx-postgres/src/bind_iter.rs21/// iterating over them again to encode.COMMENT
LOWsqlx-postgres/src/bind_iter.rs41/// birthdate: DateTime<Utc>,COMMENT
LOWsqlx-postgres/src/listener.rs81 /// while [`Self::recv()`] or [`Self::try_recv()`] are waiting for a message, the wait isCOMMENT
LOWsqlx-postgres/src/listener.rs101 /// Set whether a lost connection in `try_recv()` should be re-established before it returnsCOMMENT
LOWsqlx-postgres/src/listener.rs201 /// If the connection to PostgreSQL is lost, it is automatically reconnected on the nextCOMMENT
LOWsqlx-postgres/src/listener.rs221 /// }COMMENT
LOWsqlx-postgres/src/listener.rs241 /// ```rust,no_runCOMMENT
LOWsqlx-postgres/src/column.rs21}COMMENT
LOWsqlx-postgres/src/options/mod.rs121 );COMMENT
LOWsqlx-postgres/src/options/mod.rs141 /// .host("localhost");COMMENT
LOWsqlx-postgres/src/options/mod.rs161 selfCOMMENT
LOWsqlx-postgres/src/options/mod.rs181 /// # use sqlx_postgres::PgConnectOptions;COMMENT
LOWsqlx-postgres/src/options/mod.rs221 &mut self.ssl_optionsCOMMENT
LOWsqlx-postgres/src/options/mod.rs241 selfCOMMENT
LOWsqlx-postgres/src/options/mod.rs261 }COMMENT
LOWsqlx-postgres/src/options/mod.rs281 ///COMMENT
LOWsqlx-postgres/src/options/mod.rs301 pub fn ssl_client_cert_from_pem(mut self, cert: impl AsRef<[u8]>) -> Self {COMMENT
LOWsqlx-postgres/src/options/mod.rs321 selfCOMMENT
LOWsqlx-postgres/src/options/mod.rs341 /// // Providing a CA certificate with less than VerifyCa is pointlessCOMMENT
LOWsqlx-postgres/src/options/mod.rs381 ///COMMENT
LOWsqlx-postgres/src/options/mod.rs401 /// The nominal range for this value is `-15` to `3`, where negative values for this optionCOMMENT
LOWsqlx-postgres/src/options/mod.rs421 /// * [Postgres manual, 20.11.2: Client Connection Defaults; Locale and Formatting][20.11.2]COMMENT
LOWsqlx-postgres/src/options/mod.rs441 self.extra_float_digits = extra_float_digits.into().map(|it| it.to_string().into());COMMENT
LOWsqlx-postgres/src/options/mod.rs501 /// .host("127.0.0.1");COMMENT
LOWsqlx-postgres/src/options/mod.rs521COMMENT
LOWsqlx-postgres/src/options/mod.rs541 /// # use sqlx_postgres::PgConnectOptions;COMMENT
LOWsqlx-postgres/src/options/mod.rs561 self.database.as_deref()COMMENT
LOWsqlx-postgres/src/options/mod.rs581 /// ```rustCOMMENT
LOWsqlx-postgres/src/types/money.rs21/// Reading `MONEY` value in text format is not supported and will cause an error.COMMENT
LOWsqlx-postgres/src/types/money.rs41/// ```COMMENT
LOWsqlx-postgres/src/types/money.rs81 /// See the type-level docs for an explanation of `locale_frac_digits`.COMMENT
LOWsqlx-postgres/src/types/ltree.rs61impl Display for PgLTreeLabel {COMMENT
LOWsqlx-postgres/src/types/lquery.rs21 UnexpectedCharacter,COMMENT
LOWsqlx-postgres/src/types/lquery.rs41/// Ideally, SQLx's Postgres driver should support falling back to text format for typesCOMMENT
LOWsqlx-postgres/src/types/mod.rs1//! Conversions between Rust and **Postgres** types.COMMENT
LOWsqlx-postgres/src/types/mod.rs21//! | [`PgLQuery`] | LQUERY |COMMENT
401 more matches not shown…
Fake / Example Data17 hits · 17 pts
SeverityFileLineSnippetContext
LOWREADME.md337 .bind("user@example.com")CODE
LOWREADME.md361 .bind("user@example.com")CODE
LOWtests/sqlite/sqlite.rs1237 sqlx::query("insert into foo(bar, baz) values (1234, 'Lorem ipsum'), (5678, 'dolor sit amet')")CODE
LOWtests/sqlite/sqlite.rs1237 sqlx::query("insert into foo(bar, baz) values (1234, 'Lorem ipsum'), (5678, 'dolor sit amet')")CODE
LOWtests/sqlite/sqlite.rs1256 assert_eq!(rows[0].1, "Lorem ipsum");CODE
LOWtests/sqlite/sqlite.rs1259 assert_eq!(rows[1].1, "dolor sit amet");CODE
LOWtests/sqlite/sqlite.rs1274 "insert into foo.foo(bar, baz) values (1234, 'Lorem ipsum'), (5678, 'dolor sit amet')",CODE
LOWtests/sqlite/sqlite.rs1274 "insert into foo.foo(bar, baz) values (1234, 'Lorem ipsum'), (5678, 'dolor sit amet')",CODE
LOWtests/sqlite/sqlite.rs1299 assert_eq!(rows[0].1, "Lorem ipsum");CODE
LOWtests/sqlite/sqlite.rs1302 assert_eq!(rows[1].1, "dolor sit amet");CODE
LOWtests/mysql/mysql.rs654 SET @myvar := 'test@test.com';CODE
LOWtests/mysql/mysql.rs717 VALUES (1, 'Hello, world!', 'Lorem ipsum dolor sit amet', X'01020304DEADBEEF');CODE
LOWtests/mysql/mysql.rs717 VALUES (1, 'Hello, world!', 'Lorem ipsum dolor sit amet', X'01020304DEADBEEF');CODE
LOWtests/mysql/mysql.rs744 "Lorem ipsum dolor sit amet"CODE
LOWtests/mysql/mysql.rs744 "Lorem ipsum dolor sit amet"CODE
LOWexamples/postgres/json/README.md28echo '{ "name": "John Doe", "age": 30 }' | cargo run -- addCODE
LOWexamples/postgres/json/README.md34echo '{ "name": "Jane Doe", "age": 25, "array": ["string", true, 0] }' | cargo run -- addCODE
AI Slop Vocabulary2 hits · 6 pts
SeverityFileLineSnippetContext
MEDIUMsqlx-core/src/from_row.rs216/// If your database supports a JSON type, you can leverage `#[sqlx(json)]`COMMENT
MEDIUMsqlx-core/src/pool/options.rs15/// Essentially, because it's impossible to write generic bounds that describe a closureCOMMENT
Hyper-Verbose Identifiers2 hits · 2 pts
SeverityFileLineSnippetContext
LOWtests/x.py38def maybe_fetch_sqlite_extension():CODE
LOWtests/x.py68def required_feature_for_test(test_name):CODE
Unused Imports2 hits · 2 pts
SeverityFileLineSnippetContext
LOWtests/x.py6CODE
LOWexamples/x.py18CODE
Redundant / Tautological Comments1 hit · 2 pts
SeverityFileLineSnippetContext
LOWgen-changelog.sh86 # Check if the entry already exists in the changelog or in our list of new authors.COMMENT
Deep Nesting1 hit · 1 pts
SeverityFileLineSnippetContext
LOWtests/x.py93CODE