You can use the SQLAlchemy library to connect to your database and retrieve information about tables, columns, and relationships.

Then, you can use Graphviz or another graph visualization library to create a visual representation of your database schema.

from sqlalchemy import create_engine, MetaData, Table
from sqlalchemy_schemadisplay import create_schema_graph
from graphviz import Source

# Create a SQLAlchemy engine and metadata object
engine = create_engine('mysql://username:password@localhost/LibraryDB')

# Create a MetaData object
metadata = MetaData()

# Reflect the database schema and bind it to the engine
metadata.reflect(bind=engine)

# Now you can access tables and their information
books_table = metadata.tables['books']
members_table = metadata.tables['members']
book_loans_table = metadata.tables['bookloans']

# You can perform operations on these tables, e.g., print columns
for column in books_table.c:
    print(column.name, column.type)

# Don't forget to close the database connection when done
engine.dispose()

# Create a graph of the database schema
graph = create_schema_graph(metadata=metadata, show_datatypes=True)

# Render the graph to a file (e.g., PDF)
graph.write_pdf('database_schema.pdf')