Can it help with connection leak issues?

Yes, the skill provides patterns for proper connection lifecycle management and validation to help identify and prevent connection leaks in your application.

How does it determine the optimal pool size?

The skill analyzes your application's concurrency requirements and database server capacity to suggest balanced minimum and maximum pool sizes that prevent resource exhaustion.

Which programming languages are compatible with this skill?

While it can be applied to most languages, it has specific optimization patterns for Python, Java, and Node.js database drivers and ORMs.

What databases does this skill support?

It supports major relational databases like PostgreSQL, MySQL, and Oracle by providing configurations for popular libraries such as SQLAlchemy, HikariCP, and psycopg2.

Does it provide monitoring for database connections?

Yes, it includes patterns for setting up monitoring for key metrics such as connection usage, wait times, and error rates to help maintain long-term stability.

Database Connection Pooler

Name: Database Connection Pooler
Author: jeremylongshore

byjeremylongshore

•

883

データベース管理

Optimizes database performance and resource management by implementing and fine-tuning connection pooling configurations across multiple programming languages.

概要

This skill provides Claude with specialized knowledge to implement, configure, and troubleshoot database connection pools, ensuring applications handle high traffic efficiently without exhausting database resources. It analyzes specific application requirements to suggest optimal settings for pool sizes, timeouts, and validation protocols for libraries like HikariCP, SQLAlchemy, and psycopg2. Whether you are building a new backend or troubleshooting connection wait times in an existing system, this skill automates the complex task of lifecycle management and performance tuning to prevent bottlenecks and improve scalability.

主な機能

883 GitHub stars
Implementation of connection validation to prevent stale connection errors
Automated connection pool configuration for Python, Java, and other major languages
Performance monitoring setup for tracking connection usage and wait times
Expert troubleshooting for common database connectivity and resource exhaustion issues
Intelligent optimization of pool size and timeout settings based on workload

ユースケース

Implementing robust connection lifecycle management to handle database restarts and network instability
Setting up a high-performance connection pool for a PostgreSQL database in a Python application
Fine-tuning HikariCP settings in a Java microservice to reduce latency and connection wait times

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills database-connection-pooler

For use in Claude.ai and ChatGPT

Download Skill

GitHub

概要