database-engineering

Examples of my Claude Code infrastructure with skill auto-activation, hooks, and agents

Category: discovered
Tags: github, community
Version: 1.0.0
Author: walid
Downloads: 0
GitHub stars: 2
Updated: 2025-11-21

Source: weirdgme/Claude-code-infrastructure-showcase

Download the latest version (v1.0.0) from this page.

SKILL.md

# Database Engineering

Guide to PostgreSQL/MySQL administration, query optimization, indexing, replication, and database best practices.

**Note:** This is a foundational version. Community contributions welcome to expand coverage!

## Purpose

Enable teams to effectively manage, optimize, and scale relational databases.

## When to Use This Skill

Automatically activates when working on:
- Database administration
- Query optimization and EXPLAIN plans
- Index design and tuning
- Database replication setup
- Backup and restore procedures
- Database migrations
- PostgreSQL or MySQL configuration

## Quick Start Checklist

- [ ] Set up database monitoring
- [ ] Configure automated backups
- [ ] Create indexes for slow queries
- [ ] Set up replication (if needed)
- [ ] Configure connection pooling
- [ ] Review query performance regularly
- [ ] Plan migration strategy

## Resource Files

- **[postgresql-fundamentals.md](resources/postgresql-fundamentals.md)** - PostgreSQL basics, configuration, extensions
- **[query-optimization.md](resources/query-optimization.md)** - EXPLAIN, indexing strategies, query tuning
- **[database-replication.md](resources/database-replication.md)** - Streaming, logical replication, conflict resolution
- **[backup-and-recovery.md](resources/backup-and-recovery.md)** - pg_dump, point-in-time recovery, backup strategies

## Best Practices

✅ Monitor slow queries
✅ Index strategically
✅ Use connection pooling
✅ Regular backups with testing
✅ Replication for high availability
✅ Optimize for read vs write patterns

## Integration Points

- **backend-dev-guidelines**: ORM usage (Prisma)
- **sre**: Database monitoring
- **cloud-engineering**: Managed databases (RDS, Aurora)

---
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
🎯 SKILL ACTIVATED: database-engineering
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━


**Total Resources:** 4 foundational guides (community can expand!)
**Status:** Basic coverage - contributions welcome