Elisha1994 MCP

MCP数据服务

提供方 未标注

数据服务 SSE · 服务端推送 未标注 社区 / 第三方
查看接入方式

全面解析MCP Llama Sqlite BridgeMCP Server的核心功能、安装配置和实用案例。作为顶级Model Context Protocol服务器,MCP Llama Sqlite Bridge能让AI助手访问实时数据、执行操作,为您提供更智能的工作体验和自动化解决方案。

一句话选型结论

按资料字段整理

Elisha1994 MCP 属于数据服务类 MCP 服务器,SSE · 服务端推送,鉴权方式未标注,有可直接复制的远程端点配置。接入前先确认权限范围;涉及写入、删除或付款的操作,建议先在测试环境验证。

分类数据服务 传输方式SSE · 服务端推送 鉴权未标注 部署方式远程部署
GitHub 星标 未标注 仓库热度,无公开仓库时显示未标注
工具数 未标注 暴露给模型的工具数量
资源 / 提示词 0 / 0 资源与提示词模板数量
维护方 社区 / 第三方 核验等级 仅资料核对

工具与能力

数据服务
数量来自来源目录的标注,具体工具清单以官方文档为准
工具数量未标注暴露给模型可调用的工具个数
资源数量0可读取的资源条目
提示词数量0内置提示词模板数量

能力标签

安装与配置

SSE · 服务端推送 未标注
早期远程传输方式,正在被 HTTP 取代
pip install -r requirements.txt

这条命令只是入口,具体启动参数请按官方文档补齐,不要直接照搬到别的服务器。

  1. 1
    准备运行环境

    确认你的客户端支持远程端点,并拿到服务地址。

  2. 2
    安装服务

    复制上面的安装命令执行;命令里带占位符的位置,换成自己的密钥或路径。

  3. 3
    写入客户端配置

    在客户端的 MCP 配置里填好启动命令和参数,保存后完全退出客户端再打开,让新配置生效。

  4. 4
    验证是否可用

    连接成功后随便调一个只读工具,确认能返回结果,再接入正式流程。

典型使用场景

3 类
按分类与标签整理的常见用法,具体以官方文档为准
数据库查询

用自然语言查库、取数,不用手写 SQL。

数据同步与清洗

把多来源数据拉到一处做整理。

报表取数

按口径快速拉出统计结果。

选择建议

选之前先看这几条
按条目字段给出的判断,不替你决定用不用

值得选的地方

  • 有现成的安装命令,不用自己找入口,照着跑就能起服务。

先想清楚的地方

  • 远程端点依赖网络与服务方可用性,注意密钥与调用额度。
  • 资料没标注工具数量,实际能力要装好后确认。
  • 版本更新与行为细节以官方仓库为准。

更适合

  • 需要在数据服务场景里让模型直接调用外部能力的人。
  • 想先快速试一下、能接受在本地或自有环境跑服务的人。

不太适合

  • 需要厂商级 SLA 和技术支持的生产环境。

同类对比

6 个同类
同分类里挑最接近的几条,字段以各自详情页为准
MCP 服务器工具数传输方式部署方式安装命令最后核验
Elisha1994 MCP当前 未标注 SSE · 服务端推送 远程部署 有 2026-05-17
Memory 9d25f64e 9 未标注 未标注 无 2026-05-17
Getzep MCP 9 stdio · 本地进程 本地部署 有 2026-05-17
anything-llm 未标注 stdio · 本地进程 本地部署 有 2026-04-11
Prisma MCP Server 未标注 stdio · 本地进程 本地部署 有 2026-05-17
Astr Bot 未标注 stdio · 本地进程 本地部署 有 2026-05-17

服务器档案

数据服务
字段来自项目仓库与公开索引,中文说明由本站标注
提供方未标注上游标注的维护方 未标注
分类数据服务本站按上游分类展示
连接方式SSE · 服务端推送早期远程传输方式,正在被 HTTP 取代
鉴权方式未标注远程服务建议用最小权限凭据
维护方社区 / 第三方核验等级 仅资料核对
包名 / 运行时未标注 · Python本地安装时用到的包标识与运行时
部署类型远程部署上游给出的部署形态
最近核验2026-05-17上游最后核验时间

详细介绍

9.5 KB
来自项目仓库与上游目录的原文,未做删改

MCP LlamaIndex SQLite Bridge

A comprehensive demonstration of Model Context Protocol (MCP) with SQLite integration and LlamaIndex client, featuring both a simple demo and a full-featured HR Management System.

Overview

This project showcases how to build and use MCP servers that expose database operations as tools, connected via LlamaIndex-based clients with Ollama LLM support. It includes:

  1. Simple Demo - Basic SQLite server with simple people table
  2. HR Management System - Advanced natural language HR system with employee management, leave tracking, compensation, and analytics

Components

Simple Demo:

  • server.py: Basic MCP server with SQL tools for a simple people database
  • client.py: LlamaIndex client for natural language database interactions

