MCP.so
登录

Sample MCP Server

@shahidain

代码仓库

关于 Sample MCP Server

Sample MCP Server written in TypeScript

基本信息

分类

其他

运行时

node

传输方式

stdio

发布者

shahidain

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-server-shahidain": {
      "command": "node",
      "args": [
        "dist/tools/testConnection.js"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Sample MCP Server?

Sample MCP Server is a Model Context Protocol (MCP) server built with TypeScript and Express.js that provides integration with SQL databases, the Jira API, and AI-powered tools for data processing and analysis. It uses Server-Sent Events (SSE) for real-time communication and includes persistent storage. It is intended for developers and teams needing to access and manage SQL data, Jira issues, and external product data through an MCP interface.

How to use Sample MCP Server?

Install Node.js (v16+), clone the repository, run npm install, configure environment variables in a .env file (SQL Server, OpenAI API key, optional Jira credentials), then build with npm run build and start with npm run start. Use the exposed tools (e.g., get-users, search-jira-issues, get-products) via an MCP client. Development mode is available with npm run dev.

Key features of Sample MCP Server

  • CRUD operations for Users, Vendors, Commodities, Currencies, and Roles
  • Advanced search and pagination on SQL database tables
  • Jira API integration with JQL support and AI-generated queries
  • Intelligent tool routing and data formatting via OpenAI
  • Real-time streaming responses using Server-Sent Events (SSE)
  • Persistent storage for JQL examples and application data

Use cases of Sample MCP Server

  • Query and manage user, vendor, and commodity records from a SQL database
  • Search and create Jira issues using natural language queries
  • Retrieve product data from the DummyJSON API with pagination and categories
  • Monitor application status in different environments in real time
  • Automate data retrieval and formatting for AI assistants or reporting tools

FAQ from Sample MCP Server

What databases does Sample MCP Server support?

It integrates with SQL Server (MSSQL) and expects tables for Users, Vendors, Commodities, Currencies, and Roles.

What AI model is used?

The server uses OpenAI, with GPT-4 recommended, but also supports GPT-3.5-turbo and any OpenAI-compatible model.

Is Jira integration required?

No, Jira configuration is optional; only SQL Server and OpenAI API key are required for AI features.

How does the server communicate?

It uses Server-Sent Events (SSE) for real-time streaming responses and supports multiple concurrent sessions.

Where are persistent data stored?

JQL examples and other application data are stored in JSON files under the data/ directory, with automatic file synchronization.

评论

其他 分类下的更多 MCP 服务器

MCP Registry

modelcontextprotocol

A community driven registry service for Model Context Protocol (MCP) servers.

7.0K

Unity MCP ✨

justinpbarnett

Unity MCP acts as a bridge between AI assistants and your Unity Editor. Give your LLM tools to manage assets, control scenes, edit scripts, and automate tasks within Unity.

12.2K

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K

Core Philosophy: Connect, Unify, Respond

mindsdb

Delegate anything. It comes back done.

39.4K