Which ORMs does this skill support?

It supports a wide range of tools including Prisma, Drizzle, SQLAlchemy 2.0, TypeORM, GORM, Diesel, Entity Framework Core 8, ActiveRecord, and Ecto.

How does it handle database testing?

It promotes testing against real databases using Testcontainers and pg_tmp rather than in-memory mocks to catch platform-specific bugs early.

Does it help with database performance?

Yes, it specializes in optimizing slow queries using EXPLAIN ANALYZE, resolving N+1 issues, and configuring connection pooling for production stability.

Can it help with database migrations?

Absolutely, it provides patterns for immutable migrations and zero-downtime schema changes to ensure data integrity across environments.

Database Implementation & ORM Mastery

Name: Database Implementation & ORM Mastery
Author: rnavarych

byrnavarych

•

数据库管理

Implements high-performance database layers and migrations across various programming languages and ORM frameworks.

This skill empowers Claude to architect, implement, and optimize database access layers using industry-standard tools like Prisma, Drizzle, SQLAlchemy, and Entity Framework Core. It focuses on production-ready patterns, including zero-downtime migrations, efficient connection pooling, and read replica routing to ensure scalability. By adhering to core principles like transaction management and real-world testing with Testcontainers, it helps developers avoid common pitfalls such as N+1 queries or database-specific bugs hidden by mocks.

主要功能

0111 GitHub stars

02Production-grade connection pooling and read replica configuration

03Performance optimization using query analysis and indexing

04Automated schema migration strategies with zero-downtime patterns

05Support for polyglot ORMs including Prisma, Drizzle, SQLAlchemy, and EF Core

06Integration testing setup with Testcontainers and data factories

使用场景

01Setting up a new data access layer for a microservice with optimized ORM selection

02Implementing complex database migrations and transaction logic for high-traffic apps

03Troubleshooting and fixing slow database queries or N+1 performance issues

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rnavarych/alpha-engineer database-implementation

For use in Claude.ai and ChatGPT

主要功能

0111 GitHub stars

02Production-grade connection pooling and read replica configuration

03Performance optimization using query analysis and indexing

04Automated schema migration strategies with zero-downtime patterns

05Support for polyglot ORMs including Prisma, Drizzle, SQLAlchemy, and EF Core

06Integration testing setup with Testcontainers and data factories

使用场景

01Setting up a new data access layer for a microservice with optimized ORM selection

02Implementing complex database migrations and transaction logic for high-traffic apps

03Troubleshooting and fixing slow database queries or N+1 performance issues

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rnavarych/alpha-engineer database-implementation

For use in Claude.ai and ChatGPT