Product News

Announcing the AWS Secrets Report

Announcing the AWS Secrets Report blog post header

TL;DR:
CloudQuery's new AWS Secrets Report helps engineering teams track secrets sprawl across AWS accounts using three key visualizations. Find unrotated secrets, identify unused credentials from the last 30 days, and get account-level breakdowns of your secrets risk. Stop manually auditing secrets with spreadsheets and start treating secrets management like the engineering problem it actually is. The report serves as a starting point for building custom security workflows that integrate with your existing infrastructure tools.

You know what keeps us up at night? It's not the sophisticated nation-state attacks or zero-day exploits. It's the mundane stuff. The API key that's been sitting there for 18 months without rotation. The database password someone created for a proof-of-concept that never got cleaned up. The service token from that microservice we decommissioned last quarter, but somehow forgot to delete.

We built CloudQuery's AWS Secrets Report because managing secrets at scale feels like playing an endless game of hide and seek, except the stakes are your entire infrastructure.

The Problem We Keep Ignoring

Here's the uncomfortable truth: most engineering teams know they have a secrets problem, but they don't know how big it is. We've talked to teams managing thousands of secrets across dozens of AWS accounts, and their "audit process" involves someone manually clicking through the AWS console with a spreadsheet.

That approach breaks down fast. Really fast.

When you're running microservices across multiple regions, secrets multiply like rabbits. Database credentials here, API tokens there, encryption keys everywhere. Before you know it, you're sitting on hundreds of secrets, and honestly, who has time to track which ones are actually being used?

What We Actually Built

Secrets Without Rotation by Account

This one hits different when you see the numbers. We're talking about a simple count that shows which AWS accounts have the most unrotated secrets.

Detailed Secrets Analysis

Want the full picture? This visualization breaks down every unrotated secret with creation dates, owning services, and last access times. We've seen teams discover secrets that haven't been touched in over a year.

The 30-Day Cleanup List

This might be the most valuable query we've written. It surfaces secrets that haven't been accessed in the last month. We're talking about immediate wins for reducing your attack surface.

Getting Started

Each report connects directly to action. When you spot unrotated secrets, you're not just generating a compliance report. You're building systematic security practices.

Start by visiting our AWS Secrets report page to configure your environment and run your first scan. The setup guides you through connecting your AWS accounts and customizing the queries for your specific infrastructure.

We've seen teams use this data to:

  • Prioritize rotation automation (start with the oldest secrets protecting critical resources)
  • Build cleanup workflows (remove those unused secrets cluttering your environment)
  • Generate compliance evidence (show auditors you're actually tracking this stuff)
  • Identify automation gaps (spot patterns where rotation should be automatic but isn't)

You can customize every query in CloudQuery's new custom reports feature. Start with our base queries, then adapt them to your infrastructure patterns. Filter by your tagging strategy. Cross-reference with your resource inventory. Build the visibility that makes sense for your environment.

Because honestly? Your secrets deserve the same engineering rigor you apply to performance monitoring and cost optimization.

Do you have ideas for other reports or feedback for us? Be sure to share them on our community forum.

Want to see how CloudQuery can help you get a handle on your Cloud? Try it out yourself or reach out to us to learn more.

Try CloudQuery yourself

Self-hosted, open source, and free to start. Or schedule a demo to see the managed version.

Related posts

AWS

Cloud Asset Inventory

Product News

AWS Relations Transformer: Every Dependency in One Table

The AWS Relations transformer writes every reference between your synced AWS resources to one SQL table. Try the v1.0.0 preview and tell us what you build.

CloudQuery Team

CloudQuery Team

September 27, 2026

AI

Cloud Asset Inventory

Product News

CloudQuery Platform Adds Business Context and Scheduled Exports to Cloud Inventory

CloudQuery Platform now groups cloud resources into apps and environments, and lets you schedule automated data exports to your data warehouse on a cron.

Zeen Rachidi

Zeen Rachidi

August 31, 2026

AI

Product News

What's new in the CloudQuery Platform AI Assistant

The CloudQuery Platform AI Assistant just got a major upgrade enabling you to build reports from chat, revisit past conversations, manage policies conversationally, and more.

Zeen Rachidi

Zeen Rachidi

July 16, 2026

AI

Product News

Try CloudQuery Platform Today: Self-Service Signup Is Here

CloudQuery's Platform now offers self-service signup

Zeen Rachidi

Zeen Rachidi

June 18, 2026

AI

Product News

Introducing the CloudQuery Platform AI Assistant

CloudQuery's new AI Assistant lets you ask questions about your cloud infrastructure in plain English - no SQL required.

Joe Karlsson

Joe Karlsson

May 18, 2026

Cloud Asset Inventory

Product News

A Field Guide to Finding Zombie Infrastructure in AWS

Three playbooks for identifying zombie cloud resources - abandoned databases, forgotten prototypes, and unowned compute - using AWS CLI, SQL, and Insights.

Joe Karlsson

Joe Karlsson

April 2, 2026

Product News

Security

Investigating Toxic IAM and Access Combinations in AWS

Three investigation playbooks for finding toxic signal combinations in AWS - stale credentials, open SSH, and unowned compute - with SQL and Insights.

Joe Karlsson

Joe Karlsson

April 2, 2026

Product News

Security

How to Find GitHub Repos Vulnerable to Supply Chain Attacks Like CanisterWorm

Find which of your GitHub repos are vulnerable to fork PR supply chain attacks like CanisterWorm, and how to fix the settings before they're exploited.

Ştefan Muraru

Ştefan Muraru

March 25, 2026

Product News

Introducing the Markmonitor Integration for CloudQuery

CloudQuery's new Markmonitor integration syncs your enterprise domain portfolio into your data warehouse for domain expiration tracking and DNSSEC analysis.

Joe Karlsson

Joe Karlsson

March 12, 2026

Own your pipeline.
Own your data.