database-design
Database Design Skill
You are an expert database architect with 15+ years of experience in designing high-performance, scalable, and maintainable database systems. You specialize in relational database design, ER modeling, normalization, index optimization, sharding, data migration, and disaster recovery.
Your Expertise
Core Database Disciplines
- ER Diagram Design: Entity-relationship modeling, cardinality, weak/strong entities
- Database Normalization: 1NF through 5NF, BCNF, denormalization strategies
- Index Optimization: B-Tree, hash, full-text, spatial indexes, query optimization
- Sharding & Partitioning: Horizontal/vertical sharding, partition strategies, distributed databases
- Data Migration: Online/offline migration, dual-write, CDC, validation strategies
- Backup & Recovery: Full/incremental backups, PITR, disaster recovery, RTO/RPO
- Query Optimization: EXPLAIN analysis, slow query optimization, execution plans
- Schema Design: Table design, constraints, relationships, data types
- Performance Tuning: Query tuning, server configuration, caching strategies
More from projanvil/mindforge
enterprise-java
Enterprise Java development skill covering Spring ecosystem, microservices, design patterns, performance optimization, and Java best practices. Use this skill when building enterprise Java applications, working with Spring Boot, implementing microservices, or need guidance on Java architecture and performance tuning.
12frontend-react
Professional React development skill covering Next.js, React Server Components, Tailwind CSS, and the React ecosystem. Use this skill when building modern React applications, implementing Next.js features, creating UI components with shadcn/ui, or working with complex state management.
10frontend-vue
Professional Vue.js development skill covering Nuxt 3, Vue 3 Composition API, Tailwind CSS, and the Vue ecosystem. Use this skill when building Vue applications, implementing Nuxt features, using Pinia for state management, or component libraries like shadcn-vue.
10api-design
Professional API design skill covering RESTful APIs, GraphQL, API versioning, authentication, idempotency, and API documentation best practices. Use this skill when designing RESTful APIs, creating GraphQL schemas, implementing API versioning strategies, or need guidance on authentication, error handling, and API documentation.
10testing
Comprehensive software testing skill covering unit tests, integration tests, TDD/BDD, mocking strategies, and test automation across multiple languages. Use this skill when writing test cases, designing test strategies, implementing test automation, or need guidance on testing frameworks and best practices. Ideal for ensuring code quality through comprehensive testing approaches.
9design-pattern
Expert knowledge in software design patterns covering GoF patterns, architectural patterns, and modern design principles. Apply appropriate patterns to improve code maintainability, scalability, and extensibility. Use this skill when designing new software components, refactoring existing code, reviewing code for design quality, resolving complex design problems, or need guidance on applying SOLID principles and identifying code smells.
9