Queries any database reachable through SQLAlchemy over ODBC (pyodbc) drivers.
接入配置
选择客户端,复制配置,再按项目文档补齐环境变量。
claude mcp add sqlalchemy --env DB_URL='<DB_URL>' --env API_KEY='<API_KEY>' --env ODBC_DSN='<ODBC_DSN>' --env ODBC_PASSWORD='<ODBC_PASSWORD>' --env ODBC_USER='<ODBC_USER>' -- uv --directory /path/to/mcp-sqlalchemy-server run mcp-sqlalchemy-server~/.codex/config.toml
[mcp_servers.sqlalchemy]
command = "uv"
args = ["--directory", "/path/to/mcp-sqlalchemy-server", "run", "mcp-sqlalchemy-server"]
env = { DB_URL = "<DB_URL>", API_KEY = "<API_KEY>", ODBC_DSN = "<ODBC_DSN>", ODBC_PASSWORD = "<ODBC_PASSWORD>", ODBC_USER = "<ODBC_USER>" }
# codex mcp add sqlalchemy --env DB_URL='<DB_URL>' --env API_KEY='<API_KEY>' --env ODBC_DSN='<ODBC_DSN>' --env ODBC_PASSWORD='<ODBC_PASSWORD>' --env ODBC_USER='<ODBC_USER>' -- uv --directory /path/to/mcp-sqlalchemy-server run mcp-sqlalchemy-server~/.cursor/mcp.json
{
"mcpServers": {
"sqlalchemy": {
"command": "uv",
"args": [
"--directory",
"/path/to/mcp-sqlalchemy-server",
"run",
"mcp-sqlalchemy-server"
],
"env": {
"DB_URL": "<DB_URL>",
"API_KEY": "<API_KEY>",
"ODBC_DSN": "<ODBC_DSN>",
"ODBC_PASSWORD": "<ODBC_PASSWORD>",
"ODBC_USER": "<ODBC_USER>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"sqlalchemy": {
"type": "stdio",
"command": "uv",
"args": [
"--directory",
"/path/to/mcp-sqlalchemy-server",
"run",
"mcp-sqlalchemy-server"
],
"env": {
"DB_URL": "<DB_URL>",
"API_KEY": "<API_KEY>",
"ODBC_DSN": "<ODBC_DSN>",
"ODBC_PASSWORD": "<ODBC_PASSWORD>",
"ODBC_USER": "<ODBC_USER>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"sqlalchemy": {
"command": "uv",
"args": [
"--directory",
"/path/to/mcp-sqlalchemy-server",
"run",
"mcp-sqlalchemy-server"
],
"env": {
"DB_URL": "<DB_URL>",
"API_KEY": "<API_KEY>",
"ODBC_DSN": "<ODBC_DSN>",
"ODBC_PASSWORD": "<ODBC_PASSWORD>",
"ODBC_USER": "<ODBC_USER>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"sqlalchemy": {
"command": "uv",
"args": [
"--directory",
"/path/to/mcp-sqlalchemy-server",
"run",
"mcp-sqlalchemy-server"
],
"env": {
"DB_URL": "<DB_URL>",
"API_KEY": "<API_KEY>",
"ODBC_DSN": "<ODBC_DSN>",
"ODBC_PASSWORD": "<ODBC_PASSWORD>",
"ODBC_USER": "<ODBC_USER>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"sqlalchemy": {
"command": "uv",
"args": [
"--directory",
"/path/to/mcp-sqlalchemy-server",
"run",
"mcp-sqlalchemy-server"
],
"env": {
"DB_URL": "<DB_URL>",
"API_KEY": "<API_KEY>",
"ODBC_DSN": "<ODBC_DSN>",
"ODBC_PASSWORD": "<ODBC_PASSWORD>",
"ODBC_USER": "<ODBC_USER>"
}
}
}
}需要的环境变量
DB_URLAPI_KEYODBC_DSNODBC_PASSWORDODBC_USER
把占位值换成你自己的密钥;不要把密钥提交到代码仓库。