---
id: CVE-2026-54529
title: SQLAdmin is a flexible Admin interface for SQLAlchemy models
summary: >-
  SQLAdmin is a flexible Admin interface for SQLAlchemy models. Prior to 0.27.1,
  ModelView.sort_query in sqladmin/models.py accepts the attacker-controlled
  sortBy list-view query parameter without enforcing the configured
  column_sortable_l…
severity: medium
cvss: 5.3
cvssVector: 'CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:N/A:N'
cwe:
  - CWE-20
  - CWE-200
  - CWE-248
  - CWE-639
vendor: smithyhq
product: sqladmin
affected:
  - sqladmin < 0.27.1
patched:
  - sqladmin 0.27.1
published: '2026-09-14'
updated: '2026-09-14'
sourceUpdated: '2026-09-14T17:17:47.487'
source: NVD
sourceUrl: 'https://nvd.nist.gov/vuln/detail/CVE-2026-54529'
references:
  - url: >-
      https://github.com/smithyhq/sqladmin/commit/741635f18f93c020bfe355167ab257da9a6ca99a
    label: security-advisories@github.com
  - url: 'https://github.com/smithyhq/sqladmin/releases/tag/0.27.1'
    label: security-advisories@github.com
  - url: >-
      https://github.com/smithyhq/sqladmin/security/advisories/GHSA-ccg5-9c8w-xh6v
    label: security-advisories@github.com
  - url: 'https://github.com/smithyhq/sqladmin'
  - url: 'https://pypi.org/project/sqladmin'
  - url: 'https://github.com/advisories/GHSA-ccg5-9c8w-xh6v'
  - url: 'https://nvd.nist.gov/vuln/detail/CVE-2026-54529'
tags:
  - nvd
  - cve.org
  - osv
  - pip
ssvc:
  exploitation: none
  automatable: 'yes'
  technicalImpact: partial
  timestamp: '2026-09-14T16:29:34.201376Z'
aliases:
  - GHSA-ccg5-9c8w-xh6v
  - PYSEC-2026-3922
ecosystem: pip
ingestedAt: '2026-09-12T03:13:01.687Z'
epss: 0.00378
epssPercentile: 0.31721
---

## Overview

SQLAdmin is a flexible Admin interface for SQLAlchemy models. Prior to 0.27.1, ModelView.sort_query in sqladmin/models.py accepts the attacker-controlled sortBy list-view query parameter without enforcing the configured column_sortable_list server-side allow-list in self._sort_fields. The value is resolved with getattr and passed to relationship joins and order_by, allowing requests to sort by columns hidden from column_list and by related-model columns through dotted paths. The resulting row order forms an information-exposure oracle for unexposed values, and reversing ascending and descending order confirms their relative ordering. Pairing sortBy with searchable or filterable columns and pagination can narrow the oracle toward specific values, but exact recovery depends on the application's available fields and data. This issue is fixed in version 0.27.1.

## Remediation

Refer to the linked advisories for vendor-supplied fixes and affected version ranges.

## Package advisory (CVE-2026-54529)

Affected packages:

- `sqladmin < 0.27.1`

Patched in:

- `sqladmin 0.27.1`

Source: https://osv.dev/vulnerability/GHSA-ccg5-9c8w-xh6v