CloudQuery
The open-source cloud asset inventory powered by SQL.
Overview
CloudQuery is an open-source, high-performance data integration tool that extracts configuration data from cloud APIs and loads it into PostgreSQL databases. This allows you to use standard SQL to query your entire cloud inventory. For drift detection, you can write SQL queries to compare live cloud configurations against a desired state, or compare snapshots over time to identify changes. It's a highly flexible framework for building custom drift detection and security analysis.
✨ Key Features
- Open-source ELT framework
- Support for 30+ cloud providers and SaaS applications
- Uses SQL for querying cloud assets
- Policy-as-Code with SQL
- Change detection and diffing
- Extensible plugin architecture
🎯 Key Differentiators
- Stores cloud asset data in a standard PostgreSQL database, enabling powerful SQL-based analysis.
- Highly extensible with a large number of provider plugins.
- ELT approach is more flexible than API-based query tools.
- Open-source and self-hostable.
Unique Value: Transforms your entire cloud and SaaS infrastructure into a relational database, enabling powerful, flexible, and universal querying with SQL.
🎯 Use Cases (4)
✅ Best For
- Custom compliance checks for complex regulatory requirements
- Creating a single pane of glass for multi-cloud asset inventory
💡 Check With Vendor
Verify these considerations match your specific requirements:
- Real-time infrastructure provisioning
- Users uncomfortable with writing SQL queries
🏆 Alternatives
Offers a more flexible and extensible approach than UI-based tools like Firefly, but requires SQL knowledge. It is more focused on data integration than Steampipe, which provides a live query interface.
💻 Platforms
🔌 Integrations
🛟 Support Options
- ✓ Email Support
- ✓ Dedicated Support (Cloud tier)
🔒 Compliance & Security
💰 Pricing
✓ 14-day free trial
Free tier: Open-source version is fully featured and free.
🔄 Similar Tools in IaC Drift Detection
driftctl
An open-source CLI that warns of infrastructure drifts and fills in the missing piece in your DevSec...
Spacelift
A sophisticated CI/CD platform for IaC that offers drift detection and automated remediation....
env0
An automation platform for IaC that simplifies governance and collaboration, with drift detection....
Scalr
A Terraform automation platform that provides hierarchical governance and self-service for developer...
Prisma Cloud (Bridgecrew)
A comprehensive cloud security platform that includes IaC scanning, drift detection, and compliance ...
Snyk Infrastructure as Code
A developer-focused security platform that includes IaC scanning and drift detection....