Mingo
Collections

Schema Analyzer

Analyze the structure of your MongoDB documents with Mingo's schema analyzer — field types, frequencies, and export options.

Schema Analyzer

The Schema Analyzer examines your collection's documents and provides a detailed breakdown of the document structure.

Analysis

The analyzer samples documents from your collection and detects:

  • Field names and their nesting structure
  • Data types for each field (String, Number, ObjectId, Date, Boolean, Array, Object, etc.)
  • Type frequency — percentage of documents containing each field and type
  • Consistency — color-coded bars showing data consistency across documents

Apply filters (selector, projection, sort, skip, limit) to analyze a specific subset of documents. Save and load analysis filters per collection.

Field Details

Click on a field to see detailed statistics:

  • Type breakdown with percentages
  • Sample values
  • Min/max values for numeric fields
  • String length statistics

Expand nested objects and arrays to see their inner fields. Use Cmd+click to expand or collapse all fields recursively.

Add Fields

Use the embedded NodeShell to add new fields to all documents directly from the Schema view. This is useful for backfilling data or adding computed fields.

Export

The Schema Analyzer can export the detected schema in multiple formats:

  • GraphQL — generates GraphQL type definitions
  • TypeScript — generates TypeScript interfaces

This is useful for bootstrapping type definitions in your application code based on your actual data structure.