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.
Key Features
01Automated schema discovery for tables, columns, and constraints using jq
02Cross-platform Enum consistency checking between PHP (server) and C# (client)
03Read-only investigation workflows to ensure data safety and integrity
04High-performance SQL querying of CSV master data via DuckDB integration
05Intelligent naming mapping between DB schemas and PascalCase CSV files
060 GitHub stars
Use Cases
01Analyzing complex data distributions and table joins across multiple CSV master files
02Verifying valid enum values and constraints before authoring new game data
03Audit and synchronization of data definitions between server-side and client-side code
