kousen/osquerymcpserver
Developer toolsこのページは AI により自動翻訳されています。技術的な詳細は原文をご確認ください。 原文を見る
MCP wrapper and Claude Code Skill for osquery
概要
A complete implementation for integrating Osquery with AI assistants, providing three approaches: an MCP server for Claude Desktop, a Spring AI client, and a Claude Code skill for direct CLI usage. This project enables AI assistants to answer system diagnostic questions like "Why is my fan running so hot?" or "What's using all my memory?" by translating natural language into Osquery SQL queries. The stack was upgraded to the latest Spring ecosystem with GraalVM native image support: : The MCP server compiles to a ~62MB native binary that starts and responds to MCP requests in ~36ms. This is critical for the voice interface use case — when a JavaFX voice client launches the server, it needs to respond instantly. : getSystemHealthSummary() now runs all 5 diagnostic queries (CPU, memory, disk, network, temperature) in parallel using Executors.newVirtualThreadPerTaskExecutor() with CompletableFuture.supplyAsync().
README
以下は原文 README の抜粋です。原文を見る。
Osquery MCP Server, Client & Skill
A complete implementation for integrating Osquery with AI assistants, providing three approaches: an MCP server for Claude Desktop, a Spring AI client, and a Claude Code skill for direct CLI usage.
Overview
This project enables AI assistants to answer system diagnostic questions like “Why is my fan running so hot?” or “What’s using all my memory?” by translating natural language into Osquery SQL queries.
Three ways to use osquery with AI:
| Approach | Best For | How It Works |
|---|---|---|
| MCP Server | Claude Desktop | Spring Boot server communicates via MCP protocol |
| Spring AI Client | Programmatic access | CLI client using Spring AI’s MCP auto-configuration |
| Claude Code Skill | Claude Code CLI | Direct osqueryi execution via Bash, no server needed |
What’s New
The stack was upgraded to the latest Spring ecosystem with GraalVM native image support:
| Component | Previous | Current |
|---|---|---|
| Spring Boot | 3.5.0 | 4.0.3 |
| Spring AI | 1.0.0 | 2.0.0 |
| Java | 21 | 25 (GraalVM CE) |
| Jackson | 2.x (com.fasterxml) |
3.x (tools.jackson) |
| Dependency mgmt | io.spring.dependency-management plugin |
Gradle platform() BOMs |
| Native image | Not supported | GraalVM native binary (~36ms startup) |
| System health | Sequential (5 queries) | Parallel via virtual threads |
Key Upgrade Details
GraalVM Native Image: The MCP server compiles to a ~62MB native binary that starts and responds to MCP requests in ~36ms. This is critical for the voice interface use case — when a JavaFX voice client launches the server, it needs to respond instantly.
Virtual Threads: getSystemHealthSummary() now runs all 5 diagnostic queries (CPU, memory, disk, network, temperature) in parallel using Executors.newVirtualThreadPerTaskExecutor() with CompletableFuture.supplyAsync(). This reduces response time from the sum of all queries to the duration of the slowest single query.
Jackson 3 Migration (client only): Spring Boot 4 ships Jackson 3 with new Maven coordinates (tools.jackson.core instead of com.fasterxml.jackson.core), immutable builders (JsonMapper.builder().build() instead of new ObjectMapper()), and unchecked exceptions (JacksonException instead of JsonProcessingException).
Gradle Build Changes: Spring Boot 4 drops the io.spring.dependency-management plugin. Dependencies are now managed with Gradle-native platform() BOMs. Spring AI 2.0.0 is GA on Maven Central, so no milestone repository is required.
Features
MCP Server
- Natural Language System Diagnostics: Ask questions like “What’s using my CPU?” and get intelligent answers
- 11 Specialized Tools for common diagnostic scenarios:
- Execute custom Osquery SQL queries
- Get table schemas and available columns
- Find high CPU/memory/disk I/O usage processes
インストール
This server does not publish a one-line install command.
Open the repository installation guide MCP 初心者？mcpskill.org のガイドから始めましょう →設定
{
"mcpServers": {
"osquery": {
"command": "java",
"args": ["-jar", "path/to/osquery-mcp-server.jar"]
}
}
}