Skip to main content
Glama

๏ปฟ# Enterprise MCP Suite

MCP Standard LangGraph Security Python Docker

Enterprise-Grade AI Agent Security & Integration Infrastructure
Connecting LLMs to PostgreSQL, GitHub, Mock ERP, and Slack via Anthropic's Model Context Protocol (MCP) standard with zero-trust AST SQL inspection and Human-in-the-Loop safeguards.


๐Ÿš€ Commercial & Client Demonstration Assets

Everything you need to pitch, demonstrate, and deploy this platform for enterprise clients:

  • ๐ŸŽฎ Live Interactive Showcase: python demo_showcase.py (Single-command menu covering all live client scenarios)

  • ๐Ÿ“Š Executive Briefing & Pitch Deck: ROI models, architecture comparison, enterprise pricing tiers

  • ๐Ÿ“ข Sales & Marketing Outreach Kit: LinkedIn copy, CTO cold emails, discovery scripts, objection handling

  • ๐Ÿงช End-to-End QA Test Guide: Complete step-by-step verification manual (12/12 automated tests)


Related MCP server: Database MCP Server

Real-World Scenario: What This Platform Solves

Imagine an alert fires at 02:45 AM:
"Payment gateway intermittent failure โ€” checkout transactions stalling!"

Traditional Manual SRE Workflow (45โ€“60 Minutes):

  1. An on-call engineer wakes up and connects via VPN.

  2. Manually parses noisy PostgreSQL logs across shards (20 mins).

  3. Queries the ERP database to identify impacted high-value customers (15 mins).

  4. Correlates GitHub commits or issue trackers for recent deployments (10 mins).

  5. Drafts and broadcasts a high-priority incident debrief on Slack (10 mins).

Autonomous Enterprise MCP Workflow (10โ€“12 Seconds):

You supply a natural language goal:

python run_investigation.py "Investigate incident INC-902 and quantify revenue exposure."

The Agent Autonomously:

  1. Formulates an execution plan via OpenAI GPT-4o.

  2. Executes safe, read-only SQL via AST-validated db_query_tool.

  3. Identifies the root cause: HTTP 502 Bad Gateway in payment-gateway.

  4. Discovers the affected VIP customer (Priya Nair / InfraStack Solutions Pvt.).

  5. Pinpoints the exact failed order ($62,400 USD).

  6. Generates a structured executive debrief with source citations and an audit trail.


System Architecture

โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”
โ”‚                     Enterprise MCP Suite                              โ”‚
โ”‚                                                                      โ”‚
โ”‚  โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”     stdio / SSE      โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”โ”‚
โ”‚  โ”‚   Claude    โ”‚โ—„โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ โ”‚   FastMCP Server           โ”‚โ”‚
โ”‚  โ”‚   Desktop   โ”‚                      โ”‚   (server/mcp_server.py)   โ”‚โ”‚
โ”‚  โ”‚   / Cursor  โ”‚                      โ”‚                            โ”‚โ”‚
โ”‚  โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜                      โ”‚  โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ” โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”  โ”‚โ”‚
โ”‚                                       โ”‚  โ”‚Tools โ”‚ โ”‚ Resources  โ”‚  โ”‚โ”‚
โ”‚  โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”  โ”‚  โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”˜ โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜  โ”‚โ”‚
โ”‚  โ”‚  LangGraph Agent (OpenAI GPT-4o)โ”‚  โ”‚  โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”  โ”‚โ”‚
โ”‚  โ”‚                                 โ”‚  โ”‚  โ”‚     Prompts         โ”‚  โ”‚โ”‚
โ”‚  โ”‚  Planner โ†’ MCPExecutor โ†’ HITL   โ”‚  โ”‚  โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜  โ”‚โ”‚
โ”‚  โ”‚         โ†’ Synthesizer           โ”‚  โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜โ”‚
โ”‚  โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜           โ”‚                     โ”‚
โ”‚                                                 โ–ผ                     โ”‚
โ”‚  โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ” โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ” โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ” โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”               โ”‚
โ”‚  โ”‚PostgreSQLโ”‚ โ”‚ GitHub   โ”‚ โ”‚ Mock ERP โ”‚ โ”‚  Slack   โ”‚               โ”‚
โ”‚  โ”‚ (Docker) โ”‚ โ”‚   API    โ”‚ โ”‚ REST API โ”‚ โ”‚ Webhooks โ”‚               โ”‚
โ”‚  โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜ โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜ โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜ โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜               โ”‚
โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜

