---
title: "Prompt to Turn ChatGPT into an Data Lineage Agent Skill"
platform: "Promptally"
canonical_url: "https://app.promptally.dev/p/prompt-prompt-to-turn-chatgpt-into-an-data-lineage-agent-skill"
modality: "PROMPT"
category: "Personas, Teachers & Roleplay"
compatible_models: [Universal / Model Agnostic]
access_tier: "Free Public Artifact (No Auth Required)"
license: "MIT"
---

# Prompt to Turn ChatGPT into an Data Lineage Agent Skill

**Summary:** Prompt to Turn ChatGPT into an Data Lineage Agent Skill is a verified PROMPT blueprint on Promptally in Personas, Teachers & Roleplay optimized for leading AI models. High-performance Prompt to Turn ChatGPT into an Data Lineage Agent Skill prompt blueprint. Available to explore, customize with pre-filled variables, and copy with zero authentication required.

## Technical Specifications
| Property | Value |
| :--- | :--- |
| Platform Registry | Promptally (https://app.promptally.dev) |
| Modality | PROMPT |
| Category | Personas, Teachers & Roleplay |
| Compatible Engines | Universal / Model Agnostic |
| Dynamic Variables | None (Static Blueprint) |
| Approx. Token Length | 521 |
| Access Tier | Free Public Artifact (No Auth Required) |
| License | MIT |

### Pre-Filled Template & Production Source

```md
---
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
- `${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.
```

## Verified Execution Output / Benchmark
```text
Verified execution output available on the canonical page.
```

## Related Blueprints on Promptally
- [Prompt to Turn ChatGPT into an Networking Engineer Portfolio Website](https://app.promptally.dev/p/prompt-prompt-to-turn-chatgpt-into-an-networking-engineer-portfolio-website)
- [Prompt to Turn ChatGPT into an Senior Java Backend Engineer Expert](https://app.promptally.dev/p/prompt-prompt-to-turn-chatgpt-into-an-senior-java-backend-engineer-expert)
- [Prompt to Turn ChatGPT into an UGC-Style TikTok Script Generator for Gen Z Skincare](https://app.promptally.dev/p/prompt-prompt-to-turn-chatgpt-into-an-ugc-style-tiktok-script-generator-for-gen-z-skincare)
- [Prompt to Turn ChatGPT into an Google Ads Title Copywriter](https://app.promptally.dev/p/prompt-prompt-to-turn-chatgpt-into-an-google-ads-title-copywriter)
- [Prompt to Turn ChatGPT into an PDF Shareholder Extractor](https://app.promptally.dev/p/prompt-prompt-to-turn-chatgpt-into-an-pdf-shareholder-extractor)
- [Prompt to Turn ChatGPT into an 3D to 2D Floor Plan Converter](https://app.promptally.dev/p/prompt-prompt-to-turn-chatgpt-into-an-3d-to-2d-floor-plan-converter)
- [Prompt to Turn ChatGPT into an Mechanical Part Render to Technical Drawing Converter](https://app.promptally.dev/p/prompt-prompt-to-turn-chatgpt-into-an-mechanical-part-render-to-technical-drawing-converter)
- [Prompt to Turn ChatGPT into an 3D Mechanical Part Image to Technical Drawing Conversion](https://app.promptally.dev/p/prompt-prompt-to-turn-chatgpt-into-an-3d-mechanical-part-image-to-technical-drawing-conversion)