Skip to content
SQL powered operating system instrumentation, monitoring, and analytics.
C++ C CMake Python Objective-C++ PowerShell Other
Branch: master
Clone or download
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github docs: Add common code-review checks to PR template (#6048) Nov 19, 2019
cmake cpack: Revert renaming com.facebook.plist to com.osquery.plist (#6093) Dec 4, 2019
docs Update steps to install prerequisites on all platforms Nov 28, 2019
external CMake: Improvements to extensions support (#5970) Oct 31, 2019
libraries CMake: explicitly enable ASM_MASM language on Windows (#6065) Nov 23, 2019
mode Upgrade Python tools to Python3 (#5846) Oct 5, 2019
osquery macOS: Add a `bsd_flags` column to the `file` table (#5981) Dec 4, 2019
packs Adding OSX Malware SearchAwesome to osx-attacks (#5713) Aug 22, 2019
plugins parsers: Always apply the options parser first (#6050) Nov 19, 2019
specs macOS: Add a `bsd_flags` column to the `file` table (#5981) Dec 4, 2019
tests macOS: Add a `bsd_flags` column to the `file` table (#5981) Dec 4, 2019
third-party tests: Add test for JSON exponent parsing (#5941) Oct 29, 2019
tools config: Add more checks for pack JSON (#6071) Dec 4, 2019
.buckconfig Move build system to BUCK Dec 7, 2018
.clang-format format: Remove Cpp restriction (#3521) Aug 2, 2017
.gitignore Restore extension SDK support to osquery 4.x (#5851) Oct 18, 2019
.gitmodules Refactor third-party libraries to build from source on Linux (#5706) Aug 30, 2019
.watchmanconfig watcher: Do not initialize the config in watcher (#3403) Jun 14, 2017 changelog: Add 4.1.1 changelog (#6058) Nov 19, 2019
CMakeLists.txt libraries: Add lzma and libxml2 to source_migration Nov 11, 2019
CODEOWNERS Initial codeowners (#5603) Jun 26, 2019 Point CODE_OF_CONDUCT at osquery/foundation (#5721) Aug 27, 2019 docs: Nitpicks to improve new-user experience (#5912) Oct 22, 2019
Doxyfile Add clang-format rules from 3.6 (#2360) Aug 15, 2016
LICENSE Clarify licensing (#4792) Aug 2, 2018
LICENSE-Apache-2.0 Clarify licensing (#4792) Aug 2, 2018
LICENSE-GPL-2.0 Clarify licensing (#4792) Aug 2, 2018 docs: Add the Coverity scan build status (#5783) Sep 9, 2019 security: Update with recent merges (#3787) Oct 5, 2017 Improve (#4835) Aug 8, 2018
Vagrantfile Prune Vagrant boxes and fix AWS support (#5819) Sep 22, 2019
azure-pipelines.yml Force git to create symlinks on the CI (#6064) Nov 21, 2019
mkdocs.yml docs: Update ReadTheDocs with new build docs (#5708) Aug 22, 2019


osquery logo

osquery is a SQL powered operating system instrumentation, monitoring, and analytics framework.
Available for Linux, macOS, Windows, and FreeBSD.

Information and resources

What is osquery?

osquery exposes an operating system as a high-performance relational database. This allows you to write SQL-based queries to explore operating system data. With osquery, SQL tables represent abstract concepts such as running processes, loaded kernel modules, open network connections, browser plugins, hardware events or file hashes.

SQL tables are implemented via a simple plugin and extensions API. A variety of tables already exist and more are being written: To best understand the expressiveness that is afforded to you by osquery, consider the following SQL queries:

List the users:

SELECT * FROM users;

Check the processes that have a deleted executable:

SELECT * FROM processes WHERE on_disk = 0;

Get the process name, port, and PID, for processes listening on all interfaces:

SELECT DISTINCT, listening_ports.port,
  FROM listening_ports JOIN processes USING (pid)
  WHERE listening_ports.address = '';

Find every macOS LaunchDaemon that launches an executable and keeps it running:

SELECT name, program || program_arguments AS executable
  FROM launchd
  WHERE (run_at_load = 1 AND keep_alive = 1)
  AND (program != '' OR program_arguments != '');

Check for ARP anomalies from the host's perspective:

SELECT address, mac, COUNT(mac) AS mac_count
  FROM arp_cache GROUP BY mac
  HAVING count(mac) > 1;

Alternatively, you could also use a SQL sub-query to accomplish the same result:

SELECT address, mac, mac_count
    (SELECT address, mac, COUNT(mac) AS mac_count FROM arp_cache GROUP BY mac)
  WHERE mac_count > 1;

These queries can be:

  • performed on an ad-hoc basis to explore operating system state using the osqueryi shell
  • executed via a scheduler to monitor operating system state across a set of hosts
  • launched from custom applications using osquery Thrift APIs

Download & Install

To download the latest stable builds and for repository information and installation instructions visit

Build from source

Building osquery from source is encouraged! Check out our build guide. Also check out our contributing guide and join the community on Slack.


By contributing to osquery you agree that your contributions will be licensed as defined on the LICENSE file.


We keep track of security announcements in our tagged version release notes on GitHub. We aggregate these into too.

Facebook has a bug bounty program that includes osquery. If you find a security vulnerability in osquery, please submit it via the process outlined on that page and do not file a public issue. For more information on finding vulnerabilities in osquery, see our blog post Bug Hunting osquery.

Learn more

If you're interested in learning more about osquery read the launch blog post for background on the project, visit the users guide.

Development and usage discussion is happening in the osquery Slack, grab an invite automatically here!

You can’t perform that action at this time.