HR Management System:

  • hr_server.py: Advanced MCP server with comprehensive HR tools
  • hr_client.py: Sophisticated client with context-aware natural language processing
  • HR_USAGE_GUIDE.md: Detailed documentation with examples

Features

Core Features

  • MCP server architecture with SQLite integration
  • Natural language interface using LlamaIndex and Ollama
  • Async support for both server and client
  • Tool-based approach for database operations

HR Management System Features

  • Employee Management: Add, update, search, and manage employee records
  • Leave Management: Request, approve, and track employee leave balances
  • Compensation: Salary updates, compensation reports, and payroll analytics
  • Organization Structure: Org charts, department management, and transfers
  • Analytics: HR dashboards, turnover analysis, and diversity metrics
  • Performance Reviews: Create and track performance evaluations
  • Audit Trail: Complete logging of all HR actions for compliance

Prerequisites

  • Python 3.8+
  • Ollama installed and running
  • llama3.2 model (or another model that supports tool calling)

⚠️ Critical Requirements

Email is REQUIRED When Adding Employees

The HR system requires an email address when adding new employees. Commands without email will fail.

❌ WRONG: Add John Doe to Engineering as Developer
✅ CORRECT: Add John Doe (john.doe@company.com) to Engineering as Developer

Without email, you'll see: ❌ Tool failed: Missing required field: email

Installation

  1. Clone this repository:```bash
    git clone https://github.com/ELISHA1994/mcp-llama-sqlite-bridge.git
    cd mcp-llama-sqlite-bridge

2. Create a virtual environment:```bash
python -m venv .venv
source .venv/bin/activate  # On Windows: .venv\Scripts\activate
  1. Install dependencies:```bash
    pip install -r requirements.txt

4. Pull the required Ollama model:```bash
ollama pull llama3.2

Usage

Option 1: Simple Demo

Starting the Simple Server```bash

python server.py --server_type=sse


#### Running the Simple Client```bash
python client.py

Option 2: HR Management System

Starting the HR Server```bash

python hr_server.py --server_type=sse


#### Running the HR Client```bash
python hr_client.py

The client will:
1. Connect to the MCP server
2. Display available tools
3. Start an interactive session where you can use natural language to interact with the database

Example Interactions

Simple Demo:```

Enter your message: Add a person named John Doe who is 30 years old and works as an Engineer
Agent: Data has been successfully added to the database.

Enter your message: Show me all people in the database
Agent: Here are all the people in the database:
1. John Doe, 30 years old, Engineer


#### HR Management System:

⚠️ **IMPORTANT: Email is REQUIRED when adding employees!**```
HR Assistant> Add Sarah Johnson (sarah.johnson@company.com) to Engineering as Senior Developer with $105,000 salary

🔧 Calling tool: add_employee
✅ Employee added successfully!
- Employee ID: EMP00001
- Name: Sarah Johnson

HR Assistant>

🔧 Calling tool: check_employee_leave_balance
   Parameters: {
     "employee_name": "Sarah Johnson"
   }
✅ Tool result received
**Leave Balance for Sarah Johnson (2024)**
- Annual Leave: 21 days remaining
- Sick Leave: 10 days remaining

HR Assistant> Generate HR dashboard

🔧 Calling tool: generate_hr_dashboard
**HR Dashboard Summary**
- Total Employees: 45
- Active: 42
- Departments: Engineering (15), Sales (10), Marketing (8)...

Natural Language Examples

Employee Management

Adding Employees (Email Required!):```
"Add Elisha Bello (elisha.bello@company.com) to Engineering as Senior Software Engineer with salary $420,000"
"Hire John Doe (john.doe@company.com) as Marketing Manager starting January 15, 2024"
"Onboard Alice Chen (alice.chen@company.com) to Sales as Account Executive, phone: 555-0123"


**Searching & Listing:**```
"List all employees"
"Find all employees in Engineering department"
"Show me employees hired in the last 6 months"
"Who reports to John Smith?"
"Search for Senior Engineers"

Updates & Changes:```
"Update John Doe's phone number to 555-9876"
"Transfer Sarah Johnson from Engineering to Product Management"
"Change Michael Brown's manager to Jennifer Wilson"
"Update Emily Davis's salary to $95,000 effective next month" ← Uses name directly!


#### Leave Management```
"Check Sarah Johnson's leave balance"  ← Uses employee name directly!
"Submit leave request for John Doe from Dec 20 to Dec 27"  ← Uses name!
"Approve leave request #45"
"Show all pending leave requests"
"How many vacation days does Michael Brown have left?"  ← Uses name!

Compensation & Benefits```

"Generate compensation report for Engineering department"
"Show average salaries by position"
"Calculate total payroll for Q4 2024"
"List employees eligible for salary review"
"Compare department salary ranges"


#### Organization & Analytics```
"Show org chart for Engineering department"
"Generate HR dashboard"
"Analyze turnover for last quarter"
"Show diversity metrics"
"List employees with upcoming work anniversaries"
"Who are the top performers this quarter?"

