PyAthena

Python DB API 2.0 (PEP 249) client for Amazon Athena

pyathena Permissive license Copyright 2017 laughingman7743 Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the… (full text in the JSON record) Active ★ 491 v3.35.4 released 2026-07-31

Install

pyathena on PyPI

pip

pip install pyathena

uv

uv add pyathena

poetry

poetry add pyathena

Package facts

License	Copyright 2017 laughingman7743 Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the… (full text in the JSON record) (permissive)
Python support	supports the current Python release (>=3.10)
Install friction	low — pure-Python wheel
Runtime dependencies	5 — boto3, botocore, fsspec, python-dateutil, tenacity
Maintenance	actively maintained — 13 days since the last release
Last repo commit	2026-08-11
First released	2017-05-20
Popularity	one of the top 1,000 most-downloaded packages on PyPI (30-day window, as of 2026-08-13)
Known vulnerabilities	none known (OSV.dev, checked 2026-08-13)

Evidence: pyathena-3.35.4-py3-none-any.whl

Development Status :: 4 - BetaIntended Audience :: DevelopersLicense :: OSI Approved :: MIT LicenseOperating System :: OS IndependentProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Topic :: Database :: Front-Ends

About PyAthena

from the package's own PyPI description — quoted content, verbatim

PyAthena

PyPI - Version (image) PyPI - Python Version (image) PyPI - Downloads (image) CI - Test (image) CD - Docs (image) License - MIT (image) linting - Ruff (image) [![types -...

Read as markdown · JSON record · Source repository · Docs

AI interpretation — verify before relying

AI-generated interpretation of the package facts above; every digit, version, license, or vulnerability id it cites is grounded in the facts already shown on this page

PyAthena is a DB API 2.0 client for Amazon Athena that lets you query data in S3 using SQL from Python, with support for both synchronous and asynchronous execution.

Installation is low-friction with a pure-wheel distribution and five well-maintained runtime dependencies (boto3, botocore, fsspec, python-dateutil, tenacity). The project is actively maintained with a recent release 13 days ago and ongoing repository activity.

MIT license permits unrestricted use, modification, and distribution with minimal restrictions—suitable for both open-source and commercial projects.

Usage

pip install PyAthena

from pyathena import connect

cursor = connect(s3_staging_dir="s3://YOUR_S3_BUCKET/path/to/",
                 region_name="us-west-2").cursor()
cursor.execute("SELECT * FROM one_row")
print(cursor.fetchall())

Requires Python 3.10 or later; AWS credentials must be configured for boto3 to authenticate with Amazon Athena.

Verdict: PyAthena is a well-maintained, actively developed DB API 2.0 client for Athena with low install friction, no known vulnerabilities, and permissive MIT licensing. It supports Python 3.10–3.14 and offers both sync and async interfaces, making it suitable for production use in AWS-integrated Python applications.

Needs verification

Whether boto3/botocore version constraints exist beyond what fsspec and tenacity impose.
Performance characteristics and query timeout behavior under high concurrency.
Compatibility with specific Athena workgroup configurations or result formats.

amazon athena python clientdb api 2.0 sql querys3 sql query pythonaws athena connectorasync sql query awspython database api athenasql on s3 python