skills.rest
oehm-smith
oehm-smithCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/oehm-smith/linux-env --skill data-engineer-oehm-smith
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
ricardocidalericardocidale

database-environments

Manages PostgreSQL environments for development and production with Drizzle ORM schema migrations and data syncing.

Community
Intermediate
fabiomilennials1234-a11yfabiomilennials1234-a11y

agent-dba

Model PostgreSQL schemas, migrations, and RLS policies for multi-tenant applications.

Community
Advanced
t-stringst-strings

Backend Migrations

Standardize versioned database migration scripts with rollback support and execution logs.

Official
Basic
victorzhukvictorzhuk

go-migration

Design and implement PostgreSQL schema and data migrations for Go applications.

Community
Advanced