import asyncio
from sqlalchemy.ext.asyncio import create_async_engine
from sqlalchemy import text

engine = create_async_engine('mysql+aiomysql://root:@localhost:3306/cems_db')

async def run():
    async with engine.begin() as conn:
        res = await conn.execute(text('DESCRIBE material_tb'))
        print([row[0] for row in res.fetchall()])

asyncio.run(run())