Yes this is very much possible using an API. But this will require a lot of custom coded functionality on each of the sites.
Here’s a great example by @shawnsroden that shows how to expose your CMS database using the http-funtions API:
Here’s a video that will help you learn more about it: