database-inventory

Compare documented database inventories with live AWS environments and update the inventory file.

2|1|Updated Feb 8, 2021
One-click install
npx skills add https://github.com/jstoobz/dotfiles --skill database-inventory
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-inventory
Source: https://github.com/jstoobz/dotfiles/tree/main/claude/skills/infrastructure/database-inventory
Command: npx skills add https://github.com/jstoobz/dotfiles --skill database-inventory

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps teams maintain a living documentation of databases across AWS environments, ensuring the documented state matches live configurations and minimizing drift.

Core Features & Use Cases

  • Maintain and update a centralized documentation of databases across QA, UAT, and Production environments.
  • Compare documented inventories with live databases, track additions and removals, and generate up-to-date reports.
  • Use cases include audits after environment changes, onboarding new environments, and generating consolidated database documentation.

Quick Start

Load the current inventory and begin the refresh workflow to populate the inventory file with the latest databases from QA, UAT, and Production. Always review diffs before committing updates.

Frequently Asked Questions about database-inventory

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

FAQPage Schema
How do I keep AWS database inventory documentation synced with live environments?

You can sync AWS database inventory by loading the current documented state, fetching live database lists across QA, UAT, and Production environments, comparing the two, and updating the inventory file to eliminate configuration drift.

What is database drift and how do I audit it after AWS environment changes?

Database drift happens when live AWS configurations diverge from documented state. Audit it by comparing your current inventory file against a freshly fetched list of live databases to track additions and removals and generate up-to-date reports.

Can I compare QA, UAT, and Production databases using a centralized inventory?

Yes, you can compare QA, UAT, and Production databases by maintaining a centralized documentation file. The workflow fetches live lists from each environment, compares them with documented state, and highlights additions or removals across all environments.

How do I onboard a new AWS environment into an existing database inventory?

To onboard a new AWS environment into your database inventory, load the current inventory file and execute the refresh workflow. This fetches live databases from the new environment, compares them against existing documentation, and updates the inventory file accordingly.

What is the best way to generate up-to-date reports for AWS database audits?

The best way to generate up-to-date AWS database audit reports is to run an inventory refresh workflow that fetches live database lists, compares them with documented state, and outputs diff results for review before committing updates.