AI Reports · Amazon · 2026-10-20 · Blog / commentary
Build a semantic layer for agentic AI on AWS with Strategy Mosaic and Amazon Bedrock AgentCore

The third post in the semantic-layer series builds a customer 360 across Amazon Redshift and Amazon Aurora with Strategy Mosaic and exposes it to a Strands agent on Amazon Bedrock AgentCore through the Mosaic MCP server. Per-user row and column security is enforced end-to-end. Mosaic's dimensional semantic layer serves four native protocols from one definition: MCP for AI agents, JDBC/ODBC over Trino for SQL clients, XMLA for Power BI and Excel, and REST for custom applications.