database-schema-architect
Database Schema Architect
Overview
This skill provides comprehensive guidance for database schema design, from initial planning through production deployment and ongoing maintenance. It covers both relational (SQL) and NoSQL databases with focus on scalability, performance, security, and compliance.
Core Design Principles
1. Start with Requirements Analysis
Before designing any schema:
- Identify primary use cases and query patterns
- Determine read/write ratio (OLTP vs OLAP)
- Establish data volume projections (current and 2-5 year growth)
- Define compliance requirements (GDPR, HIPAA, SOC2, etc.)
- List critical performance requirements (response times, throughput)
2. Naming Conventions (Critical for Maintainability)
More from sitechfromgeorgia/georgian-distribution-system
modern-ui-designer
Expert guidance for creating stunning, professional 2025 UI designs using Tailwind CSS and shadcn/ui. Ensures clean minimal aesthetics, 8px grid consistency, mobile-first responsive patterns, and WCAG accessibility compliance. Use when designing interfaces, reviewing UI, creating components, or when visual design needs modern professional standards.
69conversion-optimization-expert
Expert CRO advisor that analyzes landing pages, product funnels, UI/UX friction, and provides data-driven A/B test ideas to maximize conversions, sign-ups, trials, and retention. Use when optimizing conversion rates, analyzing funnels, designing experiments, improving CTAs, reducing drop-offs, or when user mentions conversion rate, CRO, landing page optimization, A/B testing, or funnel analysis.
66saas-architect
Comprehensive SaaS architecture planner for Next.js + Supabase applications. Converts ideas into production-ready technical plans with database schemas, file structures, feature breakdowns, and week-by-week development roadmaps. Use when planning subscription-based applications, multi-tenant SaaS products, or building from idea to launch.
63nextjs-supabase-saas-planner
Comprehensive SaaS architecture planner for Next.js and Supabase applications. Converts ideas into production-ready technical plans with database schemas, file structures, feature breakdowns, and week-by-week development roadmaps. Use when planning subscription-based applications, multi-tenant SaaS products, or building from idea to launch with Next.js and Supabase stack.
37idea-validator-pro
Advanced product idea validation through comprehensive market research, competitive analysis, demand verification, technical feasibility assessment, and monetization potential analysis. Use when evaluating startup ideas, SaaS concepts, or any new product before development begins. Provides data-driven scoring and actionable recommendations.
23mobile-first-designer
Expert responsive design mentor focused on modern mobile UI patterns, touch-friendly interactions, and performance optimization. Reviews layouts for mobile-first best practices, identifies accessibility issues, validates touch targets, checks responsive breakpoints, and suggests PWA enhancements. Use when designing or reviewing mobile interfaces, responsive layouts, touch interactions, or when users mention mobile design, responsive web design, PWA, or accessibility.
23