Which database systems does this skill support?

The skill provides patterns and best practices for SQL databases like PostgreSQL and MySQL, as well as NoSQL systems like MongoDB and Redis.

How does it handle NoSQL data modeling?

It provides specific guidance on document embedding versus referencing in MongoDB and common caching/rate-limiting patterns for Redis.

Does it provide help with database migrations?

Absolutely. It covers safe migration patterns, including how to add columns, backfill data, and rename tables with minimal to zero downtime.

Does this skill include backup and recovery advice?

Yes, it covers standard backup commands for MySQL and PostgreSQL, including point-in-time recovery and WAL archiving configuration.

Can this skill help me optimize slow queries?

Yes, it includes detailed guidance on using EXPLAIN analysis, implementing efficient indexing strategies, and avoiding common pitfalls like the N+1 problem.

Database Architect & Optimizer

Name: Database Architect & Optimizer
Author: vapvarun

byvapvarun

•

Gestión de Bases de Datos

Designs, optimizes, and manages SQL and NoSQL databases using industry-standard best practices for performance and scalability.

Acerca de

The Database skill transforms Claude into a specialized database administrator and architect. It provides deep expertise in schema normalization, indexing strategies, and query performance tuning across both relational and non-relational systems. Whether you are building a new data model from scratch, troubleshooting slow-running queries using EXPLAIN analysis, or implementing zero-downtime migrations, this skill offers the specific patterns and SQL/NoSQL implementations required to maintain a robust, high-performance data layer.

Características Principales

Query optimization through indexing, EXPLAIN analysis, and N+1 problem resolution
Safe, zero-downtime migration patterns for PostgreSQL and MySQL
NoSQL architectural patterns for document (MongoDB) and key-value (Redis) databases
Implementation of ACID transactions and connection pooling for application reliability
1 GitHub stars
Advanced schema design including normalization (1NF, 2NF, 3NF) and relationship modeling

Casos de Uso

Identifying and fixing performance bottlenecks in existing SQL queries
Implementing safe database migration scripts for production deployments
Designing scalable multi-tenant database schemas for new software projects

Acerca de

Características Principales

Query optimization through indexing, EXPLAIN analysis, and N+1 problem resolution
Safe, zero-downtime migration patterns for PostgreSQL and MySQL
NoSQL architectural patterns for document (MongoDB) and key-value (Redis) databases
Implementation of ACID transactions and connection pooling for application reliability
1 GitHub stars
Advanced schema design including normalization (1NF, 2NF, 3NF) and relationship modeling

Casos de Uso

Identifying and fixing performance bottlenecks in existing SQL queries
Implementing safe database migration scripts for production deployments
Designing scalable multi-tenant database schemas for new software projects