prompts.chatprompts.chatprompts.chat
BotsPromptsSkillsWorkflowsCategoriesTagsPromptmastersTaste
BookFor KidsDevelopers
Login
CC0 2026 prompts.chat
DeepWikiHow to...DocsAPIPrivacyTermsSupportAboutGitHub

Data Lineage Agent Skill

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

J
@ajillell_uhg
6 months agoApril 29, 2026 at 04:31 AM
Agent Skill•AgentData AnalysisAutomationBusiness
Database

Content

Variables
--- 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 - ``: The URL of the GitHub repository. - ``: 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.

Comments (0)

Related Skills

trello-integration-skill

Skill

This skill allows you to interact with Trello account to list boards, view lists, and create cards automatically.

M@mertogemini
0

Supabase Principal Architect Infrastructure Optimization

Skill

Act as a Supabase Principal Architect. Build and optimize a production-ready Postgres/Edge infrastructure. Your responsibilities include running pg_cron for auditing schemas, addressing RLS alignment gaps, eliminating unused indexes, and auto-generating target indexing definitions. Additionally, construct real-time broadcast tables for tracking states across OpenHands, Obsidian storage pipelines, Hermes, KAI9000, LangGraph, and GitHub workflows. Deploy Edge Functions to manage dynamic webhooks f

S@samhiotis
0

Agent Organization Expert

Skill

Multi-agent orchestration skill for team assembly, task decomposition, workflow optimization, and coordination strategies to achieve optimal team performance and resource utilization.

İ@izzetemre
1

Unity Architecture Specialist

Skill

A Claude Code agent skill for Unity game developers. Provides expert-level architectural planning, system design, refactoring guidance, and implementation roadmaps with concrete C# code signatures. Covers ScriptableObject architectures, assembly definitions, dependency injection, scene management, and performance-conscious design patterns.

M@metehanyengil
1

Related Bots

ML Experiment Watcher

Watches your training runs: summarises loss curves and metrics, detects divergence, NaNs and stalled GPUs early, and writes a comparison when runs finish.

@f1 scheduled routine1 event trigger0

Dashboard Narrator

Turns your dashboard numbers into a short weekly story of what changed and why.

@f1 scheduled routine0

Price Drop Hunter

Watches the products, flights or listings you care about, keeps a price history, and pings you only when the price falls below your target or hits a 90-day low.

@f1 scheduled routine0

Support Inbox Triage

Sorts your customer support inbox by urgency, groups repeat questions, drafts answers from your docs, and sends a daily summary of the top issues customers are hitting.

@f1 scheduled routine1 event trigger0