dbdock analyze

npx dbdock analyze <database-url>

npx dbdock analyze "mongodb://localhost:27017/myapp"

npx dbdock analyze "postgresql://user:pass@localhost:5432/myapp"

Database: myapp (mongodb://localhost:27017)
Collections: 4

┌──────────────┬──────────┬────────┬─────────┐
│ Collection   │ Documents│ Fields │ Indexes │
├──────────────┼──────────┼────────┼─────────┤
│ users        │   12,450 │     8  │    3    │
│ orders       │   48,910 │    12  │    5    │
│ products     │      820 │    14  │    2    │
│ reviews      │    3,180 │     6  │    1    │
└──────────────┴──────────┴────────┴─────────┘

users:
  _id            ObjectId     (unique)
  email          String       (unique, 12,450 values)
  name           String
  age            Number       (99.2% Int, 0.8% Double)  ⚠️ mixed types
  created_at     Date
  metadata       Object       (nested, depth 2)
  deleted_at     Date|null
  tags           Array<String>

⚠️ Inconsistencies found:
  • users.age has mixed numeric types (Int and Double)
  • orders.total has 12 documents missing the field
  • products.price has 3 documents with type String instead of Number