Studio3T have quite an advanced SQL to MongoDB Migration wizard. It seems to be able to connect to any SQL Server and includes some UI for defining relationships between tables to create structured documents with arrays etc during the import process.

Since we don't have any official/home-grown tools for transforming SQL data during import, I think Compass would be a great place to introduce such a feature.

This could include some tips/heuristics to help first-time customers define a scalable, performant schema, including:

• recommending data types (e.g. date detection from string)
• bucketing options for time-series
• detecting unique field for reuse as _id field
• shorter field names
• JSON Schema