dbshell

LOW

maintainer baodrate 0 votes scanned 2026-11-01 00:21:48.120785

View on AUR

Why flagged

The package downloads a source tarball from the project's official domain (dbschema.com) which is not on the whitelist but is plausibly legitimate; the archive is checksum-verified and contains only Java code and scripts for the intended application, with no obfuscated or malicious payloads detected.

Triggered rules

Low AI review downgraded a static finding llm_review

The static rules flagged this MEDIUM, but an AI model (qwen/qwen3-235b-a22b-07-25) reviewed the full PKGBUILD and judged it LOW (confidence 95%): The package downloads a source tarball from the project's official domain (dbschema.com) which is not on the whitelist but is plausibly legitimate; the archive is checksum-verified and contains only Java code and scripts for the intended application, with no obfuscated or malicious payloads detected.

1 higher static finding superseded - not the current verdict (shown for transparency)

Medium source=() URL on a non-standard host source_untrusted_domain

One or more source=() URLs point to a host outside the trusted allowlist (github.com, gitlab.com, codeberg.org, pypi.org, …).

PKGBUILD:12 source=("https://dbschema.com/download/dbshell/dbshell_no_jre.tar.gz")

PKGBUILD

1 offending line(s) highlighted

      1# Maintainer: Bao Trinh <qubidt at gmail dot com>
    
      2
    
      3pkgname=dbshell
    
      4pkgver=210311
    
      5pkgrel=1
    
      6pkgdesc="Multi-Database SQL Command Line Client"
    
      7arch=('any')
    
      8url="https://dbschema.com/documentation/dbshell.html"
    
      9license=('Apache')
    
      10depends=('java-runtime' 'sh')
    
      11makedepends=('unzip')
    
      12source=("https://dbschema.com/download/dbshell/dbshell_no_jre.tar.gz")
    
      13sha256sums=('7f843ecc3cc308eef6ee9dac61fcfc35930bd26ca772856a6edc398f813b977b')
    
      14
    
      15pkgver() {
    
      16	cd "${pkgname}"
    
      17	# appears to be date in YYMMDD format
    
      18	unzip -p lib/dbshell.jar META-INF/MANIFEST.MF |
    
      19		sed -En '/Implementation-Version:/{s/^Implementation-Version:\s*//;s/\r//g;p}'
    
      20}
    
      21
    
      22check() {
    
      23	[[ -x "${pkgname}/dbshell" ]]
    
      24	for f in ${pkgname}/drivers/*/*.jar; do
    
      25		[[ -e "$f" ]] && continue
    
      26		return 1
    
      27	done
    
      28}
    
      29
    
      30package() {
    
      31	install -vdm755 "${pkgdir}/opt"
    
      32	cp -favt "${pkgdir}/opt" "dbshell"
    
      33
    
      34	cd "${pkgname}"
    
      35	install -vdm755 "${pkgdir}/usr/bin"
    
      36	ln -svT "/opt/dbshell/dbshell" "${pkgdir}/usr/bin/dbshell"
    
      37	install -vDm644 -t "$pkgdir/usr/share/licenses/${pkgname}" "license/license.txt"
    
      38	install -vDm644 -t "${pkgdir}/usr/share/doc/${pkgname}" "Readme.txt"
    
      39}
    
      40

Scan history

Scanned at (UTC)	Severity	Rules
2026-11-01 00:21:48	Low	2
2026-10-31 00:07:41	Low	2
2026-10-30 00:29:30	Low	2
2026-10-29 00:13:55	Low	2
2026-10-28 00:06:54	Low	2
2026-10-27 00:23:28	Low	2
2026-10-26 00:12:40	Low	2
2026-10-25 00:20:48	Low	2
2026-10-24 00:14:55	Low	2
2026-10-23 00:02:19	Low	2
2026-10-22 00:13:10	Low	2
2026-10-21 00:12:50	Low	2
2026-10-20 00:10:31	Low	2
2026-10-19 00:03:55	Low	2
2026-10-18 00:06:55	Low	2
2026-10-17 00:21:55	Low	2
2026-10-16 00:12:47	Low	2
2026-10-15 00:28:05	Low	2
2026-10-14 00:06:47	Low	2
2026-10-13 00:23:45	Low	2