# aiomysql > MySQL driver for asyncio. - **URL**: https://www.freshcrate.ai/projects/aiomysql - **Author**: pypi - **Category**: Databases - **Latest version**: `0.3.2` (2026-04-21) - **License**: Unknown - **Source**: https://github.com/aio-libs/aiomysql/actions - **Homepage**: https://pypi.org/project/aiomysql/ - **Language**: Python - **GitHub**: 1,888 stars, 262 forks - **Registry**: pypi (`aiomysql`) - **Tags**: `aiomysql`, `asyncio`, `mariadb`, `mysql`, `pypi` ## Description aiomysql ======== .. image:: https://github.com/aio-libs/aiomysql/actions/workflows/ci-cd.yml/badge.svg?branch=main :target: https://github.com/aio-libs/aiomysql/actions/workflows/ci-cd.yml .. image:: https://codecov.io/gh/aio-libs/aiomysql/branch/main/graph/badge.svg :target: https://codecov.io/gh/aio-libs/aiomysql :alt: Code coverage .. image:: https://badge.fury.io/py/aiomysql.svg :target: https://badge.fury.io/py/aiomysql :alt: Latest Version .. image:: https://readthedocs.org/projects/aiomysql/badge/?version=latest :target: https://aiomysql.readthedocs.io/ :alt: Documentation Status .. image:: https://badges.gitter.im/Join%20Chat.svg :target: https://gitter.im/aio-libs/Lobby :alt: Chat on Gitter **aiomysql** is a "driver" for accessing a `MySQL` database from the asyncio_ (PEP-3156/tulip) framework. It depends on and reuses most parts of PyMySQL_ . *aiomysql* tries to be like awesome aiopg_ library and preserve same api, look and feel. Internally **aiomysql** is copy of PyMySQL, underlying io calls switched to async, basically ``yield from`` and ``asyncio.coroutine`` added in proper places)). `sqlalchemy` support ported from aiopg_. Documentation ------------- https://aiomysql.readthedocs.io/ Basic Example ------------- **aiomysql** based on PyMySQL_ , and provides same api, you just need to use ``await conn.f()`` or ``yield from conn.f()`` instead of calling ``conn.f()`` for every method. Properties are unchanged, so ``conn.prop`` is correct as well as ``conn.prop = val``. .. code:: python import asyncio import aiomysql async def test_example(): async with aiomysql.create_pool(host='127.0.0.1', port=3306, user='root', password='', db='mysql') as pool: async with pool.acquire() as conn: async with conn.cursor() as cur: await cur.execute("SELECT 42;") print(cur.description) (r,) = await cur.fetchone() assert r == 42 asyncio.run(test_example()) Example of SQLAlchemy optional integration ------------------------------------------ Sqlalchemy support has been ported from aiopg_ so api should be very familiar for aiopg_ user.: .. code:: python import asyncio import sqlalchemy as sa from aiomysql.sa import create_engine metadata = sa.MetaData() tbl = sa.Table('tbl', metadata, sa.Column('id', sa.Integer, primary_key=True), sa.Column('val', sa.String(255))) async def go(): engine = await create_engine(user='root', db='test_pymysql', host='127.0.0.1', password='') async with engine.acquire() as conn: await conn.execute(tbl.insert().values(val='abc')) await conn.execute(tbl.insert().values(val='xyz')) async for row in conn.execute(tbl.select()): print(row.id, row.val) engine.close() await engine.wait_closed() asyncio.run(go()) Requirements ------------ * Python_ 3.9+ * PyMySQL_ .. _Python: https://www.python.org .. _asyncio: http://docs.python.org/3.5/library/asyncio.html .. _aiopg: https://github.com/aio-libs/aiopg .. _PyMySQL: https://github.com/PyMySQL/PyMySQL .. _Tornado-MySQL: https://github.com/PyMySQL/Tornado-MySQL ## Recent releases | Version | Date | Urgency | Changes | | --- | --- | --- | --- | | `0.3.2` | 2026-04-21 | Low | Imported from PyPI (0.3.2) | | `v0.3.2` | 2025-10-22 | Low | Changes ------- 0.3.2 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix not persisting GitHub credentials during Git checkout action in CI for publishing release tags #1047 0.3.1 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix permissions in GitHub Actions workflow to allow pushing git tag after release #1046 0.3.0 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Drop support for Python 3.7 and 3.8, replaced by 3.12 and 3.13 #1026 * Bump minimum Sphinx version to generate documentation to 6.2.0 for Python 3.13 support #1026 | | `v0.3.2` | 2025-10-22 | Low | Changes ------- 0.3.2 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix not persisting GitHub credentials during Git checkout action in CI for publishing release tags #1047 0.3.1 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix permissions in GitHub Actions workflow to allow pushing git tag after release #1046 0.3.0 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Drop support for Python 3.7 and 3.8, replaced by 3.12 and 3.13 #1026 * Bump minimum Sphinx version to generate documentation to 6.2.0 for Python 3.13 support #1026 | | `v0.3.2` | 2025-10-22 | Low | Changes ------- 0.3.2 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix not persisting GitHub credentials during Git checkout action in CI for publishing release tags #1047 0.3.1 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix permissions in GitHub Actions workflow to allow pushing git tag after release #1046 0.3.0 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Drop support for Python 3.7 and 3.8, replaced by 3.12 and 3.13 #1026 * Bump minimum Sphinx version to generate documentation to 6.2.0 for Python 3.13 support #1026 | | `v0.3.2` | 2025-10-22 | Low | Changes ------- 0.3.2 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix not persisting GitHub credentials during Git checkout action in CI for publishing release tags #1047 0.3.1 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix permissions in GitHub Actions workflow to allow pushing git tag after release #1046 0.3.0 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Drop support for Python 3.7 and 3.8, replaced by 3.12 and 3.13 #1026 * Bump minimum Sphinx version to generate documentation to 6.2.0 for Python 3.13 support #1026 | | `v0.3.2` | 2025-10-22 | Low | Changes ------- 0.3.2 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix not persisting GitHub credentials during Git checkout action in CI for publishing release tags #1047 0.3.1 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix permissions in GitHub Actions workflow to allow pushing git tag after release #1046 0.3.0 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Drop support for Python 3.7 and 3.8, replaced by 3.12 and 3.13 #1026 * Bump minimum Sphinx version to generate documentation to 6.2.0 for Python 3.13 support #1026 | | `v0.3.2` | 2025-10-22 | Low | Changes ------- 0.3.2 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix not persisting GitHub credentials during Git checkout action in CI for publishing release tags #1047 0.3.1 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix permissions in GitHub Actions workflow to allow pushing git tag after release #1046 0.3.0 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Drop support for Python 3.7 and 3.8, replaced by 3.12 and 3.13 #1026 * Bump minimum Sphinx version to generate documentation to 6.2.0 for Python 3.13 support #1026 | | `v0.3.2` | 2025-10-22 | Low | Changes ------- 0.3.2 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix not persisting GitHub credentials during Git checkout action in CI for publishing release tags #1047 0.3.1 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix permissions in GitHub Actions workflow to allow pushing git tag after release #1046 0.3.0 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Drop support for Python 3.7 and 3.8, replaced by 3.12 and 3.13 #1026 * Bump minimum Sphinx version to generate documentation to 6.2.0 for Python 3.13 support #1026 | | `v0.3.2` | 2025-10-22 | Low | Changes ------- 0.3.2 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix not persisting GitHub credentials during Git checkout action in CI for publishing release tags #1047 0.3.1 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix permissions in GitHub Actions workflow to allow pushing git tag after release #1046 0.3.0 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Drop support for Python 3.7 and 3.8, replaced by 3.12 and 3.13 #1026 * Bump minimum Sphinx version to generate documentation to 6.2.0 for Python 3.13 support #1026 | | `v0.3.2` | 2025-10-22 | Low | Changes ------- 0.3.2 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix not persisting GitHub credentials during Git checkout action in CI for publishing release tags #1047 0.3.1 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Fix permissions in GitHub Actions workflow to allow pushing git tag after release #1046 0.3.0 (2025-10-21) ^^^^^^^^^^^^^^^^^^ * Drop support for Python 3.7 and 3.8, replaced by 3.12 and 3.13 #1026 * Bump minimum Sphinx version to generate documentation to 6.2.0 for Python 3.13 support #1026 | ## Citation - HTML: https://www.freshcrate.ai/projects/aiomysql - Markdown: https://www.freshcrate.ai/projects/aiomysql.md - Dependencies JSON: https://www.freshcrate.ai/api/projects/aiomysql/deps _Generated by freshcrate.ai. Indexes pypi releases for AI-agent ecosystem packages._