Skip to main content
Glama
sumitkrgupta05

LearnDCAgentMCPServer

by sumitkrgupta05
OverviewSchemaSourceRelated ServersScoreDiscussionsAdmin
Remote

🚀 Omni-Channel Customer Success Intelligence Platform

Salesforce Lightning ⚡ Google Cloud Platform ☁️ Slack Enterprise 💬 Snowflake DWH ❄️ Google Gemini 3.6 Flash 🧠

Salesforce Google Cloud Slack Snowflake Google Gemini Tests

🌟 Executive Overview

The Omni-Channel Customer Success Intelligence Platform is an enterprise-grade, event-driven solution that unifies Salesforce Lightning CRM, Google Cloud Platform, Slack Enterprise, Snowflake Cloud Data Warehouse, and Google AI Studio (Gemini 3.6 Flash) into a single, cohesive customer success copilot.

Customer Success Managers (CSMs) and Account Executives (AEs) operate with complete workflow continuity across Salesforce record pages, Slack channels, and private direct messages—with zero platform friction, zero brand leakage, and strict enterprise security guardrails.

Related MCP server: Snowflake Cortex AI MCP Server

🏛️ Grand Unified Architecture

graph TD
    subgraph SF_PLATFORM["Salesforce Lightning Platform (CRM)"]
        LWC_BOT["slackBotAgent (LWC)<br/>• Left Thread History<br/>• User Privacy Isolation<br/>• Native Desktop Alerts<br/>• Slash Commands Palette"]
        LWC_GMAIL["accountGmail (LWC)<br/>• Split-Pane Reader<br/>• RFC 2822 Header Threading<br/>• Whole Thread AI Summary"]
        LWC_CAL["accountGoogleCalendar (LWC)<br/>• Meeting Scheduler<br/>• Auto Google Meet Link<br/>• Event Type Isolation"]
        
        CTRL_BOT["SlackBotAgentController.cls<br/>& SlackUserIdentityService.cls"]
        CTRL_GMAIL["AccountGmailController.cls<br/>& AccountGmailInboundHandler.cls"]
        CTRL_CAL["AccountCalendarController.cls<br/>& GoogleAuthService.cls (JWT)"]
        
        MCP_SERVER["LearnDCAgentMCPServer.cls<br/>(Apex Invocable MCP Server)<br/>• search_accounts<br/>• query_snowflake<br/>• create_account_task"]
        
        LWC_BOT --> CTRL_BOT
        LWC_GMAIL --> CTRL_GMAIL
        LWC_CAL --> CTRL_CAL
        CTRL_BOT --> MCP_SERVER
    end

    subgraph GCP_CLOUDRUN["Google Cloud Platform (slack-gemini-agent)"]
        GATEWAY["Express HTTP Gateway (Port 8080)<br/>• GET /auth/login<br/>• POST /auth/slack/confirm<br/>• POST /api/chat<br/>• GET /health"]
        CONSENT_UI["Slack Workspace Consent Screen<br/>(Branded User Authorization UI)"]
        GEMINI_ENGINE["Google AI Studio Gemini 3.6 Flash<br/>• Multi-turn Session Manager<br/>• Autonomous Tool Loop"]
        SNOW_DAEMON["SnowflakeSyncDaemon.ts<br/>• Continuous 5s Bi-Directional Sync<br/>• 0s On-Demand SLA Reconciliation"]
        
        GATEWAY --> CONSENT_UI
        GATEWAY --> GEMINI_ENGINE
        GATEWAY --> SNOW_DAEMON
    end

    subgraph SLACK_WORKSPACE["Slack Enterprise Workspace (T0BU7EDE40P)"]
        SOCKET_MODE["Socket Mode WebSocket (wss://)<br/>• No Public Ports / Ngrok<br/>• Outbound Persistent Tunnel"]
        SLACK_BOT["Slack App: test_agent_app<br/>(App ID: A0BU7FHCFEK)"]
        SLASH_CMDS["Slash Commands Engine<br/>• /account-brief (3s ack)<br/>• /summarize-thread<br/>• /snowflake<br/>• /help"]
        PRIVATE_DMS["Private 1-on-1 DMs<br/>(conversations.open per CSM)"]
        
        SOCKET_MODE --> SLACK_BOT
        SLACK_BOT --> SLASH_CMDS
        SLACK_BOT --> PRIVATE_DMS
    end

    subgraph SNOWFLAKE_DWH["Snowflake Cloud Data Warehouse (hjyxziv-mi58790)"]
        BASE_ANALYTICS[("LEARNDC_DB.ANALYTICS<br/>ACCOUNT_ANALYTICS<br/>(Base Table - 5s Sync)")]
        SECURE_MCP[("LEARNDC_MCP_DB.SECURE_ANALYTICS<br/>V_ACCOUNT_INSIGHTS<br/>(8 Sanitized Telemetry Fields)")]
        MCP_ROLE["Role: MCP_AGENT_READER_ROLE<br/>• Least-Privilege Read-Only<br/>• Key-Pair RSA Authentication"]
        
        BASE_ANALYTICS --> SECURE_MCP
        SECURE_MCP --> MCP_ROLE
    end

    subgraph GOOGLE_WORKSPACE["Google Workspace Services"]
        GMAIL_SVC["Gmail API & Inbound Relay<br/>(RFC 2822 Headers & csm-reply@...)"]
        GCAL_SVC["Google Calendar API v3<br/>& Google Meet Video Link Generator"]
        GPUSH_SVC["Google Push Notifications Webhook<br/>(Delta Sync with syncToken)"]
    end

    CTRL_BOT <==>|Fast Identity & REST Invocable| GATEWAY
    GATEWAY <==>|Socket Mode wss://| SOCKET_MODE
    GEMINI_ENGINE <==>|Autonomous Function Calling| MCP_SERVER
    SNOW_DAEMON <==>|MERGE INTO & Telemetry Writeback| BASE_ANALYTICS
    GEMINI_ENGINE <==>|Read-Only Parameterized SQL| SECURE_MCP
    CTRL_GMAIL <==>|Inbound & Outbound Dual Delivery| GMAIL_SVC
    CTRL_CAL <==>|RSA JWT Bearer & Webhook Push| GCAL_SVC
    GPUSH_SVC -->|Delta Notification Ping| CTRL_CAL

