cubesql

LOW

maintainer tee 1 votes scanned 2026-09-18 00:17:11.210425

View on AUR

Why flagged

The package downloads a prebuilt binary from the project's official domain (sqlabs.com), which is not on the whitelist but is plausibly legitimate; the worst case of a swapped source is limited to code execution, but the source is official and checksummed, reducing risk.

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 prebuilt binary from the project's official domain (sqlabs.com), which is not on the whitelist but is plausibly legitimate; the worst case of a swapped source is limited to code execution, but the source is official and checksummed, reducing risk.

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=("$pkgname-$pkgver.tgz::https://www.sqlabs.com/download/cubesql/latest/cubesql_linux64bit.tar.gz"

PKGBUILD

1 offending line(s) highlighted

      1# Contributor: Martin Schrodt <martin@schrodt.org>
    
      2# Maintainer: tee < teeaur at duck dot com >
    
      3
    
      4pkgname=cubesql
    
      5pkgdesc='cubeSQL is a relational database management system built on top of the sqlite database engine.'
    
      6pkgver=5.9.6
    
      7pkgrel=1
    
      8arch=('x86_64')
    
      9url='http://www.sqlabs.com/cubesql.php'
    
      10license=('custom:cubesql')
    
      11optdepends=('gtk3')
    
      12source=("$pkgname-$pkgver.tgz::https://www.sqlabs.com/download/cubesql/latest/cubesql_linux64bit.tar.gz"
    
      13	'cubesql.service'
    
      14	'cubesql-admin'
    
      15	'cubesql-sysusers.conf'
    
      16	'cubesql-tmpfiles.conf'
    
      17    'cubesql.desktop')
    
      18sha256sums=('131adcfe1d935f1a676721ca25b3876b37449230e1adb012a54cb702d9b76571'
    
      19            '3bfe6eec238b33581f9441be552b34a875b8dac783314d0efaec6dd3992be490'
    
      20            'dec44ae33559e89061db90177322d3e9a289df64da1b1287df3bd47379b6a8b5'
    
      21            'bf57a4e0ec18559a3de8457e07262aece9cf27995af84a561f56f7ff84dfb88f'
    
      22            '0cd36e0d6bace234c454d1b66a2ed843de6b883900915165a19f5bc4bda7fd97'
    
      23            '32014ebb12363bff1474ea1959157988f3e11609a495553b8db6d7b656bc66aa')
    
      24
    
      25package() {
    
      26  mkdir -p $pkgdir/usr/bin
    
      27  mkdir -p $pkgdir/usr/share/doc/cubesql
    
      28  mkdir -p $pkgdir/usr/lib/cubesql
    
      29  
    
      30  install -D -m644 cubesql.service -t "$pkgdir/usr/lib/systemd/system"
    
      31  install -D -m644 cubesql-sysusers.conf "$pkgdir/usr/lib/sysusers.d/cubesql.conf"
    
      32  install -D -m644 cubesql-tmpfiles.conf "$pkgdir/usr/lib/tmpfiles.d/cubesql.conf"
    
      33  install -D -m755 cubesql-admin -t "$pkgdir/usr/bin"
    
      34  install -Dm644 cubesql.desktop -t "$pkgdir/usr/share/applications"
    
      35    
    
      36  cd $srcdir/cubesql_64bit/data
    
      37  cp cubesql $pkgdir/usr/bin/cubesql
    
      38  cp Documentation/* $pkgdir/usr/share/doc/cubesql
    
      39  
    
      40  cp -r cubeSQLAdmin/* $pkgdir/usr/lib/cubesql
    
      41}
    
      42 
    
      43# vim:set noet sts=0 sw=4 ts=4 ft=PKGBUILD:
    
      44

Scan history

Scanned at (UTC)	Severity	Rules
2026-09-18 00:17:11	Low	2
2026-09-17 00:27:14	Low	2
2026-09-16 00:03:17	Low	2
2026-09-15 00:25:31	Low	2
2026-09-14 00:27:57	Low	2
2026-09-13 00:19:54	Low	2
2026-09-12 00:25:17	Low	2
2026-09-11 00:19:22	Low	2
2026-09-10 00:22:44	Low	2
2026-09-09 00:04:09	Low	2
2026-09-08 00:18:08	Low	2
2026-09-07 00:30:15	Low	2
2026-09-06 00:17:06	Low	2
2026-09-05 00:16:27	Low	2
2026-09-04 00:03:13	Low	2
2026-09-03 00:15:47	Low	2
2026-09-02 00:02:31	Low	2
2026-09-01 00:11:19	Low	2
2026-08-31 00:19:57	Low	2
2026-08-30 00:04:14	Low	2