RepoTrust

Leaderboard github.com

andrisasuke/gemini-sql

A modern, cross-platform SQL editor with AI-powered query generation. Built with Tauri, React, and Rust.

  • View repository ↗
  • TypeScript
  • ★ 17
  • commit 46a5c605728a
  • scored 2026-11-14
  • scoring prov-5+qual-2+sec-2

unreviewed-ai-risk

AI provenance

100%

explicit

Confidence
72%
Coverage
100%

Estimated share of AI-generated code. Explicit attribution is a lower bound.

Code quality

46/100

poor

Confidence
90%
Coverage
100%

Complexity, duplication, lint density, tests, CI, docs and review process.

Security

68/100

weak

Confidence
85%
Coverage
100%

Secrets, static analysis, vulnerable dependencies, CI and supply-chain posture.

AI provenance

100% explicit

Explicit AI attribution on 100% of first-party code added; an estimated 100% including velocity signals.

How the score is built

  • Explicitly attributed share100%
  • Unattributed share in AI-pace bursts0%
  • Estimated AI-generated share100%
  • AI tool configuration files1
  • Work sessions at AI pace0
  • Releases at AI pacenot measured
  • Coding-style index (1.0+ means possible)0.00

Attributed AI tools

ToolCommitsLines addedFirst seenLast seen
Claude Code97,2132025-12-302026-01-28

Lines added per month all AI-attributed share

  1. 2025-124,888 · 100% AI
  2. 2026-012,325 · 100% AI

Findings in AI-attributed lines vs the rest

From git blame: 6,845 lines trace to AI-attributed commits, 0 to others. Too few lines in one group for a fair comparison. Reported, not scored.

Findings per 1,000 linesAI-attributedOtherRatio
Code quality0.44——
Security0.15——

Evidence by analyzer

Explicit AI attributionok10 items
attributed_commit_share
100.0%
attributed_commits
9
attributed_loc
7,213
attributed_loc_share
100.0%
commits
9
effective_loc
7,213
tools_detected
1
AI tool configurationok1 item
artifacts
1
earliest_adoption
2026-01-11
tools_configured
1
workflow_agents
0
Commit velocityok
excluded_import_loc
4,485
flagged_loc
0
flagged_loc_share
0.0%
flagged_units
0
max_loc_per_hour
415.75
measured_loc
2,728
median_loc_per_hour
57.12
pr_timed_units
0
pre_ai_era_burst_loc
0
pre_ai_era_bursts
0
pre_ai_era_measured_loc
0
work_units
6
Release velocityskipped
Coding styleok
count:assistant_voice
0
count:emoji_in_code
0
count:narrated_steps
0
count:placeholder
0
files:assistant_voice
0
files:emoji_in_code
0
files:narrated_steps
0
files:placeholder
0
index
0
lines_scanned
6,845
per_kloc:assistant_voice
0
per_kloc:emoji_in_code
0
per_kloc:narrated_steps
0
per_kloc:placeholder
0
Findings in AI-written linesok
ai_lines
6,845
blame_failures
0
files_blamed
67
other_lines
0
quality:ai_findings
3
quality:ai_per_kloc
0.44
quality:other_findings
0
security:ai_findings
1
security:ai_per_kloc
0.15
security:other_findings
0

Code quality

46 poor

Code quality is poor: test-to-source ratio 0.00, no CI test run detected; 23% of function code in complex or long functions; 14% duplicated lines. Weakest area: testing.

How the score is built

  • Complexity50
  • Duplication44
  • Lint and smells90
  • Tests and CI0
  • Documentation65
  • Type safety100
  • Review processnot measured

Evidence by analyzer

Complexity (lizard)ok10 items
complex_functions
10
function_nloc
4,645
functions
420
long_functions
7
many_param_functions
0
mean_ccn
2.63
p90_ccn
5
risky_nloc_share
23.1%
Duplication (jscpd)ok10 items
compared_lines
5,022
duplicated_lines
697
duplicated_share
13.9%
files
67
Lintok
category:best-practice
3
findings
3
scanned_lines
6,845
weighted_findings
3
Tests and CIok
check:ci_present
no
check:ci_runs_lint
no
check:ci_runs_tests
no
check:has_tests
no
check:test_ratio
no
check:tests_cochange
no
ci_files
0
cochange_commits
8
cochange_share
0.0%
source_lines
6,845
test_lines
0
test_ratio
0
Documentationok2 items
  • README.md README.md
  • LICENSE LICENSE
