skills.rest
LeoTechPro
LeoTechProCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

dba-role

Review database schema changes and migration scripts before deployment.

1|Updated Nov 13, 2023
Search Tags:#performance#security#database#postgresql#migrations#schema#dba
One-click install
npx skills add https://github.com/LeoTechPro/intTools --skill dba-role
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dba-role
Source: https://github.com/LeoTechPro/intTools/tree/main/codex/assets/codex-home/skills/dba-role
Command: npx skills add https://github.com/LeoTechPro/intTools --skill dba-role

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill ensures the security, integrity, and performance of database schemas and migrations, preventing data loss and performance degradation.

Core Features & Use Cases

  • Schema & Migration Review: Analyzes database schema changes and migration scripts for potential issues.
  • Performance & Security Audits: Validates indexes, RLS/ACL policies, and query plans.
  • Use Case: Before deploying new features, the DBA role reviews all proposed database migrations to ensure they are safe, efficient, and do not introduce performance bottlenecks or security vulnerabilities.

Quick Start

Use the dba-role skill to review new database migrations for the backend project.

Frequently Asked Questions about dba-role

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

FAQPage Schema
How do I review database migrations for security and performance issues?▼

Review database migrations by analyzing schema changes, constraints, indexes, and query plans to ensure data integrity, access control, and performance. Enforcing migration review acts as a critical gate before deployment to prevent bottlenecks and data loss.

What does a database schema security audit include?▼

A database schema security audit validates indexes, Row Level Security (RLS), and Access Control List (ACL) policies. This verifies data integrity and access control while identifying potential security vulnerabilities before deployment.

How do I validate PostgreSQL query performance before deploying schema changes?▼

Validate PostgreSQL query performance by reviewing proposed schema migrations and analyzing query plans. This detects inefficient constraints or indexes that could introduce performance bottlenecks and degrade database responsiveness.

When do I need to enforce a database migration review gate?▼

You need to enforce a database migration review gate before deploying new backend features. This verifies proposed schema changes are safe, efficient, and do not introduce performance bottlenecks or security vulnerabilities.

Can I use this approach to optimize existing database indexes and constraints?▼

Yes, you can optimize existing database indexes and constraints by running performance audits. This evaluates current query plans and schema definitions to validate efficiency and ensure data integrity is maintained.

Related Skills

Explore More Software Engineering Skills→
mDevsLabsmDevsLabs
1

db-migrations

Generate and validate idempotent Drizzle database migration scripts.

Community
Intermediate
dige04dige04

databases

Analyze and optimize MongoDB and PostgreSQL performance across production workloads.

Community
Intermediate
Adelie-SquadAdelie-Squad
17

backend-engineer

Develop REST and GraphQL API endpoints in Node.js and TypeScript.

Official
Advanced
wshobsonwshobson
38.6k

gitlab-ci-patterns

Generate GitLab CI/CD pipeline configurations for automated testing, building, and deployment.

Community
Advanced