Data Engineer

Automate PostgreSQL migrations, RLS policies, and data transformations with reversible scripts.

1|Updated Jul 8, 2016

Search Tags:#security #database #postgresql #migrations #rls #data-transformation

Ready to run

npx skills add https://github.com/oehm-smith/linux-env --skill data-engineer-oehm-smith

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Data Engineer
Source: https://github.com/oehm-smith/linux-env/tree/main/HOME/.claude/skills/lifecycle/sustainment/migrations
Command: npx skills add https://github.com/oehm-smith/linux-env --skill data-engineer-oehm-smith

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Data Engineers need a repeatable workflow to apply and rollback database migrations, implement RLS policies, and perform data transformations safely.

Core Features & Use Cases

Migration scripting: generate, organize, and apply reversible migrations with up and down scripts.
RLS policy automation: define and enforce row-level security across multi-tenant schemas.
Data transformation support: prepare and transform data as part of schema changes.
Indexing guidance: propose and apply indexing strategies to optimize queries.

Quick Start

Run the Data Engineer workflow to generate a new migration, apply it in a staging environment, and validate reversible changes with the accompanying DOWN migration.

Frequently Asked Questions about Data Engineer

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

FAQPage Schema

How do I automate PostgreSQL migrations and ensure they are reversible?▼

Automate PostgreSQL migrations by generating organized up and down scripts, allowing you to apply schema changes and safely rollback reversible migrations across staging and production environments.

What is the best way to implement row-level security for multi-tenant PostgreSQL schemas?▼

Implement row-level security (RLS) by defining and enforcing policies across multi-tenant schemas, ensuring secure data access controls are systematically applied during your database migration workflow.

How do I handle data transformations during database schema changes?▼

Handle data transformations by preparing and transforming data as an integrated step within your schema migration scripts, ensuring data structure remains consistent across development and production environments.

Can I generate indexing strategies alongside my database migration scripts?▼

Yes, you can generate and apply indexing strategies alongside database migration scripts, proposing optimized indexes to improve query performance as part of the comprehensive migration artifacts.

Does this database migration workflow support multi-environment deployments from staging to production?▼

Yes, the database migration workflow supports multi-environment deployments, allowing you to systematically apply migrations, RLS policies, and data pipelines across development, staging, and production environments.