Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Freebies — Db Connection Tester

    1

    Diagnose database connectivity, pool sizing, and SSL/TLS configuration for PostgreSQL, MySQL, and MongoDB.

    Free

    Security scanned
    Freebies — Db Connection Tester

    Freebies — Db Connection Tester

    Example session with this skill installed

    Our PostgreSQL service is throwing 504 timeouts under load. We have 4 CPU cores and use sslmode=prefer. Can you check our pool settings and connection string?

    • Read your context and instructions
    • Compiled the freebies

    I have analyzed your PostgreSQL configuration. The 504 timeouts are likely caused by the sslmode=prefer setting introducing latency and an undersized connection pool for your hardware.

    Database Diagnostic Report

    ComponentCurrent StatusRecommendation
    SSL Configurationsslmode=preferChange to sslmode=require or verify-full to prevent handshake retries.
    Pool SizingNot definedSet pool size to 9 (Formula: (4 cores * 2) + 1 spindle).
    URI EncodingValidEnsure special characters in passwords are percent-encoded if changed.
    Timeout LogicDefaultExplicitly set connect_timeout=5 to fail fast during network spikes.

    Diagnostic Commands

    Run these commands from your application environment to verify connectivity:

    
    # Check if Postgres is accepting connections
    pg_isready -h your-db-host -p 5432
    
    # Verify SSL handshake capability
    openssl s_client -starttls postgres -connect your-db-host:5432
    
    # Test network path
    nc -zv your-db-host 5432
    

    Next steps

    1. Update your .env file with DATABASE_URL=postgres://user:pass@host:5432/db?sslmode=require&connect_timeout=5.
    2. Configure your application's connection pool library to a maximum of 9 connections.
    3. Check for unclosed cursors in your repository's database utility files.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Connectivity failures and pool exhaustion kill application performance before you even hit scale. This skill diagnoses database timeouts, leaks, and SSL configuration errors across PostgreSQL, MySQL, and MongoDB environments.

    What it does

    • Connection String Audit: Validates URI encoding, SSL modes, and timeout parameters for production readiness.
    • Pool Sizing Calculation: Determines optimal connection pool limits using CPU core and spindle counts.
    • Leak Identification: Detects unclosed cursors and missing lifecycle blocks that cause connection exhaustion.
    • Diagnostic Scripting: Generates ready-to-use shell commands for network and service availability testing.

    How it works

    1. Provide your connection configuration, environment variables, or relevant application code snippets.
    2. The skill audits the configuration for syntax errors, missing SSL parameters, and improper timeout settings.
    3. It calculates recommended pool sizes based on your infrastructure specifications.
    4. You receive a diagnostic report with fix recommendations and shell scripts for live troubleshooting.

    Frameworks & tools

    Supports PostgreSQL, MySQL, and MongoDB. Uses standard diagnostic utilities like pg_isready, netcat, and openssl.

    Why this beats prompting it yourself

    Generic prompts often miss specific pool sizing math or fail to account for SSL mode nuances that cause silent failures. This skill applies a deterministic workflow to ensure no diagnostic step, like URI encoding or spindle count math, is skipped.

    Use cases

    • Debugging "Connection refused" or timeout errors in new deployments.
    • Tuning pool parameters for high-concurrency Node.js or Python apps.
    • Verifying SSL/TLS handshake requirements for managed database providers.
    • Identifying code paths that fail to release database connections.

    Known limitations

    Performs static diagnostic analysis only. Does not execute live database queries or modify system-level network configurations.

    Static diagnostic analysis only. No live DB execution or global package installation. restricted to project workspace.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Free forever

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 2 days ago

    • Free with an Agensi account

    Requires

    File System Read/Write (strictly scoped to current project workspace `./`).
    Zero global installation or elevated privileges required.

    Permissions

    Read Files

    Target Use Cases: - Diagnose database connection pool exhaustion error. - Calculate optimal PostgreSQL connection pool size. - Fix SSL connection error in database connection string.

    Listed2 days ago

    What's inside

    Frequently Asked Questions

    This skill identifies the root cause of connection timeouts, SSL handshake failures, and 'Too many connections' errors, while providing specific math for optimal pool sizing.

    The skill performs a static audit of your connection strings, environment variables, and code snippets to identify misconfigurations without requiring direct access to your live database.

    It is fully compatible with PostgreSQL, MySQL, and MongoDB, including support for managed instances like AWS RDS, Azure Database, and MongoDB Atlas.

    You will receive the core diagnostic logic, pool sizing calculators, and a library of ready-to-use shell commands for network testing across different environments.

    No installation is required; simply provide your configuration details or code snippets to the AI agent to begin the diagnostic process.

    While the skill can identify code blocks where connections aren't being closed, it focuses on diagnosis and does not automatically rewrite or execute code on your behalf.

    New in Data & Databases