Sample MCP Server

@shahidain

About Sample MCP Server

Sample MCP Server written in TypeScript

Basic information

Category

Other

Runtime

node

Transports

stdio

Publisher

shahidain

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.

Comments

More Other MCP servers

Inbox Zero AI MCP

The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.

IDA Pro MCP

AI-powered reverse engineering assistant that bridges IDA Pro with language models through MCP.

EverArt

modelcontextprotocol

Model Context Protocol Servers

FastMCP v2 🚀

🚀 The fast, Pythonic way to build MCP servers and clients.

Nginx UI

Yet another WebUI for Nginx