osquery

It provides a SQL interface for querying operating‑system information, exposing system data as virtual tables that can be inspected with standard SELECT statements. By treating configuration files, running processes, hardware details and other OS attributes as relational data, users can write familiar queries to retrieve and analyze the state of a machine.

The tool is aimed at developers, system administrators and security engineers who need to gather diagnostics, monitor compliance or perform forensic investigations across fleets of computers. Because it runs on macOS, it can be integrated into existing tooling pipelines to automate data collection and reporting without requiring custom scripts for each data source.

Its design emphasizes stability and a consistent query language, allowing users to compose complex filters and joins while relying on a well‑tested core that has reached a mature, production‑ready stage.