skills.rest
ahmedemad3
ahmedemad3COMMUNITY
Explore all skills by this author →
GitHub

database-principal-authority

Define database architectures and generate SCHEMA.sql, SEED_DATA.sql, and data-model.md.

60|12|Updated Apr 2, 2026
Search Tags:#architecture#performance#database#schema#migration#sql
One-click install
npx skills add https://github.com/ahmedemad3/super-ai-agency-framework --skill database-principal-authority
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-principal-authority
Source: https://github.com/ahmedemad3/super-ai-agency-framework/tree/main/.agent/skills/DBA-skill
Command: npx skills add https://github.com/ahmedemad3/super-ai-agency-framework --skill database-principal-authority

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps organizations design scalable, production-ready database architectures by combining architectural strategy with hands-on DBA execution to deliver complete schema, data, and governance artifacts.

Core Features & Use Cases

  • End-to-end database architecture: technology selection, modeling, indexing, migration planning, and governance.
  • Deliverables automation: SCHEMA.sql, SEED_DATA.sql, and data-model.md generation with migration plans.
  • Use Case: Greenfield projects requiring scalable schema and zero-downtime migrations.

Quick Start

Design a full database architecture and generate end-to-end deliverables (SCHEMA.sql, SEED_DATA.sql, and data-model.md) for a scalable production system.

Frequently Asked Questions about database-principal-authority

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

FAQPage Schema
How do I design a scalable database architecture for a greenfield production system?▼

A complete database architecture defines schemas, indexes, and governance policies from strategy to production. It generates concrete deliverables like SCHEMA.sql, SEED_DATA.sql, and data-model.md to ensure scalable and maintainable data structures.

What is the best way to plan zero-downtime database migrations?▼

Planning zero-downtime database migrations requires combining architectural strategy with DBA execution. It involves generating comprehensive migration plans and performance validations to re-architect systems without disrupting production availability.

How do I generate schema and seed data files for a new database project?▼

Generating schema and seed data files requires defining data models and architectural governance. The process automates the creation of SCHEMA.sql and SEED_DATA.sql, providing the exact SQL artifacts needed to deploy and initialize production databases.

Can I use this approach to re-architect an existing database schema?▼

Yes, database re-architecture applies to existing systems by evaluating technology selection and data modeling. It delivers migration strategies and performance validations to safely transition legacy schemas to robust, scalable production designs.

What artifacts do I need to enforce database governance and performance?▼

Enforcing database governance and performance requires data-model.md documentation alongside SCHEMA.sql and SEED_DATA.sql. These artifacts establish indexing rules, migration plans, and architectural standards to maintain system integrity.

Related Skills

Explore More Software Engineering Skills→
akillnessakillness
40

database-schema-design

Define and optimize relational and NoSQL database schemas with entities, relationships, normalization, indexing, constraints, and migrations.

Community
Advanced
vecearvecear

migration-planner

Plan and execute phased migrations with validation and rollback procedures.

Community
Advanced
JesusFigueroa25JesusFigueroa25

DevOps Automator

Automate DevOps processes with Terraform, GitHub Actions, and Kubernetes.

Community
Advanced
carson-sweetcarson-sweet
6

design-data-model

Design database schemas with entities, relationships, constraints, and migration strategies.

Community
Advanced