sqlalchemy-jdbcapi
Modern SQLAlchemy dialect for JDBC connections with native implementation
Decision gist · record as of 2026-08-14
Yes, with conditions. Install if you need JDBC or ODBC connectivity to one of the supported databases and want SQLAlchemy integration without manual driver management. The low install friction and permissive license are favorable. However, maintenance is aging (268 days since last release), and the description explicitly requests community testing feedback, indicating some dialects may not be production-hardened. Verify that your target database is actively used by the community before deploying to production.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Java Runtime Environment (JRE) 8 or later for JDBC connections; ODBC variant requires OS-installed ODBC driver.
- Python 3.10+ required.
- Low install friction with a pure-wheel distribution.
License · maintenance · safety
Apache-2.0 (permissive) — Licensed under Apache License 2.0 (permissive), which allows commercial and private use with minimal restrictions. No notable licensing constraints for typical adoption.
last release 2025-11-19 (268 days) · last repo commit 2025-11-26 · 27 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 218,280 downloads/mo, #9,341 on PyPI
Alternatives
Verify before relying
pip install sqlalchemy-jdbcapi
from sqlalchemy import create_engine, text
engine = create_engine('jdbcapi+postgresql://user:password@localhost/mydb')
with engine.connect() as conn:
result = conn.execute(text("SELECT * FROM users"))
for row in result:
print(row)- Extent of real-world testing coverage across all 18 database dialects—description notes reliance on community feedback for database support.
- Performance characteristics and connection pooling behavior under production load with HikariCP.
- Stability and maturity of asyncio support for Core and ORM operations.
What it is and what it does
SQLAlchemy JDBC/ODBC API is a SQLAlchemy dialect that bridges Python to JDBC and ODBC database connections, enabling access to PostgreSQL, Oracle, MySQL, MariaDB, SQL Server, DB2, SQLite, OceanBase, GBase 8s, IBM iSeries, MS Access, and Apache Phoenix. It handles automatic JDBC driver download from Maven Central, eliminating manual driver setup for JDBC connections, while also supporting native ODBC for systems where a JVM is unavailable. The package integrates fully with SQLAlchemy's ORM, reflection, and Alembic migration tools, and includes asyncio support for async/await workflows and HikariCP connection pooling for high-performance scenarios.
The package targets developers who need to connect Python applications to enterprise or specialized databases via JDBC or ODBC without managing driver downloads manually. It requires Java 8+ for JDBC use and Python 3.10+, and provides type hints throughout. The maintainer explicitly notes that community feedback is essential for improving support across all databases, suggesting that some dialects may have less mature testing than others.
Use it for
- Connect a Python application to Oracle or SQL Server databases via JDBC without manual driver installation.
- Use SQLAlchemy ORM and query reflection against PostgreSQL, MySQL, or MariaDB through JDBC.
- Migrate database schemas with Alembic across multiple database backends supported by the dialect.
- Build async database applications using asyncio with Core or ORM operations.
- Access specialized databases like OceanBase, GBase 8s, or Apache Phoenix from Python.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, with conditions.
Install if you need JDBC or ODBC connectivity to one of the supported databases and want SQLAlchemy integration without manual driver management. The low install friction and permissive license are favorable. However, maintenance is aging (268 days since last release), and the description explicitly requests community testing feedback, indicating some dialects may not be production-hardened. Verify that your target database is actively used by the community before deploying to production.
Install
sqlalchemy-jdbcapi on PyPI
Before you install
Low install friction with a pure-wheel distribution. Maintenance status is aging—last release was 268 days ago—but the repository remains active with recent commits and no archived status. Depends on sqlalchemy and JPype1, both established packages.
Requires Java Runtime Environment (JRE) 8 or later for JDBC connections; ODBC variant requires OS-installed ODBC driver. Python 3.10+ required.
License in practice
Licensed under Apache License 2.0 (permissive), which allows commercial and private use with minimal restrictions. No notable licensing constraints for typical adoption.
Quickstart
pip install sqlalchemy-jdbcapi
from sqlalchemy import create_engine, text
engine = create_engine('jdbcapi+postgresql://user:password@localhost/mydb')
with engine.connect() as conn:
result = conn.execute(text("SELECT * FROM users"))
for row in result:
print(row)Verify before relying
- Extent of real-world testing coverage across all 18 database dialects—description notes reliance on community feedback for database support.
- Performance characteristics and connection pooling behavior under production load with HikariCP.
- Stability and maturity of asyncio support for Core and ORM operations.
Package facts
| License | Apache-2.0 permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 2 packagessqlalchemyJPype1 |
| Maintenance | Aging 268 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 218,280 / month, #9,341 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 :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: Implementation :: CPythonTopic :: DatabaseTopic :: Database :: Front-EndsTopic :: Software Development :: Libraries :: Python ModulesTyping :: Typed |
Evidence: sqlalchemy_jdbcapi-2.2.1-py3-none-any.whl
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 › “sqlalchemy jdbc dialect”
- sqlalchemy-jdbcapiSQLAlchemy dialect for JDBC and ODBC database connections with…
- sqlalchemy-drillSQLAlchemy dialect for Apache Drill that enables SQL queries against…
- pyathenajdbcPyAthenaJDBC wraps the Amazon Athena JDBC driver to provide a Python…
Give your agent the search over MCP, or paste the wish link into any chat.
More Python Modules packages
Converts domain names between Unicode and ASCII-compatible encoding (Punycode) according to IDNA 2008 and Unicode Technical Standard 46, with security validation and broader script coverage than the standard library.
Install it if you work with internationalized domain names, need to validate domains, or use HTTP clients that depend on it transitively.
Setuptools is a Python build backend and package management tool that handles building, distributing, and installing Python packages, including support for C/C++ extension modules.
PyYAML parses and emits YAML 1.1 data format, enabling serialization and deserialization of configuration files and Python objects to and from human-readable YAML text.
Pydantic validates Python data structures against type hints, coercing and checking input at runtime to ensure it matches a declared schema.
Provides reusable metadata objects for use with PEP-593 `typing.Annotated` to express common constraints like bounds, collection sizes, and predicates on types.
Install it if you use or build libraries that need to express type constraints in a standardized, inspectable way—or if you want to annotate your own types with…
Provides runtime tools to inspect and introspect Python type annotations, enabling programmatic examination of type hints at execution time.
See also django-db-connection-pool · sqlalchemy-cockroachdb · sqlalchemy-drill · sqlalchemy_exasol · sqlalchemy-ibmi · SQLAlchemy-JSONField · sqlalchemy-pgspider · duckdb-engine · sqlalchemy-risingwave · ibm-db-sa