---
id: pyathena
version: "3.35.4"
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)
license_treatment: permissive
maintenance: active
---

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

License: permissive · Maintenance: active · Popularity: top 1,000 on PyPI

## Install

pip install pyathena
uv add pyathena
poetry add pyathena

## Description

# PyAthena

<div align="center">

<img src="https://raw.githubusercontent.com/pyathena-dev/PyAthena/master/docs/_static/icon.png" alt="PyAthena logo" width="250">

[![PyPI - Version](https://badge.fury.io/py/pyathena.svg)](https://badge.fury.io/py/pyathena)
[![PyPI - Python Version](https://img.shields.io/pypi/pyversions/PyAthena.svg)](https://pypi.org/project/PyAthena/)
[![PyPI - Downloads](https://static.pepy.tech/badge/pyathena/month)](https://pepy.tech/project/pyathena)
[![CI - Test](https://github.com/pyathena-dev/PyAthena/actions/workflows/test.yaml/badge.svg)](https://github.com/pyathena-dev/PyAthena/actions/workflows/test.yaml)
[![CD - Docs](https://github.com/pyathena-dev/PyAthena/actions/workflows/docs.yaml/badge.svg)](https://github.com/pyathena-dev/PyAthena/actions/workflows/docs.yaml)
[![License - MIT](https://img.shields.io/pypi/l/PyAthena.svg)](https://github.com/pyathena-dev/PyAthena/blob/master/LICENSE)
[![linting - Ruff](https://img.shields.io/endpoint?url=https://raw.githubusercontent.com/astral-sh/ruff/main/assets/badge/v2.json)](https://github.com/astral-sh/ruff)
[![types -...

## AI interpretation — verify before relying

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.

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.

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