mxql

Generate, validate, and test MXQL queries with ADDROW sample data.

2|1|Updated Nov 7, 2025
One-click install
npx skills add https://github.com/kyupid/mxql-for-claude-code --skill mxql
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: mxql
Source: https://github.com/kyupid/mxql-for-claude-code/tree/main/mxql
Command: npx skills add https://github.com/kyupid/mxql-for-claude-code --skill mxql

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

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.

Frequently Asked Questions about mxql

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate an MXQL query for monitoring metrics?

MXQL query generation guides you through conversational steps to create queries across 631 metric categories and 36+ product types—Database, APM, Infrastructure, Kubernetes, Cloud, and Container. Specify your metric need (e.g., CPU usage, active sessions) and receive a ready-to-use query tailored to your monitoring context.

Can I validate MXQL syntax and check for performance issues?

Yes, MXQL validation automatically checks syntax errors, JSON structure, bracket balance, and semantic correctness, then identifies performance bottlenecks and provides optimization suggestions to improve query efficiency before deployment.

What's the best way to test an MXQL query before using it in production?

MXQL test data generation creates ready-to-use test queries with sample ADDROW data, allowing you to validate query logic and results in a safe environment before running against live metrics.

Does this work with metrics across different product types and monitoring platforms?

Yes, MXQL handles metrics spanning 631 categories across 36+ product types including Database, Application/APM, Infrastructure, Kubernetes, Cloud, Container, Real User Monitoring, and others, supporting comprehensive cross-platform monitoring workflows.

How do I find the right metric categories for my monitoring needs?

Comprehensive category discovery helps you quickly locate relevant metric categories, fields, and product types by searching for specific monitoring needs—for example, finding categories related to Kubernetes pod CPU usage or database performance metrics.

Can I use conversational guidance to build complex MXQL queries?

Yes, conversational query generation provides step-by-step guidance to construct MXQL queries iteratively, helping you navigate complexity and build optimized queries for metrics across any of the 631 supported categories.