Documentation

Databases

SQL, NoSQL, vector, and real-time databases — and how StackPilot recommends the right one for your data model.

The database is the foundation of your stack. StackPilot recommends the engine that fits your data model, scale, and team.

Database families

  • Relational (SQL) — PostgreSQL, MySQL. Structured data and transactions.
  • Document (NoSQL) — MongoDB. Flexible schemas for rapid iteration.
  • In-memory / cache — Redis. Caching, queues, and real-time counters.
  • Vector — pgvector, Pinecone, Weaviate. Similarity search for AI features.
  • Real-time — Supabase Realtime, Firebase. Live data sync.

How to choose

Start with the shape of your data. Structured and relational data points to PostgreSQL. Rapidly changing documents point to MongoDB. AI embeddings point to a vector database. When in doubt, PostgreSQL is a safe default that scales with you.