Generic Database MCP Server

A Model Context Protocol (MCP) server that connects to multiple database types (MSSQL, PostgreSQL, MySQL). It provides read-only access to list tables, inspect schemas, and run queries.

Features

• Multi-Database Support: Connects to MSSQL, PostgreSQL, or MySQL via configuration.

• Tools Namespacing: Support for TOOL_PREFIX to run multiple server instances (e.g., mssql_, pg_) without collision.

• Safety First: Enforces Read-Only permissions. Blocks UPDATE, DELETE, DROP, etc.

• Efficient: Uses native connection pooling for each driver.

Related MCP server: postgres-mcp-server

Tools

• list_tables: List all base tables in the database.

• describe_table: Get schema information (columns, types) for a specific table.

• sql_query: Execute a read-only SQL query.

Configuration

Configuration is handled via environment variables.

Common Variables

MSSQL Specific

• DB_ENCRYPT: Set to true / false (default true)

• DB_TRUST_SERVER_CERTIFICATE: Set to true / false (default false)

Setup & Build

1. Install Dependencies

   npm install

2. Build

   npm run build

3. Run Locally (HTTP Mode)

   # Create a .env file first
   TRANSPORT=http PORT=3000 node build/index.js

4. Run Locally (stdio MCP Mode)

   TRANSPORT=stdio node build/index.js

HTTP Deployment

This server now supports MCP over Streamable HTTP for remote deployment platforms like Dockploy.

HTTP Environment Variables

HTTP Endpoints

• POST /mcp: MCP Streamable HTTP endpoint

• GET /health: Health check endpoint

Docker

docker build -t generic-database-mcp-server .
docker run --rm -p 3000:3000 \
  -e TRANSPORT=http \
  -e PORT=3000 \
  -e DB_TYPE=mssql \
  -e DB_HOST=host.docker.internal \
  -e DB_PORT=1433 \
  -e DB_USER=sa \
  -e DB_PASSWORD=yourPassword \
  -e DB_DATABASE=yourDatabase \
  generic-database-mcp-server

For Dockploy, route traffic to container port 3000 and configure the service health check against /health.

MCP Client Configuration

You can run multiple instances of this server for different databases.

Example: mcp_config.json

{
  "mcpServers": {
    "mssql-primary": {
      "command": "node",
      "args": ["/absolute/path/to/build/index.js"],
      "env": {
        "TRANSPORT": "stdio",
        "TOOL_PREFIX": "mssql_",
        "DB_TYPE": "mssql",
        "DB_HOST": "154.113.161.35",
        "DB_PORT": "2945",
        "DB_USER": "metro_dba",
        "DB_PASSWORD": "yourPassword",
        "DB_DATABASE": "HMO_CBA",
        "DB_TRUST_SERVER_CERTIFICATE": "true"
      }
    },
    "postgres-local": {
      "command": "node",
      "args": ["/absolute/path/to/build/index.js"],
      "env": {
        "TRANSPORT": "stdio",
        "TOOL_PREFIX": "pg_",
        "DB_TYPE": "postgres",
        "DB_HOST": "localhost",
        "DB_PORT": "5432",
        "DB_USER": "postgres",
        "DB_PASSWORD": "yourPassword",
        "DB_DATABASE": "analytics"
      }
    }
  }
}

This configuration exposes tools like:

• mssql_list_tables

• mssql_sql_query

• pg_list_tables

• pg_sql_query