How does it handle database migrations?

It follows a 'version-controlled, incremental' approach, providing standardized commands for popular ORMs like Prisma, SQLAlchemy, and TypeORM while ensuring every migration is reversible.

Does it provide patterns for preventing the N+1 problem?

Yes, the skill includes specific implementation patterns for eager loading, JOINs, and batch loading to prevent the common performance pitfalls of repetitive database round-trips.

Which database systems does this skill support?

The skill provides specialized guidance for PostgreSQL, MySQL, Oracle, and SQLite, automatically detecting the database type based on your project's connection strings or ORM configurations.

Can this skill help with slow database queries?

Yes, it includes strategies for using EXPLAIN to analyze slow queries, recommending appropriate B-tree or GIN indexes, and optimizing pagination to avoid large offset performance hits.

Database Architect

Name: Database Architect
Author: xiaobei930

byxiaobei930

•

Database Management

Streamlines database schema design, query optimization, and migration management for robust data foundations.

The Database Architect skill empowers Claude to act as a senior database engineer, providing domain-specific guidance for designing scalable schemas, writing high-performance queries, and managing complex migrations. It supports multiple dialects including PostgreSQL, MySQL, Oracle, and SQLite, ensuring that naming conventions, indexing strategies, and transaction logic are optimized for your specific technology stack. Whether you are resolving N+1 query problems or implementing cursor-based pagination, this skill provides the architectural constraints and best practices necessary for enterprise-grade data management.

Key Features

01Multi-database support for PostgreSQL, MySQL, Oracle, and SQLite

02Automated migration workflow management for popular ORMs

03Expert query optimization and indexing strategy recommendations

04Detection and resolution patterns for N+1 query issues

05Standardized schema design with automated naming conventions

0634 GitHub stars

Use Cases

01Identifying and fixing performance bottlenecks in existing SQL queries

02Designing normalized relational database schemas for new microservices

03Generating version-controlled migration files for Prisma, TypeORM, or Alembic

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xiaobei930/cc-best database

For use in Claude.ai and ChatGPT

Download Skill