CloudQuery

CloudQuery is a cloud-infrastructure data tool for teams that need a common view across providers and services. It is strongest for technical users who want to query synced inventory with SQL and control its destinations. Its flexibility is appealing, but the annual row-counting model and credential-security responsibilities deserve attention.

Overview

CloudQuery syncs data from more than 80 sources and maps it into a normalized relational schema. That gives teams a consistent way to query infrastructure from services such as AWS, GCP, Azure, GitHub, and Okta instead of treating every source as a separate data model. The payoff is greatest when SQL is already part of the team’s workflow; readers seeking an inventory interface without a query-oriented approach may find the emphasis less suitable.

Synced data can go to destinations including Postgres, BigQuery, Snowflake, and S3. CloudQuery Platform provides a more integrated workflow: it writes data to S3 and processes it into a built-in ClickHouse database for inventory, SQL Console, policies, and reports. The open-source engine leaves destination and surrounding setup under the user’s control, while Platform brings those capabilities together in one environment.

Key features

SQL-ready infrastructure data

Standard SQL works across the normalized data, making CloudQuery a practical option for teams that want to inspect cloud assets or use synced records in downstream systems. Its usefulness depends on having people or tools ready to query and act on that data; normalization alone does not replace that work.

Configurable syncs and integrations

Each sync is defined in version-controlled YAML and can be reviewed through pull requests. That is a meaningful advantage for teams that want configuration changes subject to the same review practices as code. CloudQuery Platform supports more than 70 source integrations, including Kubernetes, Entra ID, GitLab, Datadog, and PagerDuty. For unsupported sources, SDKs in Go, Python, JavaScript, and Java let users build custom integrations, though that route requires development effort.

Self-hosting and AI access

CloudQuery can run on infrastructure the user controls, keeping data within the user’s network unless configured otherwise. Its MCP server can operate in PostgreSQL or Snowflake mode, allowing AI agents and internal systems to query synced data without a Platform subscription. This flexibility suits teams with an existing database and suitable controls; it does not remove the need to protect the machine holding integration credentials. CloudQuery recommends read-only integration credentials and securing that machine.

Pricing

CloudQuery is freemium, and billing is based on rows synced per year: each record counts every time it is synced. That makes sync frequency relevant to quota planning, not just the size of the inventory.

• Free — free, billed Forever: Includes cloud asset inventory in your database, an MCP server, 50+ sources, and DIY dashboards and querying, with a 1M-row limitation. It suits evaluation or smaller workloads that can stay within the cap. The constraint is substantial for recurring syncs or broad inventories because repeated syncing counts toward the limit.
• Enterprise — custom pricing, billed tailored to your organization: Includes everything in Free and supports 1M+ rows. It is the option for organizations whose usage exceeds the free allowance; the plan’s tailored terms mean the cost needs to be established for each organization.

A free trial is offered. The CLI is available for macOS, Windows, and Linux through Homebrew, precompiled binaries, and other installation methods. Support plans range from Free through Silver and Gold to Platinum; Platinum provides 24×7 support with a one-hour initial response SLA for business-critical issues.

Platforms

CloudQuery lists API, Linux, macOS, self-hosted, web, and Windows support. The CLI’s named download platforms are macOS, Windows, and Linux. Its hybrid deployment model is useful to teams balancing controlled infrastructure with a web-based Platform workflow.

Who it's for

CloudQuery is a strong fit for infrastructure, security, and data teams that need to combine cloud and SaaS inventory, query it with SQL, or send it to databases and storage they already use. Versioned YAML and self-hosting also suit teams that want reviewable sync configuration and control over where data runs. It is less compelling for readers who want a ready-made asset-management workflow without SQL, or who cannot justify managing credentials and an execution host.

Pros and cons

• Pro: A normalized schema and standard SQL make data from multiple sources more consistent to query.
• Pro: Users can choose among destinations, self-hosting, and CloudQuery Platform’s built-in ClickHouse workflow.
• Pro: Version-controlled YAML and custom-integration SDKs support reviewable and extensible sync pipelines.
• Con: The free plan’s 1M-row cap can constrain repeated syncs because every synced record counts again.
• Con: Users must secure the machine containing cloud credentials, adding an operational responsibility to deployment.
• Con: Custom integrations and DIY dashboards call for technical effort rather than providing a turnkey experience.

Alternatives

For a broader comparison, browse IT Asset Discovery Software.

• OCS Inventory NG is worth considering for a free option with a broad range of listed platforms; its editor also provides integration and support.
• Lansweeper may suit readers who want an asset-focused alternative with a 14-day full trial, then a free option for up to 100 assets and unlimited user seats.
• Komiser is another free option, with Linux, macOS, self-hosted, web, and Windows platforms listed.
• LOGINventory offers a forever-free plan for up to 20 devices, making it a possible fit for small inventories on a device-count limit rather than CloudQuery’s row-based allowance.
• Open-AudIT may fit teams that prioritize an unlimited-device free plan with community support.
• runZero is an alternative whose free Community Edition covers 100 assets, one organization, 10 recurring tasks, and 30 days of data retention.
• rxInventory is another freemium option to compare for Linux, macOS, or Windows environments.
• IT Asset Tool offers a free Basic plan for up to 35 assets, a more directly capped starting point for smaller inventories.

Verdict

Choose CloudQuery if your team needs to bring infrastructure data together, query it with SQL, and retain control over sync configuration or deployment. Its open-source engine, flexible destinations, and Platform workflow make it particularly capable for technically equipped teams. Look elsewhere if you need a turnkey asset-management tool or a free allowance that is not consumed again with every sync.