genealogy-app/check_columns.py

import pymysql

DB_CONFIG = {
    "host": "rm-f8ze60yirdj8786u2.mysql.rds.aliyuncs.com",
    "port": 3306,
    "user": "root",
    "password": "csqz@20255",
    "db": "csqz-client",
    "charset": "utf8mb4",
    "cursorclass": pymysql.cursors.DictCursor
}

conn = pymysql.connect(**DB_CONFIG)
try:
    with conn.cursor() as cursor:
        cursor.execute("DESCRIBE family_member_info")
        columns = cursor.fetchall()
        for col in columns:
            print(f"{col['Field']} - {col['Type']}")
finally:
    conn.close()