Flamingo Raises $4.5M to Get MSPs Out of the Ticket Queue

Skip to content
Osquery logo

Osquery

Endpoint Security (Antivirus/EPP)

Open Source
Selected
Gen3
Free Tier
Self-hosted
OpenMSP Score
57
40
Reddit Impact Score
Github Score
328M
23KStars
2KForks
6KCommits
OtherLicense
Nov 20, 2026Last commit
osquery is an open-source operating system instrumentation framework that exposes a machine as a relational database. Processes, users, network connections, installed software, file hashes, kernel modules, browser extensions and hundreds of other data points become SQL tables you can query. It was created at Facebook in 2014 and is now hosted by the Linux Foundation's osquery foundation, dual-licensed under Apache 2.0 and GPL 2.0. It ships as osqueryi, an interactive shell, and osqueryd, a daemon that runs scheduled queries, records event-based tables (process, file and socket events) and sends results to logging plugins such as files, TLS endpoints, Kafka or AWS Kinesis. Extensions add custom tables. It runs on Linux, macOS and Windows; the latest release is 5.24.0 (October 2026). osquery has no user interface or central console of its own. To use it across many endpoints, MSPs pair it with a fleet manager such as Fleet, a SIEM or an RMM that can push queries and collect results.
image media

Key Features

SQL-based OS queries

Exposes operating system information as a relational database queryable with SQL, making system interrogation accessible to analysts.

Real-time monitoring events

Event-based tables capture system changes in real-time including file modifications, process launches, and network connections.

File integrity monitoring

The file_events table and FIM settings watch chosen paths and record hashes and attributes when files change.

Cross-platform support

The same SQL schema on Linux, macOS and Windows, so one query works across a mixed fleet.

System resource tables

Tables expose CPU, memory, disk and process resource usage for troubleshooting and baselining.

Query packs

Packs group scheduled queries for use cases such as incident response, compliance and vulnerability checks.

Pros and Cons

Pros

SQL interface

Any administrator who knows SQL can question endpoints without learning a new query language.

Integration friendly

Logger plugins send results to files, TLS endpoints, Kafka or AWS Kinesis, and many SIEMs and fleet managers support osquery.

Open source

Dual-licensed under Apache 2.0 and GPL 2.0 and maintained under the Linux Foundation with regular releases.

Cross-platform

One agent and schema for Linux, macOS and Windows.

Low footprint

Lightweight daemon with a watchdog that limits its CPU and memory use.

Cons

Query expertise

Requires SQL and system knowledge

Not a complete EDR

Collects visibility data but does not block threats or include detection content; it is not an EDR.

Limited response

Read-only by design; it cannot kill processes or isolate hosts.

Needs a fleet manager

No central console or multi-tenant management; MSPs need Fleet, a SIEM or an RMM integration to run it across clients.

No user interface

The project ships only a command-line shell and daemon; dashboards and alerting come from other tools.

Feature Comparison

Features
Cost and Licensing
Loading the comparison

Comments

No reviews yet. Be the first to share your experience with Osquery.

Frequently Asked Questions

/vendor/osquery