> ## Documentation Index
> Fetch the complete documentation index at: https://docs.tembo.io/llms.txt
> Use this file to discover all available pages before exploring further.

# AWS

> RDS PostgreSQL performance monitoring and optimization.

<Frame>
  <img src="https://mintcdn.com/test-8862363a/ZNDzs01gTiL6UMVz/images/integrations/aws.png?fit=max&auto=format&n=ZNDzs01gTiL6UMVz&q=85&s=00c1c882f1a11f742297d1d9d05c91aa" alt="AWS" width="2560" height="1440" data-path="images/integrations/aws.png" />
</Frame>

<Note>Email [support@tembo.io](mailto:support@tembo.io) for access to this integration.</Note>

## Features

* Monitor slow queries across RDS PostgreSQL instances
* Detect missing and unused indexes
* Open PRs with migration scripts
* Multi-region RDS instance discovery

## Installation

<Steps>
  <Step title="Connect">
    Go to [Integrations](https://app.tembo.io/integrations) and click **Connect** next to AWS. You'll be redirected to CloudFormation.
  </Step>

  <Step title="Deploy stack">
    Deploy the CloudFormation stack to create an IAM role for Tembo.
  </Step>

  <Step title="Activate instances">
    Select which RDS PostgreSQL instances to monitor under "Active Instances".
  </Step>

  <Step title="Map repository">
    Map instances to the repository where migrations are stored.
  </Step>
</Steps>

## Usage

Tembo monitors your RDS instances using `pg_stat_statements`. When it finds optimization opportunities, it opens PRs with migration scripts.

Requires `pg_stat_statements` extension enabled on your RDS instances.

## Advanced

<AccordionGroup>
  <Accordion title="Instances not appearing">
    Wait a few minutes for region scanning. Verify the CloudFormation stack deployed successfully and the IAM role has permission to describe RDS instances.
  </Accordion>

  <Accordion title="Connection issues">
    Verify security groups allow Tembo's IP ranges. Ensure your RDS instance is accessible and SSL/TLS settings are correct.
  </Accordion>
</AccordionGroup>