Connecting PostgreSQL to Amazon Q Business

PostgreSQL is an open source database management system. You can connect your PostgreSQL instance to Amazon Q Business—using either the AWS Management Console, CLI, or the CreateDataSource API—and create an Amazon Q web experience.

The Amazon Q PostgreSQL data source connector supports PostgreSQL 9.6.

Important

As a best practice, provide Amazon Q with read-only database credentials. Also, avoid adding tables with sensitive data or personal identifiable information (PII).

Learn more

• For an overview of the Amazon Q web experience creation process, see Configuring an application.

• For an overview of connector features, see Data source connector concepts.

• For information about connector configuration best practices, see Connector configuration best practices.

Topics

• PostgreSQL connector overview
• Prerequisites for connecting Amazon Q Business to PostgreSQL
• Connecting Amazon Q Business to PostgreSQL using the console
• Connecting Amazon Q Business to PostgreSQL using APIs
• How Amazon Q Business connector crawls PostgreSQL ACLs
• Amazon Q BusinessPostgreSQL data source connector field mappings
• IAM role for Amazon Q BusinessPostgreSQL connector
• Known limitations for the Amazon Q BusinessPostgreSQL connector