mcp ok

https://www.python.org/


https://nodejs.org/en


powershell -ExecutionPolicy ByPass -c "irm https://astral.sh/uv/install.ps1 | iex"


https://github.com/runekaagaard/mcp-alchemy   (连接mysql 和 oracle )


https://github.com/liliangshan/mcp-server-mssqlserver    (连接SqlServer  注意启用 tcp协议)




{
  "mcpServers": {
    "freesqlTest": {
      "command": "npx",
      "args": ["@liangshanli/mcp-server-mssqlserver"],
      "env": {
        "MSSQL_SERVER": "localhost",
        "MSSQL_PORT": "1433",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "sa",
        "MSSQL_DATABASE": "freesqlTest",
        "MSSQL_SCHEMA": "dbo",
        "MSSQL_ENCRYPT": "false",
        "MSSQL_TRUST_SERVER_CERTIFICATE": "true",
        "ALLOW_DDL": "false",
        "ALLOW_DROP": "false",
        "ALLOW_DELETE": "false"
      }
    },
    "imes": {
      "command": "uvx",
      "args": ["--from", "mcp-alchemy==2025.8.15.91819", "--with", "oracledb",
               "--refresh-package", "mcp-alchemy", "mcp-alchemy"],
      "env": {
        "DB_URL": "oracle+oracledb://imes:imes@10.30.35.204/MQ1"
      }
    },
    "test2025": {
      "command": "uvx",
      "args": ["--from", "mcp-alchemy==2025.8.15.91819", "--with", "pymysql",
               "--refresh-package", "mcp-alchemy", "mcp-alchemy"],
      "env": {
        "DB_URL": "mysql+pymysql://root:root@localhost/test2025"
      }
    }
  }
}
posted @ 2025-10-11 18:59  网络来者  阅读(9)  评论(0)    收藏  举报