aio-libs/aiomysql

Health v2 · maintenance only

Adoption not part of the score

1896 stars · 272 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

aiomysql is an asyncio-based Python driver for accessing MySQL and MariaDB databases, built on top of PyMySQL with its I/O calls converted to async. It also offers optional SQLAlchemy integration ported from aiopg, preserving a familiar API for aiopg users.

Use cases

• query MySQL from an asyncio Python application
• connect to MariaDB asynchronously
• use SQLAlchemy core with async MySQL connections
• pool async MySQL connections in a web app
• migrate aiopg-style code to MySQL
• run async database queries with cursors in Python

When to choose

• you need async MySQL/MariaDB access in an asyncio codebase
• you want a PyMySQL-compatible API with await support
• you want SQLAlchemy integration similar to aiopg

When to avoid

• you use synchronous code or another framework without asyncio
• you need a different database like PostgreSQL (use aiopg or asyncpg)
• you need an ORM with full async model support (consider SQLAlchemy 2.0 async or Tortoise ORM)

Facets

library · maturity active

database-driver database orm databases backend developer-tools python cross-platform asyncio mysql mariadb pymysql sqlalchemy connection-pooling

Member repositories

For agents

markdown · JSON · MCP: product_card(name="aio-libs/aiomysql")