⚡ Key Core Capabilities & Architectural Pillars

1. 🤖 Omni-Channel Slack Bot Agent & LWC Copilot (slackBotAgent)

  • Headless AI Agent Architecture: Single primary Gemini 3.6 Flash engine powers both Slack and the Salesforce Account LWC.

  • Left Sidebar Thread History: Scoped by Account and strictly isolated by user (CreatedById = :currentUserId). Users never see other reps' private chats.

  • Activity Timeline Hygiene: General chats never flood Salesforce with dummy tasks. Salesforce Task records are only created with explicit parameters and an intentional user confirmation modal.

  • Slack Deep Links (Slack ↗): One-click navigation to the exact persistent Slack thread in desktop or web.

  • Hybrid High-Availability Fallback: Automatic failover from Node.js Gateway to native Apex MCP Server if the gateway is ever offline.

2. 📬 Domain-Free Bidirectional Gmail Threading

  • Overcomes Domain & Admin Restrictions: Bypasses corporate Google Workspace domain verification and daily developer email limits.

  • RFC 2822 Inbound & Outbound Header Engine: Injects Message-ID, In-Reply-To, and References headers, ensuring native Gmail thread grouping.

  • Dual-Delivery Routing: Automatically delivers to the customer and mirrors to the CSM's personal inbox (skgsummo5@gmail.com).

  • Whole-Thread AI Summarizer: Gemini 3.6 Flash analyzes entire conversation chains to produce an executive summary, discussion highlights, and action items, cached in Gmail_Thread_Summary__c.

