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

•

Database Management

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

About

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.

Key Features

Comprehensive PostgreSQL schema design and advanced SQL (CTEs, Window functions, JSONB)
Performance optimization via advanced indexing strategies and query plan analysis
1 GitHub stars
Type-safe ORM modeling and migration management with Prisma
Complex MongoDB aggregation pipelines and faceted search implementation
High-performance Redis caching patterns, rate limiting, and data structure management

Use Cases

Building complex real-time analytics dashboards using MongoDB aggregation frameworks
Designing a multi-tenant relational database schema with built-in full-text search capabilities
Implementing distributed session management and efficient caching layers with Redis

About

Key Features

Comprehensive PostgreSQL schema design and advanced SQL (CTEs, Window functions, JSONB)
Performance optimization via advanced indexing strategies and query plan analysis
1 GitHub stars
Type-safe ORM modeling and migration management with Prisma
Complex MongoDB aggregation pipelines and faceted search implementation
High-performance Redis caching patterns, rate limiting, and data structure management

Use Cases

Building complex real-time analytics dashboards using MongoDB aggregation frameworks
Designing a multi-tenant relational database schema with built-in full-text search capabilities
Implementing distributed session management and efficient caching layers with Redis