skills.rest
cyanluna-git
cyanluna-gitCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

migrate-worklogs

Migrate CSV worklog backups into PostgreSQL with deduplication and dry-run modes.

Updated Dec 10, 2025
Search Tags:#ETL#PostgreSQL#CSV#migrate#worklog#semantic-mapping
One-click install
npx skills add https://github.com/cyanluna-git/edwards.reousrce.management --skill migrate-worklogs
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: migrate-worklogs
Source: https://github.com/cyanluna-git/edwards.reousrce.management/tree/main/.claude/skills/migrate-worklogs
Command: npx skills add https://github.com/cyanluna-git/edwards.reousrce.management --skill migrate-worklogs

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

CSV backups contain historical worklog data that must be migrated into the target PostgreSQL database without duplicating existing records, while preserving data integrity and enabling traceability.

Core Features & Use Cases

  • Semantic mapping of User, Project, and WorkType to ensure accurate associations during migration.
  • Date-range filtering for incremental updates and reproducible runs.
  • Dry-run and execute modes to validate the migration plan before applying changes.

Quick Start

Use the migrate-worklogs skill to analyze and migrate a subset of CSV worklogs. Examples: /migrate-worklogs -7d --dry-run /migrate-worklogs -1d --execute /migrate-worklogs -20d

Frequently Asked Questions about migrate-worklogs

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I migrate worklog data from a CSV backup into PostgreSQL without duplicating records?▼

You can migrate worklog data from a CSV backup into PostgreSQL by using a pipeline that applies semantic mapping for User, Project, and WorkType. This process enables deduplication and ensures auditable results within a specified date range.

What is semantic mapping in CSV to PostgreSQL worklog migration?▼

Semantic mapping in CSV worklog migration infers relationships for User, Project, and WorkType fields. It ensures accurate associations in PostgreSQL, preventing duplicate entries and maintaining data integrity during the transfer.

Can I validate a CSV worklog migration before applying changes to PostgreSQL?▼

Yes, you can validate a CSV worklog migration before applying changes to PostgreSQL by using a configurable dry-run mode. This allows you to analyze and verify the migration plan safely without modifying the target database.

How do I perform an incremental worklog migration for a specific date range?▼

You can perform an incremental worklog migration for a specific date range by applying date-range filters to your CSV data. This ensures only new or updated records within the specified period are processed and migrated.

Does the CSV to PostgreSQL worklog migration pipeline support reproducible runs?▼

Yes, the CSV to PostgreSQL worklog migration pipeline supports reproducible runs. By combining date-range filtering with semantic mapping and dry-run validation, it ensures safe, consistent, and auditable migration outcomes every time.

Related Skills

Explore More Data & Analytics Skills→
GDSDNGDSDN
3

db-snapshot

Generate schema-only SQL snapshots from PostgreSQL databases using pg_dump.

Community
Advanced
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
bobmatnycbobmatnyc
3

pydantic

Validate Python data models with Pydantic v2 runtime type checking.

Community
Intermediate
FalkorDBFalkorDB
22

Use Bulk Loader from CSV

Load CSV files into FalkorDB graph databases using the bulk loader utility.

Official
Intermediate