enterprise-core
Allows triaging and annotating GitHub issues, listing open issues, and fetching CI/CD commit statuses from repositories.
Provides tools for querying PostgreSQL safely with AST-validated read-only SQL, listing tables, and accessing live table schemas, enabling incident investigation and data analysis.
Enables sending Slack notifications formatted with Block Kit, including alerts for errors and critical incidents.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@enterprise-coreInvestigate incident INC-902 and quantify revenue exposure."
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
๏ปฟ# Enterprise MCP Suite
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):
An on-call engineer wakes up and connects via VPN.
Manually parses noisy PostgreSQL logs across shards (20 mins).
Queries the ERP database to identify impacted high-value customers (15 mins).
Correlates GitHub commits or issue trackers for recent deployments (10 mins).
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:
Formulates an execution plan via OpenAI GPT-4o.
Executes safe, read-only SQL via AST-validated
db_query_tool.Identifies the root cause: HTTP 502 Bad Gateway in
payment-gateway.Discovers the affected VIP customer (
Priya Nair / InfraStack Solutions Pvt.).Pinpoints the exact failed order (
$62,400 USD).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 documentationQuick 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 .envOpen .env and configure your OPENAI_API_KEY:
OPENAI_API_KEY=sk-proj-your-actual-key-here3. Start Database Infrastructure
docker-compose up -d
# Verify healthy status (wait ~20 seconds)
docker-compose ps4. Run the Automated Verification Suite
python test_end_to_end.pyExpected 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.pyAccess all 5 demonstration scenarios live through an interactive terminal interface.
MCP Tools Reference
Tool Name | Description | Requires HITL |
| Execute safe SQL query (read-only by default) | No |
| List all user tables in enterprise catalogue | No |
| Triage and annotate GitHub issues | Comment only |
| List open repository issues | No |
| Fetch CI/CD pipeline commit status | No |
| Retrieve ERP order details and fulfillment history | No |
| List customer order portfolio | No |
| Trigger warehouse order dispatch | Yes |
| Send Slack notification (Block Kit formatted) | Error/Critical |
MCP Resources Reference
URI Pattern | Description |
| Real-time DDL table schema from PostgreSQL catalogue |
| Live connection pool telemetry, service latency, server status |
MCP Prompts Reference
Prompt Name | Description |
| End-to-end SRE incident triage workflow |
| 360-degree account and revenue intelligence dossier |
| Security and vulnerability audit workflow |
Claude Desktop Integration
To register this server natively with Claude Desktop:
Copy the contents of
claude_desktop_config.json.Paste into your Claude Desktop config file:
Windows:
%APPDATA%\Claude\claude_desktop_config.jsonmacOS:
~/Library/Application Support/Claude/claude_desktop_config.json
Update
OPENAI_API_KEYand working directory paths.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.
This server cannot be installed
Maintenance
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
Deterministic safety, correctness & cost gate that vets Postgres SQL before your AI agent runs it.
Safe, read-only Postgres and MySQL access for AI agents. Audit log + column-level controls.
Query PostgreSQL databases in plain English โ LLM-generated, safety-validated SQL.
- mcpOAuthcom.vibgrate
Query your team's drift, vulnerability, and upgrade data from any AI assistant. OAuth 2.1, 51 tools.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables 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.607MIT
- AlicenseNot gradedqualityCmaintenanceEnables AI agents to securely interact with multiple databases (MySQL, PostgreSQL) via natural language queries, with cross-database querying and enterprise-grade security.14MIT
- AlicenseNot gradedqualityBmaintenanceConnects AI assistants to PostgreSQL databases with production-grade safety features including query validation, guarded writes, rate limiting, and audit logging.3MIT
- AlicenseAqualityDmaintenanceEnables AI agents to securely query databases (PostgreSQL, SQLite, MySQL, DuckDB) with read-only defaults and multi-layer SQL injection prevention.81MIT
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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