Skills
.Work. You
Rest

database-query-analysis

Community

Query Magento data fast to fuel insights.

Data & Analytics#SQL#queries#MCP#catalog#reporting#analyze#Magento
AuthorProxiBlue
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This skill provides rapid database query execution for Magento 2 data analysis tasks, enabling quick access to catalog, order, configuration, and system data.

Core Features & Use Cases

  • Catalog Data Queries: product counts by type, category relationships, stock status, attribute usage, and price analysis.
  • Order & Sales Queries: order volume, revenue by period, payment method distribution, shipping costs, and customer lifetime value.
  • Configuration Queries: system configuration by scope, module status, store hierarchy, admin users, and cron history.
  • Performance Queries: index status, cache analysis, table sizes, slow queries, and session insights.

Quick Start

Run the database-query-analysis skill to execute predefined common queries against Magento 2 MCP servers and export results as CSV or JSON.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: database-query-analysis
Download link: https://github.com/ProxiBlue/claude-skills/archive/main.zip#database-query-analysis

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.