database-query-best-practicesPrevent connection pool exhaustion when querying Railway PostgreSQL database. Use when (1) Running database queries from local environment, (2) Diagnosing "t...
Install via ClawdBot CLI:
clawdbot install urbantech/database-query-best-practicesGrade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Generated Aug 3, 2026
A developer working locally on a web application that connects to a Railway-managed PostgreSQL database. They frequently encounter 'too many clients' errors due to connection leaks from local dev servers and need best practices to avoid pool exhaustion.
A DevOps engineer troubleshooting connection pool exhaustion in a production environment. They use the skill to check active connections, identify idle sessions, and terminate them safely to restore service.
A data analyst writes Python scripts to query a production database for reporting purposes. They need to ensure that connections are properly closed using context managers or try/finally blocks to prevent leaking connections.
A product manager or support engineer needs to run quick SQL queries to investigate data for customer support or product decisions. They use Railway CLI to avoid consuming local connection pool and follow secure practices.
A team of developers each running local dev servers that connect to a shared staging database. The skill helps them coordinate to avoid exhausting the connection pool, especially during testing phases.
Provides a cloud-hosted application with a backend database. Ensures service reliability by preventing connection pool exhaustion, which is critical for maintaining uptime and user satisfaction.
Offers managed PostgreSQL databases on Railway or similar platforms. Implements connection management best practices to ensure efficient resource usage and reduce infrastructure costs.
Builds internal tools for developers that rely on database queries. Standardizes connection handling practices to reduce support tickets and improve developer productivity.
💬 Integration Tip
Integrate this skill into your CI/CD pipeline by adding a pre-query check step that verifies connection pool status before running any database migrations or scripts.
Scored Aug 3, 2026
Use Redis effectively for caching, queues, and data structures with proper expiration and persistence.
MarkItDown is a Python utility from Microsoft for converting various files (PDF, Word, Excel, PPTX, Images, Audio) to Markdown. Useful for extracting structu...
Database Designer - POWERFUL Tier Skill
Skill Oracle — Curated documentation of quality ClawHub skills. Markdown tables telling agents which tools work and which are empty. Not an API or code library.
Database Schema Designer
Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.