akashbauri/SK-IT-COMPANY-MANAGEMENT-MCP-SERVER
3.2
If you are the rightful owner of SK-IT-COMPANY-MANAGEMENT-MCP-SERVER and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
Advanced Company Management MCP Server is a comprehensive FastMCP server designed for managing company operations with seamless Excel database integration.
Tools
12
Resources
0
Prompts
0
🏢 Advanced Company Management MCP Server
A comprehensive FastMCP server for managing company operations with Excel database integration.
✨ Features
👥 Employee Management
- Employee Information: Complete employee profiles with contact details
- Department Search: Find employees by department
- Skills Search: Locate employees with specific technical skills
- Leave Balance: Check individual leave balances and history
🏢 Department Operations
- Department Profiles: Complete department information with budgets
- Team Analytics: Department-wise employee distribution
- Manager Information: Department leadership details
- Budget Tracking: Financial allocation by department
📅 Holiday Management
- Holiday Calendar: Company-wide and department-specific holidays
- Upcoming Events: View holidays within specified timeframes
- Department Holidays: Tech-specific celebration days
- Holiday Types: National, Festival, Religious, and Tech holidays
📋 Leave Management
- Leave Applications: Submit and track leave requests
- Leave Statistics: Analytics by department or company-wide
- Status Tracking: Approved, Pending, and Rejected applications
- Balance Management: Real-time leave balance updates
🕐 Working Hours
- Department Configuration: Custom working hours by team
- Weekend Settings: Flexible weekend configurations
- Schedule Management: Weekly hour allocations
📊 Advanced Analytics
- Company Dashboard: Comprehensive overview with key metrics
- Department Breakdown: Employee distribution analytics
- Leave Analytics: Leave pattern analysis and reporting
- Resource Planning: Budget and headcount insights
🗄️ Database Structure
Tables (5 Excel Sheets):
- Employees (36 records): Complete employee master data
- Departments (4 records): Tech department profiles
- Holidays (13 records): Company and department holidays
- Leave Records (150 records): Historical leave applications
- Weekend Config (5 records): Working hour configurations
Departments:
- AI Department (8 employees) - ₹50L budget
- Cyber Security (9 employees) - ₹35L budget
- Data Science (8 employees) - ₹42L budget
- Web Development (11 employees) - ₹38L budget
🔧 Available MCP Tools
| Tool | Description | Parameters |
|---|---|---|
get_employee_info | Employee details | employee_id |
search_employees_by_department | Department employee list | department |
search_employees_by_skills | Skill-based search | skill |
get_employee_leave_balance | Leave balance check | employee_id |
get_department_info | Department details | department_name |
get_all_departments_summary | All departments overview | None |
get_upcoming_holidays | Holiday calendar | days_ahead |
get_department_holidays | Department holidays | department |
apply_employee_leave | Leave application | employee_id, start_date, end_date, leave_type, reason |
get_leave_statistics | Leave analytics | department (optional) |
get_working_hours | Working hours config | department |
generate_company_dashboard | Complete dashboard | None |