Home icon

Design responsible AI controls for Amazon Aurora PostgreSQL

Machine Learning Blog



This article demonstrates how to design responsible AI controls for a customer support chatbot built on Amazon Aurora PostgreSQL using Retrieval Augmented Generation (RAG) with pgvector embeddings and Aurora ML.

  • Maps eight AWS Responsible AI dimensions (Fairness, Explainability, Privacy, Safety, Controllability, Veracity, Governance, Transparency) to Aurora PostgreSQL capabilities
  • Implements Explainability in depth through comprehensive interaction logging: retrieved chunk IDs, similarity scores, cited sources, and guardrail traces
  • Uses Aurora ML to generate vector embeddings directly from SQL without data movement or custom ETL pipelines
  • Enforces tenant isolation with Row-Level Security and redacts PII before embedding using Amazon Bedrock Guardrails
  • Provides database schema design with chat_interactions table capturing full RAG provenance for audit trails
  • Includes pgaudit and pg_cron for governance, audit logging, and automated 90-day retention with S3 archival
  • Demonstrates contextual grounding with Bedrock Guardrails to verify responses are supported by retrieved sources

The design patterns enable queryable audit trails at the database layer, distinguishing cited from retrieved sources to make AI responses fully explainable and traceable.



Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Nov 16
2026
PostgreSQL large objects: Best practices for Amazon Aurora and RDS
Sep 1
2026
SQL Server to Aurora PostgreSQL conversion with AI agents for AWS DMS
Nov 17
2026
Build an AI-powered DBA assistant for Amazon Aurora and Amazon RDS with Kiro
Nov 17
2026
Fine-tune SQL Server to Aurora PostgreSQL conversions with AWS Transform and Kiro

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.