jeremylongshore/tons-of-skills-marketplace / plugins/database/database-cache-layer/skills/implementing-database-caching
implementing-database-caching
VerifiedProcess use when you need to implement multi-tier caching to improve database performance. This skill sets up Redis, in-memory caching, and CDN layers to reduce database load. Trigger with phrases like "implement database caching", "add Redis cache layer", "improve query performance with caching", or "reduce database load".
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 7.2 KB |
| assets/README.md | markdown | 136 B |
| references/README.md | markdown | 63 B |
| scripts/README.md | markdown | 339 B |
| scripts/redis_setup.pyexecutable | script | 2.5 KB |
scripts/redis_setup.py
View on GitHub#!/usr/bin/env python3
"""
database-cache-layer - Initialization Script
Automates Redis installation and configuration.
Generated: 2025-12-10 03:48:17
"""
import json
import argparse
from pathlib import Path
def create_project_structure(project_name: str, output_dir: str = "."):
"""Create project structure for database-cache-layer."""
base_path = Path(output_dir) / project_name
# Create directories
directories = [base_path, base_path / "config", base_path / "data", base_path / "output", base_path / "logs"]
for dir_path in directories:
dir_path.mkdir(parents=True, exist_ok=True)
print(f"✓ Created {dir_path}")
# Create configuration file
config = {
"project": project_name,
"version": "1.0.0",
"skill": "database-cache-layer",
"category": "database",
"created": time.strftime("%Y-%m-%d %H:%M:%S"),
"settings": {"debug": False, "verbose": True, "max_workers": 4},
}
config_file = base_path / "config" / "settings.json"
with open(config_file, "w") as f:
json.dump(config, f, indent=2)
print(f"✓ Created configuration: {config_file}")
# Create README
readme_content = f"""# {project_name}
Initialized with database-cache-layer skill
## Structure
- config/ - Configuration files
- data/ - Input data
- output/ - Generated output
- logs/ - Application logs
## Usage
See skill documentation for usage instructions.
"""
readme_file = base_path / "README.md"
readme_file.write_text(readme_content)
print(f"✓ Created README: {readme_file}")
return base_path
def main():
parser = argparse.ArgumentParser(description="Automates Redis installation and configuration.")
parser.add_argument("--project", "-p", required=True, help="Project name")
parser.add_argument("--output", "-o", default=".", help="Output directory")
parser.add_argument("--config", "-c", help="Configuration file")
args = parser.parse_args()
print(f"🚀 Initializing {args.project}...")
project_path = create_project_structure(args.project, args.output)
if args.config:
# Load additional configuration
if Path(args.config).exists():
with open(args.config) as f:
json.load(f)
print(f"✓ Loaded configuration from {args.config}")
print(f"\n✅ Project initialized successfully at {project_path}")
return 0
if __name__ == "__main__":
import sys
import time
sys.exit(main())
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |