Skip to main content
Email support@tembo.io for access to this integration.
Connect AWS RDS PostgreSQL databases to Tembo for performance monitoring and optimization.

​
Features

  • Monitor slow queries - Identifies queries that exceed performance thresholds and suggests optimizations
  • Detect missing indexes - Analyzes query patterns to find opportunities for new indexes that would improve performance
  • Detect unused indexes - Identifies indexes that are no longer being used, helping reduce storage overhead and write performance impact
  • Automatic optimization PRs - Generates pull requests with database migration scripts to implement recommended improvements
  • Multi-region support - Automatically discovers RDS instances across multiple AWS regions

​
Installation

1

Connect AWS Account

Navigate to the Integrations page in Tembo and click the Connect button next to AWS. You’ll be redirected to AWS CloudFormation to create a connection using a secure IAM role.
2

Deploy CloudFormation Stack

Follow the CloudFormation wizard to deploy the connection stack. This creates an IAM role that allows Tembo to discover and monitor your RDS instances securely.
3

Activate RDS Instances

After the connection is established, Tembo will automatically discover your RDS PostgreSQL instances across supported regions. Select which instances you want to monitor under “Active Instances” on the Integrations page.
4

Map Repository

Map your RDS instances to the GitHub, GitLab, or Bitbucket repository where your database migrations are stored. This allows Tembo to create PRs with optimization suggestions.

​
Usage

Once connected, Tembo continuously monitors your RDS PostgreSQL instances for slow queries, missing indexes, and unused indexes using PostgreSQL’s pg_stat_statements extension. When optimization opportunities are identified, Tembo creates pull requests with database migration scripts, detailed explanations, and performance metrics.

​
Troubleshooting

RDS instances not appearing? Wait a few minutes for region scanning, verify the CloudFormation stack deployed successfully, check IAM role permissions to describe RDS instances, and ensure instances are PostgreSQL. Optimization PRs not being created? Verify repository mapping for your RDS instance, ensure pg_stat_statements extension is enabled, allow time for statistics collection, and check branch permissions. Connection issues? Verify security groups allow Tembo’s IP ranges, ensure your RDS instance is accessible (public or via VPN/Direct Connect), and confirm SSL/TLS settings match your configuration.

​
Best Practices

  • Connect production databases for accurate insights; test migrations in staging first
  • Review all suggested migrations before merging, especially for large tables
  • Ensure pg_stat_statements is enabled for comprehensive query analysis