database-performance
CommunityDatabase optimization, indexing, caching patterns.
Authoromanjaya
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Slow queries and poor database design hinder application performance. This Skill provides practical guidance on schema design, indexing strategies, and caching patterns to accelerate data access.
Core Features & Use Cases
- Index Strategies: Single, composite, covering, and unique constraints to speed lookups.
- Query Optimization: Avoid N+1 queries, select only needed columns, and use chunking for large datasets.
- Caching Patterns: Cache expensive queries and dashboard data to reduce load.
Quick Start
Add a composite index on (department_id, status) and fetch active employees with pagination, while enabling query caching for the result.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: database-performance Download link: https://github.com/omanjaya/attendancedev/archive/main.zip#database-performance Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.