mcp

mcp

Provides MCP servers for GitHub API operations and SQL database queries, enabling users to interact with GitHub repositories and databases through natural language.

Category
Visit Server

README

MCP Server Project

A simple project demonstrating how to build and use MCP (Model Context Protocol) servers.

Quick Start

  1. Install dependencies:
pip install -r requirements.txt
  1. 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"]
    }
  }
}
  1. 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

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.

Official
Featured
TypeScript
Magic Component Platform (MCP)

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.

Official
Featured
Local
TypeScript
Audiense Insights MCP Server

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.

Official
Featured
Local
TypeScript
VeyraX MCP

VeyraX MCP

Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.

Official
Featured
Local
graphlit-mcp-server

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.

Official
Featured
TypeScript
Kagi MCP Server

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.

Official
Featured
Python
E2B

E2B

Using MCP to run code via e2b.

Official
Featured
Neon Database

Neon Database

MCP server for interacting with Neon Management API and databases

Official
Featured
Qdrant Server

Qdrant Server

This repository is an example of how to create a MCP server for Qdrant, a vector search engine.

Official
Featured
Exa Search

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.

Official
Featured