javeedishaq/mongodb-production-query

MongoDB Production Query Skill

Query the Ballee production MongoDB database (Meteor application) safely using credentials from .env.local (with 1Password reference).

When to Use This Skill

Use this skill when:

• Debugging Meteor/MongoDB data issues
• Verifying MongoDB documents exist before sync
• Investigating Meteor-to-Supabase sync issues
• Exploring legacy data structure for migration planning
• Counting documents in MongoDB collections
• Comparing MongoDB data with Supabase data

MongoDB Server Reference

| Environment | Host | Database | Auth | |-------------|------|----------|------| | Production | mdb-p-{0,1,2}.ballee.db-eu2.zcloud.ws | meteor | authSource=admin |

Connection Details

• Replica Set: mdb-p (3 nodes)
• Ports: 60601, 60602, 60603
• SSL: Required (ssl=true&tlsInsecure=true)
• CA Certificate: .claude/skills/mongodb-production-query/ca-eu-2.pem

Credential Management

Environment Variable (Primary)

Credentials stored in apps/web/.env.local:

METEOR_MONGO_URL="op://Ballee/MongoDB Production (zCloud)/connection string"

1Password Reference

| Credential | 1Password Item | Field | |------------|----------------|-------| | Connection String | MongoDB Production (zCloud) | connection string | | Username | MongoDB Production (zCloud) | username | | Password | MongoDB Production (zCloud) | password |

Prerequisites

• Node.js with mongodb package installed
• Credentials in .env.local OR 1Password CLI authenticated (op whoami)

Quick Reference Commands

Connect via Node.js

const { MongoClient } = require('mongodb');

const url = process.env.METEOR_MONGO_URL ||
  'mongodb://root:<password>@mdb-p-0.ballee.db-eu2.zcloud.ws:60601,mdb-p-1.ballee.db-eu2.zcloud.ws:60602,mdb-p-2.ballee.db-eu2.zcloud.ws:60603/meteor?authSource=admin&ssl=true&tlsInsecure=true&replicaSet=mdb-p';

async function connect() {
  const client = new MongoClient(url);
  await client.connect();
  return client.db('meteor');
}

List Collections

const db = await connect();
const collections = await db.listCollections().toArray();
console.log(collections.map(c => c.name));

Count Documents

const db = await connect();
const count = await db.collection('Organizations').countDocuments();
console.log('Organizations:', count);

Quick Connection Test

cd /Users/antoineschaller/GitHub/ballee-community-app && node -e "
const { MongoClient } = require('mongodb');
const url = process.env.METEOR_MONGO_URL;
async function test() {
  const client = new MongoClient(url, { serverSelectionTimeoutMS: 10000 });
  await client.connect();
  const db = client.db('meteor');
  const collections = await db.listCollections().toArray();
  console.log('Collections:', collections.map(c => c.name).join(', '));
  await client.close();
}
test().catch(console.error);
"

Available Collections

| Collection | Description | Approx Count | |------------|-------------|--------------| | Organizations | Dance schools, companies | ~428 | | Candidates | Dancer profiles | ~20,018 | | Posts | Social posts | ~1,492 | | Experiences | Work/education history | varies | | Media | Photos, videos, headshots | varies | | Comments | Post comments | varies | | Likes | Post/comment likes | varies | | Follow | User follows | varies | | users | Meteor auth users | varies |

Common Queries

Find Organization by Name

const org = await db.collection('Organizations')
  .findOne({ name: /fever/i });
console.log(org);

Find Candidate by Email

const candidate = await db.collection('Candidates')
  .findOne({ 'emails.address': '[email protected]' });
console.log(candidate);

Count Documents by Type

const collections = ['Organizations', 'Candidates', 'Posts', 'Experiences', 'Media', 'Comments', 'Likes', 'Follow'];
for (const coll of collections) {
  const count = await db.collection(coll).countDocuments();
  console.log(`${coll}: ${count}`);
}

Sample Document Structure

// Get sample document to understand schema
const sample = await db.collection('Candidates').findOne();
console.log(JSON.stringify(sample, null, 2));

Find Recent Documents

const recent = await db.collection('Posts')
  .find()
  .sort({ 'meta.createdAt': -1 })
  .limit(10)
  .toArray();
console.log(recent);

Meteor to Supabase Field Mapping

| Meteor Field | Supabase Field | Notes | |--------------|----------------|-------| | _id | meteor_id | Store original ID | | meta.createdAt | created_at | Timestamp | | meta.modifiedAt | updated_at | Timestamp | | name | name | Direct mapping | | camelCase | snake_case | Transform field names |

Related Documentation

• Meteor Sync Service: apps/web/app/admin/sync/meteor/
• Sync Plan: .claude/plans/dreamy-wiggling-emerson.md
• Migration Scripts: scripts/migration/
• Airtable Sync Specialist: .claude/skills/airtable-sync-specialist/SKILL.md