How do I install the Database Connection Pooling skill?

Run npx skillmds add majiayu000/database-connection-pooling in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Database Connection Pooling safe to use?

This skill has not completed SkillMD's automated safety review yet. Capability flags: docs only. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Database Connection Pooling?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Database Connection Pooling free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Database Connection Pooling?

majiayu000 (@majiayu000) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Database Connection Pooling by majiayu000

Name: Database Connection Pooling
Rating: 4.2 (5 reviews)
Author: majiayu000

Database Connection Pooling

Configures and manages database connection pools, with a focus on SQLAlchemy. Use this skill for tasks involving connection pool configuration, sizing, lifecycle management, health checks, and monitoring. It provides specialized guidance for both traditional server-based databases and serverless databases like Neon and PlanetScale.

majiayu000 01b0ab6 2 files · 3.7 KB Updated Sep 9, 2026 567 repo stars

File contents

Database Connection Pooling Configuration

Overview

This skill provides guidance and resources for configuring database connection pools, primarily using Python's SQLAlchemy library. It covers best practices for traditional databases and provides specific advice for modern serverless database architectures.

Workflow

Identify Environment: First, determine if the user's database is a traditional, server-based instance or a serverless one (e.g., Neon, PlanetScale, AWS Aurora Serverless).
Gather Workload Details: Ask the user about their application's workload.
- For traditional web apps: How many application servers? How many worker processes/threads per server?
- For serverless functions: What is the expected concurrency?
Provide Configuration: Based on the environment, guide the user to the appropriate reference material.
- For traditional databases, use references/sqlalchemy_config.md to configure a robust connection pool with appropriate sizing and recycling.
- For serverless databases, use references/serverless_pooling.md to learn about the unique challenges and recommended configurations for platforms like Neon and PlanetScale.
Implement Monitoring: Once the pool is configured, refer to references/monitoring.md for best practices on monitoring pool health and detecting connection leaks. Use the scripts/generate_dashboard_config.py script to create a basic monitoring configuration.

Resources

`references/sqlalchemy_config.md`

Use for: Configuring connection pools for traditional, server-based databases (e.g., a dedicated PostgreSQL or MySQL server).
Contains: Detailed examples for create_engine, pool sizing formulas, and health check patterns.

`references/serverless_pooling.md`

Use for: Configuring connection pools for serverless database platforms.
Contains: Specific guidance and settings for Neon and PlanetScale, including the use of external poolers like PgBouncer.

`references/monitoring.md`

Use for: Understanding how to monitor the connection pool and diagnose issues like connection leaks.
Contains: Key metrics to track and instructions for using the generate_dashboard_config.py script.

`scripts/generate_dashboard_config.py`

Use for: Generating a basic JSON configuration for a monitoring dashboard.
To run: python3 scripts/generate_dashboard_config.py. The output can be used as a template for setting up monitoring tools.

---name: database-connection-poolingdescription: Configures and manages database connection pools, with a focus on SQLAlchemy. Use this skill for tasks involving connection pool configuration, sizing, lifecycle management, health checks, and monitoring. It provides specialized guidance for both traditional server-based databases and serverless databases like Neon and PlanetScale.--- # Database Connection Pooling Configuration ## Overview This skill provides guidance and resources for configuring database connection pools, primarily using Python's SQLAlchemy library. It covers best practices for traditional databases and provides specific advice for modern serverless database architectures. ## Workflow 1. **Identify Environment**: First, determine if the user's database is a traditional, server-based instance or a serverless one (e.g., Neon, PlanetScale, AWS Aurora Serverless). 2. **Gather Workload Details**: Ask the user about their application's workload. * For traditional web apps: How many application servers? How many worker processes/threads per server? * For serverless functions: What is the expected concurrency? 3. **Provide Configuration**: Based on the environment, guide the user to the appropriate reference material. * For **traditional databases**, use `references/sqlalchemy_config.md` to configure a robust connection pool with appropriate sizing and recycling. * For **serverless databases**, use `references/serverless_pooling.md` to learn about the unique challenges and recommended configurations for platforms like Neon and PlanetScale. 4. **Implement Monitoring**: Once the pool is configured, refer to `references/monitoring.md` for best practices on monitoring pool health and detecting connection leaks. Use the `scripts/generate_dashboard_config.py` script to create a basic monitoring configuration. ## Resources ### `references/sqlalchemy_config.md` - **Use for**: Configuring connection pools for traditional, server-based databases (e.g., a dedicated PostgreSQL or MySQL server). - **Contains**: Detailed examples for `create_engine`, pool sizing formulas, and health check patterns. ### `references/serverless_pooling.md` - **Use for**: Configuring connection pools for serverless database platforms. - **Contains**: Specific guidance and settings for Neon and PlanetScale, including the use of external poolers like PgBouncer. ### `references/monitoring.md` - **Use for**: Understanding how to monitor the connection pool and diagnose issues like connection leaks. - **Contains**: Key metrics to track and instructions for using the `generate_dashboard_config.py` script. ### `scripts/generate_dashboard_config.py` - **Use for**: Generating a basic JSON configuration for a monitoring dashboard. - **To run**: `python3 scripts/generate_dashboard_config.py`. The output can be used as a template for setting up monitoring tools.

Frequently asked questions