OsqueryMcpServer

kousen/OsqueryMcpServer

3.3

If you are the rightful owner of OsqueryMcpServer and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The Osquery MCP Server is a comprehensive Model Context Protocol implementation that bridges AI models with operating systems for natural language system diagnostics.

The Osquery MCP Server is designed to facilitate intelligent system diagnostics by translating natural language queries into precise Osquery SQL commands. This server, built with Spring Boot and Java 21, allows AI assistants to perform system diagnostics, monitor performance, and investigate security issues using natural language. It includes a Spring AI-based CLI client that demonstrates communication with the server through the Model Context Protocol. The server supports a variety of diagnostic tools, enabling users to ask questions like 'What's using my CPU?' or 'Why is my fan running so hot?' and receive intelligent responses. The project emphasizes performance and reliability with features like query timeouts, process management, and error handling, ensuring robust and efficient operation.

Features

  • Natural Language System Diagnostics: Enables users to ask system-related questions in natural language and receive intelligent responses.
  • Specialized Diagnostic Tools: Provides nine tools for common diagnostic scenarios, including CPU/memory usage analysis and network connection monitoring.
  • Smart Query Assistance: Offers built-in examples and schema discovery to help AI construct better queries.
  • Spring Boot and Java 21: Utilizes modern technologies for an efficient and maintainable codebase.
  • Comprehensive Testing: Includes automated unit tests for query mapping logic to ensure reliability.

Usages

usage with Claude Desktop

{
  "mcpServers": {
    "osquery": {
      "command": "java",
      "args": ["-jar", "path/to/osquery-mcp-server.jar"]
    }
  }
}

Tools

  1. executeOsquery

    Execute any valid Osquery SQL query

  2. listOsqueryTables

    Get all available Osquery tables on your system

  3. getTableSchema

    Discover columns and types for any table

  4. getHighCpuProcesses

    Find processes consuming the most CPU

  5. getHighMemoryProcesses

    Find processes using the most memory

  6. getNetworkConnections

    Show active network connections with process info

  7. getTemperatureInfo

    Get system temperature and fan speeds (macOS)

  8. getCommonQueries

    Get example queries for common diagnostic scenarios

  9. getSystemHealthSummary

    Get comprehensive overview of CPU, memory, disk, network, and temperature