| name | moai-platform-database-cloud |
| description | Cloud database platform specialist covering Neon (serverless PostgreSQL), Supabase (PostgreSQL 16 with real-time), and Firebase Firestore (NoSQL with offline sync). Use when choosing or setting up cloud databases.
|
| license | Apache-2.0 |
| compatibility | Designed for Claude Code |
| allowed-tools | Read, Write, Bash(psql:*), Bash(npm:*), Bash(npx:*), Bash(neonctl:*), Bash(firebase:*), Bash(supabase:*), Grep, Glob, mcp__context7__resolve-library-id, mcp__context7__get-library-docs |
| user-invocable | false |
| metadata | {"version":"2.0.0","category":"platform","status":"active","updated":"2026-02-09","modularized":"true","tags":"database, postgresql, nosql, serverless, real-time, offline, cloud","context7-libraries":"/neondatabase/neon, /supabase/supabase, /firebase/firebase-docs","related-skills":"moai-platform-auth, moai-lang-typescript, moai-domain-backend"} |
| progressive_disclosure | {"enabled":true,"level1_tokens":100,"level2_tokens":4500} |
| triggers | {"keywords":["neon","supabase","firestore","cloud database","serverless postgresql","real-time database","offline sync","pgvector","rls","database branching","vector database","nosql","mobile database"],"agents":["expert-backend","expert-devops","manager-spec"],"phases":["plan","run"],"languages":["typescript","javascript","python","go"]} |
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: Use Firestore.
Database Type Selection
SQL vs NoSQL Decision: Choose SQL (Neon, Supabase) for structured data with complex relationships, ACID transactions, and query flexibility. Choose NoSQL (Firestore) for flexible schemas, offline-first mobile apps, and real-time sync across clients.
PostgreSQL Variants: Choose Neon for serverless auto-scaling and branching. Choose Supabase for integrated features (auth, storage, real-time) and pgvector.
Platform Selection Matrix
Use Case Alignment
Serverless Applications benefit from Neon's auto-scaling and scale-to-zero that reduce costs significantly.
Multi-tenant SaaS benefits from Supabase Row-Level Security providing automatic tenant isolation.
AI/ML Applications benefit from Supabase pgvector for vector embeddings and similarity search.
Real-time Collaboration benefits from Supabase Postgres Changes or Firestore real-time listeners.
Mobile-First Apps benefit from Firestore offline caching and mobile-optimized SDKs.
Preview Environments benefit from Neon database branching for per-PR databases.
Edge Deployment benefits from Neon connection pooling for edge runtime compatibility.
