mongosh "$MONGODB_URI" --quiet --eval "
  const plan = db.<collection>.<operation>.explain('executionStats');
  printjson({
    queryPlanner: plan.queryPlanner.winningPlan,
    executionStats: {
      nReturned: plan.executionStats.nReturned,
      totalDocsExamined: plan.executionStats.totalDocsExamined,
      totalKeysExamined: plan.executionStats.totalKeysExamined,
      executionTimeMillis: plan.executionStats.executionTimeMillis
    }
  });
"

// Query: find active users in age range, sorted by name
db.users.find({ status: "active", age: { $gte: 18, $lte: 65 } }).sort({ name: 1 })

// Optimal index: equality first, then sort, then range
db.users.createIndex({ status: 1, name: 1, age: 1 })

// Single field
db.collection.createIndex({ email: 1 })

// Compound
db.collection.createIndex({ category: 1, createdAt: -1 })

// Text search
db.collection.createIndex({ title: "text", description: "text" })

// TTL (auto-expire documents)
db.collection.createIndex({ expiresAt: 1 }, { expireAfterSeconds: 0 })

// Partial (index only matching documents)
db.collection.createIndex(
  { email: 1 },
  { partialFilterExpression: { status: "active" } }
)

// Unique
db.collection.createIndex({ email: 1 }, { unique: true })

mongosh "$MONGODB_URI" --quiet --eval "
  db.getCollectionNames().forEach(coll => {
    const indexes = db.getCollection(coll).getIndexes();
    const stats = db.getCollection(coll).stats();
    print('=== ' + coll + ' ===');
    print('Documents: ' + stats.count + ', Size: ' + (stats.size / 1024 / 1024).toFixed(2) + ' MB');
    indexes.forEach(idx => {
      print('  Index: ' + JSON.stringify(idx.key) + (idx.unique ? ' [unique]' : '') + (idx.sparse ? ' [sparse]' : ''));
    });
    print('');
  });
"