crm-sync

The crm-sync skill acts as a robust data pipeline designed for agents and power users who need to maintain a local, searchable copy of their Zoho CRM data. By bridging the gap between cloud-based CRM systems and local persistence, it enables advanced knowledge retrieval, offline data exploration, and historical tracking without relying on constant API calls. This skill is particularly valuable for consultants, sales teams, and CRM administrators who want to perform high-speed queries on customer profiles, lead sources, and communication histories using SQL.

• Automated synchronization of Zoho Leads module data into a local SQLite file (raw/crm/crm.db).

• Intelligent upsert logic that compares Zoho Modified_Time with local records to ensure only necessary changes are processed.

• Full historical audit trail stored in the leads_history table, documenting every insert, update, or deletion for compliance and data lineage.

• Integrated logging mechanism within the sync_log table to track the status, error messages, and metrics of each synchronization run.

• Secure field mapping including ID, First Name, Last Name, Company, Email, Phone, Lead Source, and Description.

• Ensure the database schema is initialized using scripts/crm/db_schema.sql before the first run.

• The tool leverages the mcp__zoho-crm__ZohoCRM_Get_Records MCP resource for connectivity; ensure your environment variables are configured correctly.

• It is a read-write automation that performs both data ingestion and logging; verify that the raw/crm/ directory is writable.

• The skill provides summary reporting after each execution, displaying metrics such as records fetched, inserted, and updated.

• Respects privacy best practices by redacting sensitive information like full email addresses and phone numbers in standard console outputs.

• Designed for the Brainqub3 Second Brain architecture, allowing seamless integration with other local knowledge base tasks.