创建

登录 ReadmeX

或

了解我们如何处理你的信息: 隐私政策

ReadmeX

陪你读懂 AI 动态

今天,想先了解什么?

选一份动态总结,或直接聊聊你的问题。

社区和关注动态总结只属于你自己。

资讯

用 EDB Postgres AI 构建智能体语义层

AI 总结

AWS Machine Learning Blog 教程介绍如何通过 EDB Postgres AI 创建语义层,并利用内置 MCP 端点和 Amazon Bedrock AgentCore Gateway 将其开放给外部智能体。示例在 Amazon Bedrock AgentCore 上运行 Strands Agents 智能体以回答客户 360 问题,同时由 PostgreSQL 授权和行级安全策略决定各调用者可访问的数据。指南还说明如何把 SQL 执行的 OpenTelemetry 追踪记录存入 aidb_otel 模式。

深度见解

该教程展示了一套统一架构,可让智能体在查询实时运营数据时结合数据库内业务语义、访问控制、身份传递和审计记录。

In this post, we show how to build a semantic layer for agentic AI using EDB Postgres AI. We run a Strands Agents agent on Amazon Bedrock AgentCore that queries the layer to answer customer 360 (C360) questions. Earlier posts in this series built the same C360 pattern with Stardog’s knowledge graph, Denodo’s data virtualization platform, AtScale’s dimensional model, and Strategy Mosaic’s linked models.

EDB Postgres AI puts the semantic layer inside the operational Postgres database as an AIDB extension. Business meaning lives next to the data in standard Postgres COMMENT statements, the join graph comes from Postgres foreign keys, and governance uses Postgres GRANT and row-level security through the Model Context Protocol (MCP) endpoint that ships with AIDB.

By the end of this post you will know:

  • How to build an AIDB semantic knowledge base (SemKB) over a Postgres schema, how COMMENT ON statements and aidb.create_semantic_alias behave as the authoring surface, and how foreign keys crawl into join paths.
  • How to expose the AIDB tool catalog to an external agent through the built-in EDB MCP endpoint, fronted by an Application Load Balancer (ALB) and registered as an MCP target on AgentCore Gateway, a capability of Amazon Bedrock AgentCore.
  • How Postgres roles, column-level GRANT statements, and row-level security produce different results for different callers. The prompt, tool catalog, and agent code stay the same.
  • How AIDB captures OpenTelemetry traces for every SQL execution as rows in the aidb_otel schema, queryable with ordinary SQL.

#EDB Postgres AI#Amazon Bedrock AgentCore#Strands Agents#Claude#EDB MCP endpoint#AgentCore Gateway#AgentCore Identity#Amazon Cognito#Application Load Balancer#PostgreSQL

原文约 18 分钟读完阅读原文
群聊

还没有评论,来说说你的看法。