osquery
SQL powered operating system instrumentation, monitoring, and analytics.
What is osquery?
SQL powered operating system instrumentation, monitoring, and analytics.
Overview of osquery
What it is
osquery is a SQL powered operating system instrumentation, monitoring, and analytics framework. It is available for Linux, macOS, and Windows. osquery exposes an operating system as a high-performance relational database, allowing SQL-based queries to explore operating system data. SQL tables represent abstract concepts such as running processes, loaded kernel modules, open network connections, browser plugins, hardware events, or file hashes. Tables are implemented via a simple plugin and extensions API.
Key features
- SQL-based queries to explore operating system data
- Ad-hoc exploration using the osqueryi shell
- Scheduled monitoring of operating system state across a set of hosts
- Custom applications via osquery Thrift APIs
- Cross-platform support for Linux, macOS, and Windows
- Plugin and extensions API for implementing custom tables
- A variety of pre-existing tables (see schema)
Use cases
- Ad-hoc exploration of operating system state (e.g., list users, check processes with deleted executables)
- Scheduled monitoring to track system changes over time across multiple hosts
- Integration into custom applications using Thrift APIs
- Security and anomaly detection (e.g., ARP cache anomalies, listening processes)
Getting started
See the repository README for installation and build instructions.
License and pricing
The project is open source. The license is not explicitly stated in the README; the LICENSE file is referenced.
Based on the project's public README and repository metadata.