mcp部署到远程服务器

服务器部署¶

在服务器上安装：

# PostgreSQL example
npx @bytebase/dbhub --transport sse --port 8080 --dsn "postgres://user:password@localhost:5432/dbname"

# sql-serve
npx @bytebase/dbhub \
--transport sse --port 8080 \
--dsn "sqlserver://sa:Sa123456@192.168.56.101:1433/Employees"

安装sql-server¶

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=Sa123456" \
-p 1433:1433 --name sql1 --hostname sql1 \
-d \
mcr.microsoft.com/mssql/server:2022-latest

Lmjx

客户端配置¶

用vscode的Cline配置

{
  "mcpServers": {
    "mcp-sql-serve": {
      "autoApprove": [],
      "disabled": false,
      "timeout": 60,
      "url": "http://192.168.56.101:8080/sse",
      "transportType": "sse"
    }
  }
}