Osquery: An sqlite3 virtual table exposing operating system data to SQL

• OSQuery

  44 21,338 8.8 C++

  SQL powered operating system instrumentation, monitoring, and analytics.

  

There's at least one open data quality issue for `process_open_sockets` on macOS[1]. It's a few years old however and, if you aren't seeing that casting error, you probably aren't hitting it. But that's a good example of the kind of debt that's been built up over time.

(In terms of general purpose/flexible tooling, I'm not aware of a close replacement for osquery.)

[1]: https://github.com/osquery/osquery/issues/6319

• Fleet

  28 2,132 10.0 Go

  Open-source platform for IT, security, and infrastructure teams. (Linux, macOS, Chrome, Windows, cloud, data center) (by fleetdm)

  

linky: https://github.com/fleetdm/fleet/blob/fleet-v4.45.1/tools/md... and seems to be mostly MIT Expat <https://github.com/fleetdm/fleet/blob/fleet-v4.45.1/LICENSE>

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• steampipe

  146 6,391 9.7 Go

  Zero-ETL, infinite possibilities. Live query APIs, code & more with SQL. No DB required.

  

be mindful of its AGPLv3 https://github.com/turbot/steampipe/blob/v0.21.8/LICENSE (AFAIK v0.4.3 is the last MIT release https://github.com/turbot/steampipe/blob/v0.4.3/LICENSE ) and the actual providers are Apache 2 <https://github.com/turbot/steampipe-plugin-aws/blob/v0.131.0...> (but I don't know if provider drift makes them compatible with 0.4 or not)

iasql seems to be AWS only, but good for them for taking this on:

• system_stats

  1 99 5.1 C

  A Postgres extension for exposing system metrics such as CPU, memory and disk information

  

system_stat is another one specific to PostgreSQL:

https://github.com/EnterpriseDB/system_stats

• steampipe-plugin-aws

  8 171 9.3 Go

  Use SQL to instantly query AWS resources across regions and accounts. Open source CLI. No DB required.

  

be mindful of its AGPLv3 https://github.com/turbot/steampipe/blob/v0.21.8/LICENSE (AFAIK v0.4.3 is the last MIT release https://github.com/turbot/steampipe/blob/v0.4.3/LICENSE ) and the actual providers are Apache 2 <https://github.com/turbot/steampipe-plugin-aws/blob/v0.131.0...> (but I don't know if provider drift makes them compatible with 0.4 or not)

iasql seems to be AWS only, but good for them for taking this on:

• iasql

  15 578 5.8 TypeScript

  Cloud Infrastructure as data in PostgreSQL

  

Suggest a related project