中文译文
数据血缘智能体技能
用途
本技能协助创建一个能够分析和报告数据库系统内数据血缘与关联关系的智能体。它非常适合用于理解对表的更改如何影响整个系统，并有助于揭示跨不同平台的依赖关系。
创建智能体的步骤
访问代码仓库：
- GitHub 仓库链接：GitHub Repo
- 克隆该仓库以访问所有数据库脚本和存储过程。
分析数据血缘：
- 使用工具解析 SQL 脚本，以识别表关系和依赖关系。
- 绘制从源表到最终表的数据流。
识别变更影响：
- 实现逻辑以追踪中间表的变更，查看哪些最终表会受到影响。
- 使用图数据库或血缘分析工具，以获得更好的可视化和影响评估。
托管智能体：
- 选择托管平台（例如 AWS、Azure）来部署该智能体，以进行持续分析和报告。
使用场景
- 影响分析： 确定系统中任何表的变更所造成的影响。
- 数据流映射： 可视化数据如何从源表流经系统到达最终表。
- 依赖关系报告： 生成关于表依赖关系和受影响平台的报告。
附加功能
- 自动告警： 当检测到潜在影响时通知用户。
- 版本控制集成： 将变更关联到仓库中的特定提交，以实现可追溯性。
示例变量
${repositoryUrl}：GitHub 仓库的 URL。${platforms}：数据流中涉及的平台列表。
本技能提供了一种结构化方法来构建能够进行全面数据血缘分析的智能体，这对于数据库管理和优化任务至关重要。
English original
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
Access the Repository:
- Link to the GitHub repository: GitHub Repo
- Clone the repository to access all database scripts and stored procedures.
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.
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.
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
${repositoryUrl}: 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.