Repository Analysis

catfan/Medoo

The lightweight PHP database framework to accelerate the development.

12.8 Low AI signal View on GitHub

Analysis Overview

This report presents the forensic synthetic code analysis of catfan/Medoo, a PHP project with 4,949 GitHub stars. SynthScan v2.0 examined 6,709 lines of code across 29 source files, recording 78 pattern matches distributed across 2 syntactic categories. The overall adjusted score of 12.8 places this repository in the Low AI signal band.

The scanner applied 160+ deterministic lexical heuristics, multi-line block detectors, abstract syntax tree depth profilers, and a cross-file Jaccard similarity matrix to construct a statistically normalised synthetic code estimate. All matches are individually weighted by severity coefficient and contextual multiplier before summation, and the resulting headline score is temporally discounted to account for the repository's development history relative to the commercial emergence of large language model coding tooling (November 2022 onward).

12.8
Adjusted Score
12.8
Raw Score
100%
Time Factor
2026-08-22
Last Push
4.9K
Stars
PHP
Language
6.7K
Lines of Code
29
Files
78
Pattern Hits
2026-08-29
Scan Date
0.00
HC Hit Rate

What These Metrics Mean

Adjusted Score
Primary synthetic code indicator. Raw score normalised per 1,000 lines of code and multiplied by the temporal discount factor. This is the definitive comparative metric — use it to rank repositories by AI authorship density.
Raw Score
The unmodified sum of all severity-weighted, context-multiplied pattern match scores before temporal discounting. Reflects the absolute signal strength independent of when the repository was last active.
Time Factor
The temporal discount multiplier (0–100%) applied to the raw score. Repositories last updated before ChatGPT's launch (Nov 2022) receive a 5% factor. Full signal is only assigned to repositories active in the post-adoption era (Jan 2024+).
Pattern Hits
Total count of individual pattern matches across all files and categories. A high hit count with a low score may indicate a very large codebase with isolated AI snippets; a low count with a high score indicates dense, concentrated AI signatures.
HC Hit Rate
High+Critical pattern hits per file, averaged across the repository. This orthogonal signal catches repositories where a few files are densely packed with high-severity AI tells — a strong indicator even when the normalised score appears moderate due to codebase size.
Lines of Code / Files
Total lines and files analysed. The scanner examines 94 file extensions. These denominators are used to normalise the score, enabling fair comparison between repositories of vastly different sizes.

Score History

This chart maps the temporal evolution of the adjusted synthetic code score across successive scan runs. An upward trajectory indicates ongoing incorporation of AI-generated code or expanding LLM-assisted scaffolding; a stable or declining trajectory may reflect active human refactoring, code removal, or the adoption of stricter authorship policies. The dashed secondary line (right axis) independently tracks total raw pattern hit count, which can diverge from the normalised score when codebase size changes significantly between scans.

Severity Breakdown

Classifies detected patterns by their diagnostic confidence and structural impact. CRITICAL patterns (coefficient 10) represent definitive synthetic signatures — hallucinated imports, explicit LLM attribution metadata — virtually never produced by human authors. HIGH (5) indicates strong structural tells such as cross-file repetition or cross-linguistic idioms. MEDIUM (2) covers recognisable conversational padding and AI-specific vocabulary. LOW (1) captures subtle indicators like tautological comments and generic boilerplate that require density to carry independent signal.

CRITICAL 0HIGH 0MEDIUM 0LOW 78

Directory Score Breakdown

This horizontal bar chart decomposes the repository's raw synthetic code score by top-level directory, allowing you to pinpoint precisely which modules or components carry the highest AI authorship density. Directories with disproportionately high scores relative to their size warrant targeted manual review: concentrated AI signatures often trace back to mass-generated configuration layers, auto-ported test suites, LLM-scaffolded boilerplate classes, or entire subsystems authored under heavy copilot assistance. Use this view to prioritise your human code-review effort.

Pattern Findings

The scanner identified 78 distinct pattern matches across 2 syntactic categories. Each entry below represents a discrete location in the source code where the engine recorded a statistically significant AI authorship indicator. 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 diagnostic confidence level (CRITICAL / HIGH / MEDIUM / LOW). The Context column identifies whether the match occurred inside executable code, an inline comment, or a string literal — comment-context matches receive a ×1.5 weight because LLMs systematically over-annotate. The ⚡ bolt icon marks clustered matches: three or more patterns within a 10-line window, each receiving an additional ×1.5 density multiplier as dense clusters constitute far stronger evidence of synthetic authorship than isolated hits.

