agentsclimarketplace

Legacy database heavy system

Skill jukrap/ai-agent-playbook/skills/legacy/legacy-database-heavy-system

Reusable AI agent skills, project templates, and guardrails for safer software maintenance and delivery.

Install
npx -y skills add jukrap/ai-agent-playbook --skill legacy-database-heavy-system

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • 2 stars2 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

Use when maintaining legacy systems where business rules live in stored procedures, triggers, views, direct SQL, scheduled jobs, or database-shaped contracts.

SKILL.md

1.2 KB, 197 tokens by cl100k_base, as published. Nobody here has run it

Legacy Database Heavy System

Treat the database as active application code, not passive storage.

Workflow

  1. Identify tables, views, stored procedures, triggers, jobs, and direct SQL call sites involved in the change.
  2. Trace both application code and database-side behavior before editing.
  3. Check transaction boundaries, locking, isolation, rollback behavior, and batch volume.
  4. Preserve existing data shape unless migration and compatibility are explicit.
  5. Verify with representative data and a rollback path.

Guardrails

  • Do not rename columns, change procedure parameters, or alter result sets without checking every caller.
  • Do not assume ORM models capture all database behavior.
  • Do not treat trigger side effects as invisible implementation details.
  • Record schema, migration, data backfill, and operational risks in PR/worklog.

Reference

Read references/database-coupling-map.md before changing stored procedures, triggers, views, jobs, result sets, or database-shaped contracts.

What ships with it: 2 files

2.0 KB alongside SKILL.md

agents/

references/

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.