Nexlink Telecom - MCP Server Lab

A Network Operations Center (NOC) Assistant built for Nexlink Telecom. This project implements the Model Context Protocol (MCP) over a local SQLite database to allow a local LLM to interact safely with telecom database records.

Database Architecture & ERD

The system uses SQLite (db/nexlink.db) with 5 tables: customers, users, network_nodes, services, and audit_logs.

erDiagram
    users {
        int id PK
        string username UK
        string role "NOC_Admin | NOC_Engineer | Guest"
        string api_token UK
    }

    customers {
        int id PK
        string name
        string industry
        string sla_tier "VIP | Enterprise | Standard"
        string contact_email
    }

    network_nodes {
        int id PK
        string name
        string type "Fiber | 5G Core | Edge Router | Satellite"
        float max_capacity_gbps
        float current_load_gbps
        string status "Healthy | Congested | Down | Maintenance"
        string location
    }

    services {
        int id PK
        int customer_id FK
        int node_id FK
        float allocated_bandwidth_gbps
        string status "Active | Suspended | Pending"
    }

    audit_logs {
        int id PK
        datetime timestamp
        int user_id
        string action
        string details
    }

    customers ||--o{ services : "subscribes to"
    network_nodes ||--o{ services : "hosts"
    users ||--o{ audit_logs : "triggers"

Related MCP server: oci-mcp-server

Protocol Concerns Implementation

Comparison Note (Read-Only vs Write Tools)

• get_customer_network_status: Read-only tool accessible to all roles.

• run_network_diagnostic: Read-only tool that emits progress notifications.

• authenticate_user: State change tool that pushes tools/list_changed notification.

• upgrade_bandwidth: Write tool requiring NOC_Admin role and mid-call elicitation confirmation for VIP upgrades.

• analyze_incident_root_cause: Read tool utilizing protocol sampling.

Transport Choice Justification

• stdio: Used for local terminal CLI development for zero-network security.

• Streamable HTTP: Used for remote deployment across regional NOC centers behind API gateways.

How to Run

1. Install dependencies:

   pip install -r requirements.txt

2. Initialize database:

   python db/setup_db.py

3. Run test runner:

   python demo_runner.py

4. Run client CLI:

   python agent/client.py