title: How to use SQLAlchemy to seamlessly access multiple databases?
body: <p>Lets say I created a product database system for different departments of my company. Each department has its own PostgreSQL-databse-instance for various reasons. The schemata of the databases are the same, however the data in them is not. For each of these systems a Python application exists that does some business logic (irrelevant). Each Python app accesses its and only its databases through SQLAlchemy.</p>
  
  <p>I want to create a Supervisior-System that can access all data in all of these databases (readthrough functionality). </p>
  
  <p>Here is an example of what I think about:
  <img src="https://i.stack.imgur.com/HtQRV.png" alt="enter image description here"></p>
  
  <p>Can I do that with SQLAlchemy? If so, what is the best approach for that kind of problem?</p>