MCP Server Demo
Provides comprehensive GitHub search capabilities including repositories, code, issues, and user information, with support for pagination and structured data returns
Enables natural language queries to MySQL databases with intelligent SQL conversion and secure execution capabilities
Utilizes OpenAI GPT for natural language to SQL conversion in database queries
Supports natural language queries to PostgreSQL databases with intelligent SQL conversion and table structure retrieval
Enables querying SQLite databases using natural language, with capabilities for SQL generation and database structure inspection
Click on "Install 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., "@MCP Server Demowhat time is it in Tokyo right now?"
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.
MCP 服务器演示项目
一个基于 Model Context Protocol (MCP) 的多功能服务器演示项目,展示了如何构建和使用不同类型的 MCP 服务器。
🚀 项目概述
本项目是一个 monorepo,包含了三个不同功能的 MCP 服务器示例:
Database Search - 智能数据库搜索服务,支持自然语言查询
GitHub Search - GitHub 仓库和用户信息搜索服务
Time - 时间获取和时区转换服务
所有服务器都基于 Model Context Protocol (MCP) 标准构建,可以与支持 MCP 的客户端(如 Claude Desktop)无缝集成。
Related MCP server: MCP Toolkit
📦 项目结构
hh-mcp-server/
├── packages/
│ ├── database-search/ # 数据库搜索 MCP 服务器
│ ├── github-search/ # GitHub 搜索 MCP 服务器
│ └── time/ # 时间服务 MCP 服务器
├── package.json # 根项目配置
├── pnpm-workspace.yaml # pnpm workspace 配置
└── README.md # 项目说明文档🛠️ 技术栈
运行时: Node.js + TypeScript
包管理: pnpm workspace
框架: Model Context Protocol SDK
数据库: MySQL, PostgreSQL, SQLite (database-search)
API: GitHub API (github-search)
工具库: dayjs, zod, prettier
🚀 快速开始
环境要求
Node.js >= 18
pnpm >= 8
安装依赖
# 克隆项目
git clone <repository-url>
cd hh-mcp-server
# 安装依赖
pnpm install构建所有包
# 构建所有 MCP 服务器
pnpm run build代码格式化
# 格式化代码
pnpm run format
# 检查代码格式
pnpm run format:check📚 MCP 服务器详解
1. Database Search MCP Server
功能: 支持自然语言查询多种数据库,提供智能 SQL 转换
核心特性:
🗄️ 多数据库支持(MySQL、PostgreSQL、SQLite)
🧠 自然语言转 SQL(基于 OpenAI GPT)
🔒 安全 SQL 检查和过滤
⚙️ 灵活的环境配置管理
🔄 连接池和资源管理
工具列表:
query_database- 自然语言数据库查询list_databases- 列出可用数据库get_table_structure- 获取表结构execute_sql- 直接执行 SQL
2. GitHub Search MCP Server
功能: 搜索 GitHub 仓库、代码、问题和用户信息
核心特性:
🔍 全面搜索(仓库、代码、问题、用户)
📄 分页支持
🔑 GitHub API 集成
📊 结构化数据返回
工具列表:
search_github- 搜索 GitHub 内容get_user_info- 获取用户详细信息
使用示例:
cd packages/github-search
# 设置 GitHub Token
export GITHUB_TOKEN=your_github_token
# 构建并运行
pnpm run build
node dist/index.js代码来源:
3. Time MCP Server
功能: 获取当前时间和进行时区转换
核心特性:
🕐 获取当前时间
🌍 时区转换
🔧 灵活的时区配置
📅 标准时间格式
工具列表:
get_current_time- 获取当前时间convert_time- 时区间时间转换
使用示例:
cd packages/time
# 构建并运行
pnpm run build
node dist/index.js代码来源:
🔧 开发指南
添加新的 MCP 服务器
在
packages/目录下创建新包配置
package.json和tsconfig.json实现 MCP 服务器逻辑
添加到 workspace 配置
项目脚本命令
# 构建所有包
pnpm run build
# 格式化代码
pnpm run format
# 检查代码格式
pnpm run format:check
# 运行测试(待实现)
pnpm run test开发最佳实践
使用 TypeScript 进行类型安全
遵循 MCP 标准和最佳实践
使用 zod 进行参数验证
实现适当的错误处理
添加详细的工具描述和参数说明
🤝 与 MCP 客户端集成
Claude Desktop 配置示例
在 Claude Desktop 的配置文件中添加服务器:
{
"mcpServers": {
"database-search": {
"command": "node",
"args": ["path/to/packages/database-search/dist/index.js"],
"env": {
"NODE_ENV": "production"
}
},
"github-search": {
"command": "node",
"args": ["path/to/packages/github-search/dist/index.js"],
"env": {
"GITHUB_TOKEN": "your_token"
}
},
"time": {
"command": "node",
"args": ["path/to/packages/time/dist/index.js"]
}
}
}📄 许可证
ISC License
🤝 贡献
欢迎提交 Issue 和 Pull Request!
📞 支持
如果您在使用过程中遇到问题,请:
查看各包的详细文档
检查环境配置
提交 Issue 描述问题
注意: 这些是 MCP (Model Context Protocol) 服务器,需要与支持 MCP 的客户端(如 Claude Desktop)配合使用。
Available Tools
2 toolsget_current_dateB
获取当前日期, 如果用户没有提供日期, 则返回当前日期, 如果用户提供的是相对单位, 如前天, 昨天, 明天, 则返回相对单位后的日期
| Name | Required | Description | Default |
|---|---|---|---|
| date | Yes | 日期 比如2025-05-29 或者 前天 昨天 明天 |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, so the description carries the full burden of behavioral disclosure. It describes the tool's behavior in returning dates based on input, but lacks details such as output format (e.g., date string structure), timezone handling, error conditions (e.g., invalid input), or performance aspects. This is a significant gap for a tool with no annotation coverage.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is concise and front-loaded, stating the core functionality in a single sentence. It efficiently covers key use cases without unnecessary elaboration. However, it could be slightly improved by structuring it more clearly (e.g., separating conditions), but overall, it's well-sized and avoids waste.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's complexity (handling both absolute and relative dates) and the lack of annotations and output schema, the description is incomplete. It doesn't explain the return values (e.g., format of the date string), error handling, or any constraints (e.g., supported date ranges). This makes it inadequate for an agent to reliably use the tool without additional context.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The schema description coverage is 100%, with the parameter 'date' documented as accepting dates like '2025-05-29' or relative units. The description adds value by clarifying that if no date is provided, it returns the current date, and it lists examples of relative units. However, it doesn't provide additional syntax or format details beyond what the schema implies, so the baseline score of 3 is appropriate.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's purpose: to get the current date or calculate relative dates based on user input. It specifies the verb '获取' (get/retrieve) and the resource '日期' (date), making the function understandable. However, it doesn't explicitly distinguish itself from the sibling tool 'get_current_weather', which might be relevant in some contexts.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description implies usage by stating it handles cases where users provide no date or relative units like '前天' (day before yesterday), '昨天' (yesterday), or '明天' (tomorrow). However, it doesn't explicitly guide when to use this tool versus alternatives (e.g., if 'get_current_weather' might also provide date-related info) or mention any exclusions, leaving some ambiguity.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
get_current_weatherC
Get weather info for a given city.
| Name | Required | Description | Default |
|---|---|---|---|
| city | Yes | 城市名称, 比如北京 上海 广州 |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden of behavioral disclosure. It mentions 'Get weather info' but doesn't specify what that entails (e.g., temperature, conditions, units), whether it's read-only (implied but not stated), error handling, or any rate limits. This leaves significant gaps in understanding the tool's behavior beyond basic functionality.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, clear sentence that efficiently conveys the core purpose without unnecessary words. It's front-loaded with the main action and resource, making it easy to parse and understand quickly.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool has no annotations and no output schema, the description is incomplete. It doesn't explain what 'weather info' includes in the response, potential errors, or usage constraints. For a tool with such minimal structured data, the description should provide more context to compensate, but it falls short.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The schema description coverage is 100%, with the parameter 'city' well-documented in the schema as a required string for city names. The description adds minimal value beyond the schema by implying the parameter's purpose ('for a given city'), but doesn't provide additional semantics like format examples or constraints beyond what's in the schema.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the action ('Get weather info') and the target resource ('for a given city'), making the purpose immediately understandable. However, it doesn't differentiate from the sibling tool 'get_current_date', which is a different domain, so it doesn't need sibling differentiation but could be more specific about what 'weather info' includes.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives or any contextual prerequisites. It simply states what it does without indicating if it's for current conditions only, if there are limitations (e.g., city availability), or how it relates to other potential weather tools.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections. Dates show when Glama detected each change.
2 tool updates
- First observed
get_current_date - First observed
get_current_weather
TDQS
The two tools have completely distinct purposes: one handles date calculations and retrieval, while the other provides weather information. There is no overlap in functionality, making it impossible to confuse them.
Both tools follow a consistent 'get_current_*' naming pattern, using snake_case and starting with the same verb 'get'. This makes the set predictable and easy to understand.
With only two tools, the server feels thin and under-scoped for a general-purpose demo. It lacks coverage for common tasks beyond dates and weather, suggesting an incomplete or narrowly focused implementation.
The server's domain appears to be general utility or information retrieval, but it only covers dates and weather. There are significant gaps, such as time, location, or other common data queries, leaving agents with limited functionality.
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Connectors
- mcpOAuthcom.gibsonai
GibsonAI MCP server: manage your databases with natural language
A comprehensive Model Context Protocol (MCP) server that enables AI assistants to interact with yo…
MCP server unifying ERPs, CRMs, APIs and knowledge base for Claude, ChatGPT and Gemini.
MCP server for building and testing AI agents with multi-model experimentation and insights.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceProvides MCP servers for GitHub API operations and SQL database queries, enabling users to interact with GitHub repositories and databases through natural language.3MIT
- AlicenseNot gradedqualityFmaintenanceA collection of production-ready MCP servers for PostgreSQL, SQLite, Redis, File System, and GitHub API, enabling database operations, file management, and GitHub interactions through natural language.2MIT

Manifest MCPofficial
AlicenseNot gradedqualityAmaintenanceA monorepo of MCP servers for Manifest Network and Cosmos SDK chains, enabling natural language interaction with on-chain queries, transactions, lease operations, and provider management.MIT- AlicenseNot gradedqualityBmaintenanceA monorepo for learning the Model Context Protocol with TypeScript, featuring example MCP servers for weather data and tax calculation.16MIT
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/CH-122/mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server