How can I directly read information from a MySQL database?

[bbzcx]

Directly obtaining data from the database is more convenient than CSV files. Beneficial for later data analysis. But I tried many methods, but there was no way. Maybe it's due to Pandas restrictions.

[longxiaofei]

1. use latest pre-release pygwalker:

   pip install --upgrade --pre pygwalker

2. install extra database client

   pip install pymysql

example:

from pygwalker.data_parsers.database_parser import Connector
import pygwalker as pyg
 
conn = Connector(
    "mysql+pymysql://username:password@host/database/schema",
    """
        SELECT
            *
        FROM
            XXX
    """
)

pyg.walk(conn)

more detail refer it: https://pygwalker-docs.vercel.app/api-reference/dataset