prompt

Database Connection Pooling Tuner

Optimize connection pool settings (size, timeout, idle strategies) for observed load patterns.

Updated June 2026
The prompt
My {{db_type}} pool config is causing {{symptom}} under {{load_profile}}. Current settings: pool_size={{pool_size}}, max_idle={{idle_timeout}}s, queue_timeout={{queue_timeout}}s.

Based on:
- Avg query time: {{avg_query_ms}}ms
- Peak connections: {{peak_connections}}
- Idle time distribution: {{idle_pattern}}

Recommend optimal pool tuning and explain why. Include monitoring queries.
Did it work? Rate this prompt

Variables

Database type (PostgreSQL/MySQL/Oracle)
Current problem (e.g., connection timeouts)
Load scenario (e.g., bursty traffic)
Current pool size
Idle timeout (seconds)
Queue timeout (seconds)
Average query duration (ms)
Peak concurrent connections
Idle distribution (e.g., 80% idle < 5s)

Details

Author

AI Khazna

License

Security

Type

prompt

Related assets

More curated picks in Development & Code.

Audit before you install

Run any source through our checks - AI visibility, security, performance, and stack detection.

More in Development & Code