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:

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

npm install

3. Seed the Database

Populate the database with sample user data:

npm run seed

4. Build and Test

Compile the TypeScript code and run the MCP Inspector:

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