mcp
Provides MCP servers for GitHub API operations and SQL database queries, enabling users to interact with GitHub repositories and databases through natural language.
README
MCP Server Project
A simple project demonstrating how to build and use MCP (Model Context Protocol) servers.
Quick Start
- Install dependencies:
pip install -r requirements.txt
- Configure MCP server in Windsurf/Claude Desktop:
{
"mcpServers": {
"github": {
"command": "python",
"args": ["/path/to/server/github.py"],
"env": {
"GITHUB_TOKEN": "your_github_token_here (see .env.example)"
}
},
"database": {
"command": "python",
"args": ["/path/to/server/database.py"]
}
}
}
- Use with LLM:
- Start Windsurf/Claude Desktop
- Ask: "Show me octocat's repositories"
- LLM will automatically call the MCP server tools
🚀 Live Deployment
This MCP server is deployed and available for testing at:
- URL:
https://my-mcp.fastmcp.app/mcp - Status: Production ready
Using the Deployed Server
Configure Windsurf to use the deployed endpoint:
{
"mcpServers": {
"github-mcp-deployed": {
"url": "https://my-mcp.fastmcp.app/mcp",
"disabled": false
}
}
}
Test the deployed server:
- Ask any LLM with MCP support: "Show me repositories for gn1264"
- The deployed server will respond with GitHub data
Benefits of Deployed Server
- ✅ No local Python environment required
- ✅ Always available and reliable
- ✅ Managed infrastructure
- ✅ Same functionality as local version
Testing (Optional)
For development and testing:
# Test GitHub server
python testing/test_github_server.py get-repos octocat
# Test Database server
python testing/test_database_server.py query "SELECT * FROM users"
Project Structure
mcp/
├── server/ # MCP servers
│ ├── github.py # GitHub API server
│ └── database.py # Database server
├── client/ # Real LLM client
│ └── mcp_client.py # LLM integration example
├── testing/ # Server testing utilities
│ ├── test_github_server.py # Test GitHub server
│ └── test_database_server.py # Test Database server
├── simple.db # Sample database file
├── requirements.txt # Dependencies
├── README.md # This file
└── learn.md # Learning guide
MCP Servers
Both servers are independent and demonstrate different use cases:
GitHub Server (server/github.py)
- Purpose: Demonstrates how GitHub MCP servers work in the market
- Use Case: Public GitHub API access for general users
- Tools: GitHub API operations (get repos, commits, search, etc.)
- Similar to: Commercial GitHub MCP integrations
Database Server (server/database.py)
- Purpose: Shows enterprise database integration patterns
- Use Case: Internal database access in enterprise environments
- Tools: SQL query execution
- Similar to: Custom internal MCP servers for company data
Testing vs Real Usage
Testing Utilities (testing/)
- Direct tool calls to test server functionality
- Manual tool selection
LLM Client (client/mcp_client.py)
- Real MCP usage with LLM integration
- Dynamic tool selection
Learning
See learn.md for detailed explanations of MCP concepts and how this project works.
推荐服务器
Baidu Map
百度地图核心API现已全面兼容MCP协议,是国内首家兼容MCP协议的地图服务商。
Playwright MCP Server
一个模型上下文协议服务器,它使大型语言模型能够通过结构化的可访问性快照与网页进行交互,而无需视觉模型或屏幕截图。
Magic Component Platform (MCP)
一个由人工智能驱动的工具,可以从自然语言描述生成现代化的用户界面组件,并与流行的集成开发环境(IDE)集成,从而简化用户界面开发流程。
Audiense Insights MCP Server
通过模型上下文协议启用与 Audiense Insights 账户的交互,从而促进营销洞察和受众数据的提取和分析,包括人口统计信息、行为和影响者互动。
VeyraX
一个单一的 MCP 工具,连接你所有喜爱的工具:Gmail、日历以及其他 40 多个工具。
graphlit-mcp-server
模型上下文协议 (MCP) 服务器实现了 MCP 客户端与 Graphlit 服务之间的集成。 除了网络爬取之外,还可以将任何内容(从 Slack 到 Gmail 再到播客订阅源)导入到 Graphlit 项目中,然后从 MCP 客户端检索相关内容。
Kagi MCP Server
一个 MCP 服务器,集成了 Kagi 搜索功能和 Claude AI,使 Claude 能够在回答需要最新信息的问题时执行实时网络搜索。
e2b-mcp-server
使用 MCP 通过 e2b 运行代码。
Neon MCP Server
用于与 Neon 管理 API 和数据库交互的 MCP 服务器
Exa MCP Server
模型上下文协议(MCP)服务器允许像 Claude 这样的 AI 助手使用 Exa AI 搜索 API 进行网络搜索。这种设置允许 AI 模型以安全和受控的方式获取实时的网络信息。