check:changelog
no
check:contributing
no
check:license
yes
check:readme
yes
readme_lines
133
Type safetyok1 item
  • TypeScript strict type checking: tsconfig.json tsconfig.json
check:low_escape_density
yes
check:strict_config
yes
escapes
0
escapes_per_kloc
0

Security

68 weak

Security posture is weak: 28 known vulnerabilities in 11 dependencies. Weakest area: posture.

How the score is built

  • Secrets100
  • Static analysis (SAST)99
  • Vulnerable dependencies31
  • CI workflowsnot measured
  • Security posture0
  • OpenSSF Scorecardnot measured

Evidence by analyzer

OpenSSF Scorecardskipped

no published OpenSSF Scorecard result for this repo

Package registriesok
checked
44
declared
44
lookup_errors
0
missing
0
recent
0
Secrets (gitleaks)ok
secrets_current
0
secrets_history
0
secrets_low_confidence
0
secrets_nonprod
0
Static analysis (opengrep)ok
findings
1
findings_high
0
findings_low
0
findings_medium
1
parse_errors
0
scanned_lines
6,845
weighted_findings
0.25
Dependencies (osv-scanner)ok
penalty
71
vulnerabilities
28
vulnerable_packages
11
vulns_critical
0
vulns_high
13
vulns_low
2
vulns_medium
13
vulns_unknown
0
CI workflows (zizmor)skipped
Security postureok1 item
  • src-tauri/Cargo.toml has no lockfile alongside it (unpinned dependencies) src-tauri/Cargo.toml
check:dependency_updates
no
check:lockfiles
no
check:security_policy
no
check:signed_commits
no
signed_commit_share
0.0%
unpinned_manifests
1
Release downloadsok
binary_assets
0
signals
0
suspicious
0

Findings

13 high17 medium2 low