Performance Management```

"Create performance review for Sarah Johnson"
"Show pending performance reviews"
"Update performance rating for John Doe to 'Exceeds Expectations'"
"List employees due for annual review"


For more examples, try the interactive help in the HR client by typing 'help'.

## Database Schema

### Simple Demo Schema

The `demo.db` contains a `people` table:
- `id`: INTEGER PRIMARY KEY AUTOINCREMENT
- `name`: TEXT NOT NULL
- `age`: INTEGER NOT NULL
- `profession`: TEXT NOT NULL

### HR Management System Schema

The `hr_management.db` contains multiple interconnected tables:
- **employees**: Comprehensive employee records
- **departments**: Organizational units and hierarchy
- **positions**: Job titles and salary ranges
- **salaries**: Compensation history
- **leave_types**: Various leave categories
- **leave_balances**: Employee leave entitlements
- **leave_requests**: Leave request tracking
- **performance_reviews**: Performance evaluations
- **training_programs**: Training catalog
- **employee_training**: Training completion records
- **audit_log**: Compliance and audit trail

## Available Tools

### Simple Demo Tools
- **add_data**: Add records using SQL INSERT
- **read_data**: Query records using SQL SELECT

### HR Management Tools

#### Simplified Tools (Use These - They Accept Employee Names!)
- **add_employee**: Add new employees (EMAIL REQUIRED!)
- **check_employee_leave_balance**: Check leave balance by employee NAME
- **update_employee_salary**: Update salary by employee NAME
- **submit_leave_request**: Submit leave request by employee NAME
- **list_all_employees**: Get all active employees
- **find_employees_by_department**: Search by department

#### Advanced Tools (Require Employee IDs)
- **manage_employee**: Add, update, terminate employees (requires employee_id)
- **search_employees**: Advanced employee search with filters
- **get_org_chart**: Generate organizational hierarchy
- **request_leave**: Submit leave requests (requires employee_id)
- **approve_leave**: Process leave approvals
- **get_leave_balance**: Check leave balances (requires employee_id)
- **update_salary**: Manage compensation (requires employee_id)
- **generate_hr_dashboard**: Comprehensive HR metrics
- **analyze_turnover**: Turnover analytics
- **calculate_compensation_metrics**: Salary statistics
- **record_performance_review**: Performance evaluations
- And many more...

## Troubleshooting

### ModuleNotFoundError
If you encounter module import errors, ensure all dependencies are installed:```bash
pip install -r requirements.txt

Ollama Model Error

If you get an error about the model not supporting tools, ensure you're using a model that supports function calling (like llama3.2, mistral, or qwen2.5-coder).

Connection Issues

Ensure the MCP server is running before starting the client.

Employee Not Added Issue

If your command to add an employee doesn't work:
- Check for email: Email is REQUIRED. Without it, the employee won't be saved.
- Look for error messages: "❌ Tool failed: Missing required field: email"
- Correct format: Add Name (email@company.com) to Department as Position
- Always include email: firstname.lastname@company.com

Tool Expects Employee ID Error

If you get errors when using employee names:
- Use the simplified tools: check_employee_leave_balance, update_employee_salary, submit_leave_request
- These accept names directly: "Check John Doe's leave balance"
- Don't use: get_leave_balance, update_salary, request_leave with names
- The simplified tools handle name-to-ID lookup automatically

License

MIT License

常见问题

7 问
答案由本站依据条目字段整理,不引用上游原文
Elisha1994 MCP 怎么安装?

在客户端按下面的安装命令接入:pip install -r requirements.txt。装完在客户端配置里引用同一个包或端点。

Elisha1994 MCP 怎么在客户端里配置?

它的传输方式未标注,在客户端 MCP 配置里按官方文档填写启动命令和参数,保存后重启客户端生效。

Elisha1994 MCP 收费吗?

本站不代收费用,也没有标注具体价格。是否收费取决于服务本身和背后的接口额度,正式使用前按官方说明确认。

Elisha1994 MCP 需要 API Key 吗?

资料没有标注鉴权方式,是否需要密钥取决于服务本身,接入前按官方文档确认。

Elisha1994 MCP 能提供哪些能力?

资料显示能力标签包括 数据库工具、Python、自然语言交互。具体工具清单以官方文档为准。

Elisha1994 MCP 需要什么运行环境?

运行时为 Python;属于远程端点,不需要在本地装运行时。

Elisha1994 MCP 是本地还是远程?

它是远程端点,连服务地址即可。传输方式为SSE · 服务端推送。

热门专题

按标签挑服务器
全部专题 →

服务器信息以作者仓库与官方文档为准;分类、传输方式与鉴权方式的中文说明为中文整理,最近核验 2026-05-17。