Repository Analysis

Sequel-Ace/Sequel-Ace

MySQL/MariaDB database management for macOS

4.9 Likely human-written View on GitHub

Analysis Overview

This report presents the forensic synthetic code analysis of Sequel-Ace/Sequel-Ace, a Objective-C project with 7,521 GitHub stars. SynthScan v2.0 examined 219,986 lines of code across 819 source files, recording 1206 pattern matches distributed across 7 syntactic categories. The overall adjusted score of 4.9 places this repository in the Likely human-written 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).

4.9
Adjusted Score
4.9
Raw Score
100%
Time Factor
2026-08-25
Last Push
7.5K
Stars
Objective-C
Language
220.0K
Lines of Code
819
Files
1.2K
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 1MEDIUM 1LOW 1204

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 1206 distinct pattern matches across 7 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.

Over-Commented Block1172 hits · 1028 pts
SeverityFileLineSnippetContext
LOWSource/Sequel-Ace-Bridging-Header.h1//COMMENT
LOWSource/Sequel-Ace-Bridging-Header.h21// AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHERCOMMENT
LOWSource/Sequel-Ace-Bridging-Header.h41#import "SPCopyTable.h"COMMENT
LOWSource/Sequel-Ace-Bridging-Header.h61#import "SPFavoriteTextFieldCell.h"COMMENT
LOWSource/main.m1//COMMENT
LOWSource/main.m21// OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE ANDCOMMENT
LOWSource/Other/CategoryAdditions/SPMainThreadTrampoline.h1//COMMENT
LOW…urce/Other/CategoryAdditions/SPMutableArrayAdditions.m1//COMMENT
LOW…urce/Other/CategoryAdditions/SPMutableArrayAdditions.m21// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIESCOMMENT
LOWSource/Other/CategoryAdditions/SPNotLoaded.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPNotLoaded.m21// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIESCOMMENT
LOW…ther/CategoryAdditions/SPDataBase64EncodingAdditions.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPStringAdditions.h1//COMMENT
LOWSource/Other/CategoryAdditions/SPArrayAdditions.h1//COMMENT
LOWSource/Other/CategoryAdditions/SPWindowAdditions.h1//COMMENT
LOWSource/Other/CategoryAdditions/SPWindowAdditions.h21// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIESCOMMENT
LOWSource/Other/CategoryAdditions/SPScreenAdditions.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPThreadAdditions.h1//COMMENT
LOWSource/Other/CategoryAdditions/SPThreadAdditions.h21// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIESCOMMENT
LOWSource/Other/CategoryAdditions/SPDataStorage.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPDataStorage.m21// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIESCOMMENT
LOWSource/Other/CategoryAdditions/SPDateAdditions.h1//COMMENT
LOWSource/Other/CategoryAdditions/SPDateAdditions.h21// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIESCOMMENT
LOWSource/Other/CategoryAdditions/SPTextViewAdditions.h1//COMMENT
LOWSource/Other/CategoryAdditions/SPDataAdditions.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPDataAdditions.m21// The above copyright notice and this permission notice shall beCOMMENT
LOWSource/Other/CategoryAdditions/SPObjectAdditions.h1//COMMENT
LOWSource/Other/CategoryAdditions/SPFileManagerAdditions.h1//COMMENT
LOWSource/Other/CategoryAdditions/SPColorAdditions.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPStringAdditions.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPStringAdditions.m21// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIESCOMMENT
LOW…ther/CategoryAdditions/SPDataBase64EncodingAdditions.h1//COMMENT
LOW…ther/CategoryAdditions/SPDataBase64EncodingAdditions.h21// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIESCOMMENT
LOWSource/Other/CategoryAdditions/SPNotLoaded.h1//COMMENT
LOW…urce/Other/CategoryAdditions/SPMutableArrayAdditions.h1//COMMENT
LOWSource/Other/CategoryAdditions/SPMainThreadTrampoline.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPThreadAdditions.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPThreadAdditions.m21// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIESCOMMENT
LOWSource/Other/CategoryAdditions/SPScreenAdditions.h1//COMMENT
LOWSource/Other/CategoryAdditions/SPWindowAdditions.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPWindowAdditions.m21// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIESCOMMENT
LOWSource/Other/CategoryAdditions/SPArrayAdditions.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPObjectAdditions.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPObjectAdditions.m61 return [object isKindOfClass:self] ? object : nil;COMMENT
LOWSource/Other/CategoryAdditions/SPObjectAdditions.m81// dispatch_once(&onceToken, ^{COMMENT
LOWSource/Other/CategoryAdditions/SPDataAdditions.h1//COMMENT
LOWSource/Other/CategoryAdditions/SPTextViewAdditions.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPTextViewAdditions.m21// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIESCOMMENT
LOWSource/Other/CategoryAdditions/SPDateAdditions.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPDateAdditions.m21// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIESCOMMENT
LOWSource/Other/CategoryAdditions/SPDataStorage.h1//COMMENT
LOWSource/Other/CategoryAdditions/SPCategoryAdditions.h1//COMMENT
LOWSource/Other/CategoryAdditions/SPCategoryAdditions.h21// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIESCOMMENT
LOWSource/Other/CategoryAdditions/SPCategoryAdditions.h41#import "SPTextViewAdditions.h"COMMENT
LOWSource/Other/CategoryAdditions/SPColorAdditions.h1//COMMENT
LOWSource/Other/CategoryAdditions/SPFileManagerAdditions.m1//COMMENT
LOWSource/Other/CategoryAdditions/SPFileManagerAdditions.m21// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIESCOMMENT
LOWSource/Other/SSHTunnel/SPSSHTunnel.h1//COMMENT
LOWSource/Other/SSHTunnel/SPSSHTunnel.h21//COMMENT
LOWSource/Other/SSHTunnel/SequelAceTunnelAssistant.m1//COMMENT
1112 more matches not shown…
Hyper-Verbose Identifiers26 hits · 26 pts
SeverityFileLineSnippetContext
LOWfastlane/test/github_release_creation_test.rb53 def create_or_validate_release_tag(tag:, target_sha:)CODE
LOWfastlane/test/github_release_creation_test.rb72 def validate_existing_release(CODE
LOWfastlane/test/github_release_creation_test.rb87 def create_or_validate_release(CODE
LOWfastlane/test/tar_archive_validator_test.rb146 def assert_concatenated_archive_invalid(first_terminated:)CODE
LOWfastlane/test/artifact_verifier_test.rb438 def assert_rejects_translocated_signature(signature, expected_error)CODE
LOWfastlane/test/test_helper.rb61 def production_build_evidence(target: 20_105)CODE
LOWfastlane/test/github_client_test.rb1416 def create_or_validate_release(client, tag:, target_sha:)CODE
LOWfastlane/test/github_client_test.rb1441 def inspected_commit_response(sha:, parent:, signed: true)CODE
LOW…stlane/lib/sequel_ace_release/tar_archive_validator.rb227 def canonical_hardlink_target(member_path, raw_target)CODE
LOWfastlane/lib/sequel_ace_release/git_repository.rb95 def latest_commit_changing_all(paths, head_ref: "HEAD")CODE
LOWfastlane/lib/sequel_ace_release/github_client.rb443 def create_or_validate_release(CODE
LOWfastlane/lib/sequel_ace_release/github_client.rb504 def validate_existing_release(CODE
LOWfastlane/lib/sequel_ace_release/github_client.rb522 def create_or_validate_release_tag(tag:, target_sha:)CODE
LOWfastlane/lib/sequel_ace_release/github_client.rb690 def validate_existing_release_response(CODE
LOWfastlane/lib/sequel_ace_release/github_client.rb932 def open_pull_requests_for_branch(branch)CODE
LOWfastlane/lib/sequel_ace_release/publish_handoff.rb168 def strip_alpha_recovery_annotations(body)CODE
LOWfastlane/lib/sequel_ace_release/cli.rb555 def github_release_publisher_mode(arguments)CODE
LOWfastlane/lib/sequel_ace_release/cli.rb604 def github_validate_release_target(arguments)CODE
LOWfastlane/lib/sequel_ace_release/cli.rb621 def github_verify_release_tag(arguments)CODE
LOWfastlane/lib/sequel_ace_release/cli.rb696 def github_public_assets_status(arguments)CODE
LOWfastlane/lib/sequel_ace_release/cli.rb791 def validate_forward_recovery(arguments)CODE
LOWfastlane/lib/sequel_ace_release/cli.rb1463 def release_pull_request_body(naming, release_body)CODE
LOWfastlane/lib/sequel_ace_release/cli.rb1566 def wait_for_submission_state(client, version, timeout: 900)CODE
LOWfastlane/lib/sequel_ace_release/cli.rb1660 def write_integrity_failure_marker(path)CODE
LOWfastlane/lib/sequel_ace_release/planner.rb95 def resolve_release_notes_head_ref(main_ref)CODE
LOWfastlane/lib/sequel_ace_release/planner.rb126 def select_changelog_base_tag(beta_tag, target_version, releases)CODE
AI Response Leakage1 hit · 8 pts
SeverityFileLineSnippetContext
HIGH…ontrollers/SubviewControllers/SPRuleFilterController.m1232 // the regex below is causing a crash so I've added logging to RegexLite exception generation.COMMENT
Redundant / Tautological Comments4 hits · 6 pts
SeverityFileLineSnippetContext
LOWFrameworks/libmysqlclient/build-libmysqlclient.sh111# Check if CMake succeededCOMMENT
LOWFrameworks/libmysqlclient/build-libmysqlclient.sh118# Check if CMake succeededCOMMENT
LOWFrameworks/libmysqlclient/build-libmysqlclient.sh173# Check if CMake succeededCOMMENT
LOWFrameworks/libmysqlclient/build-libmysqlclient.sh180# Check if CMake succeededCOMMENT
AI Slop Vocabulary1 hit · 3 pts
SeverityFileLineSnippetContext
MEDIUMSource/Other/AWS/AWSSTSClient.swift378 // Use XMLParser for robust parsingCOMMENT
Slop Phrases1 hit · 2 pts
SeverityFileLineSnippetContext
LOW…LFramework/MySQL Client Libraries/include/my_command.h98 /* don't forget to update std::string Command_names::m_names[] in sql_parse.ccCOMMENT
Fake / Example Data1 hit · 1 pts
SeverityFileLineSnippetContext
LOWfastlane/test/tar_archive_validator_test.rb97 file("placeholder", "unsafe\n")CODE