# Monica Personal CRM

> Personal relationship management system.

- Category: Productivity & Collaboration
- Difficulty: intermediate
- Components: monica, mariadb
- Tags: monica, crm, contacts, relationships
- Source: https://docker.recipes/productivity/monica-crm

## Overview

Monica is an open-source personal relationship management (PRM) system designed to help individuals maintain meaningful connections with friends, family, and professional contacts. Launched in 2017 by Régis Freyd, Monica addresses the modern challenge of remembering personal details, important dates, and conversation history across an expanding network of relationships. Unlike traditional CRMs focused on sales and business processes, Monica emphasizes personal relationship nurturing through features like contact journaling, gift tracking, activity logging, and automatic reminder systems. This deployment combines Monica's PHP-based application with MariaDB to create a robust personal relationship management platform. MariaDB serves as the data backbone, storing contact information, relationship mappings, conversation histories, and reminder schedules, while providing the performance and reliability needed for complex relationship queries and data integrity. The enhanced storage engines and JSON capabilities of MariaDB particularly benefit Monica's flexible contact attribute system and activity tracking features. This stack appeals to professionals managing extensive personal networks, individuals seeking to improve their relationship maintenance habits, and families wanting to coordinate contact management across multiple members. The combination provides enterprise-grade data persistence for personal relationship data while maintaining the simplicity and privacy of self-hosted deployment, making it ideal for users who value data ownership and relationship privacy.

## Features

- Contact relationship mapping with family trees, friendships, and professional connections
- Conversation logging and history tracking with searchable notes and context
- Automated reminder system for birthdays, anniversaries, and follow-up activities
- Gift idea tracking and purchase history linked to specific contacts
- Activity and event logging with date tracking and photo attachments
- Journal integration for recording personal thoughts about relationships
- Debt and loan tracking between contacts with payment history
- vCard and CSV contact import with relationship preservation

## Use cases

- Sales professionals maintaining personal connections separate from business CRM systems
- Consultants and freelancers managing client relationships and personal networking
- Busy professionals tracking family events, birthdays, and personal obligations
- Individuals with ADHD or memory challenges needing relationship management support
- Families coordinating shared contact information and relationship histories
- Community leaders managing relationships with constituents and volunteers
- Therapists and counselors organizing personal professional relationship notes

## Prerequisites

- Minimum 1GB RAM for MariaDB database operations and contact relationship queries
- Docker and Docker Compose installed with container orchestration capabilities
- Port 8080 available for Monica web interface access
- Understanding of PHP application key generation for Monica security
- Basic knowledge of environment variable configuration for database credentials
- Familiarity with MariaDB administration for backup and maintenance tasks

## docker-compose.yml

```yaml
services:
  monica:
    image: monica:latest
    container_name: monica
    restart: unless-stopped
    environment:
      APP_KEY: ${APP_KEY}
      DB_HOST: db
      DB_DATABASE: monica
      DB_USERNAME: monica
      DB_PASSWORD: ${DB_PASSWORD}
      APP_URL: http://localhost:8080
    ports:
      - "8080:80"
    volumes:
      - monica_data:/var/www/html/storage
    depends_on:
      - db

  db:
    image: mariadb:10
    container_name: monica-db
    restart: unless-stopped
    environment:
      MYSQL_ROOT_PASSWORD: ${DB_PASSWORD}
      MYSQL_DATABASE: monica
      MYSQL_USER: monica
      MYSQL_PASSWORD: ${DB_PASSWORD}
    volumes:
      - monica_db:/var/lib/mysql

volumes:
  monica_data:
  monica_db:
```

## .env

```bash
APP_KEY=base64:generate-32-char-key
DB_PASSWORD=changeme
```

## Usage notes

- Docs: https://www.monicahq.com/docs/
- Access at http://localhost:8080 - register to create account
- Generate APP_KEY: php artisan key:generate --show
- Track contacts, activities, conversations, reminders
- Journal, debt tracking, gift ideas features
- Import contacts from vCard, CSV, or other sources

## Troubleshooting

- Application Error - No encryption key: Generate APP_KEY using 'php artisan key:generate --show' and add to environment variables
- Database connection refused: Verify MariaDB container is running and DB_HOST points to 'db' service name
- Monica shows blank page after login: Check storage volume permissions and ensure monica_data volume is properly mounted
- Import contacts failing: Verify CSV format matches Monica expectations and file encoding is UTF-8
- Performance issues with large contact lists: Increase MariaDB memory allocation and enable query cache optimization
- Lost admin access after setup: Reset through database or use Monica's built-in recovery commands via container exec

