Excellent overview, Chloe. I enjoyed reading this article. While I never read about ai-powered schema design, it sounds promising. Have you heard about data vaults? Daniel Lindstedt introduced it in 2000 and revisited it later (data vault 2.0). It's a schema model and a process that deals with several problems the good old star and snowflake still have. For example, it works excellent in an agile work environment, where requirements for the data change very quickly.

Have a great day!