# Enterprise Customer Success Dashboard: Notion MCP Integration

## Overview
This repository demonstrates a secure AI architecture that leverages a custom Model Context Protocol (MCP) framework to allow local developer agents to securely interact with a Notion-backed CRM database. 

Built as a proof-of-concept for enterprise deployment, the primary objective is to enable natural language querying of proprietary client health data directly within secure terminal environments, establishing Notion as the system of record for technical deployment tracking.

## Key Features & Notion Integration

### 1. Database Generation via Notion AI
The foundational schema for the Enterprise Customer Success Dashboard was rapidly prototyped and generated utilizing **Notion AI**. By prompting Notion AI with our core business requirements, it automatically structured a robust relational database tracking:
*   **Client Name**
*   **Annual Recurring Revenue (ARR)**
*   **Health Score** (Healthy, At Risk, Escalated, Onboarding)
*   **Target Product**
*   **Deployment Roadblocks**

**📍 View the Database Schema:** Because the live database requires authenticated API access, a full export of the Notion AI-generated structure and mock data is available in this repository under `data/mock_client_data.csv`. This provides a tangible look at the exact functional data structure produced by Notion AI.

### 2. Custom MCP Middleware
To securely expose this Notion data to local AI agents without hardcoding API requests into every prompt, I engineered a custom **Model Context Protocol (MCP)** library. 
*   **Enterprise Viability:** This custom MCP library acts as secure middleware, enabling LLMs to fetch real-time client health data and evaluate deployment bottlenecks. It was designed robustly enough to be adopted as a team framework by enterprise stakeholders.
*   **Zero-Trust Security:** The architecture strictly separates local execution from external context. The Notion API keys remain locally vaulted, ensuring proprietary CRM data can be queried by the AI without leaking credentials to external or public environments.

## Architecture & Workflow
1. **System of Record:** Notion hosts the CRM database, maintaining the single source of truth for client deployment statuses and ARR metrics.
2. **The MCP Bridge:** The custom TypeScript/Node.js MCP server intercepts natural language queries from the local agent.
3. **Execution:** The agent securely reads the Notion database to instantly evaluate high-ARR client statuses and summarize technical deployment bottlenecks, streamlining client success workflows.

## Getting Started

### Prerequisites
* Node.js (v18+)
* A Notion Integration API Key
* A Notion Database ID

### Setup
1. Clone this repository.
2. Run `npm install` (or `pnpm install`) to install dependencies.
3. Copy the `.env.example` file and rename it to `.env`. 
4. Insert your secure Notion API credentials into the new `.env` file. (Note: `.env` is git-ignored to prevent credential leaks).

## Author
**Arnav Kharya**