database-query-best-practices
OfficialPrevent DB pool exhaustion on local queries.
Software Engineering#database#postgresql#railway#connection-pool#context-manager#psycopg2#query-safety
AuthorAINative-Studio
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Local development queries to Railway PostgreSQL can exhaust connections, causing "too many clients" errors when multiple dev servers are running and connections are left open, leading to unreliable development workflows.
Core Features & Use Cases
- Enforce safe querying: Check pool status before queries and use short-lived connections.
- Promote robust scripts: Always use context managers to ensure resources are released.
- Guidance for debugging: Provide best practices for diagnosing pool exhaustion in local environments.
Quick Start
Always run a short-lived connection test and use a context manager to open and close the database connection before executing queries.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: database-query-best-practices Download link: https://github.com/AINative-Studio/telemetry-agent/archive/main.zip#database-query-best-practices Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.