CyMySQL

What’s CyMySQL

This package contains a python MySQL client library.

It is a fork project from PyMySQL https://pymysql.readthedocs.io/en/latest/.

CyMySQL is accerarated by Cython.

Documentation on the MySQL client/server protocol can be found here: http://dev.mysql.com/doc/internals/en/client-server-protocol.html

Requirements

Python 3.10+
MySQL 5.7 or higher, MariaDB

Installation

With cythonize

$ pip install cymysql

Or without cythonize

$ NO_CYTHON=1 pip install cymysql

Example

Python Database API Specification v2.0

https://peps.python.org/pep-0249/

import cymysql
conn = cymysql.connect(host='127.0.0.1', user='root', passwd='', db='database_name')
cur = conn.cursor()
cur.execute('select foo, bar from baz')
for r in cur.fetchall():
   print(r[0], r[1])

asyncio

You can use asyncio to write the following.

Use connect

import asyncio
import cymysql

async def conn_example():
    conn = await cymysql.aio.connect(
        host="127.0.0.1",
        user="root",
        passwd="",
        db="database_name",
    )
    cur = conn.cursor()
    await cur.execute("SELECT 42")
    print(await cur.fetchall())
asyncio.run(conn_example())

Use pool

import asyncio
import cymysql

async def pool_example(loop):
    pool = await cymysql.aio.create_pool(
        host="127.0.0.1",
        user="root",
        passwd="",
        db="database_name",
        loop=loop,
    )
    async with pool.acquire() as conn:
        async with conn.cursor() as cur:
            await cur.execute("SELECT 42")
            print(await cur.fetchall())
    pool.close()
    await pool.wait_closed()

loop = asyncio.get_event_loop()
loop.run_until_complete(pool_example(loop))
loop.close()

Metadata

Release files for CyMySQL 1.1.2

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for CyMySQL 1.1.2
File	Size	Uploaded
cymysql-1.1.2.tar.gz	51.9 kB	Sep 19, 2026	Details

Release files / cymysql-1.1.2.tar.gz

Download URL	cymysql-1.1.2.tar.gz
Size	51.9 kB
Tags	Source
SHA-256 checksum How to use checksums	`d21625dd6a52501f33880760d5a96f1997c30b4103ef3859593f4d4cab501ee4`
BLAKE2b-256 checksum How to use checksums	`fc0dbc84a2efac5c14ae444cb4276e7e060ed7c419596b92fbed237f1d2acd5a`
Upload date	Sep 19, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/7.0.0 CPython/3.14.4`