Sample MCP Server

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.