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

# pydoris — Python interface to Doris

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

## What it is and what it does

Pydoris bridges Python applications to Apache Doris, an MPP analytical database designed for sub-second query response times on large datasets. It provides a SQLAlchemy dialect that lets you connect using standard SQLAlchemy patterns—create_engine with a doris:// URL, then execute queries through the connection object. The package depends on sqlalchemy, sqlalchemy-utils, mysqlclient, and requests, making it a thin wrapper around Doris's wire protocol.

You use it when you need Python code to query Doris for reporting, ad-hoc analysis, or data lake acceleration. It's not an ORM layer but a database driver: you write SQL or use SQLAlchemy's text() construct to run queries and fetch results. The package requires Python 3.7 or later and is marked as production-stable.

Use it for:

- Connect a Python analytics or reporting application to Doris for real-time query execution.
- Build ETL pipelines that read from Doris using SQLAlchemy's connection and metadata introspection.
- Execute ad-hoc SQL queries against a Doris cluster from Python scripts or Jupyter notebooks.
- Integrate Doris as a backend for a data warehouse or data lake query layer in a larger Python service.

## Worth the install?

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

Pydoris is a Python client for Apache Doris that enables SQLAlchemy-based database connections and query execution against a Doris analytical database.

Yes. Pydoris is actively maintained, carries no known vulnerabilities, has low install friction, and is licensed permissively. Install it if you need to query Apache Doris from Python—it's the standard SQLAlchemy dialect for that purpose. No significant blockers.

## Install

pip install pydoris
uv add pydoris
poetry add pydoris

## Installing pydoris

Before you install: Low install friction with a pure-Python wheel distribution. The package is actively maintained with a recent release and carries a high star count on its repository, suggesting stable community adoption.

License in practice: Licensed under Apache 2.0 (permissive), which allows commercial use, modification, and distribution with minimal restrictions—suitable for most production and proprietary projects.

Quickstart:

pip install pydoris

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

Requires Python 3.7 or later; mysqlclient dependency may require system libraries for compilation on some platforms.

Verify before relying:

- Whether the package supports connection pooling or concurrent query execution patterns.
- Performance characteristics and query timeout behavior when working with large result sets.
- Whether SQLAlchemy ORM features (not just raw SQL) are fully supported through this dialect.

## Package facts

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

## Tags

apache doris python client, doris sqlalchemy connector, python doris database driver, doris analytics client, sqlalchemy doris integration, doris query interface python, analytical database python client, database-driver, sqlalchemy-dialect, analytics

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