메뉴
Discover, document, and visualize database schemas including tables, columns, relationships, and join paths. Use when working with an unfamiliar database, creating ERD documentation, or understanding how tables connect before writing queries.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Create standardized metadata for data assets. Use when documenting new datasets, building data catalogs, improving data discoverability, or creating data dictionaries for teams.
Structure analysis approach before starting work. Use when receiving new analysis requests, breaking down complex questions into steps, or planning iterative analysis workflows.
Comprehensive data quality assessment against business rules, schema constraints, and freshness expectations. Activate when validating production pipelines, onboarding new data sources, or when stakeholders report data quality concerns.
Identify distinct customer or user segments based on behavior, attributes, or value. Activate when you need to answer "who are our best customers?" or "what distinct groups exist in our user base?" and need data-driven profiles to inform strategy.
Create effective, publication-ready data visualizations. Use when choosing chart types, designing presentation visuals, building dashboard charts, or applying visual design best practices to data output.
Create a clear, transparent explanation of analytical methodology for any audience level. Activate when you deliver findings that require the audience to trust the method — A/B tests, attribution models, forecasts, statistical analyses, or anything where "how did you get that?" is a likely question.
| name | schema-mapper |
| description | Discover, document, and visualize database schemas including tables, columns, relationships, and join paths. Use when working with an unfamiliar database, creating ERD documentation, or understanding how tables connect before writing queries. |
scripts/schema_extractor.py; confirm access permissionsuser_id in multiple tables); document confidence levelscripts/data_dictionary_generator.py; include data type, sample values, null rate, and business context where availablescripts/join_path_finder.py (BFS on relationship graph) to identify how any two tables can be joined; document intermediate tablesscripts/erd_generator.py; include cardinality notationassets/schema_quick_reference.md with most-used tables, key columns, and common join patternsassets/schema_quick_reference.md — human-readable quick reference guide