Specification
- Skill ID
- aj-geddes/useful-ai-prompts/query-caching-strategies
- Publisher
- aj-geddes
- Repository
- useful-ai-prompts
- Installs
- 0
- Files
- 9
- Synced
- Sep 23, 2026
How to use it
Open any RiverX project, open the Skills panel in the chat, and search for this identifier. The files are fetched from the source repository at install time.
aj-geddes/useful-ai-prompts/query-caching-strategiesInstalls these files- SKILL.md
- references/event-based-invalidation.md
- references/memcached-caching.md
- references/mysql-query-cache.md
- references/postgresql-query-cache.md
- references/redis-caching-with-postgresql.md
- references/time-based-invalidation.md
- scripts/validate-schema.sh
- templates/migration-template.sql
What this skill tells the agent
Query Caching Strategies
Table of Contents
- Overview
- When to Use
- Quick Start
- Reference Guides
- Best Practices
Overview
Implement multi-level caching strategies using Redis, Memcached, and database-level caching. Covers cache invalidation, TTL strategies, and cache warming patterns.
When to Use
- Query result caching
- High-read workload optimization
- Reducing database load
- Improving response time
- Cache layer selection
- Cache invalidation patterns
- Distributed cache setup
Quick Start
Minimal working example:
// Node.js example with Redis
const redis = require("redis");
const client = redis.createClient({
host: "localhost",
port: 6379,
db: 0,
});
// Get user with caching
async function getUser(userId) {
const cacheKey = `user:${userId}`;
// Check cache
const cached = await client.get(cacheKey);
if (cached) return JSON.parse(cached);
// Query database
const user = await db.query("SELECT * FROM users WHERE id = $1", [userId]);
// Cache result (TTL: 1 hour)
await client.setex(cacheKey, 3600, JSON.stringify(user));
return user;
}
// Cache warming on startup
// ... (see reference guides for full implementation)Reference Guides
Detailed implementations in the references/ directory:
| Guide | Contents |
|---|---|
| Redis Caching with PostgreSQL | Redis Caching with PostgreSQL |
| Memcached Caching | Memcached Caching |
| PostgreSQL Query Cache | PostgreSQL Query Cache |
| MySQL Query Cache | MySQL Query Cache |
| Event-Based Invalidation | Event-Based Invalidation |
| Time-Based Invalidation | Time-Based Invalidation, LRU Cache Eviction |
Best Practices
✅ DO
- Follow established patterns and conventions
- Write clean, maintainable code
- Add appropriate documentation
- Test thoroughly before deploying
❌ DON'T
- Skip testing or validation
- Ignore error handling
- Hard-code configuration values
More from aj-geddes
Use this skill in a project
Open any RiverX project, search the Skills panel for aj-geddes/useful-ai-prompts/query-caching-strategies, and install it in one click.