---
id: kylinpy
version: "2.8.4"
license: MIT License
license_treatment: permissive
maintenance: abandoned
---

# kylinpy — Apache Kylin Python Client Library

License: permissive · Maintenance: abandoned · Downloads: 2.0M/mo

## 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 above — 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

pip install kylinpy
uv add kylinpy
poetry add kylinpy

## Installing 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: unspecified
- Install friction: high
- Maintenance: abandoned
- Downloads: 2.0M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

apache kylin python client, kylin sqlalchemy dialect, kylin olap query, kylin sql connector, kyligence enterprise client, olap, abandoned

[View on SkillFed](https://skillfed.io/packages/kylinpy) · [View on PyPI](https://pypi.org/project/kylinpy/)