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

•

Database Management

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

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.

Key Features

01Query optimization through indexing, EXPLAIN analysis, and N+1 problem resolution

02Safe, zero-downtime migration patterns for PostgreSQL and MySQL

03NoSQL architectural patterns for document (MongoDB) and key-value (Redis) databases

04Implementation of ACID transactions and connection pooling for application reliability

051 GitHub stars

06Advanced schema design including normalization (1NF, 2NF, 3NF) and relationship modeling

Use Cases

01Identifying and fixing performance bottlenecks in existing SQL queries

02Implementing safe database migration scripts for production deployments

03Designing scalable multi-tenant database schemas for new software projects

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add vapvarun/claude-backup database

For use in Claude.ai and ChatGPT

Download Skill