Skip to main content
Glama

SQL Server MCP Service

by vini-cius
transportManager.tsโ€ข1.1 kB
import { StreamableHTTPServerTransport } from '@modelcontextprotocol/sdk/server/streamableHttp.js' class TransportManager { private transports: Map< string, { transport: StreamableHTTPServerTransport; createdAt: number } > = new Map() private TTL = 15 * 60 * 1000 get(sessionId: string): StreamableHTTPServerTransport | undefined { const record = this.transports.get(sessionId) if (record && Date.now() - record.createdAt < this.TTL) { return record.transport } this.transports.delete(sessionId) return undefined } set(sessionId: string, transport: StreamableHTTPServerTransport) { this.transports.set(sessionId, { transport, createdAt: Date.now() }) } delete(sessionId: string) { this.transports.delete(sessionId) } cleanup() { const now = Date.now() for (const [id, { createdAt }] of this.transports.entries()) { if (now - createdAt >= this.TTL) { this.transports.delete(id) } } } } export const transportManager = new TransportManager() setInterval(() => transportManager.cleanup(), 5 * 60 * 1000)

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/vini-cius/mcp-sqlserver'

If you have feedback or need assistance with the MCP directory API, please join our Discord server