Skip to main content
Glama
employee-mcp-server

employee-mcp-server

employee-mcp-server

A Node.js MCP (Model Context Protocol) server that connects Claude to a MySQL employees database, exposing tools to list, search, add, and analyze employee records.

Features list_employees — returns all employees search_employee — find employees by name (partial match) employees_by_department — filter employees by department add_employee — insert a new employee (name, department, salary) highest_salary — returns the highest-paid employee Tech Stack Node.js (ES modules) @modelcontextprotocol/sdk — MCP server implementation mysql2 — MySQL driver zod — input schema validation dotenv — local environment variable loading Project Structure employee-mcp/ ├── index.js # MCP server: defines and registers the 5 tools ├── db.js # MySQL connection pool ├── manifest.json # Desktop Extension (.mcpb) manifest ├── package.json # Dependencies ├── .env # Local DB credentials (not committed) └── .gitignore Setup Install dependencies: bash npm install Create a .env file in the project root: DB_HOST=localhost DB_USER=root DB_PASSWORD=your_password DB_NAME=company Run the server directly (for testing): bash node index.js Using with Claude Desktop

This project is packaged as a Desktop Extension (.mcpb) for one-click install:

bash npm install -g @anthropic-ai/mcpb npm install --production mcpb validate manifest.json mcpb pack .

Then in Claude Desktop: Settings → Extensions → Advanced settings → Extension Developer → Install Extension…, select the generated .mcpb file, and enter your MySQL credentials in the setup screen.

Example Prompts Prompt Tool Called "List all employees" list_employees "Search for an employee named Mahesh" search_employee "Show employees in the Engineering department" employees_by_department "Add a new employee named Mahesh Khatal in Engineering with salary 120000" add_employee "Who has the highest salary?" highest_salary Notes .env and node_modules/ are excluded via .gitignore and never committed. Full build walkthrough and debugging notes available in the accompanying project documentation.

Available Tools

5 tools
add_employeeAdd EmployeeC

Adds a new employee

Inputs: name (required), salary (required), department (required).

employees_by_departmentEmployees By DepartmentB

Returns employees from one department

Inputs: department (required).

highest_salaryHighest SalaryA

Returns highest paid employee

Inputs: no named parameters.

list_employeesList EmployeesA

Returns all employees

Inputs: no named parameters.

search_employeeSearch EmployeeB

Find employee by name

Inputs: name (required).

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.2/5.0

    Scored across 5 tools

    Disambiguation4/5

    Each tool has a clear purpose: list all, search by name, filter by department, add, and find highest salary. While search and department filtering overlap with listing, the descriptions clarify specific query intents, so ambiguity is minimal.

    Naming Consistency3/5

    Tool names follow mixed conventions: list_employees, search_employee, and add_employee use verb_noun, but employees_by_department and highest_salary do not follow that pattern. The names are still readable and descriptive, but not fully consistent.

    Tool Count5/5

    With 5 tools, the server is well-scoped for employee management. Each tool covers a distinct need without excessive fragmentation or bloat, fitting comfortably in the ideal range.

    Completeness3/5

    Provides read and create operations (list, search, department filter, add, highest salary) but lacks update and delete operations. This is a notable gap for a full employee management lifecycle.

    Maintenance

    ActivityInactive
    ResponsivenessOutdated data

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      B
      quality
      D
      maintenance
      MCP server that allows Claude AI to interact directly with MySQL databases, enabling query execution and table information retrieval through natural language.
      1
      4
      ISC
    • A
      license
      Not graded
      quality
      D
      maintenance
      MySQL MCP Server enables Claude Desktop and Claude Code to execute SQL queries, explore databases, Webview to add or enable Databases, Connections, and interact with your MySQL data - all through a secure, permission-controlled interface.
      107 npm
      1
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      MCP server providing natural-language tools for managing and querying an employee database, including user CRUD, search, and statistics.
      MIT