Home / stephencelis / SQLite.swift
AI Slop Code RIsk Monitor

stephencelis/SQLite.swift

A type-safe, Swift-language layer over SQLite3.

5.7 Moderate pattern signal View on GitHub

Maintenance and Governance Review

This report summarizes scanner evidence for stephencelis/SQLite.swift, a Swift project with 10,185 GitHub stars. SynthScan examined 19,493 lines of code across 95 source files, recording 119 pattern matches distributed across 2 syntactic categories. The legacy adjusted pattern signal is 5.7 (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.

5.7
Adjusted Signal
5.7
Raw Pattern Score
100%
Time Factor
2026-09-22
Last Push
10.2K
Stars
Swift
Language
19.5K
Lines of Code
95
Files
119
Pattern Hits
2026-10-12
Scan Date
0.00
HC Hit Rate

Risk Review · v3

Use each vector to guide manual verification of the underlying findings.

Cognitive Ownership Risk 24.8/100 · LOW

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

Hallucinated Dependency & Supply Chain Risk 0.3/100 · LOW

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

Agent Over-Engineering Ratio 0.0/100 · LOW

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

PR Review Velocity Impact 26.3/100 · MEDIUM

Which changes need focused human review? 119 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

Run additional scans to build a history of the legacy pattern signal. Score changes are not a measure of AI adoption or code quality.

No multi-scan history yet — run the scanner again to build trend data.

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 0LOW 119

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 119 distinct pattern matches across 2 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 Block118 hits · 111 pts
SeverityFileLineSnippetContext
LOWTests/SQLiteTests/Core/ConnectionTests.swift501 XCTAssertGreaterThanOrEqual(version, .init(major: 3, minor: 43, point: 2))COMMENT
LOWSources/SQLite/Helpers.swift1//COMMENT
LOWSources/SQLite/Foundation.swift1//COMMENT
LOWSources/SQLite/Core/Connection.swift1//COMMENT
LOWSources/SQLite/Core/Connection.swift41 public enum Location {COMMENT
LOWSources/SQLite/Core/Connection.swift101 ///COMMENT
LOWSources/SQLite/Core/Connection.swift141 /// - filename: The location of the database. Creates a new database ifCOMMENT
LOWSources/SQLite/Core/Connection.swift241 ///COMMENT
LOWSources/SQLite/Core/Connection.swift261 ///COMMENT
LOWSources/SQLite/Core/Connection.swift281COMMENT
LOWSources/SQLite/Core/Connection.swift301 /// - statement: A single SQL statement.COMMENT
LOWSources/SQLite/Core/Connection.swift341 /// returning the first value of the first row.COMMENT
LOWSources/SQLite/Core/Connection.swift361 /// - bindings: A list of parameters to bind to the statement.COMMENT
LOWSources/SQLite/Core/Connection.swift401 /// - Note: Transactions cannot be nested. To nest transactions, seeCOMMENT
LOWSources/SQLite/Core/Connection.swift421 /// Runs a transaction with the given savepoint name (if omitted, it willCOMMENT
LOWSources/SQLite/Core/Connection.swift641 ///COMMENT
LOWSources/SQLite/Core/Connection.swift721 /// - Parameters:COMMENT
LOWSources/SQLite/Core/Backup.swift1//COMMENT
LOWSources/SQLite/Core/Backup.swift21// OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS INCOMMENT
LOWSources/SQLite/Core/Backup.swift101COMMENT
LOWSources/SQLite/Core/Result.swift1#if StandaloneSQLiteCOMMENT
LOWSources/SQLite/Core/Connection+Aggregation.swift1import FoundationCOMMENT
LOWSources/SQLite/Core/Connection+Aggregation.swift21 /// - argumentCount: The number of arguments that the aggregate takes. IfCOMMENT
LOWSources/SQLite/Core/Blob.swift1//COMMENT
LOWSources/SQLite/Core/Connection+Pragmas.swift61 /// change. SQLite reports the resulting mode; callers should compare againstCOMMENT
LOWSources/SQLite/Core/Statement.swift1//COMMENT
LOWSources/SQLite/Core/Statement.swift141 ///COMMENT
LOWSources/SQLite/Core/Value.swift1//COMMENT
LOWSources/SQLite/Extensions/Cipher.swift41 }COMMENT
LOWSources/SQLite/Extensions/Cipher.swift61 /// of key data.COMMENT
LOWSources/SQLite/Extensions/Cipher.swift81 /// your app may ise older version of SQLCipherCOMMENT
LOWSources/SQLite/Extensions/Cipher.swift121 /// When using Commercial or Enterprise SQLCipher packages you must callCOMMENT
LOWSources/SQLite/Extensions/RTree.swift1//COMMENT
LOWSources/SQLite/Extensions/FTS4.swift1//COMMENT
LOWSources/SQLite/Extensions/FTS4.swift41COMMENT
LOWSources/SQLite/Extensions/FTS5.swift1//COMMENT
LOWSources/SQLite/Typed/Query.swift1//COMMENT
LOWSources/SQLite/Typed/Query.swift41extension SchemaType {COMMENT
LOWSources/SQLite/Typed/Query.swift61 /// let users = Table("users")COMMENT
LOWSources/SQLite/Typed/Query.swift81 /// // SELECT "id", "email" FROM "users"COMMENT
LOWSources/SQLite/Typed/Query.swift101 public func select(distinct columns: [Expressible]) -> Self {COMMENT
LOWSources/SQLite/Typed/Query.swift121 /// let users = Table("users")COMMENT
LOWSources/SQLite/Typed/Query.swift141 /// - Parameter all: A list of expressions to select.COMMENT
LOWSources/SQLite/Typed/Query.swift181 query.clauses.select = (distinct, columns)COMMENT
LOWSources/SQLite/Typed/Query.swift201 /// - Returns: A query with the given `UNION` clause applied.COMMENT
LOWSources/SQLite/Typed/Query.swift221 ///COMMENT
LOWSources/SQLite/Typed/Query.swift241 /// - Parameters:COMMENT
LOWSources/SQLite/Typed/Query.swift261 ///COMMENT
LOWSources/SQLite/Typed/Query.swift281 ///COMMENT
LOWSources/SQLite/Typed/Query.swift301 // MARK: WHERECOMMENT
LOWSources/SQLite/Typed/Query.swift341 /// Adds a condition to the query’s `WHERE` clause.COMMENT
LOWSources/SQLite/Typed/Query.swift361 ///COMMENT
LOWSources/SQLite/Typed/Query.swift381 ///COMMENT
LOWSources/SQLite/Typed/Query.swift421 query.clauses.group = (by, having)COMMENT
LOWSources/SQLite/Typed/Query.swift441 }COMMENT
LOWSources/SQLite/Typed/Query.swift461 // MARK: LIMIT/OFFSETCOMMENT
LOWSources/SQLite/Typed/Query.swift481 ///COMMENT
LOWSources/SQLite/Typed/Query.swift1121 /// - SeeAlso: `QueryType.insert(value:_:)`COMMENT
LOWSources/SQLite/Typed/Query.swift1141 /// - SeeAlso: `QueryType.insert(query:)`COMMENT
LOWSources/SQLite/Typed/Coding.swift1//COMMENT
58 more matches not shown…
Fake / Example Data1 hit · 1 pts
SeverityFileLineSnippetContext
LOWTests/SQLiteTests/Core/Connection+AttachTests.swift47 XCTAssertEqual(["foo@bar.com"], rows)CODE