skills.rest
fabiolpgomes
fabiolpgomesCOMMUNITY
Explore all skills by this author →
Website𝕏@fabiolpgomesGitHub

aiox-data-engineer

Architect PostgreSQL and Supabase schemas with migrations, RLS policies, and query tuning workflows.

Updated Apr 16, 2026
Search Tags:#architecture#performance#database#postgresql#migrations#rls#supabase
One-click install
npx skills add https://github.com/fabiolpgomes/lodgra --skill aiox-data-engineer-fabiolpgomes
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: aiox-data-engineer
Source: https://github.com/fabiolpgomes/lodgra/tree/main/.agents/skills/AIOX/agents/data-engineer
Command: npx skills add https://github.com/fabiolpgomes/lodgra --skill aiox-data-engineer-fabiolpgomes

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill addresses the complexity of managing database lifecycles, ensuring that schema design, security policies, and performance tuning are handled with professional-grade rigor and safety.

Core Features & Use Cases

  • Database Lifecycle Management: Provides a structured approach to schema design, migration planning, and version-controlled database operations.
  • Security & Performance: Includes automated security audits for RLS policies and performance analysis for query optimization.
  • Use Case: When scaling a Supabase project, use this Skill to design a secure RLS policy, run a dry-run migration to prevent downtime, and audit the schema for potential performance bottlenecks.

Quick Start

Activate the data-engineer skill to begin a domain modeling session for your new database schema.

Frequently Asked Questions about aiox-data-engineer

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

FAQPage Schema
How do I design and manage PostgreSQL database migrations safely?▼

PostgreSQL database migrations are managed through structured schema design and version-controlled operations. This approach supports dry-run migrations to prevent downtime and enforces idempotency for safe, repeatable schema deployments.

What is the best way to enforce Row Level Security policies in Supabase?▼

Row Level Security policies in Supabase are enforced through automated security audits. This mechanism evaluates schema designs to ensure security-first policy enforcement and prevents unauthorized data access across your database environment.

How do I optimize slow PostgreSQL queries in a production environment?▼

PostgreSQL query performance is optimized through automated performance analysis. This process audits your schema for potential bottlenecks and applies query tuning to improve operational efficiency in production systems.

Can I run a dry-run database migration to prevent Supabase downtime?▼

Yes, you can run dry-run database migrations to prevent downtime. This capability allows you to validate schema changes and RLS policies safely before applying them to your live Supabase production environment.

What is needed to start a domain modeling session for a new database schema?▼

To start a domain modeling session for a new database schema, you need to activate the data-engineer capability. This initiates a structured approach to architect your schema, plan migrations, and define security policies.

Related Skills

Explore More Software Engineering Skills→
bughqbughq
2

stacks-orm

Define database models and execute queries with Stacks ORM.

Official
Advanced
jeremylongshorejeremylongshore
2.6k

monitoring-database-health

Monitor PostgreSQL and MySQL database health with real-time metrics and alerts.

Community
Advanced
rodrigo-altissimorodrigo-altissimo

aiox-data-engineer

Design Supabase and PostgreSQL schemas with RLS policies and safe migrations.

Community
Advanced
4lerman4lerman

sql-database-assistant

Generate SQL queries, introspect schemas, optimize performance, and create migration scripts.

Community
Advanced