Database Management
Monitor database health and perform data migrations
Data Consistency
88%
GoodTotal Records
58
38 users, 20 patients
Data Issues
7
Issues requiring attention
Appointments
951
Total appointments
Data Quality Issues
Issues that can be fixed by running migration
Incomplete User Profiles
Users missing firstName, lastName, or email
Patients Missing Data
Patients without name or species information
Inconsistent Addresses
Addresses with missing or malformed data
Collection Statistics
Current database collection sizes
Users Collection
Client and staff accounts
38
records
Patients Collection
Pet records and medical data
20
records
Appointments
Scheduled visits and history
951
records
Data Migration Tools
Fix data inconsistencies and standardize database structure
What the migration will do:
- • Fix users without proper firstName/lastName structure
- • Standardize phone number formats to (XXX) XXX-XXXX
- • Normalize address data structure and formatting
- • Ensure consistent patient name and species data
- • Synchronize profile data between different field locations
- • Remove duplicate records where possible