skills.rest
miXshift
miXshiftOFFICIAL
Explore all skills by this author →
WebsiteGitHub

mx-data-explore

Query MixShift's MySQL warehouse, sample data, and export CSV files.

2|Updated May 13, 2026
Search Tags:#data analysis#data exploration#CSV export#SQL query#MixShift
One-click install
npx skills add https://github.com/miXshift/mx-claude-plugin --skill mx-data-explore
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mx-data-explore
Source: https://github.com/miXshift/mx-claude-plugin/tree/main/plugins/mixshift-ai/skills/mx-data-explore
Command: npx skills add https://github.com/miXshift/mx-claude-plugin --skill mx-data-explore

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides access to ad-hoc querying, sampling, and CSV exporting against MixShift's MySQL warehouse, enabling users to easily explore and analyze their data.

Core Features & Use Cases

  • Ad-Hoc Querying: Execute custom SQL queries on MixShift's warehouse.
  • Data Sampling: Sample data from tables to view individual rows.
  • CSV Export: Export data from tables to CSV files for further analysis.
  • Use Case: If a user wants to analyze their Amazon advertising campaign performance, they can use this Skill to run a query against the campaignmetric table to retrieve campaign metrics.

Quick Start

Use the mx-data-explore skill to query the 'campaignmetric' table for campaign metrics from the past 30 days.

Frequently Asked Questions about mx-data-explore

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

FAQPage Schema
How do I run ad-hoc SQL queries on MixShift warehouse data?▼

To run ad-hoc SQL queries on MixShift warehouse data, use this Skill to execute custom SQL statements against the MySQL warehouse, which requires MixShift authentication and access to your account.

Can I export data from the MixShift warehouse to CSV?▼

Yes, you can export data from the MixShift warehouse to CSV. This Skill handles CSV exporting by processing your SQL queries and providing the resulting sample data as downloadable CSV files.

How do I sample individual rows from a MySQL warehouse table?▼

To sample individual rows from a MySQL warehouse table, use the data sampling feature to retrieve and view specific rows from tables like the campaignmetric table for Amazon advertising analysis.

Do I need MixShift authentication to query the MySQL warehouse?▼

Yes, MixShift authentication is required to query the MySQL warehouse. This Skill provides read-only access to the warehouse, meaning you must have an active MixShift account and proper access credentials.

What are the limitations of read-only access to the MixShift MySQL warehouse?▼

The limitation of read-only access to the MixShift MySQL warehouse is that you can only query, sample, and export data. You cannot modify, insert, or delete records within the warehouse using this Skill.

What is the best way to analyze Amazon advertising campaign performance in MixShift?▼

The best way to analyze Amazon advertising campaign performance in MixShift is to run a custom SQL query against the campaignmetric table, retrieving specific campaign metrics and exporting the results to CSV for further analysis.

Related Skills

Explore More Data & Analytics Skills→
marcosgomeseburymarcosgomesebury

mysql_connect

Validate MySQL database connectivity using environment-provided credentials.

Community
Intermediate
CompSci-SquadCompSci-Squad

data-scientist

Perform advanced analytics, predictive modeling, and statistical modeling for data science tasks.

Official
Advanced
miXshiftmiXshift
2

mx-auth-login

Authenticate users against the MixShift warehouse with token-based access.

Official
Advanced
timequitytimequity
6

warehouse-optimization

Optimize data warehouse queries and storage across Snowflake, BigQuery, and Redshift.

Official
Intermediate