Security Pipeline

Agent Tool Request โ”€โ”€โ–บ SafeQueryInspector (sqlglot AST) โ”€โ”€โ–บ Blocked if DROP/DELETE
                              โ”‚                                  (0 ms, pre-connection)
                              โ–ผ
                     Connection Pool โ”€โ”€โ–บ Read-Only PostgreSQL
                              โ”‚
             [Mutating Tools] โ”€โ”€โ–บ HITL Guard โ”€โ”€โ–บ Awaits approval_token='APPROVED'

Project Structure

enterprise-mcp-suite/
โ”œโ”€โ”€ docker-compose.yml              # PostgreSQL 16 Alpine container with healthcheck
โ”œโ”€โ”€ init-db/
โ”‚   โ””โ”€โ”€ 01_seed_enterprise.sql     # 4 schemas + 30+ enterprise seed rows (INC-902 scenario)
โ”œโ”€โ”€ requirements.txt                # Pinned production dependencies
โ”œโ”€โ”€ .env.example                    # Comprehensive environment template
โ”œโ”€โ”€ config.py                       # Pydantic v2 typed settings with SecretStr protection
โ”œโ”€โ”€ demo_showcase.py                # Interactive CLI client presentation panel
โ”œโ”€โ”€ run_investigation.py            # Turnkey CLI autonomous investigation runner
โ”œโ”€โ”€ COMMERCIAL_DECK.md              # Executive briefing, ROI calculations, commercial tiers
โ”œโ”€โ”€ SALES_PITCH_KIT.md              # Marketing kit, LinkedIn posts, CTO cold email templates
โ”œโ”€โ”€ TEST_GUIDE.md                   # 7-group QA and testing manual
โ”œโ”€โ”€ server/
โ”‚   โ”œโ”€โ”€ security.py                 # AST SQL validator + HITL decorator + sanitizers
โ”‚   โ”œโ”€โ”€ tools/
โ”‚   โ”‚   โ”œโ”€โ”€ db_tools.py             # PostgreSQL tools (psycopg connection pool)
โ”‚   โ”‚   โ”œโ”€โ”€ github_tools.py         # GitHub REST API tools
โ”‚   โ”‚   โ”œโ”€โ”€ erp_tools.py            # ERP tools (with in-memory mock fallback)
โ”‚   โ”‚   โ””โ”€โ”€ notification_tools.py   # Slack Block Kit notification tools
โ”‚   โ”œโ”€โ”€ resources/
โ”‚   โ”‚   โ””โ”€โ”€ schema_resources.py     # Dynamic postgres://schema/* and system://health
โ”‚   โ”œโ”€โ”€ prompts/
โ”‚   โ”‚   โ””โ”€โ”€ enterprise_prompts.py   # System incident, customer 360, security audit prompts
โ”‚   โ””โ”€โ”€ mcp_server.py               # FastMCP 2.x server application entry point
โ”œโ”€โ”€ client/
โ”‚   โ”œโ”€โ”€ mcp_client.py               # Async stdio/SSE MCP client wrapper
โ”‚   โ””โ”€โ”€ agent_workflow.py           # LangGraph 4-node autonomous state machine
โ”œโ”€โ”€ test_end_to_end.py              # 12-test automated verification suite
โ”œโ”€โ”€ claude_desktop_config.json      # Native Claude Desktop configuration
โ””โ”€โ”€ README.md                       # Master platform documentation

Quick Start

1. Prerequisites

  • Python 3.11+

  • Docker & Docker Compose running locally

  • OpenAI API Key (sk-proj-... from platform.openai.com)

2. Environment Setup

# Navigate to workspace
cd C:\Users\HP\.gemini\antigravity\scratch\enterprise-mcp-suite

# Activate virtual environment
.venv\Scripts\activate

# Install production dependencies
pip install -r requirements.txt

