Document reusable database patterns for PostgreSQL, Redis, and SQLAlchemy.
npx skills add https://github.com/skomax/skills --skill database-patterns-skomax
Please help me install this Agent Skill. Skill: database-patterns Source: https://github.com/skomax/skills/tree/main/.claude/skills/database-patterns Command: npx skills add https://github.com/skomax/skills --skill database-patterns-skomax
PostgreSQL, Redis, and ORM integrations often require ad-hoc patterns, leading to inconsistency and maintenance overhead.
Apply PostgreSQL, Redis, and SQLAlchemy best practices to a sample project and generate optimized schemas, models, and queries.
High-intent search queries and answers about installing and using this skill.
Async SQLAlchemy 2.x session management best practices involve using recommended async models and sessions for concurrent database operations. This skill provides documented patterns and ready-to-adapt code examples to guide architecture decisions and practical implementation of scalable async database layers.
Safe and incremental PostgreSQL migrations require standardized approaches for tables, indexes, and versioned changes. This skill provides guidelines and practical examples for structured migration practices to ensure incremental schema evolution.
Implementing Redis caching strategies alongside PostgreSQL involves dedicated data modeling approaches for cache layers. This skill guides architecture decisions for Redis-based caching and JSONB data modeling, providing best-practice recommendations embedded in the content.
Yes, this database patterns skill works with both PostgreSQL and Redis. It solves the need for reusable database practices across PostgreSQL, Redis, and ORM layers, providing standardized approaches for schema design, caching strategies, and async SQLAlchemy patterns.
Modeling JSONB data in PostgreSQL for scalable applications requires specific caching and data modeling strategies. This skill provides documented patterns and ready-to-adapt code examples to guide JSONB data modeling and architecture decisions for robust apps.
WTFoxFix SQLAlchemy 2.x async pattern mistakes in PostgreSQL code.
devkit-stackApply Redis data-structure, memory, and query-engine best practices to optimize performance.
ils15Scaffold async FastAPI endpoints with service/repository patterns and dependency injection.
marquesfelipIdentify and fix SQL injection vulnerabilities in data access layers.
