Build a semantic layer for agentic AI with EDB Postgres AI and Amazon Bedrock AgentCore

This post shows how to build a semantic layer for agentic AI using EDB Postgres AI's AIDB extension, where business meaning lives in Postgres COMMENT statements, join paths come from foreign keys, and governance uses GRANT and row-level security through the built-in MCP endpoint. A Strands Agents agent on Amazon Bedrock AgentCore queries the layer via AgentCore Gateway and an ALB to answer customer 360 questions, with two Postgres roles receiving different results for the same prompt based on column-level grants. AIDB also captures OpenTelemetry traces for each SQL execution as rows in the aidb_otel schema, queryable with ordinary SQL.