🔥 DBHub 测评：让AI替你写SQL，这款“零依赖”数据库网关到底有多香？

# 1. 安装Node.js（如未安装）
# 访问 https://nodejs.org/ 下载LTS版本，安装时勾选“Add to PATH”

# 2. 打开命令提示符（cmd）或PowerShell
# 3. 直接运行DBHub（无需单独安装）
npx @bytebase/dbhub@latest --transport stdio --dsn "mysql://root:123456@localhost:3306/test_db"

# 1. 下载Docker Desktop for Windows
# https://www.docker.com/products/docker-desktop/

# 2. 运行容器（注意用host.docker.internal连接宿主机数据库）
docker run --rm --init ^
  --name dbhub ^
  --publish 8080:8080 ^
  bytebase/dbhub ^
  --transport http ^
  --port 8080 ^
  --dsn "mysql://root:123456@host.docker.internal:3306/test_db"

# 1. 安装Node.js（推荐通过Homebrew）
brew install node

# 2. 验证安装
node --version  # 应显示v18+

# 3. 启动DBHub
npx @bytebase/dbhub@latest --transport stdio --dsn "postgres://user:password@localhost:5432/mydb"

# 1. 安装Docker Desktop for Mac
# https://www.docker.com/products/docker-desktop/

# 2. 启动服务（Apple Silicon芯片原生支持）
docker run --rm --init \
  --name dbhub \
  --publish 8080:8080 \
  bytebase/dbhub \
  --transport http \
  --port 8080 \
  --dsn "postgres://user:password@host.docker.internal:5432/mydb"

# 1. 安装Node.js（使用NodeSource仓库）
curl -fsSL https://deb.nodesource.com/setup_20.x | sudo -E bash -
sudo apt-get install -y nodejs

# 2. 验证安装
node --version

# 3. 启动DBHub
npx @bytebase/dbhub@latest --transport stdio --dsn "postgres://user:password@localhost:5432/mydb"

# 创建服务文件
sudo nano /etc/systemd/system/dbhub.service

[Unit]
Description=DBHub MCP Server
After=network.target

[Service]
ExecStart=/usr/bin/npx @bytebase/dbhub@latest --transport http --port 8080 --dsn "postgres://user:password@localhost:5432/mydb"
Restart=always
User=your-username

[Install]
WantedBy=multi-user.target

sudo systemctl enable dbhub
sudo systemctl start dbhub
sudo systemctl status dbhub

# 方式一：stdio模式（直接测试）
echo '{"jsonrpc":"2.0","method":"tools/list","id":1}' | npx @bytebase/dbhub@latest --transport stdio --dsn "your-dsn"

# 方式二：HTTP模式（浏览器访问）
# 访问 http://localhost:8080，看到Workbench界面即成功[citation:1][citation:5]

{
  "mysql_dbhub": {
    "command": "npx",
    "args": ["-y", "@bytebase/dbhub", "--transport", "stdio", "--dsn", "mysql://root:123456@localhost:3306/test_db"],
    "transportType": "stdio"
  }
}

{
  "mcpServers": {
    "dbhub-postgres": {
      "command": "npx",
      "args": ["-y", "@bytebase/dbhub", "--transport", "stdio", "--dsn", "postgres://user:password@localhost:5432/mydb"]
    },
    "dbhub-demo": {
      "command": "npx", 
      "args": ["-y", "@bytebase/dbhub", "--transport", "stdio", "--demo"]
    }
  }
}

{
  "sqlserver": {
    "url": "http://192.168.1.100:8080/message",
    "transport": "streamable_http"
  }
}

# 终端运行
npx @bytebase/dbhub@latest --transport stdio --dsn "mysql://root:123456@localhost:3306/shop"

📊 数据库 shop 结构概览：

users（用户表）：3条记录
- id (int) 主键
- name (varchar) 
- email (varchar)
- register_date (datetime)

orders（订单表）：8条记录
- id (int) 主键
- user_id (int) 外键→users.id
- amount (decimal)
- status (varchar) 枚举值：pending/completed/cancelled
- created_at (datetime)

products（商品表）：5条记录
- id (int) 主键
- name (varchar)
- price (decimal)
- stock (int)

SELECT DATE(created_at) as order_date, SUM(amount) as daily_total
FROM orders 
WHERE status = 'completed' 
  AND MONTH(created_at) = MONTH(CURRENT_DATE())
GROUP BY DATE(created_at)
ORDER BY order_date DESC;

📈 本月订单统计（已完成）：
- 2026-03-25：¥12,340
- 2026-03-24：¥8,560
- 2026-03-23：¥15,200

SELECT u.name, u.email, SUM(o.amount) as total_spent
FROM users u
JOIN orders o ON u.id = o.user_id
WHERE o.status = 'completed'
GROUP BY u.id, u.name, u.email
ORDER BY total_spent DESC
LIMIT 3;

🏆 消费榜 TOP3：
1. 张伟（zhangwei@example.com）：¥35,800
2. 李芳（lifang@example.com）：¥28,400
3. 王磊（wanglei@example.com）：¥21,900

INSERT INTO orders (user_id, amount, status, created_at)
VALUES (
  (SELECT id FROM users WHERE name = '张伟'),
  597.00,
  'pending',
  NOW()
);

UPDATE orders SET status = 'completed' WHERE id = 12;

{
  "mcpServers": {
    "shop-database": {
      "command": "npx",
      "args": [
        "-y",
        "@bytebase/dbhub",
        "--transport",
        "stdio",
        "--dsn",
        "mysql://root:yourpassword@localhost:3306/shop"
      ],
      "transportType": "stdio",
      "autoApprove": [
        "execute_sql",
        "search_objects"
      ]
    }
  }
}

# 定义生产数据库源
[[sources]]
id = "prod"
dsn = "mysql://app_user:app_pass@localhost:3306/shop"

# 自定义工具1：获取用户订单
[[tools]]
name = "get_user_orders"
description = "根据用户邮箱获取该用户的订单列表"
source = "prod"
statement = "SELECT o.id, o.amount, o.status, o.created_at FROM orders o JOIN users u ON o.user_id = u.id WHERE u.email = $1 ORDER BY o.created_at DESC LIMIT $2"

[[tools.parameters]]
name = "email"
type = "string"
description = "用户邮箱"

[[tools.parameters]]
name = "limit"
type = "integer"
description = "返回订单数量"
default = "10"

# 自定义工具2：库存预警
[[tools]]
name = "low_stock_alert"
description = "查询库存低于阈值的商品"
source = "prod"
statement = "SELECT name, stock, price FROM products WHERE stock < $1 ORDER BY stock ASC"

[[tools.parameters]]
name = "threshold"
type = "integer"
description = "库存阈值"
default = "10"

npx @bytebase/dbhub --config dbhub.toml --transport stdio