---
id: pydoris-custom
version: "1.1.0"
license: Apache 2.0
license_treatment: permissive
maintenance: active
---

# pydoris-custom — Python interface to Doris (custom build with relaxed dependencies)

License: permissive · Maintenance: active · Downloads: 216.3K/mo

## What it is and what it does

This is a Python driver for Apache Doris, a real-time analytical database designed for fast queries on large datasets. It wraps the Doris client protocol and exposes it through SQLAlchemy, so you can use standard SQLAlchemy patterns to connect, query, and fetch results. The package depends on sqlalchemy for ORM/query building, mysqlclient for the underlying protocol connection, and requests for HTTP communication.

The custom build removes sqlalchemy-utils, which the original package included but never actually used, making the install lighter. It supports Python 3.7 through 3.11 and is marked production-stable. The package is actively maintained and has no known security vulnerabilities.

Use it for:

- Running analytical queries on Doris from a Python application using SQLAlchemy's query API
- Building data pipelines that read from Doris and transform results in Python
- Connecting a web framework (Django, Flask) to a Doris backend for reporting or dashboards
- Prototyping analytics code against a Doris cluster before deploying to production
- Integrating Doris queries into Python data science workflows alongside pandas or numpy

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

A Python client for Apache Doris that provides SQLAlchemy integration to query a high-performance analytical database with sub-second response times on large datasets.

Yes, if you need to query Apache Doris from Python. The package is production-stable, actively maintained, has no vulnerabilities, and low install friction. The custom build removes unnecessary bloat. The only caveat is that mysqlclient may require system libraries on some platforms, but that is a one-time setup cost.

## Install

pip install pydoris-custom
uv add pydoris-custom
poetry add pydoris-custom

## Installing pydoris-custom

Before you install: Low friction install with three stable runtime dependencies (sqlalchemy, mysqlclient, requests). The package is actively maintained with recent commits and marked production-stable. The custom build removes an unused dependency, reducing bloat.

License in practice: Apache 2.0 is permissive; you can use this package in commercial and proprietary projects with minimal restrictions, provided you include a copy of the license.

Quickstart:

pip install pydoris-custom

from sqlalchemy import create_engine, text

engine = create_engine('doris://root:password@localhost:9030/catalog.database')
connection = engine.connect()
rows = connection.execute(text('SELECT * FROM table')).fetchall()

mysqlclient requires MySQL development headers; on some systems you may need to install libmysqlclient-dev or equivalent before pip install succeeds.

Verify before relying:

- Whether mysqlclient requires system-level MySQL development libraries on your platform
- Performance characteristics and query latency on datasets of different scales
- Compatibility with specific Doris versions beyond what the README documents

## Package facts

- License: Apache 2.0 (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 216.3K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

apache doris python client, doris sqlalchemy connector, python doris database driver, doris mpp analytics client, sqlalchemy doris integration, doris query python, real-time analytics database python, database-driver, sqlalchemy-dialect, analytics

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