数据血缘代理技能

---
name: data-lineage-agent
description: 一项用于创建代理以分析数据库脚本和存储过程中数据血缘关系与关联性的技能。
---

# 数据血缘代理技能

## 目的
该技能有助于创建一个能够分析和报告数据库系统内数据血缘关系与关联性的代理。它非常适合用于理解表的更改如何影响整个系统，并帮助揭示不同平台之间的依赖关系。

## 创建代理的步骤
1. **访问代码仓库：**
   - GitHub 仓库链接：[GitHub Repo](https://github.com/optuminsight-payer/COB-PARS_DB_SCRIPTS)
   - 克隆该仓库以访问所有数据库脚本和存储过程。

2. **分析数据血缘：**
   - 使用工具解析 SQL 脚本，识别表之间的关系和依赖。
   - 绘制从源表到最终表的数据流图。

3. **识别变更影响：**
   - 实现逻辑以追踪中间表的变更，查看哪些最终表受到影响。
   - 使用图数据库或血缘分析工具进行更佳的可视化和影响评估。

4. **托管代理：**
   - 选择一个托管平台（例如 AWS、Azure）来部署代理，以实现持续分析和报告。

## 使用场景
- **影响分析：** 确定系统中任意表的更改所产生的影响。
- **数据流映射：** 可视化数据如何从源表流向最终表。
- **依赖报告：** 生成关于表依赖关系及受影响平台的报告。

## 附加功能
- **自动告警：** 当检测到潜在影响时通知用户。
- **版本控制集成：** 将变更链接到仓库中的特定提交，以实现可追溯性。

## 示例变量
- `{{repository_url}}`：GitHub 仓库的 URL。
- `{{platforms}}`：参与数据流的平台列表。

该技能为构建能够执行全面数据血缘分析的代理提供了结构化方法，在数据库管理和优化任务中可能至关重要。

---
name: data-lineage-agent
description: A skill for creating an agent to analyze data lineage and linkage across database scripts and stored procedures.
---

# Data Lineage Agent Skill

## Purpose
This skill assists in creating an agent that can analyze and report on the data lineage and linkage within a database system. It is ideal for understanding how changes to tables can affect the overall system and helps in uncovering the dependencies across different platforms.

## Steps to Create the Agent
1. **Access the Repository:**
   - Link to the GitHub repository: [GitHub Repo](https://github.com/optuminsight-payer/COB-PARS_DB_SCRIPTS)
   - Clone the repository to access all database scripts and stored procedures.

2. **Analyze Data Lineage:**
   - Use tools to parse SQL scripts to identify table relationships and dependencies.
   - Map out the data flow from source tables to final tables.

3. **Identify Changes Impact:**
   - Implement logic to trace changes in intermediate tables to see which final tables are affected.
   - Use graph databases or lineage analysis tools for better visualization and impact assessment.

4. **Host the Agent:**
   - Choose a hosting platform (e.g., AWS, Azure) to deploy the agent for continuous analysis and reporting.

## Use Cases
- **Impact Analysis:** Determine the impact of changes in any table across the system.
- **Data Flow Mapping:** Visualize how data moves through the system from source to final tables.
- **Dependency Reporting:** Generate reports on table dependencies and affected platforms.

## Additional Features
- **Automated Alerts:** Notify users when potential impacts are detected.
- **Version Control Integration:** Link changes to specific commits in the repository for traceability.

## Example Variables
- `{{repository_url}}`: The URL of the GitHub repository.
- `{{platforms}}`: List of platforms involved in the data flow.

This skill provides a structured approach to building an agent capable of comprehensive data lineage analysis, which can be crucial for database management and optimization tasks.