employee-mcp-server
Provides tools for interacting with a MySQL database to manage employee records, including listing employees, searching by name, filtering by department, adding new employees, and finding the highest salary.
Click on "Deploy 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., "@employee-mcp-server Who has the highest salary?"
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.
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 toolsadd_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
Scored across 5 tools
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.
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.
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.
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
Related MCP Connectors
MCP server unifying ERPs, CRMs, APIs and knowledge base for Claude, ChatGPT and Gemini.
Hosted MySQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
MCP server exposing klokin time-tracking operations (employees, time entries, stores) to AI clients.
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Related MCP Servers
- AlicenseCqualityDmaintenanceAn MCP server that enables MySQL database integration with Claude. You can execute SQL queries and manage database connections.29MIT
- AlicenseBqualityDmaintenanceMCP server that allows Claude AI to interact directly with MySQL databases, enabling query execution and table information retrieval through natural language.14ISC
- AlicenseNot gradedqualityDmaintenanceMySQL 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 npm1MIT
- AlicenseNot gradedqualityDmaintenanceMCP server providing natural-language tools for managing and querying an employee database, including user CRUD, search, and statistics.MIT