3. 📅 Real-Time Google Calendar & Meet Sync

  • Enterprise JWT Bearer Authentication: Apex crafts RSA-SHA256 signed JWT assertion tokens for Google Workspace Domain-Wide Delegation.

  • Google Meet Auto-Generation: Seamlessly generates and binds Google Meet video links (https://meet.google.com/...) upon booking.

  • Push Webhook Delta-Syncing: Inbound changes from Google Calendar trigger webhook pings, processed via queueable jobs using syncToken to eliminate infinite loops.

  • Event Type Isolation: Calendar meetings and email interactions maintain strict type separation on the standard Event object.

4. ⌨️ Slack Slash Commands Engine (/account-brief, etc.)

  • 3-Second Acknowledgment Rule: Immediate await ack() prevents Slack operation_timeout errors.

  • 360° Account Briefing (/account-brief): Parallel retrieval of Salesforce CRM vitals, Snowflake telemetry, and Gmail thread intelligence in an executive Block Kit card.

  • Dynamic Thread Summarization (/summarize-thread): Extracts critical action items from email chains on demand.

  • Snowflake Telemetry (/snowflake): Direct read of warehouse health scores and compute hours.

5. 🔔 Native OS Desktop Notifications & Background Alerts

  • Page Visibility API: Detects when the user minimizes the browser or multitasks in another tab (document.hidden === true).

  • HTML5 Web Notification API: Dispatches native Windows 11 / macOS desktop toast cards with sound and Salesforce cloud branding.

  • One-Click Tab Focus: Clicking the notification instantly brings the browser tab to the front.

  • Tab Title Pulsing: Alternates tab title with 🔔 (1) New Reply Ready | Salesforce until focused.

6. ❄️ Snowflake Two-Tier Bi-Directional Sync & Secure MCP View

  • Tier 1 (5s Daemon): SnowflakeSyncDaemon.ts continuously syncs modified Accounts to LEARNDC_DB.ANALYTICS.ACCOUNT_ANALYTICS and writes back telemetry.

  • Tier 2 (Secure MCP): Dedicated database LEARNDC_MCP_DB and Secure View V_ACCOUNT_INSIGHTS restrict access to strictly 8 sanitized telemetry fields.

  • Least-Privilege Role: MCP_AGENT_READER_ROLE with key-pair RSA authentication and zero DML/DDL permissions.

  • Zero Platform Brand Leakage: AI synthesizes unified dossiers without exposing vendor names to business users.

7. 🔐 Multi-User Identity & OAuth Consent Handshake

  • Frictionless Onboarding: Clicking "Sign in with Slack" opens a secure popup to the GCP Gateway (/auth/login).

  • User Authorization Screen: Presents a branded Slack Workspace Consent Screen detailing permissions.

  • Automated DM Channel Provisioning: POST /auth/slack/confirm creates a dedicated 1-on-1 private channel (conversations.open) and updates the Salesforce User record in <5ms.

📂 Repository Structure

├── force-app/main/default/              # Salesforce DX Metadata
│   ├── classes/                         # Apex Controllers, Services & Tests (100% Pass)
│   │   ├── SlackBotAgentController.cls  # LWC Copilot Controller & Session Resumption
│   │   ├── SlackUserIdentityService.cls # User Identity Resolver & Auth URL Generator
│   │   ├── AccountGmailController.cls   # Gmail Split-Pane Backend Controller
│   │   ├── AccountGmailInboundHdlr.cls  # Inbound RFC 2822 Email Service Handler
│   │   ├── GmailAIService.cls           # Whole Thread Gemini AI Summarizer
│   │   ├── AccountCalendarCtrl.cls      # Google Calendar Meeting Scheduler
│   │   ├── GoogleAuthService.cls        # RSA-SHA256 JWT Bearer Assertion Generator
│   │   ├── GoogleCalendarService.cls    # Google Calendar API v3 Callout Engine
│   │   ├── GoogleCalendarQueueable.cls  # Delta-Syncing Webhook Queueable Job
│   │   └── LearnDCAgentMCPServer.cls    # Apex Invocable MCP Server Provider
│   └── lwc/                             # Lightning Web Components
│       ├── slackBotAgent/               # AI Copilot Cockpit & Notification Controller
│       ├── accountGmail/                # Master-Detail Split-Pane Conversation Reader
│       └── accountGoogleCalendar/       # Interactive Meeting Scheduler with Meet Link
├── slack-gemini-agent/                  # Google Cloud Platform Node.js/TS Middleware
│   ├── src/
│   │   ├── index.ts                     # Express HTTP Server & Socket Mode Entry Point
│   │   ├── api/auth.ts                  # OAuth Handshake & Consent Screen Controller
│   │   ├── bot/slackBot.ts              # Slack Bolt Framework Event Orchestration
│   │   ├── commands/slashCommands.ts    # Slash Command Handlers (/account-brief, etc.)
│   │   ├── services/geminiService.ts    # Google AI Studio Gemini 3.6 Flash Interface
│   │   ├── services/snowflakeDaemon.ts  # 5-Second Real-Time Salesforce <-> Snowflake Sync
│   │   └── mcp/                         # Model Context Protocol Client Implementations
│   ├── Dockerfile                       # Multi-stage Container Runtime
│   └── package.json                     # Node.js Dependencies & Build Scripts
├── docs/                                # Technical Markdown Documentation
└── docs-html/                           # Interactive HTML Documentation with Mermaid & SVGs

📚 Documentation Library

Every architectural component is documented with both a Markdown specification and an interactive HTML guide featuring embedded SVG illustrations and Mermaid diagrams:

Documentation Topic

Markdown Guide (docs/)

Interactive HTML Guide (docs-html/)

⭐ Grand Unified Master Playbook

MASTER_SALESFORCE_INTEGRATION_GUIDE.md

MASTER_SALESFORCE_INTEGRATION_GUIDE.html

☁️ GCP Slackbot & Salesforce MCP Setup

GCP_SLACKBOT_MCP_SETUP_GUIDE.md

GCP_SLACKBOT_MCP_SETUP_GUIDE.html

📬 Gmail Real-Time Bidirectional Sync

SALESFORCE_GMAIL_INTEGRATION.md

SALESFORCE_GMAIL_INTEGRATION.html

📅 Google Calendar & Meet Booking

SALESFORCE_GOOGLE_CALENDAR_INTEGRATION.md

SALESFORCE_GOOGLE_CALENDAR_INTEGRATION.html

🤖 Slack & Google AI Studio Integration

SALESFORCE_SLACK_GOOGLE_AI_STUDIO_INTEGRATION.md

SALESFORCE_SLACK_GOOGLE_AI_STUDIO_INTEGRATION.html

❄️ Snowflake Two-Tier Bi-Directional DWH

SALESFORCE_SNOWFLAKE_INTEGRATION.md

SALESFORCE_SNOWFLAKE_INTEGRATION.html

💬 Slack Bot Agent LWC Architecture

SLACK_BOT_AGENT_LWC_INTEGRATION.md

SLACK_BOT_AGENT_LWC_INTEGRATION.html

⌨️ Slack Slash Commands Implementation

SLACK_SLASH_COMMANDS_GUIDE.md

SLACK_SLASH_COMMANDS_GUIDE.html

🔔 Native OS Desktop Notifications

LWC_DESKTOP_NOTIFICATIONS_INTEGRATION.md

LWC_DESKTOP_NOTIFICATIONS_INTEGRATION.html

🔌 Snowflake Model Context Protocol (MCP)

SNOWFLAKE_MCP_INTEGRATION_GUIDE.md

SNOWFLAKE_MCP_INTEGRATION_GUIDE.html

🛠️ Quick Start & Local Setup

1. Prerequisites

  • Node.js: v20.x or v22.x+

  • Salesforce CLI (sf): v2.x+

  • Docker (Optional, for containerized local runtime)

2. Salesforce Deployment

Deploy the metadata to your target org:

sf project deploy start -o <your-org-alias>

Run the test suite to verify 100% test pass rate:

sf apex run test -n "SlackBotAgentControllerTest,SlackUserIdentityServiceTest" -o <your-org-alias> -r human -c

3. Middleware Service Configuration

Navigate to slack-gemini-agent and configure environment variables:

cd slack-gemini-agent
cp .env.example .env

Fill in your secrets:

PORT=8080
GEMINI_API_KEY=your_gemini_api_key
SLACK_BOT_TOKEN=xoxb-...
SLACK_SIGNING_SECRET=your_signing_secret
SLACK_APP_TOKEN=xapp-...
SF_LOGIN_URL=https://login.salesforce.com
SF_CLIENT_ID=your_connected_app_client_id
SF_CLIENT_SECRET=your_connected_app_client_secret
SF_USERNAME=your_salesforce_username
SF_PASSWORD=your_password_and_token
SNOWFLAKE_ACCOUNT=your_snowflake_account
SNOWFLAKE_USERNAME=LEARNDC_MCP_AGENT
SNOWFLAKE_PRIVATE_KEY_PATH=./secrets/rsa_key.p8
SNOWFLAKE_DATABASE=LEARNDC_MCP_DB
SNOWFLAKE_SCHEMA=SECURE_ANALYTICS
SNOWFLAKE_ROLE=MCP_AGENT_READER_ROLE

Install dependencies and start the service:

npm install
npm run build
npm run start

🛡️ Enterprise Security & Quality Certification

  • Zero Brand Leakage: Business users interact with a unified AI persona without underlying infrastructure seams.

  • Least-Privilege Security: Snowflake access is restricted to read-only views with key-pair authentication.

  • Privacy Isolation: User chat histories in Salesforce are scoped by CreatedById, preventing cross-rep data leaks.

  • Activity Hygiene: Chat messages do not pollute CRM timelines with unnecessary tasks.

  • Production Certified: Verified with 100% Apex test coverage across all controller and service classes.

👤 Author & Support

  • Lead Engineer & Architect: Summo CSM (skgsummo5@gmail.com)

  • Organization: Teqfocus Solutions / Learn DC Enterprise Architecture

This server cannot be installed

RayrunBuild, deploy, and operate MCP servers without becoming an infrastructure team.ray.runAd

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Connectors

Related MCP Servers

  • MCP Force

    RapidoCloud
    A
    license
    Not graded
    quality
    D
    maintenance
    Enables AI agents to interact with Salesforce organizations through natural language by exposing Salesforce APIs (REST, Bulk v2, GraphQL, Tooling, Auth) as MCP tools for querying data, managing records, and executing SOQL queries.
    8
    19
    MIT

  • Snowflake Cortex AI MCP Server

    sfc-gh-tgordonjr
    A
    license
    Not graded
    quality
    D
    maintenance
    Integrates Snowflake Cortex AI features like Cortex Search and Analyst into the MCP ecosystem, enabling retrieval-augmented generation and structured data analysis. It also provides tools for chat completions and agentic orchestration using Snowflake-hosted large language models.
    Apache 2.0

  • Salesforce MCP Server

    hypn4
    A
    license
    A
    quality
    C
    maintenance
    Enables AI agents to interact with Salesforce through MCP, supporting queries, records, metadata, and bulk operations with flexible OAuth authentication.
    16
    MIT