Skip to main content
Glama

PostgreSQL MCP Server

by sreedhag
app.ts1.26 kB
import express from "express"; import cors from "cors"; import { config } from "../config/env.js"; import { createMcpServer } from "../server/server.js"; import { handleMcpRequest, handleMcpDelete, handleMcpGet, closeAllTransports, } from "./httpHandler.js"; export function createApp() { const app = express(); const mcpServer = createMcpServer(); // CORS configuration app.use( cors({ origin: config.server.corsOrigins, methods: ["GET", "POST", "DELETE", "OPTIONS"], allowedHeaders: ["Content-Type", "Accept", "Mcp-Session-Id"], exposedHeaders: ["Mcp-Session-Id"], credentials: true, maxAge: 86400, }), ); app.options("/mcp", (req, res) => { res.status(200).end(); }); app.use(express.json()); app.use((req, res, next) => { if (!req.headers.accept) { req.headers.accept = "application/json, text/event-stream"; } next(); }); // Route handlers app.post("/mcp", (req, res) => handleMcpRequest(mcpServer, req, res)); app.delete("/mcp", handleMcpDelete); app.get("/mcp", handleMcpGet); app.get("/health", (req, res) => { res.status(200).json({ status: "OK", uptime: process.uptime() }); }); return { app, mcpServer, closeAllTransports }; }

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/sreedhag/postgres-mcp-server'

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