# DevOps Assistant MCP Server (Modular)

A professional-grade **Model Context Protocol (MCP)** server built with TypeScript. It acts as a multi-functional "DevOps Assistant" that allows AI models to securely query local databases and manage Docker infrastructure through a standardized interface.

## 🚀 Features

- **Modern Architecture:** Built using the latest `@modelcontextprotocol/sdk` (v1.3+).
- **Multi-Service Integration:** Single entry point for Database, System, and Docker management.
- **Docker Management:** Directly interact with the local Docker socket to inspect containers and debug logs.
- **Modular Design:** Separation of concerns between configuration, server orchestration, and service-specific tool logic.
- **Type-Safe:** Full TypeScript implementation with **Zod** schema validation for all tool inputs.

## 🛠️ Tools Provided

### 🗄️ Database Tools
- **`query_database`**: Execute SQL queries on the local MySQL instance to analyze data or system records.

### 🐳 Docker Tools
- **`list_containers`**: List all local Docker containers and their current status (Running, Stopped, etc.).
- **`get_container_logs`**: Retrieve the last 50 lines of logs from a specific container for real-time debugging.

### ⚙️ System Tools
- **`get_system_time`**: Utility tool to retrieve the server's current time for log synchronization.

## 📋 Prerequisites

- **Node.js** (v18+)
- **Docker Desktop** (or OrbStack)
- **MCP Client** (e.g., VS Code with "Continue" or "Roo Code", or the MCP Inspector)

## 🚦 Quick Start

### 1. Start the Sample Database
Run the MySQL container using Docker:

```bash
docker run -d \
  --name mcp-app-db \
  -e MYSQL_ROOT_PASSWORD=mypassword \
  -e MYSQL_DATABASE=mcp_learning \
  -p 3306:3306 \
  mysql:latest
```

### 2. Install Dependencies
```bash
npm install
```

### 3. Seed the Database
Populate the database with sample user data:
```bash
npm run seed
```

### 4. Build and Test
Compile the TypeScript code and run the MCP Inspector:
```bash
npm run build
npx @modelcontextprotocol/inspector node dist/index.js
```

## 🏗️ Project Structure
- `src/config.ts`: Centralized configuration for all services.
- `src/tools/database.ts`: SQL query logic.
- `src/tools/docker.ts`: Docker socket integration logic.
- `src/tools/system.ts`: General utility tools.
- `src/index.ts`: The main orchestrator and entry point.

## 📄 License
ISC