skill-card.md

## Description: <br>
Generate semantic YAML files from databases or Excel; use when users need to quickly build semantic models, generate topic configs or export table structure definitions from MySQL/SQL Server/PostgreSQL/Oracle databases and Excel files. <br>

This skill is ready for commercial/non-commercial use. <br>

## Publisher: <br>
[asksqlai](https://clawhub.ai/user/asksqlai) <br>

### License/Terms of Use: <br>
MIT-0 <br>


## Use Case: <br>
Developers and data engineers use this skill to discover database tables or Excel sheets, select relevant sources, and generate Open Semantic Interchange YAML semantic models for downstream text-to-SQL workflows. <br>

### Deployment Geography for Use: <br>
Global <br>

## Known Risks and Mitigations: <br>
Risk: Selected spreadsheet contents and database metadata/sample values may be sent to asksql.ai without a clear consent step. <br>
Mitigation: Review before installing, use redacted test data or non-sensitive workbooks by default, and proceed with company, customer, HR, finance, or regulated data only after confirming that external transfer is acceptable. <br>
Risk: Generated semantic YAML may include misleading descriptions or mappings if source samples are incomplete or sensitive values bias the generated model. <br>
Mitigation: Review the generated YAML before using it in downstream text-to-SQL workflows, especially table, column, relationship, and access-control semantics. <br>


## Reference(s): <br>
- [Open Semantic Interchange Field Specification](references/open_semantic_interchange_description.md) <br>
- [AskSQL](https://www.asksql.ai) <br>
- [ClawHub skill page](https://clawhub.ai/asksqlai/database-semantic-generator) <br>


## Skill Output: <br>
**Output Type(s):** [Shell commands, Configuration, Files, Guidance] <br>
**Output Format:** [Markdown guidance with shell commands and generated YAML files] <br>
**Output Parameters:** [1D] <br>
**Other Properties Related to Output:** [Generates one semantic YAML file per requested topic after a discover-then-generate workflow.] <br>

## Skill Version(s): <br>
1.0.3 (source: server release metadata) <br>

## Ethical Considerations: <br>
Users should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment. <br>