kylinpy
Apache Kylin Python Client Library
What it is and what it does
kylinpy is a Python client library that provides a SQLAlchemy dialect for Apache Kylin, an OLAP engine. It allows Python applications to query Kylin clusters using standard SQL through a DSN connection string, supporting multiple Kylin versions (v1, v2, v4) and optional features like SSL, debug mode, and table pushdown. The library handles connection management and API communication with Kylin clusters.
The package is designed for teams running Apache Kylin or Kyligence Enterprise who need Python-based query access. It abstracts the HTTP API layer, letting you write SQL queries and integrate Kylin data into Python workflows without learning Kylin-specific APIs.
Use it for:
- Query Apache Kylin OLAP cubes from Python for data analysis and reporting.
- Configure BI platforms to connect to Kylin clusters via the SQLAlchemy dialect.
- Build Python pipelines that read pre-aggregated Kylin data for downstream processing.
- Enable SQL-based analytics on Kylin without writing custom HTTP client code.
Worth the install?
AI-flagged interpretation of the facts on this page — verify before relying
Python client library and SQLAlchemy dialect for querying Apache Kylin OLAP engines using SQL from Python applications and BI tools.
No. The project is abandoned with last release on 2020-08-11 and no commits since 2023-04-21. High install friction and undeclared dependencies create deployment risk. Unless maintaining legacy code on an older Python version with an existing Kylin cluster, the lack of recent maintenance makes this unsuitable for new projects. Investigate whether your Kylin deployment offers a newer, actively maintained client.
Install
kylinpy on PyPI
pip
pip install kylinpyuv
uv add kylinpypoetry
poetry add kylinpyInstalling kylinpy
Before you install
High install friction with no declared runtime dependencies in package metadata. Project is abandoned with last release on 2020-08-11 and no commits since 2023-04-21.
License in practice
MIT License (permissive) places no restrictions on use, modification, or distribution.
Quickstart
pip install kylinpy
import kylinpy
# Configure DSN: kylin://username:password@hostname:port/project?timeout=30&version=v1
Requires a running Apache Kylin or Kyligence Enterprise cluster; connection credentials and project name must be configured in the DSN.
Verify before relying
- What runtime dependencies kylinpy actually requires, given none are declared in package metadata.
- Current compatibility with modern Python versions and recent releases, given last release was 2020-08-11.
- Whether the package functions with current Apache Kylin versions or only legacy deployments.
- Why install friction is marked high despite no declared dependencies.
Package facts
| License | MIT License (permissive) |
| Python support | not specified |
| Install friction | high — source build required |
| Runtime dependencies | none |
| Maintenance | abandoned — 2,194 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 1,967,279/month — #3,403 on PyPI (30-day window, as of 2026-08-14) |
| Known vulnerabilities | none known (OSV.dev, checked 2026-08-14) |
Evidence: kylinpy-2.8.4.tar.gz
Keywords: apache kylin, kylin, kap, kyligence, kyligence enterprise, cli, sqlalchemy dialect
Tags
More Front-Ends packages
SQLAlchemy is a Python SQL toolkit and Object…
permissive · top 100 on PyPI
psycopg2-binarypsycopg2-binary is a PostgreSQL database…
copyleft · top 1,000 on PyPI
alembicAlembic generates and manages database schema…
permissive · top 1,000 on PyPI
weaviate-clientA Python client library for connecting to and…
permissive · top 1,000 on PyPI
databricks-sql-connectorA Python client library that connects to…
permissive · top 1,000 on PyPI
psycopgPsycopg 3 is a PostgreSQL database adapter for…
copyleft · top 1,000 on PyPI
apache-airflow-providers-apache-kylinIntegrates Apache Kylin OLAP analytics with…
permissive · top 15,000 on PyPI
sqlalchemy-solrProvides a SQLAlchemy dialect that allows you…
permissive · top 15,000 on PyPI
teradatasqlalchemyProvides a SQLAlchemy dialect that enables…
unclear · top 5,000 on PyPI
sqlalchemy-verticaProvides a SQLAlchemy dialect for Vertica,…
permissive · top 15,000 on PyPI
sqlalchemy-hanaProvides a SQLAlchemy dialect that enables you…
permissive · top 15,000 on PyPI
sqlalchemy-drillSQLAlchemy dialect for Apache Drill that…
permissive · top 5,000 on PyPI
sqlalchemy-databricksProvides a SQLAlchemy dialect that connects to…
permissive · top 15,000 on PyPI
sqlalchemy_exasolSQLAlchemy dialect that enables Python…
permissive · top 15,000 on PyPI
sqlalchemy-dremioProvides a SQLAlchemy dialect to query Dremio…
permissive · top 15,000 on PyPI
shillelaghShillelagh lets you query APIs, files,…
permissive · top 5,000 on PyPI