skills.rest
kousen
kousenCOMMUNITY
Explore all skills by this author →
Website𝕏@kenkousenGitHub

osquery

Translate natural language questions into Osquery SQL queries and parse JSON results.

10|14|Updated Jun 5, 2025
Search Tags:#bash#cpu usage#temperature#system diagnostics#memory usage#osquery#network connections
One-click install
npx skills add https://github.com/kousen/OsqueryMcpServer --skill osquery
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: osquery
Source: https://github.com/kousen/OsqueryMcpServer/tree/main/.claude/skills/osquery
Command: npx skills add https://github.com/kousen/OsqueryMcpServer --skill osquery

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill enables AI to perform comprehensive system diagnostics by translating natural language questions into Osquery SQL queries and parsing the JSON results. It helps you understand CPU usage, memory consumption, network activity, running processes, disk I/O, temperatures (macOS), and security-related queries without manually building SQL queries.

Core Features & Use Cases

  • Unified Diagnostics: Query CPU, memory, network, disk I/O, temperature, and processes from a single interface.
  • Predefined Templates: Access common diagnostic templates in queries.md to quickly map natural language prompts to queries.
  • Platform Awareness: macOS-focused sensors for temperatures and fans with guidance for Linux equivalents.
  • Result Interpretation: AI-friendly outputs with guidance on what the results mean and next steps.

Quick Start

On a system with Osquery installed:

  • Run an example: osqueryi --json "SELECT name, pid, resident_size FROM processes ORDER BY resident_size DESC LIMIT 5"
  • Or ask: "What's using my CPU?" and have the AI map it to the appropriate query.