Does it handle NoSQL aggregation?

Absolutely. It specializes in complex MongoDB aggregation pipelines, including multi-stage lookups, grouping, and faceted search for e-commerce or analytics.

How does it assist with data migrations?

The skill provides patterns for safe schema evolutions, Prisma migration workflows, and SQL-based table alterations that minimize downtime.

Can it help with slow database queries?

Yes, it includes patterns for query plan analysis (EXPLAIN ANALYZE), advanced indexing strategies (GIN, BRIN, Partial), and table partitioning to improve performance.

Which databases does this skill support?

The skill provides deep expertise in PostgreSQL, MySQL, MongoDB, and Redis, as well as integration patterns for the Prisma ORM.

Database Architect & Management

Name: Database Architect & Management
Author: miles990

bymiles990

•

데이터베이스 관리

Designs, optimizes, and manages relational and NoSQL databases using industry-standard patterns and performance-tuning techniques.

The Database skill empowers Claude to act as a senior database architect, capable of designing robust schemas, writing complex queries, and implementing advanced data management patterns. It covers a wide spectrum of technologies including PostgreSQL for relational data, MongoDB for document storage, Redis for high-performance caching, and Prisma for type-safe ORM integration. Whether you need to optimize query performance using execution plans, implement hierarchical data structures via recursive CTEs, or design scalable caching strategies, this skill provides the domain-specific knowledge required to build performant and maintainable data layers.

주요 기능

01Comprehensive PostgreSQL schema design and advanced SQL (CTEs, Window functions, JSONB)

02Performance optimization via advanced indexing strategies and query plan analysis

031 GitHub stars

04Type-safe ORM modeling and migration management with Prisma

05Complex MongoDB aggregation pipelines and faceted search implementation

06High-performance Redis caching patterns, rate limiting, and data structure management

사용 사례

01Building complex real-time analytics dashboards using MongoDB aggregation frameworks

02Designing a multi-tenant relational database schema with built-in full-text search capabilities

03Implementing distributed session management and efficient caching layers with Redis

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add miles990/claude-software-skills database

For use in Claude.ai and ChatGPT

Download Skill