Data Governance Skill for Openclaw

A comprehensive toolset for managing data quality, metadata, and compliance across multiple database environments.

xingjianliu0417
v1.10.1
Mar 26, 2026
1
1.2k
0

Install & Download

1. ClawHub CLI

The fastest way to install a skill directly from the registry.

npx clawhub@latest install data-governance

2. Manual Installation

Copy the skill folder to one of these locations

Global
~/.openclaw/skills/
Workspace
<project>/skills/

Priority: Workspace > Local > Bundled

3. Prompt Installation

Copy this prompt to OpenClaw to install it automatically.

Help me install data-governance using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).

Prefer to download?

Get the raw skill files in a ZIP archive.

What is Data Governance Skill?

The Data Governance skill provides a robust framework for exercising authority and control over organizational data assets. It is specifically designed to facilitate tasks such as data quality assessment, metadata management, data lineage tracking, and compliance audits. By leveraging this skill within Openclaw Skills, teams can ensure their data remains accurate, consistent, and secure while maintaining high standards for privacy protection.

This utility acts as a bridge between raw database operations and high-level asset management. It supports a variety of database engines through a unified abstraction layer, allowing for standardized governance workflows regardless of whether the underlying storage is MySQL, PostgreSQL, or SQLite.

Data Governance Skill Use Cases

  • Assessing the completeness and accuracy of production datasets.
  • Generating automated data dictionaries and technical metadata catalogs.
  • Performing lineage analysis to understand how data flows and transforms between systems.
  • Conducting compliance checks to identify sensitive data or security risks.
  • Standardizing naming conventions and data types across enterprise databases.

How Data Governance Skill Works

  1. Configure secure access to target databases using environment variables to maintain credential safety.
  2. Execute specific governance scripts to perform tasks like quality checks, metadata extraction, or lineage analysis.
  3. The skill utilizes SQLAlchemy and Pandas to interact with the database and process the retrieved records according to predefined business rules.
  4. Analytical results are synthesized into a structured markdown report covering quality metrics, found issues, and technical metadata.
  5. The workflow concludes with actionable suggestions to improve the overall data health and governance posture.

Data Governance Skill Setup

To start using this skill in your Openclaw Skills environment, follow these steps:

  1. Install the required Python dependencies:
# Create and activate a virtual environment
python3 -m venv venv
source venv/bin/activate

# Install required libraries
pip install -r requirements.txt
  1. Configure your database credentials via environment variables:
# Example for MySQL
export DB_HOST=localhost
export DB_PORT=3306
export DB_USER=your_user
export DB_PASS=your_password
export DB_NAME=your_database
  1. Run a governance task (e.g., a data quality check):
python scripts/data_quality_check.py --table users --db-type mysql

Data Governance Skill Data Schema & Taxonomy

The skill organizes governance data into the following schema and output structures:

Data Category Key Metrics / Metadata Description
Data Quality Completeness, Accuracy, Consistency Quantitative assessment of record health.
Technical Metadata Table structure, Field types, Sources Schema-level details extracted from the DB.
Business Metadata Definitions, Rules, Owners The contextual meaning and usage of the data.
Operational Metadata Update frequency, ETL info Logs and statistics regarding data movement.
Lineage Source-to-target paths Tracing of transformations and downstream impacts.

Data Governance Skill Advanced Features

  • Multi-engine support for MySQL, PostgreSQL, and SQLite via SQLAlchemy 2.0.
  • Automated data masking for sensitive information during report sharing.
  • Deep lineage analysis covering source tracing, transformation tracking, and downstream impact assessment.
  • Customizable business rule validation to enforce organization-specific data standards.
  • Integration-ready structured reporting for automated governance documentation.

SKILL.md


Loading

Related Openclaw Skills

METADATA

Github Stars: 0
forks: 0

Featured*