# Create your .env file
copy .env.example .env

Open .env and configure your OPENAI_API_KEY:

OPENAI_API_KEY=sk-proj-your-actual-key-here

3. Start Database Infrastructure

docker-compose up -d

# Verify healthy status (wait ~20 seconds)
docker-compose ps

4. Run the Automated Verification Suite

python test_end_to_end.py

Expected result: Total: 12 | 12 passed | 0 failed

5. Run an Autonomous Investigation

# Single-command default investigation (INC-902):
python run_investigation.py

# Or provide a custom investigation prompt:
python run_investigation.py "Find all enterprise customers with failed transactions."

The report is displayed on the console and automatically saved to latest_investigation_report.md.

6. Launch the Interactive Client Showcase

python demo_showcase.py

Access all 5 demonstration scenarios live through an interactive terminal interface.


MCP Tools Reference

Tool Name

Description

Requires HITL

db_query_tool

Execute safe SQL query (read-only by default)

No

db_list_tables_tool

List all user tables in enterprise catalogue

No

github_triage_issue_tool

Triage and annotate GitHub issues

Comment only

github_list_open_issues_tool

List open repository issues

No

github_get_commit_status_tool

Fetch CI/CD pipeline commit status

No

erp_get_order_tool

Retrieve ERP order details and fulfillment history

No

erp_list_customer_orders_tool

List customer order portfolio

No

erp_dispatch_order_tool

Trigger warehouse order dispatch

Yes

slack_send_alert_tool

Send Slack notification (Block Kit formatted)

Error/Critical

MCP Resources Reference

URI Pattern

Description

postgres://schema/{table_name}

Real-time DDL table schema from PostgreSQL catalogue

system://health

Live connection pool telemetry, service latency, server status

MCP Prompts Reference

Prompt Name

Description

triage_system_incident

End-to-end SRE incident triage workflow

customer_360

360-degree account and revenue intelligence dossier

security_audit

Security and vulnerability audit workflow


Claude Desktop Integration

To register this server natively with Claude Desktop:

  1. Copy the contents of claude_desktop_config.json.

  2. Paste into your Claude Desktop config file:

    • Windows: %APPDATA%\Claude\claude_desktop_config.json

    • macOS: ~/Library/Application Support/Claude/claude_desktop_config.json

  3. Update OPENAI_API_KEY and working directory paths.

  4. Restart Claude Desktop. The server will appear under the enterprise-core hammer icon.


Security Architecture

Pre-Connection AST Inspection

Traditional regex validation is fragile and vulnerable to dialect obfuscation. The SafeQueryInspector parses incoming queries into an Abstract Syntax Tree (AST) using sqlglot. Statements containing Drop, Delete, TruncateTable, Update, Insert, Create, or Alter are intercepted and rejected prior to opening any database socket.

Human-in-the-Loop (HITL) Enforcement

Mutating operations utilize the @requires_hitl_approval() decorator. Any invocation lacking approval_token='APPROVED' raises a structured HITLRequiredError. In the LangGraph agent workflow, execution pauses at the hitl_guard node, prompting a human supervisor before re-routing.


License

Enterprise Proprietary / Apache 2.0 Dual License.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections. Dates show when Glama detected each change.

No tool schema history has been recorded yet.

Maintenance

ActivityMaintained
ResponsivenessNo issues

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

  • A
    license
    Not graded
    quality
    D
    maintenance
    Enables AI agents to interact with PostgreSQL databases through schema intelligence, query execution, and DBA tooling including index analysis and health monitoring. Features configurable access levels and audit logging for secure database operations.
    607
    MIT
  • A
    license
    Not graded
    quality
    C
    maintenance
    Enables AI agents to securely interact with multiple databases (MySQL, PostgreSQL) via natural language queries, with cross-database querying and enterprise-grade security.
    14
    MIT
  • A
    license
    Not graded
    quality
    B
    maintenance
    Connects AI assistants to PostgreSQL databases with production-grade safety features including query validation, guarded writes, rate limiting, and audit logging.
    3
    MIT

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Muhammedali26/enterprise-mcp-suite'

If you have feedback or need assistance with the MCP directory API, please join our Discord server