pyhdb
SAP HANA Database Client for Python
Decision gist · record as of 2026-08-14
No. The package is abandoned (last updated 2018-02-16, repository archived) and targets obsolete Python versions. It will not run on current Python without porting. If you are locked into legacy Python or maintaining legacy code, it may work, but for any new project or modern environment, seek a maintained SAP HANA client library.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires a running SAP HANA database instance accessible at the specified host and port.
- Package targets Python 2.6, 2.7, 3.3, 3.4 and will not run on later versions.
- High install friction: the package is abandoned (last commit 2021-05-04, archived repository) and has not been updated since 2018-02-16.
License · maintenance · safety
Apache License Version 2.0 (permissive) — Licensed under Apache License Version 2.0 (permissive), allowing commercial and private use with minimal restrictions. No licensing barrier to adoption, but the abandoned status is a more pressing concern than the license terms.
last release 2018-02-16 (3101 days) · last repo commit 2021-05-04 · 318 stars · archived
0 known vulnerabilities (OSV.dev, 2026-08-14) · 76,115 downloads/mo, #14,654 on PyPI
Alternatives
Verify before relying
pip install pyhdb
import pyhdb
connection = pyhdb.connect(
host="example.com",
port=30015,
user="user",
password="secret"
)
cursor = connection.cursor()
cursor.execute("SELECT 'Hello Python World' FROM DUMMY")
print(cursor.fetchone())
connection.close()- Whether the codebase can be successfully installed and run on modern Python versions without modification.
- Current state of compatibility with modern SAP HANA server versions and protocol changes since 2018.
- Whether any community forks or maintained alternatives exist for current Python environments.
What it is and what it does
pyhdb is a pure Python client for SAP HANA databases that implements the DBAPI Specification v2.0 (PEP 249). It allows Python applications to connect to a HANA server, execute SQL queries, and retrieve results through a standard cursor interface. The package supports basic authentication, DDL and DML operations, transaction control via commit and rollback, and LOB (Large Object) handling for binary and text data with lazy loading.
The package is no longer maintained: the repository was archived and the last release was 2018-02-16. It targets Python 2.7, 3.3, 3.4, 3.5, which are now end-of-life. While it has no external runtime dependencies and remains available on PyPI, using it in production requires either running on a legacy Python version or undertaking significant porting work.
Use it for
- Connect a Python application to an existing SAP HANA database for data retrieval and reporting.
- Execute parameterized SQL queries and fetch results using the standard DBAPI cursor interface.
- Handle large text or binary data (LOBs) stored in HANA with file-like read/seek operations.
- Call stored procedures in SAP HANA with scalar input and output parameters.
- Manage transactions across multiple cursor operations on the same connection.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
No.
The package is abandoned (last updated 2018-02-16, repository archived) and targets obsolete Python versions. It will not run on current Python without porting. If you are locked into legacy Python or maintaining legacy code, it may work, but for any new project or modern environment, seek a maintained SAP HANA client library.
Install
pyhdb on PyPI
Before you install
High install friction: the package is abandoned (last commit 2021-05-04, archived repository) and has not been updated since 2018-02-16. No runtime dependencies, but the codebase targets obsolete Python versions and will not function on modern Python without significant porting work.
Requires a running SAP HANA database instance accessible at the specified host and port. Package targets Python 2.6, 2.7, 3.3, 3.4 and will not run on later versions.
License in practice
Licensed under Apache License Version 2.0 (permissive), allowing commercial and private use with minimal restrictions. No licensing barrier to adoption, but the abandoned status is a more pressing concern than the license terms.
Quickstart
pip install pyhdb
import pyhdb
connection = pyhdb.connect(
host="example.com",
port=30015,
user="user",
password="secret"
)
cursor = connection.cursor()
cursor.execute("SELECT 'Hello Python World' FROM DUMMY")
print(cursor.fetchone())
connection.close()
Verify before relying
- Whether the codebase can be successfully installed and run on modern Python versions without modification.
- Current state of compatibility with modern SAP HANA server versions and protocol changes since 2018.
- Whether any community forks or maintained alternatives exist for current Python environments.
Package facts
| License | Apache License Version 2.0 permissive |
| Python support | Not specified |
| Install friction | High. Source build required |
| Runtime dependencies | None |
| Maintenance | Abandoned 3,101 days since the last release |
| Last repo commit | repository archived |
| First released | |
| Downloads | 76,115 / month, #14,654 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 4 - BetaIntended Audience :: DevelopersLicense :: OSI Approved :: Apache Software LicenseOperating System :: OS IndependentProgramming Language :: Python :: 2.6Programming Language :: Python :: 2.7Programming Language :: Python :: 3.3Programming Language :: Python :: 3.4Programming Language :: Python :: Implementation :: PyPyProgramming Language :: SQLTopic :: DatabaseTopic :: Database :: Front-EndsTopic :: Software DevelopmentTopic :: Software Development :: Libraries :: Python Modules |
Evidence: pyhdb-0.3.4.tar.gz
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “HANA SQL connection Python”
- pyhdbA pure Python client library for connecting to and querying SAP HANA…
- sqlalchemy-hanaProvides a SQLAlchemy dialect that enables you to use SAP HANA as a…
- hdbcliA PEP 249-compliant Python database driver for connecting to and…
Give your agent the search over MCP, or paste the wish link into any chat.
More Software Development packages
Provides backported and experimental type hints for Python 3.9+, allowing use of newer typing features on older Python versions and enabling early experimentation with type system PEPs before they enter the standard library.
NumPy provides an N-dimensional array object and a comprehensive suite of mathematical, linear algebra, Fourier transform, and random number functions for scientific computing in Python.
FastAPI is a Python web framework for building REST APIs using type hints, with automatic request validation, serialization, and interactive API documentation.
Provides a way to document function parameters, class attributes, return types, and variables inline using Python's `Annotated` type hint syntax instead of traditional docstrings.
Typer builds command-line applications from Python functions using type hints, automatically generating help text, argument parsing, and shell completion.
Install it if you are building CLIs in Python.
Distlib provides low-level packaging utilities for building, distributing, and managing Python software—including metadata handling, version specifiers, wheel support, script installation, and dependency resolution.
See also hdbcli · ydb-dbapi · pydynamodb · hana-ml · sqlalchemy-hana · dbapi · databricks-dbapi · intersystems-irispython · pyodata · impyla