mxql

What problem does it solve?

Working with MXQL (Metrics Query Language) can be complex and time-consuming, leading to syntax errors, inefficient queries, and a lack of confidence in results. This Skill automates the entire MXQL lifecycle, from initial query generation to in-depth analysis and robust testing, allowing you to focus on insights rather than syntax.

Core Features & Use Cases

• Effortless Query Generation: Conversational, step-by-step guidance to create MXQL queries for monitoring diverse metrics across 631 categories (e.g., "Generate an MXQL query for high CPU usage in MySQL instances").
• Intelligent Query Analysis & Validation: Automatically checks for syntax errors, semantic issues, and performance bottlenecks, providing actionable optimization suggestions (e.g., "Analyze this MXQL query for correctness and performance").
• Automated Test Query Generation: Creates ready-to-use test queries with sample ADDROW data, enabling you to validate logic and results before deployment (e.g., "Generate a test version of my MXQL query with sample data").
• Comprehensive Category Discovery: Helps you quickly find relevant metric categories, fields, and product types (e.g., "Find categories related to Kubernetes pod CPU usage").

Quick Start

Use the mxql skill to generate an MXQL query for PostgreSQL active sessions, then validate it and generate a test version with sample data.