SeverityRuleLocationMessageTool
high osv/GHSA-28wg-ghj8-5hjv package-lock.json [email protected] (npm) is affected by GHSA-28wg-ghj8-5hjv Dependencies (osv-scanner)
high osv/GHSA-2v37-7h3g-55p8 package-lock.json [email protected] (npm) is affected by GHSA-2v37-7h3g-55p8 Dependencies (osv-scanner)
high osv/GHSA-587h-7wmj-h5pm package-lock.json [email protected] (npm) is affected by GHSA-587h-7wmj-h5pm Dependencies (osv-scanner)
high osv/GHSA-68fv-2mgg-jv7q package-lock.json [email protected] (npm) is affected by GHSA-68fv-2mgg-jv7q Dependencies (osv-scanner)
high osv/GHSA-6g55-p6wh-862q package-lock.json [email protected] (npm) is affected by GHSA-6g55-p6wh-862q Dependencies (osv-scanner)
high osv/GHSA-73wf-gq98-2v4g package-lock.json [email protected] (npm) is affected by GHSA-73wf-gq98-2v4g Dependencies (osv-scanner)
high osv/GHSA-c2c7-rcm5-vvqj package-lock.json [email protected] (npm) is affected by GHSA-c2c7-rcm5-vvqj Dependencies (osv-scanner)
high osv/GHSA-c2c7-rcm5-vvqj package-lock.json [email protected] (npm) is affected by GHSA-c2c7-rcm5-vvqj Dependencies (osv-scanner)
high osv/GHSA-c83g-rgw3-j3cx package-lock.json [email protected] (npm) is affected by GHSA-c83g-rgw3-j3cx Dependencies (osv-scanner)
high osv/GHSA-mw96-cpmx-2vgc package-lock.json [email protected] (npm) is affected by GHSA-mw96-cpmx-2vgc Dependencies (osv-scanner)
high osv/GHSA-p9ff-h696-f583 package-lock.json [email protected] (npm) is affected by GHSA-p9ff-h696-f583 Dependencies (osv-scanner)
high osv/GHSA-r28c-9q8g-f849 package-lock.json [email protected] (npm) is affected by GHSA-r28c-9q8g-f849 Dependencies (osv-scanner)
high osv/GHSA-xwg4-73v4-xw9w package-lock.json [email protected] (npm) is affected by GHSA-xwg4-73v4-xw9w Dependencies (osv-scanner)
medium opengrep/typescript.react.best-practice.react-props-spreading src/components/common/Button.tsx:37 It's best practice to explicitly pass props to an HTML component rather than use the spread operator. The spread operator risks passing invalid HTML props to an HTML element, which can cause console warnings or worse, give malicious... Lint
medium opengrep/typescript.react.best-practice.react-props-spreading src/components/common/Input.tsx:28 It's best practice to explicitly pass props to an HTML component rather than use the spread operator. The spread operator risks passing invalid HTML props to an HTML element, which can cause console warnings or worse, give malicious... Lint
medium opengrep/typescript.react.best-practice.react-props-spreading src/components/common/Select.tsx:26 It's best practice to explicitly pass props to an HTML component rather than use the spread operator. The spread operator risks passing invalid HTML props to an HTML element, which can cause console warnings or worse, give malicious... Lint
medium osv/GHSA-3v7f-55p6-f55p package-lock.json [email protected] (npm) is affected by GHSA-3v7f-55p6-f55p Dependencies (osv-scanner)
medium osv/GHSA-3v7f-55p6-f55p package-lock.json [email protected] (npm) is affected by GHSA-3v7f-55p6-f55p Dependencies (osv-scanner)
medium osv/GHSA-4w7w-66w2-5vf9 package-lock.json [email protected] (npm) is affected by GHSA-4w7w-66w2-5vf9 Dependencies (osv-scanner)
medium osv/GHSA-698v-4r3x-3vcv package-lock.json [email protected] (npm) is affected by GHSA-698v-4r3x-3vcv Dependencies (osv-scanner)
medium osv/GHSA-fx2h-pf6j-xcff package-lock.json [email protected] (npm) is affected by GHSA-fx2h-pf6j-xcff Dependencies (osv-scanner)
medium osv/GHSA-fxqj-rqcc-2cmp package-lock.json [email protected] (npm) is affected by GHSA-fxqj-rqcc-2cmp Dependencies (osv-scanner)
medium osv/GHSA-qx2v-qp2m-jg93 package-lock.json [email protected] (npm) is affected by GHSA-qx2v-qp2m-jg93 Dependencies (osv-scanner)
medium osv/GHSA-r825-w8mm-5pxw package-lock.json [email protected] (npm) is affected by GHSA-r825-w8mm-5pxw Dependencies (osv-scanner)
medium osv/GHSA-rj75-hqrm-r3gf package-lock.json [email protected] (npm) is affected by GHSA-rj75-hqrm-r3gf Dependencies (osv-scanner)
medium osv/GHSA-rq7h-c2jc-7f22 package-lock.json [email protected] (npm) is affected by GHSA-rq7h-c2jc-7f22 Dependencies (osv-scanner)
medium osv/GHSA-v6wh-96g9-6wx3 package-lock.json [email protected] (npm) is affected by GHSA-v6wh-96g9-6wx3 Dependencies (osv-scanner)
medium osv/GHSA-w5vr-8v7q-w6rv package-lock.json [email protected] (npm) is affected by GHSA-w5vr-8v7q-w6rv Dependencies (osv-scanner)
medium osv/GHSA-w9m9-85wc-3x92 package-lock.json [email protected] (npm) is affected by GHSA-w9m9-85wc-3x92 Dependencies (osv-scanner)
medium opengrep/javascript.lang.security.audit.detect-non-literal-regexp src/components/editor/QueryEditor.tsx:293 RegExp() called with a `context` function argument, this might allow an attacker to cause a Regular Expression Denial-of-Service (ReDoS) within your application as RegExP blocks the main thread. For this reason, it is recommended to use... Static analysis (opengrep)
low osv/GHSA-4x5r-pxfx-6jf8 package-lock.json @babel/[email protected] (npm) is affected by GHSA-4x5r-pxfx-6jf8 Dependencies (osv-scanner)
low osv/GHSA-9jrq-w75r-8gcw package-lock.json [email protected] (npm) is affected by GHSA-9jrq-w75r-8gcw Dependencies (osv-scanner)

Tools and coverage

Every analyzer that ran on this commit. A failed or skipped tool is a coverage gap: its share of the score is left out and the coverage figure drops.

AnalyzerPillarStatusVersionFindingsNote
AI tool configurationAI provenanceoksignatures-v10
Explicit AI attributionAI provenanceoksignatures-v10
Release velocityAI provenanceskipped—0
Coding styleAI provenanceok—0
Commit velocityAI provenanceokprov-40
Findings in AI-written linesAI provenanceokgit-blame0
Complexity (lizard)Code qualityoklizard 1.25.10
DocumentationCode qualityok—0
Duplication (jscpd)Code qualityokrepotrust-dup-w60
LintCode qualityokopengrep 1.33.1; rules f1d2b562b4143
Tests and CICode qualityok—0
Type safetyCode qualityok—0
CI workflows (zizmor)Securityskipped—0
Dependencies (osv-scanner)Securityokosv-scanner version: 2.7.128
Release downloadsSecurityok—0
Security postureSecurityok—0
Package registriesSecurityok—0
Static analysis (opengrep)Securityokopengrep 1.33.1; rules f1d2b562b4141
OpenSSF ScorecardSecurityskipped—0no published OpenSSF Scorecard result for this repo
Secrets (gitleaks)Securityokgitleaks 8.30.10

