# Conflict Check MCP

## Overview

The **Conflict Check MCP (Model Context Protocol) Server** is an enterprise conflict-review assistant designed to help users perform historical relationship checks, prior work analysis, affiliate discovery, contractual obligation reviews, and conflict-of-interest assessments using Verdantas project data, client data, Deltek records, contract metadata, clause repositories, and supporting documentation. 【1-8cdcb4】【2-65bc00】

The MCP provides a natural language interface for conflict checks and exposes structured tools that allow users to:

- Search historical Verdantas project involvement
- Perform client and affiliate relationship reviews
- Identify contractors, subcontractors, vendors, and teaming partners
- Analyze site and property matches
- Review contract relationships
- Discover parent-company and affiliate relationships
- Identify confidentiality and NDA obligations
- Detect potential conflict-of-interest restrictions
- Review expert testimony, litigation, and dispute-related clauses
- Generate complete conflict review reports

The MCP currently supports:

✅ Claude Desktop MCP Integration

✅ Query Matrix Driven Execution

✅ Schema-Aware Data Discovery

✅ Dry-Run SQL Validation

✅ Multi-Entity Conflict Reviews

✅ Historical Client & Project Analysis

✅ Contract & Clause Risk Review

---

# Available MCP Tools

## health_check

Checks:

- MCP server availability
- Excel query matrix availability
- Schema workbook availability
- Dry-run status
- Database configuration
- Query loading status

---

## list_available_conflict_queries

Returns:

- Query ID
- Review section
- Business objective
- Parameters
- SQL mapping

---

## get_conflict_query_details

Returns:

- Query details
- Business objective
- Required parameters
- SQL definition

---

## run_conflict_check_query

Runs a single conflict-review query.

Supports:

- Client searches
- Contractor searches
- Affiliate searches
- Address searches
- Contract reviews

---

## run_full_conflict_check_report

Executes all applicable conflict-review queries and returns a complete conflict assessment.

---

## get_conflict_schema_summary

Returns:

- Fabric tables
- Deltek source tables
- Contract tables
- Join relationships
- Linkage documentation

---

# Example Questions Users Can Ask

---

# MCP Validation

```text
Run health_check.
```

```text
List all available conflict-check queries.
```

```text
Show details for query Q001.
```

```text
Show the schema summary.
```

---

# Client & Party Search

### Historical Client Search

```text
Check whether Zelestra exists in historical Verdantas projects.
```

### Client KPI Review

```text
Show historical revenue, proposals, invoices, and project metrics for Zelestra.
```

### Vendor / Competitor Check

```text
Has Zelestra ever appeared as a client, vendor, competitor, contractor, or affiliate?
```

### Relationship Analysis

```text
What is Verdantas' historical relationship with Zelestra?
```

---

# Address & Site Match Questions

### Historical Client Match

```text
What historical clients are associated with Austin?
```

### Site Match

```text
Have we worked at 500 Energy Plaza before?
```

### Location Match

```text
Have we previously worked at the same project location?
```

### Contract Address Search

```text
Does this address appear in historical contracts?
```

---

# Project Review Questions

### Prior Work Review

```text
Have we performed previous work on the West Texas Utility-Scale Solar project?
```

### Similar Project Match

```text
Have we performed work on the same corridor or similar project?
```

### Supporting Documentation

```text
Find project documentation related to West Texas Utility-Scale Solar.
```

### Historical Project Search

```text
Show all historical projects related to this client.
```

---

# Ultimate Client Review

### Relationship History

```text
What historical relationship has Verdantas had with ERCOT?
```

### KPI Analysis

```text
Show relationship KPIs for ERCOT.
```

### Financial Relationship Review

```text
How much revenue has been generated from ERCOT projects?
```

---

# Related Entity Discovery

### Affiliate Discovery

```text
Discover affiliated organizations related to Zelestra.
```

### Vendor Discovery

```text
Identify vendors associated with Zelestra.
```

### Teaming Partner Discovery

```text
Identify teaming partners associated with Zelestra.
```

### Contract Entity Discovery

```text
Extract additional entities mentioned within related contracts.
```

---

# Hiring Client Risk Assessment

### Historical Project Review

```text
Show prior project history for Zelestra USA Development LLC.
```

### Risk Assessment

```text
Determine relationship history and risk factors for Zelestra USA Development LLC.
```

### Contract Assessment

```text
Identify contracts involving Zelestra USA Development LLC.
```

### Materiality Review

```text
Show project materiality and financial exposure for Zelestra USA Development LLC.
```

---

# Parent Company & Affiliate Review

