{"skill":{"slug":"database-query-best-practices","displayName":"Database Query Best Practices","summary":"Prevent connection pool exhaustion when querying Railway PostgreSQL database. Use when (1) Running database queries from local environment, (2) Diagnosing \"t...","tags":{"latest":"1.0.0"},"stats":{"comments":0,"downloads":166,"installsAllTime":1,"installsCurrent":1,"stars":0,"versions":1},"createdAt":1774326934219,"updatedAt":1777526555331},"latestVersion":{"version":"1.0.0","createdAt":1774326934219,"changelog":"- Initial release with comprehensive guidelines to prevent PostgreSQL connection pool exhaustion on Railway.\n- Includes critical best practices for checking pool status, closing connections, and using short-lived queries.\n- Step-by-step instructions for safely querying from local scripts and recommending the use of Railway CLI.\n- Troubleshooting steps provided for \"too many clients\" errors and emergency connection termination.","license":"MIT-0"},"metadata":null,"owner":{"handle":"urbantech","userId":"s1705vnaxvfmy5a3t55qeprr4d83hnbz","displayName":"Toby Morning","image":"https://avatars.githubusercontent.com/u/2746731?v=4"},"moderation":null}