create-sql-mappings

Generate or update SQL mappings for existing Stratio Governance views.

4|10|Updated Feb 20, 2026
One-click install
npx skills add https://github.com/Stratio/genai-agents --skill create-sql-mappings
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: create-sql-mappings
Source: https://github.com/Stratio/genai-agents/tree/main/shared-skills/create-sql-mappings
Command: npx skills add https://github.com/Stratio/genai-agents --skill create-sql-mappings

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Creates or updates SQL mappings for existing business views in Stratio Governance without recreating the views, preserving semantic terms and enabling focused corrections.

Core Features & Use Cases

  • Safe, selective mapping updates: update mappings for specific views or all views within a domain, without touching the view definitions.
  • Optional publication: publish affected Draft views after successful mappings to move them toward production.
  • Glossary instruction enrichment: generate or refine user_instructions from the data dictionary before invoking the mapping tool.

Quick Start

Specify the technical domain and target views, then run the skill to create or update SQL mappings without rebuilding the views.

Frequently Asked Questions about create-sql-mappings

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

FAQPage Schema
How do I update SQL mappings for existing views without recreating the view definitions?

To update SQL mappings without recreating views, specify the technical domain and target views to selectively overwrite only the SQL mappings while preserving the original view definitions and semantic terms.

Can I publish draft views directly after updating their SQL mappings?

Yes, you can publish affected Draft views directly after updating SQL mappings. The workflow supports optional publication of Draft views to move them toward production as an end-to-end process.

How does glossary enrichment work for SQL view mappings?

Glossary enrichment for SQL view mappings generates or refines user instructions from the data dictionary before invoking the mapping tool, ensuring semantic terms align with the governance semantic layer.

Do I need to define a technical domain before creating SQL mappings?

Yes, identifying the relevant technical domain is required before creating SQL mappings. The skill uses the domain to target specific views or all views within that domain for selective mapping updates.

What is the best way to correct SQL mappings for specific business views in a governance semantic layer?

The best way to correct SQL mappings in a governance semantic layer is to use selective mapping updates that overwrite only the SQL mappings for specific views, preserving existing semantic terms without touching view definitions.

Why are my SQL mapping updates not preserving the semantic terms in my views?

SQL mapping updates should preserve semantic terms by default. If terms are lost, verify that the glossary instruction enrichment is properly generating user instructions from the data dictionary before the mapping tool executes.