skills.rest
ProxiBlue
ProxiBlueCOMMUNITY
Explore all skills by this author →
Website𝕏@proxiblueGitHub

database-query-analysis

Execute predefined and dynamic SQL queries against Magento 2 data sources.

15|1|Updated Oct 24, 2025
Search Tags:#SQL#queries#MCP#catalog#reporting#analyze#Magento
One-click install
npx skills add https://github.com/ProxiBlue/claude-skills --skill database-query-analysis
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-query-analysis
Source: https://github.com/ProxiBlue/claude-skills/tree/main/database-query-analysis
Command: npx skills add https://github.com/ProxiBlue/claude-skills --skill database-query-analysis

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about database-query-analysis

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

FAQPage Schema
How do I run SQL queries to analyze Magento 2 catalog and sales data?▼

Magento 2 SQL query analysis is performed by executing predefined or dynamic queries against your data source via MCP servers, returning structured CSV or JSON results for catalog and sales insights.

What kind of Magento database insights can I get from direct SQL execution?▼

Direct SQL execution provides insights into product counts, category relationships, order volume, revenue by period, configuration scopes, and table sizes, enabling comprehensive catalog, sales, and performance audits.

Can I compare sales revenue across different time periods using Magento queries?▼

Yes, Magento queries support period comparisons, allowing you to analyze revenue, order volume, and sales performance across different time ranges directly from your database data.

Does this query analysis approach require an MCP server connection?▼

Yes, executing these database queries requires a connection to Magento 2 MCP servers, which facilitates direct SQL execution, structured result formatting, and rapid data retrieval.

How do I export Magento 2 database query results into CSV or JSON?▼

Magento 2 database query results export to CSV or JSON formats automatically after execution, providing structured result formatting suitable for reporting and downstream data analysis.

What's the best way to audit Magento 2 system configuration and module status?▼

The best way to audit Magento 2 configuration is by running targeted database queries to retrieve system configuration by scope, module status, store hierarchy, and admin user data quickly.

Related Skills

Explore More Data & Analytics Skills→
stericisherestericishere
1

claude-mcp-expert

Configure and troubleshoot MCP servers for Claude Code integration.

Community
Advanced
Datus-aiDatus-ai
1.5k

report-generator

Generate JSON, CSV, or markdown reports from SQL query results.

Official
Basic
caravanglorycaravanglory
2

performance

Diagnose and optimize Magento 2 performance bottlenecks with profiler evidence.

Community
Advanced
InchooInchoo
18

ui-component-forms

Create and manage Magento 2 admin forms with UI component XML.

Official
Intermediate