Smart Cache Manager
Analyze cache hit rates, identify cold keys, and optimize TTL settings
Example Prompt
Analyze our Redis cache hit rates, find keys with poor TTL settings, and optimize them
About
Examines Redis cache metrics to evaluate hit/miss ratios, identify frequently cold or stale keys, and detect inefficient TTL configurations. Provides data-driven recommendations for TTL adjustments and cache warming strategies, then applies optimized settings.
Workflow Steps
Retrieve cache statistics and sample key metadata from Redis to assess current performance
🔑 Get KeyQuery the application database for access pattern logs to correlate with cache behavior
📊 Run SQL QueryAnalyze hit/miss ratios and identify cold keys with suboptimal TTL settings
🧠 Structured ReasoningApply optimized TTL values and pre-warm critical cache keys
🔒 Set KeyPost a cache optimization report with before/after metrics to Slack
📨 Send MessageTools Used
Run SQL Query
Execute a read-only SQL query against a PostgreSQL database and return results
Get Key
Retrieve the value of a key from a Redis datastore
Set Key
Set a key-value pair in Redis with optional expiration
Structured Reasoning
Break down a complex problem into sequential reasoning steps with explicit chain-of-thought
Send Message
Send a message to a Slack channel or direct message conversation
Required MCP Servers
PostgreSQL
Query, inspect, and manage PostgreSQL databases with full SQL support
Redis
Read, write, and manage keys in Redis for caching and real-time data
Sequential Thinking
Dynamic problem-solving through structured thought sequences with branching and revision
Slack
Send messages, read channels, and manage Slack workspace interactions