moai-platform-database-cloud

# moai-platform-database-cloud: Cloud Database Platform Specialist ## Quick Reference Cloud Database Platform Coverage: Consolidated expertise for Neon (serverless PostgreSQL), Supabase (PostgreSQL 16 with real-time), and Firebase Firestore (NoSQL with offline sync). ### Platform Comparison Neon provides serverless PostgreSQL with auto-scaling, database branching, and scale-to-zero compute for cost optimization. Best for serverless applications, preview environments, and edge deployment with connection pooling. Supabase provides PostgreSQL 16 with pgvector for AI/ML, Row-Level Security for multi-tenant apps, real-time subscriptions, and integrated auth/storage. Best for full-stack apps requiring real-time features and vector search. Firestore provides NoSQL document database with real-time sync, offline caching, Security Rules, and mobile-optimized SDKs. Best for mobile-first apps, offline-first architecture, and cross-platform development. ### Quick Decision Guide Need serverless PostgreSQL with auto-scaling: Use Neon. Need database branching for CI/CD: Use Neon branching. Need edge-compatible database: Use Neon with connection pooling. Need vector search for AI/ML: Use Supabase with pgvector. Need Row-Level Security: Use Supabase RLS policies. Need real-time subscriptions: Use Supabase real-time or Firestore listeners. Need offline-first mobile app: Use Firestore with offline persistence. Need SQL with real-time features: Use Supabase. Need NoSQL flexibility...