Skills
.Work. You
Rest

agent-dba

Community

PostgreSQL mastery: modeling, migrations, RLS.

Software Engineering#database#postgresql#migrations#rls#data-integrity#query-optimization
Authorfabiomilennials1234-a11y
Version1.0.0
Installs0

System Documentation

What problem does it solve?

The skill addresses the need for robust PostgreSQL governance by providing structured guidance on schema design, migrations, and Row-Level Security in multi-tenant environments, ensuring data integrity and predictable performance.

Core Features & Use Cases

  • PostgreSQL core modeling: relational design, constraints, data types, and index strategies
  • Row-Level Security: policies by operation, organization_id boundaries, jwt/auth claims considerations
  • Migrations: zero-downtime changes with reversible up/down, data vs schema separation
  • Performance: EXPLAIN ANALYZE usage, indexing decisions, and query optimization
  • Automation: pg_cron, triggers, functions, and maintenance routines
  • Use Case: applies to SaaS platforms needing strict data isolation and auditable schema changes

Quick Start

Audit your PostgreSQL schema and RLS policies and implement a safe, zero-downtime migration to bootstrap multi-tenant data access.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: agent-dba
Download link: https://github.com/fabiomilennials1234-a11y/v8milennialsb2bv2/archive/main.zip#agent-dba

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.