Score history

Scores from different scoring versions aren't directly comparable.

ScoredCommitScoringAI provenanceQualitySecurity
2026-11-1446a5c605728aprov-5+qual-2+sec-2100%4668
2026-11-1446a5c605728aprov-4+qual-2+sec-2100%4668

Embed a badge

Maintainers can show these in a README. Badges update when the repository is re-scored.

[![RepoTrust ai](https://repotrust.synapticcyber.com/badge/github.com/andrisasuke/gemini-sql/ai.svg)](https://repotrust.synapticcyber.com/r/github.com/andrisasuke/gemini-sql/)
[![RepoTrust quality](https://repotrust.synapticcyber.com/badge/github.com/andrisasuke/gemini-sql/quality.svg)](https://repotrust.synapticcyber.com/r/github.com/andrisasuke/gemini-sql/)
[![RepoTrust security](https://repotrust.synapticcyber.com/badge/github.com/andrisasuke/gemini-sql/security.svg)](https://repotrust.synapticcyber.com/r/github.com/andrisasuke/gemini-sql/)
Full text report

Scores

Unreviewed AI code risk: a large share of this code is explicitly AI-attributed, and its tests or review process are weak while quality or security scores are low.

Pillar Score Signal Confidence Coverage
AI provenance (estimated AI-generated share) 100 explicit 72% 100%
Code quality 46 poor 90% 100%
Security 68 weak 85% 100%

AI provenance

Explicit AI attribution on 100% of first-party code added; an estimated 100% including velocity signals.

  • Explicitly attributed share (lower bound): 100.0%
  • Unattributed share in AI-consistent velocity bursts: 0.0%
  • Estimated AI-generated share: 100.0%
AI tool Attributed commits Lines added
Claude Code 9 7,213
  • AI tooling configured in repo: claude-code

Current source lines last changed by AI-attributed commits: 6,845 of 6,845.

Too few lines in one group to compare finding densities.

Month Lines added Attributed to AI
2025-12 4,888 100%
2026-01 2,325 100%

Evidence

  • Claude Code: trailer 'Co-Authored-By: Claude' (46a5c605728a)
  • Claude Code: trailer 'Co-Authored-By: Claude' (ab3795d82655)
  • Claude Code: trailer 'Co-Authored-By: Claude' (08b06b985502)
  • Claude Code: trailer 'Co-Authored-By: Claude' (6e94e23604f0)
  • Claude Code: trailer 'Co-Authored-By: Claude' (5121354fe110)
  • Claude Code: trailer 'Co-Authored-By: Claude' (e6eae5d37c11)
  • Claude Code: trailer 'Co-Authored-By: Claude' (555c0f134ecd)
  • Claude Code: trailer 'Co-Authored-By: Claude' (cc5b08ca293a)
  • Claude Code: trailer 'Co-Authored-By: Claude' (9857c05df88d)
  • CLAUDE.md (claude-code configuration) (CLAUDE.md)

AI provenance describes how code was produced; it is not a quality judgment. Unless attribution is explicit, these are signals consistent with AI generation, not proof. Squash/rebase workflows, imported code, and rewritten history reduce accuracy.

Code quality

Code quality is poor: test-to-source ratio 0.00, no CI test run detected; 23% of function code in complex or long functions; 14% duplicated lines. Weakest area: testing.

Area Score
Complexity (lizard) 50
Duplication 44
Code smells (Opengrep) 90
Tests and CI 0
Documentation 65
Type safety 100
Process (Scorecard review/maintenance) n/a
  • Functions: 420; mean complexity 2.6, 90th percentile 5; 10 complex and 7 long functions
  • Duplicated lines: 13.9% of 5,022 compared
  • Tests: 0 test lines for 6,845 source lines (ratio 0.00); CI test commands: none detected; 0% of recent source commits also change tests
  • Docs missing or thin: contributing, changelog

Most complex functions:

Security

Security posture is weak: 28 known vulnerabilities in 11 dependencies. Weakest area: posture.

Area Score
Secrets (gitleaks, tree + history) 100
Static analysis (Opengrep) 99
Vulnerable dependencies (OSV) 31
CI workflows (zizmor) n/a
Posture (policy, updates, signing, lockfiles) 0
OpenSSF Scorecard n/a
  • Known vulnerabilities: 28 in 11 packages (critical 0, high 13, medium 13, low 2)

  • Posture checks passed: none; missing: security policy, dependency updates, signed commits, lockfiles

Top findings

Severity Finding Location
high osv/GHSA-73wf-gq98-2v4g: [email protected] (npm) is affected by GHSA-73wf-gq98-2v4g package-lock.json
high osv/GHSA-c83g-rgw3-j3cx: [email protected] (npm) is affected by GHSA-c83g-rgw3-j3cx package-lock.json
high osv/GHSA-28wg-ghj8-5hjv: [email protected] (npm) is affected by GHSA-28wg-ghj8-5hjv package-lock.json
high osv/GHSA-2v37-7h3g-55p8: [email protected] (npm) is affected by GHSA-2v37-7h3g-55p8 package-lock.json
high osv/GHSA-xwg4-73v4-xw9w: [email protected] (npm) is affected by GHSA-xwg4-73v4-xw9w package-lock.json
high osv/GHSA-c2c7-rcm5-vvqj: [email protected] (npm) is affected by GHSA-c2c7-rcm5-vvqj package-lock.json
high osv/GHSA-c2c7-rcm5-vvqj: [email protected] (npm) is affected by GHSA-c2c7-rcm5-vvqj package-lock.json
high osv/GHSA-6g55-p6wh-862q: [email protected] (npm) is affected by GHSA-6g55-p6wh-862q package-lock.json
high osv/GHSA-r28c-9q8g-f849: [email protected] (npm) is affected by GHSA-r28c-9q8g-f849 package-lock.json
high osv/GHSA-mw96-cpmx-2vgc: [email protected] (npm) is affected by GHSA-mw96-cpmx-2vgc package-lock.json
high osv/GHSA-68fv-2mgg-jv7q: [email protected] (npm) is affected by GHSA-68fv-2mgg-jv7q package-lock.json
high osv/GHSA-587h-7wmj-h5pm: [email protected] (npm) is affected by GHSA-587h-7wmj-h5pm package-lock.json
high osv/GHSA-p9ff-h696-f583: [email protected] (npm) is affected by GHSA-p9ff-h696-f583 package-lock.json
medium opengrep/javascript.lang.security.audit.detect-non-literal-regexp: RegExp() called with a context function argument, this might allow an attacker to cause a Regular Expression Denial-of-Service (ReDoS) within your application as RegExP blocks the main thread. For this reason, it is recommended to use hardcoded regexes instead. If your regex is run on user-control [confidence low] src/components/editor/QueryEditor.tsx:293
medium osv/GHSA-w5vr-8v7q-w6rv: [email protected] (npm) is affected by GHSA-w5vr-8v7q-w6rv package-lock.json
medium osv/GHSA-3v7f-55p6-f55p: [email protected] (npm) is affected by GHSA-3v7f-55p6-f55p package-lock.json
medium osv/GHSA-3v7f-55p6-f55p: [email protected] (npm) is affected by GHSA-3v7f-55p6-f55p package-lock.json
medium osv/GHSA-fxqj-rqcc-2cmp: [email protected] (npm) is affected by GHSA-fxqj-rqcc-2cmp package-lock.json
medium osv/GHSA-qx2v-qp2m-jg93: [email protected] (npm) is affected by GHSA-qx2v-qp2m-jg93 package-lock.json
medium osv/GHSA-rj75-hqrm-r3gf: [email protected] (npm) is affected by GHSA-rj75-hqrm-r3gf package-lock.json
medium osv/GHSA-w9m9-85wc-3x92: [email protected] (npm) is affected by GHSA-w9m9-85wc-3x92 package-lock.json
medium osv/GHSA-4w7w-66w2-5vf9: [email protected] (npm) is affected by GHSA-4w7w-66w2-5vf9 package-lock.json
medium osv/GHSA-698v-4r3x-3vcv: [email protected] (npm) is affected by GHSA-698v-4r3x-3vcv package-lock.json
medium osv/GHSA-fx2h-pf6j-xcff: [email protected] (npm) is affected by GHSA-fx2h-pf6j-xcff package-lock.json
medium osv/GHSA-r825-w8mm-5pxw: [email protected] (npm) is affected by GHSA-r825-w8mm-5pxw package-lock.json

Static signals only: the scorer never runs the project's code. Secret findings are pattern matches that were not verified, and secret values are never stored.

Repository profile

  • Source lines: 6,845; test lines: 0
Language Lines
TypeScript 5,091
Rust 1,688
JavaScript 66