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.
Recommended Servers
playwright-mcp
A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.
Magic Component Platform (MCP)
An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.
Audiense Insights MCP Server
Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.
VeyraX MCP
Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.
graphlit-mcp-server
The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.
Kagi MCP Server
An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.
E2B
Using MCP to run code via e2b.
Neon Database
MCP server for interacting with Neon Management API and databases
Qdrant Server
This repository is an example of how to create a MCP server for Qdrant, a vector search engine.
Exa Search
A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.