Hyper-Verbose Identifiers58 hits · 61 pts
SeverityFileLineSnippetContext
LOWtests/SelectTest.php75 public function testSelectColumnsWithAlias(string $type): voidCODE
LOWtests/SelectTest.php91 public function testSelectColumnsWithType(string $type): voidCODE
LOWtests/SelectTest.php107 public function testSelectColumnsWithAliasAndType(string $type): voidCODE
LOWtests/SelectTest.php255 public function testSelectWithSameKeysJoin(string $type): voidCODE
LOWtests/SelectTest.php351 public function testSelectWithMultipleConditionJoin(string $type): voidCODE
LOWtests/SelectTest.php382 public function testSelectWithAdditionalConditionJoin(string $type): voidCODE
LOWtests/SelectTest.php448 public function testSelectWithDataMapping(string $type): voidCODE
LOWtests/SelectTest.php480 public function testSelectWithIndexMapping(string $type): voidCODE
LOWtests/SelectTest.php520 public function testSelectWithDistinctDiffOrder(string $type): voidCODE
LOWtests/SelectTest.php539 public function testSelectWithUnicodeCharacter(string $type): voidCODE
LOWtests/SelectTest.php558 public function testSelectWithHyphenCharacter(string $type): voidCODE
LOWtests/SelectTest.php576 public function testSelectWithSingleCharacter(string $type): voidCODE
LOWtests/QueryTest.php62 public function testQueryShowTableWithPrefix(): voidCODE
LOWtests/QueryTest.php80 public function testPreparedStatementQuery(string $type): voidCODE
LOWtests/ConnectionTest.php12 public function testPostgreSQLAppliesValidatedCharsetToInjectedPdo(): voidCODE
LOWtests/ConnectionTest.php26 public function testPostgreSQLRejectsInvalidCharset(mixed $charset): voidCODE
LOWtests/ConnectionTest.php41 public static function invalidEncodingNamesProvider(): arrayCODE
LOWtests/ConnectionTest.php53 public function testMySQLRejectsInvalidCollation(): voidCODE
LOWtests/InsertTest.php154 public function testOracleWithPrimaryKeyInsert(): voidCODE
LOWtests/InsertTest.php173 public function testPostgreSQLWithPrimaryKeyInsert(): voidCODE
LOWtests/InsertTest.php213 public function testOracleWithLOBsAndIdInsert(): voidCODE
LOWtests/RawTest.php29 public function testRawWithSamePlaceholderName(string $type): voidCODE
LOWtests/CreateTest.php61 public function testCreateWithCustomIdentityColumn(): voidCODE
LOWtests/CreateTest.php77 public function testCreateRejectsInvalidIdentity(string $identity): voidCODE
LOWtests/CreateTest.php98 public function testCreateRejectsMultipleIdentityColumns(): voidCODE
LOWtests/CreateTest.php109 public function testCreateRejectsIdentityColumnCollision(array $columns): voidCODE
LOWtests/CreateTest.php119 public static function identityCollisionProvider(): arrayCODE
LOWtests/CreateTest.php127 public function testCreateRejectsIdentityForUnsupportedDatabase(): voidCODE
LOWtests/CreateTest.php136 public function testSQLiteIdentityExecution(): voidCODE
LOWtests/CreateTest.php208 public function testCreateWithStringDefinition(string $type): voidCODE
LOWtests/CreateTest.php240 public function testCreateWithSingleOption(string $type): voidCODE
LOWtests/WhereTest.php173 public function testArrayStringValuesWhere(string $type): voidCODE
LOWtests/WhereTest.php193 public function testEmptyArrayValuesWhere(string $type): voidCODE
LOWtests/WhereTest.php405 public function testCompoundDuplicatedKeysWhere(string $type): voidCODE
LOWtests/WhereTest.php71 public function testNotBetweenDateTimeWhere(string $type): voidCODE
LOWtests/WhereTest.php212 public function testEmptyNotInArrayValuesWhere(string $type): voidCODE
LOWtests/WhereTest.php254 public function testRawNotInArrayValuesWhere(string $type): voidCODE
LOWtests/WhereTest.php309 public function testBasicAndRelativityWhere(string $type): voidCODE
LOWtests/WhereTest.php332 public function testBasicSingleRelativityWhere(string $type): voidCODE
LOWtests/WhereTest.php353 public function testBasicOrRelativityWhere(string $type): voidCODE
LOWtests/WhereTest.php379 public function testCompoundRelativityWhere(string $type): voidCODE
LOWtests/WhereTest.php435 public function testColumnsRelationshipWhere(string $type): voidCODE
LOWtests/WhereTest.php706 public function testMultipleOrderWhereWithStringValues(string $type): voidCODE
LOWtests/WhereTest.php772 public function testRegularExpressionWhere(string $type): voidCODE
LOWtests/WhereTest.php805 public function testNegativeRegularExpressionWhere(string $type): voidCODE
LOWtests/WhereTest.php1016 public function testHavingWithAggregateRawWhere(string $type): voidCODE
LOWtests/WhereTest.php1058 public function testRawWhereWithJoinClause(string $type): voidCODE
LOWtests/DataMapTest.php10 public function testDataMapKeepsIndexedNestedResultConsistent(): voidCODE
LOWtests/IdTest.php12 public function testOracleIdReturnsCachedValue(): voidCODE
LOWtests/IdTest.php20 public function testIdReturnsNullWithoutConnection(): voidCODE
LOWtests/IdTest.php27 public function testPostgreSQLIdUsesLastvalWithoutSequenceName(): voidCODE
LOWtests/IdTest.php38 public function testPostgreSQLIdUsesCachedReturningValue(): voidCODE
LOWtests/IdTest.php50 public function testPostgreSQLIdReturnsNullBeforeSequenceUse(): voidCODE
LOWtests/IdTest.php58 public function testPostgreSQLIdUsesSequenceName(): voidCODE
LOWtests/IdTest.php69 public function testPostgreSQLIdKeepsZeroValue(): voidCODE
LOWtests/IdTest.php88 public function testDriverFalseIdReturnsNull(): voidCODE
LOWtests/IdTest.php96 public function testDefaultDriverIdUsesPdoLastInsertId(): voidCODE
LOWtests/ColumnMappingTest.php10 public function testColumnHelpersKeepIndexedNestedResultsConsistent(): voidCODE
Fake / Example Data20 hits · 25 pts
SeverityFileLineSnippetContext
LOWREADME.md84 'email' => 'foo@bar.com'CODE
LOWREADME.md99// "email" : "foo@bar.com",COMMENT
LOWtests/InsertTest.php17 "email" => "foo@bar.com"CODE
LOWtests/InsertTest.php23 VALUES ('foo', 'foo@bar.com')CODE
LOWtests/InsertTest.php137 "email" => "foo@bar.com"CODE
LOWtests/InsertTest.php148 VALUES ('foo', 'foo@bar.com'), ('bar', 'bar@foo.com')CODE
LOWtests/InsertTest.php160 "EMAIL" => "foo@bar.com"CODE
LOWtests/InsertTest.php166 VALUES ('foo', 'foo@bar.com')CODE
LOWtests/InsertTest.php179 "email" => "foo@bar.com"CODE
LOWtests/InsertTest.php185 VALUES ('foo', 'foo@bar.com')CODE
LOWtests/WhereTest.php178 "email" => ["foo@bar.com", "cat@dog.com", "admin@medoo.in"]CODE
LOWtests/WhereTest.php186 "email" IN ('foo@bar.com', 'cat@dog.com', 'admin@medoo.in')CODE
LOWtests/WhereTest.php398 (("user_name" = 'foo' OR "email" = 'foo@bar.com') AND "password" = '12345')CODE
LOWtests/WhereTest.php413 "email" => "foo@bar.com"CODE
LOWtests/WhereTest.php16 "email" => "foo@bar.com",CODE
LOWtests/WhereTest.php34 "email" = 'foo@bar.com' ANDCODE
LOWtests/WhereTest.php285 "email[!]" => ["foo@bar.com", "admin@medoo.in"],CODE
LOWtests/WhereTest.php299 "email" NOT IN ('foo@bar.com', 'admin@medoo.in') ANDCODE
LOWtests/WhereTest.php387 "email" => "foo@bar.com"CODE
LOWtests/WhereTest.php427 (("user_name" = 'foo' OR "email" = 'foo@bar.com') ANDCODE