CloudQuery vs rxInventory

CloudQuery is an open-source context engine for cloud infrastructure that syncs data from more than 80 sources. It maps information from services such as AWS, GCP, Azure, GitHub, and Okta into a normalized relational schema that users can query with standard SQL. Data can be sent to destinations including Postgres, BigQuery, Snowflake, and S3. CloudQuery Platform supports more than 70 integrations and processes synced data into a built-in ClickHouse database for inventory, SQL Console, policies, and reports. An MCP server in PostgreSQL or Snowflake mode lets AI agents and internal systems query synced data without a Platform subscription. Sync definitions use version-controlled YAML, and SDKs in Go, Python, JavaScript, or Java can be used to build unsupported integrations. CloudQuery can run on infrastructure the user controls, keeping data within the network unless configured otherwise. Its Free plan costs nothing, billed Forever, with a 1M rows limitation. Pricing counts rows each time they are synced. The CLI is offered for macOS, Windows, and Linux.

rxInventory is an on-premises tool for discovering and tracking network computers, other devices, and manually recorded fixed assets. Scheduled scans update inventory in the background without requiring Windows client software across the network. Linux and macOS computers can be scanned when SSH is enabled. A Visual Basic-like scripting language can collect registry values and file information or run WMI, SNMP, and SSH requests. Supported databases include Microsoft Access, Microsoft SQL Server, Oracle Database, MySQL/MariaDB, and PostgreSQL. License records can include purchase dates, expiration, and prices; reports can analyze asset data, export to Microsoft Excel, or query SQL views. The product shows when hardware and software changes occurred, and user information can be excluded from storage. The free Basic plan covers up to 20 clients with full functionality and support, but those clients cannot be combined with a purchased license. Professional licenses are listed at tiered per-client prices from 5.00 € once, excluding VAT; Enterprise is 4999.00 EUR once, also excluding VAT.