skillfed

kylinpy

Apache Kylin Python Client Library

kylinpy v2.8.4 2.0M downloads/30d#3,403 on PyPI62
Permissive license MIT License Abandoned released

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 kylinpy

uv

uv add kylinpy

poetry

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 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

Environment :: ConsoleIntended Audience :: DevelopersLicense :: OSI Approved :: MIT LicenseOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 2.7Programming Language :: Python :: 3

Tags

apache kylin python clientkylin sqlalchemy dialectkylin olap querykylin sql connectorkyligence enterprise client
olapabandoned

More Front-Ends packages

SQLAlchemy

SQLAlchemy is a Python SQL toolkit and Object…

permissive · top 100 on PyPI

psycopg2-binary

psycopg2-binary is a PostgreSQL database…

copyleft · top 1,000 on PyPI

alembic

Alembic generates and manages database schema…

permissive · top 1,000 on PyPI

weaviate-client

A Python client library for connecting to and…

permissive · top 1,000 on PyPI

databricks-sql-connector

A Python client library that connects to…

permissive · top 1,000 on PyPI

psycopg

Psycopg 3 is a PostgreSQL database adapter for…

copyleft · top 1,000 on PyPI

apache-airflow-providers-apache-kylin

Integrates Apache Kylin OLAP analytics with…

permissive · top 15,000 on PyPI

sqlalchemy-solr

Provides a SQLAlchemy dialect that allows you…

permissive · top 15,000 on PyPI

teradatasqlalchemy

Provides a SQLAlchemy dialect that enables…

unclear · top 5,000 on PyPI

sqlalchemy-vertica

Provides a SQLAlchemy dialect for Vertica,…

permissive · top 15,000 on PyPI

sqlalchemy-hana

Provides a SQLAlchemy dialect that enables you…

permissive · top 15,000 on PyPI

sqlalchemy-drill

SQLAlchemy dialect for Apache Drill that…

permissive · top 5,000 on PyPI

sqlalchemy-databricks

Provides a SQLAlchemy dialect that connects to…

permissive · top 15,000 on PyPI

sqlalchemy_exasol

SQLAlchemy dialect that enables Python…

permissive · top 15,000 on PyPI

sqlalchemy-dremio

Provides a SQLAlchemy dialect to query Dremio…

permissive · top 15,000 on PyPI

shillelagh

Shillelagh lets you query APIs, files,…

permissive · top 5,000 on PyPI