[Python] SQLAlchemy: Get the database name from connection

Discussão em 'Python' iniciado por Stack, Junho 23, 2025.

  1. Stack

    Stack Membro Participativo

    I wonder if it is possible to get the database name after a connection. I known that it is possible with the engine created by the function 'create_engine' (here) and I would like to have the same possibility after a connection.

    from sqlalchemy import create_engine, inspect
    engine = create_engine('mysql+mysqldb://login:pass@localhost/MyDatabase')
    print (engine.url.database) # print the dabase name with an engine
    con = engine.connect()


    I looked at the inspector tool, but there is no way to retrieve the database name like:

    db_name = inspect(con.get_database_name() )


    May be it is not possible. Any idea ?

    Thanks a lot!

    Continue reading...

Compartilhe esta Página