- Home
- Skills
- Data & Databases
- Freebies — Db Connection Tester
Works with the AI Agents you already use
Freebies — Db Connection Tester
Diagnose database connectivity, pool sizing, and SSL/TLS configuration for PostgreSQL, MySQL, and MongoDB.
Free
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
| Component | Current Status | Recommendation |
|---|---|---|
| SSL Configuration | sslmode=prefer | Change to sslmode=require or verify-full to prevent handshake retries. |
| Pool Sizing | Not defined | Set pool size to 9 (Formula: (4 cores * 2) + 1 spindle). |
| URI Encoding | Valid | Ensure special characters in passwords are percent-encoded if changed. |
| Timeout Logic | Default | Explicitly 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
- Update your
.envfile withDATABASE_URL=postgres://user:pass@host:5432/db?sslmode=require&connect_timeout=5. - Configure your application's connection pool library to a maximum of 9 connections.
- 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
- Provide your connection configuration, environment variables, or relevant application code snippets.
- The skill audits the configuration for syntax errors, missing SSL parameters, and improper timeout settings.
- It calculates recommended pool sizes based on your infrastructure specifications.
- 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
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
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 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
Permissions
Target Use Cases: - Diagnose database connection pool exhaustion error. - Calculate optimal PostgreSQL connection pool size. - Fix SSL connection error in database connection string.