How does it handle different table and file naming conventions?

The skill includes logic to map between snake_case plural database names (used in schemas) and PascalCase singular names (used for CSV filenames).

Is this skill safe for production data?

Yes, this skill is strictly read-only. It provides tools for investigation and analysis but does not include functionality to create or edit data files.

Can it detect discrepancies between server and client enums?

Yes, the included enum-detector script can compare Enum values defined in PHP (server) and C# (client) to ensure they are synchronized.

Do I need to install DuckDB to use the analysis features?

Yes, the SQL querying functionality requires DuckDB to be installed on your system (e.g., via Homebrew). It uses a specialized .duckdbrc for optimal CSV parsing.

Masterdata Explorer

Name: Masterdata Explorer
Author: Wonderplanet

byWonderplanet

数据库管理

Explores and analyzes project master data through schema discovery and SQL-powered CSV querying.

关于

Masterdata Explorer is a specialized skill designed for deep investigation and analysis of game project master data. It enables developers to perform high-performance SQL queries on CSV files using DuckDB, investigate database schemas with automated scripts, and ensure data integrity by validating enums across server and client codebases. This skill streamlines the process of understanding complex table relationships and data distributions without the need for manual CSV browsing or external database tools.

主要功能

Automated schema discovery for tables, columns, and constraints using jq
Cross-platform Enum consistency checking between PHP (server) and C# (client)
Read-only investigation workflows to ensure data safety and integrity
High-performance SQL querying of CSV master data via DuckDB integration
Intelligent naming mapping between DB schemas and PascalCase CSV files
0 GitHub stars

使用场景

Analyzing complex data distributions and table joins across multiple CSV master files
Verifying valid enum values and constraints before authoring new game data
Audit and synchronization of data definitions between server-side and client-side code

关于

主要功能

Automated schema discovery for tables, columns, and constraints using jq
Cross-platform Enum consistency checking between PHP (server) and C# (client)
Read-only investigation workflows to ensure data safety and integrity
High-performance SQL querying of CSV master data via DuckDB integration
Intelligent naming mapping between DB schemas and PascalCase CSV files
0 GitHub stars

使用场景

Analyzing complex data distributions and table joins across multiple CSV master files
Verifying valid enum values and constraints before authoring new game data
Audit and synchronization of data definitions between server-side and client-side code