### Corporate Family Search

```text
Show all affiliates related to Zelestra Group.
```

### Parent Hierarchy

```text
Show the parent-child hierarchy for Zelestra Group.
```

### Affiliate Contract Review

```text
Identify contracts involving companies under Zelestra Group.
```

### Vendor Discovery

```text
Show vendors associated with Zelestra Group.
```

---

# Developer Review

### Prior Project Involvement

```text
Determine prior project involvement for Zelestra USA Development LLC.
```

### Contract Involvement

```text
Determine contract involvement for Zelestra USA Development LLC.
```

### Historical Engagement Review

```text
Show historical Verdantas engagements involving Zelestra USA Development LLC.
```

---

# General Contractor Review

### Contractor Relationship

```text
Have we worked with Mortenson Construction?
```

### Historical Project Review

```text
Show historical project involvement for Mortenson Construction.
```

### Vendor Review

```text
Show contractor and vendor relationships involving Mortenson Construction.
```

---

# Subcontractor Review

### Relationship Review

```text
Show historical relationships with Terracon Consultants.
```

### Prior Participation

```text
Identify projects involving Terracon Consultants.
```

### Vendor Assessment

```text
Show vendor information for Terracon Consultants.
```

---

# Opposing Counsel Review

### Law Firm Search

```text
Does Brown & Associates LLP appear in historical contracts?
```

### Legal Reference Search

```text
Locate legal references involving Brown & Associates LLP.
```

### Contract Summary Review

```text
Show contract summaries mentioning Brown & Associates LLP.
```

---

# Contractual Relationship Review

### Active Contract Review

```text
Identify active contracts involving Zelestra.
```

### Historical Contract Review

```text
Show historical contract relationships involving ERCOT.
```

### Relationship Context

```text
Explain the contract context for Zelestra-related engagements.
```

---

# Confidentiality & NDA Review

### Confidentiality Obligations

```text
Determine confidentiality obligations related to this matter.
```

### NDA Review

```text
Determine NDA obligations related to this engagement.
```

### Ownership Review

```text
Determine ownership restrictions related to this project.
```

### Original Clause Retrieval

```text
Retrieve original confidentiality clause language.
```

---

# Conflict of Interest Review

### Conflict Assessment

```text
Identify conflict obligations affecting this project.
```

### Exclusive Service Review

```text
Identify exclusive-service obligations.
```

### Non-Compete Review

```text
Identify competitive restrictions.
```

### Subcontracting Restriction Review

```text
Identify subcontracting restrictions.
```

---

# Expert Testimony & Litigation Risk

### Expert Testimony Review

```text
Identify expert testimony obligations.
```

### Litigation Review

```text
Identify litigation-related obligations.
```

### Dispute Review

```text
Identify dispute-related obligations.
```

---

# Full Conflict Reports

### Full Client Conflict Check

```text
Run a full conflict check for Zelestra USA Development LLC.
```

### Full Project Conflict Review

```text
Generate a conflict report for the West Texas Utility-Scale Solar Development Program.
```

### Multi-Party Review

```text
Perform a conflict review for ERCOT, Zelestra USA Development LLC, and Mortenson Construction.
```

### Address-Based Review

```text
Analyze potential conflicts related to 500 Energy Plaza, Austin, Texas.
```

### Comprehensive Intake Review

```text
Run a complete conflict check using:

Hiring Client: Zelestra USA Development LLC
Ultimate Client: ERCOT
Project: West Texas Utility-Scale Solar Development Program
Address: 500 Energy Plaza, Austin TX
General Contractor: Mortenson Construction
Subcontractor: Terracon Consultants

Return findings related to:
- Prior Verdantas work
- Client relationships
- Parent company affiliations
- Site matches
- Contractor/subcontractor involvement
- Contractual restrictions
- Potential conflict indicators
```

---

# Current Status

| Component | Status |
|------------|---------|
| Claude Desktop MCP Integration | ✅ Enabled |
| Conflict Query Matrix Loaded | ✅ Enabled |
| Schema Workbook Loaded | ✅ Enabled |
| Query Discovery | ✅ Enabled |
| Dry-Run SQL Generation | ✅ Enabled |
| Live Database Execution | ⚠ Requires DB Configuration |
| Fabric Connectivity | ⚠ Pending Configuration |

---

# Notes

- The MCP currently runs in **dry-run mode**.
- SQL queries are validated before execution.
- Live execution requires Fabric SQL endpoint configuration.
- Database credentials must be configured through environment variables before production usage.
- The MCP is designed to support both standalone conflict reviews and future Copilot Studio integrations.