# Pitfall Log / 踩坑日志

项目：sdebruyn/fabric-dw-mcp-cli

摘要：发现 34 个潜在踩坑项，其中 5 个为 high/blocking；最高优先级：安全/权限坑 - 失败模式：security_permissions: Track: measure execute_sql overuse after the MCP instructions block (needs telemetry)。

## 1. 安全/权限坑 · 失败模式：security_permissions: Track: measure execute_sql overuse after the MCP instructions block (needs telemetry)

- 严重度：high
- 证据强度：source_linked
- 发现：Developers should check this security_permissions risk before relying on the project: Track: measure execute_sql overuse after the MCP instructions block (needs telemetry)
- 对用户的影响：Developers may expose sensitive permissions or credentials: Track: measure execute_sql overuse after the MCP instructions block (needs telemetry)
- 证据：failure_mode_cluster:github_issue | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/985 | Track: measure execute_sql overuse after the MCP instructions block (needs telemetry)

## 2. 安全/权限坑 · 失败模式：security_permissions: feat(mcp): add server instructions and steer execute_sql toward dedicated tools

- 严重度：high
- 证据强度：source_linked
- 发现：Developers should check this security_permissions risk before relying on the project: feat(mcp): add server instructions and steer execute_sql toward dedicated tools
- 对用户的影响：Developers may expose sensitive permissions or credentials: feat(mcp): add server instructions and steer execute_sql toward dedicated tools
- 证据：failure_mode_cluster:github_issue | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/984 | feat(mcp): add server instructions and steer execute_sql toward dedicated tools

## 3. 安全/权限坑 · 失败模式：security_permissions: feat(mcp): name the remaining tool domains in the server instructions

- 严重度：high
- 证据强度：source_linked
- 发现：Developers should check this security_permissions risk before relying on the project: feat(mcp): name the remaining tool domains in the server instructions
- 对用户的影响：Developers may expose sensitive permissions or credentials: feat(mcp): name the remaining tool domains in the server instructions
- 证据：failure_mode_cluster:github_issue | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/992 | feat(mcp): name the remaining tool domains in the server instructions

## 4. 安全/权限坑 · 失败模式：security_permissions: fix(cli): leading optional ITEM positional swallows the first required argument

- 严重度：high
- 证据强度：source_linked
- 发现：Developers should check this security_permissions risk before relying on the project: fix(cli): leading optional ITEM positional swallows the first required argument
- 对用户的影响：Developers may expose sensitive permissions or credentials: fix(cli): leading optional ITEM positional swallows the first required argument
- 证据：failure_mode_cluster:github_issue | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/981 | fix(cli): leading optional ITEM positional swallows the first required argument

## 5. 安全/权限坑 · 来源证据：Track: set SQL connection program_name to fdw.debruyn.dev (blocked on mssql-python#649)

- 严重度：high
- 证据强度：source_linked
- 发现：GitHub 社区证据显示该项目存在一个安全/权限相关的待验证问题：Track: set SQL connection program_name to fdw.debruyn.dev (blocked on mssql-python#649)
- 对用户的影响：可能阻塞安装或首次运行。
- 证据：community_evidence:github | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/892 | 来源讨论提到 python 相关条件，需在安装/试用前复核。

## 6. 身份坑 · 仓库名和安装名不一致

- 严重度：medium
- 证据强度：runtime_trace
- 发现：仓库名 `fabric-dw-mcp-cli` 与安装入口 `fabric-dw` 不完全一致。
- 对用户的影响：用户照着仓库名搜索包或照着包名找仓库时容易走错入口。
- 复现命令：`pip install fabric-dw`
- 证据：identity.distribution | https://github.com/sdebruyn/fabric-dw-mcp-cli | repo=fabric-dw-mcp-cli; install=fabric-dw

## 7. 安装坑 · 失败模式：installation: fix(ci): replace uv sync --frozen with --locked in remaining workflows

- 严重度：medium
- 证据强度：source_linked
- 发现：Developers should check this installation risk before relying on the project: fix(ci): replace uv sync --frozen with --locked in remaining workflows
- 对用户的影响：Developers may fail before the first successful local run: fix(ci): replace uv sync --frozen with --locked in remaining workflows
- 证据：failure_mode_cluster:github_issue | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/990 | fix(ci): replace uv sync --frozen with --locked in remaining workflows

## 8. 安装坑 · 失败模式：installation: fix(ci): uv.lock is out of sync with pyproject.toml, and nothing detects it

- 严重度：medium
- 证据强度：source_linked
- 发现：Developers should check this installation risk before relying on the project: fix(ci): uv.lock is out of sync with pyproject.toml, and nothing detects it
- 对用户的影响：Developers may fail before the first successful local run: fix(ci): uv.lock is out of sync with pyproject.toml, and nothing detects it
- 证据：failure_mode_cluster:github_issue | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/988 | fix(ci): uv.lock is out of sync with pyproject.toml, and nothing detects it

## 9. 安装坑 · 失败模式：installation: fix(deps): cap httpx below 2.0 so the pre-release build is installable

- 严重度：medium
- 证据强度：source_linked
- 发现：Developers should check this installation risk before relying on the project: fix(deps): cap httpx below 2.0 so the pre-release build is installable
- 对用户的影响：Developers may fail before the first successful local run: fix(deps): cap httpx below 2.0 so the pre-release build is installable
- 证据：failure_mode_cluster:github_issue | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/995 | fix(deps): cap httpx below 2.0 so the pre-release build is installable

## 10. 安装坑 · 失败模式：installation: test(integration): add an end-to-end journey smoke test exercising config defaults

- 严重度：medium
- 证据强度：source_linked
- 发现：Developers should check this installation risk before relying on the project: test(integration): add an end-to-end journey smoke test exercising config defaults
- 对用户的影响：Developers may fail before the first successful local run: test(integration): add an end-to-end journey smoke test exercising config defaults
- 证据：failure_mode_cluster:github_issue | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/982 | test(integration): add an end-to-end journey smoke test exercising config defaults

## 11. 安装坑 · 失败模式：installation: v2026.7.0

- 严重度：medium
- 证据强度：source_linked
- 发现：Developers should check this installation risk before relying on the project: v2026.7.0
- 对用户的影响：Upgrade or migration may change expected behavior: v2026.7.0
- 证据：failure_mode_cluster:github_release | https://github.com/sdebruyn/fabric-dw-mcp-cli/releases/tag/v2026.7.0 | v2026.7.0

## 12. 安装坑 · 失败模式：installation: v2026.7.1

- 严重度：medium
- 证据强度：source_linked
- 发现：Developers should check this installation risk before relying on the project: v2026.7.1
- 对用户的影响：Upgrade or migration may change expected behavior: v2026.7.1
- 证据：failure_mode_cluster:github_release | https://github.com/sdebruyn/fabric-dw-mcp-cli/releases/tag/v2026.7.1 | v2026.7.1

## 13. 安装坑 · 失败模式：installation: v2026.7.1rc1

- 严重度：medium
- 证据强度：source_linked
- 发现：Developers should check this installation risk before relying on the project: v2026.7.1rc1
- 对用户的影响：Upgrade or migration may change expected behavior: v2026.7.1rc1
- 证据：failure_mode_cluster:github_release | https://github.com/sdebruyn/fabric-dw-mcp-cli/releases/tag/v2026.7.1rc1 | v2026.7.1rc1

## 14. 安装坑 · 来源证据：fix(ci): uv.lock is out of sync with pyproject.toml, and nothing detects it

- 严重度：medium
- 证据强度：source_linked
- 发现：GitHub 社区证据显示该项目存在一个安装相关的待验证问题：fix(ci): uv.lock is out of sync with pyproject.toml, and nothing detects it
- 对用户的影响：可能增加新用户试用和生产接入成本。
- 证据：community_evidence:github | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/988 | 来源类型 github_issue 暴露的待验证使用条件。

## 15. 安装坑 · 来源证据：fix(deps): cap httpx below 2.0 so the pre-release build is installable

- 严重度：medium
- 证据强度：source_linked
- 发现：GitHub 社区证据显示该项目存在一个安装相关的待验证问题：fix(deps): cap httpx below 2.0 so the pre-release build is installable
- 对用户的影响：可能增加新用户试用和生产接入成本。
- 证据：community_evidence:github | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/995 | 来源类型 github_issue 暴露的待验证使用条件。

## 16. 安装坑 · 来源证据：test(integration): add an end-to-end journey smoke test exercising config defaults

- 严重度：medium
- 证据强度：source_linked
- 发现：GitHub 社区证据显示该项目存在一个安装相关的待验证问题：test(integration): add an end-to-end journey smoke test exercising config defaults
- 对用户的影响：可能增加新用户试用和生产接入成本。
- 证据：community_evidence:github | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/982 | 来源类型 github_issue 暴露的待验证使用条件。

## 17. 配置坑 · 可能修改宿主 AI 配置

- 严重度：medium
- 证据强度：source_linked
- 发现：项目面向 Claude/Cursor/Codex/Gemini/OpenCode 等宿主，或安装命令涉及用户配置目录。
- 对用户的影响：安装可能改变本机 AI 工具行为，用户需要知道写入位置和回滚方法。
- 证据：capability.host_targets | https://github.com/sdebruyn/fabric-dw-mcp-cli | host_targets=mcp_host, claude

## 18. 配置坑 · 失败模式：configuration: Track: set SQL connection program_name to fdw.debruyn.dev (blocked on mssql-python#649)

- 严重度：medium
- 证据强度：source_linked
- 发现：Developers should check this configuration risk before relying on the project: Track: set SQL connection program_name to fdw.debruyn.dev (blocked on mssql-python#649)
- 对用户的影响：Developers may misconfigure credentials, environment, or host setup: Track: set SQL connection program_name to fdw.debruyn.dev (blocked on mssql-python#649)
- 证据：failure_mode_cluster:github_issue | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/892 | Track: set SQL connection program_name to fdw.debruyn.dev (blocked on mssql-python#649)

## 19. 配置坑 · 失败模式：configuration: fix(test): sql_pools integration tests must ensure a warehouse exists (endpoint 500s on empty...

- 严重度：medium
- 证据强度：source_linked
- 发现：Developers should check this configuration risk before relying on the project: fix(test): sql_pools integration tests must ensure a warehouse exists (endpoint 500s on empty workspace)
- 对用户的影响：Developers may misconfigure credentials, environment, or host setup: fix(test): sql_pools integration tests must ensure a warehouse exists (endpoint 500s on empty workspace)
- 证据：failure_mode_cluster:github_issue | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/994 | fix(test): sql_pools integration tests must ensure a warehouse exists (endpoint 500s on empty workspace)

## 20. 配置坑 · 失败模式：configuration: v2026.6.0

- 严重度：medium
- 证据强度：source_linked
- 发现：Developers should check this configuration risk before relying on the project: v2026.6.0
- 对用户的影响：Upgrade or migration may change expected behavior: v2026.6.0
- 证据：failure_mode_cluster:github_release | https://github.com/sdebruyn/fabric-dw-mcp-cli/releases/tag/v2026.6.0 | v2026.6.0

## 21. 配置坑 · 失败模式：configuration: v2026.6.0rc0

- 严重度：medium
- 证据强度：source_linked
- 发现：Developers should check this configuration risk before relying on the project: v2026.6.0rc0
- 对用户的影响：Upgrade or migration may change expected behavior: v2026.6.0rc0
- 证据：failure_mode_cluster:github_release | https://github.com/sdebruyn/fabric-dw-mcp-cli/releases/tag/v2026.6.0rc0 | v2026.6.0rc0

## 22. 配置坑 · 失败模式：configuration: v2026.6.0rc2

- 严重度：medium
- 证据强度：source_linked
- 发现：Developers should check this configuration risk before relying on the project: v2026.6.0rc2
- 对用户的影响：Upgrade or migration may change expected behavior: v2026.6.0rc2
- 证据：failure_mode_cluster:github_release | https://github.com/sdebruyn/fabric-dw-mcp-cli/releases/tag/v2026.6.0rc2 | v2026.6.0rc2

## 23. 配置坑 · 来源证据：fix(test): sql_pools integration tests must ensure a warehouse exists (endpoint 500s on empty workspace)

- 严重度：medium
- 证据强度：source_linked
- 发现：GitHub 社区证据显示该项目存在一个配置相关的待验证问题：fix(test): sql_pools integration tests must ensure a warehouse exists (endpoint 500s on empty workspace)
- 对用户的影响：可能阻塞安装或首次运行。
- 证据：community_evidence:github | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/994 | 来源类型 github_issue 暴露的待验证使用条件。

## 24. 能力坑 · 能力判断依赖假设

- 严重度：medium
- 证据强度：source_linked
- 发现：README/documentation is current enough for a first validation pass.
- 对用户的影响：假设不成立时，用户拿不到承诺的能力。
- 证据：capability.assumptions | https://github.com/sdebruyn/fabric-dw-mcp-cli | README/documentation is current enough for a first validation pass.

## 25. 维护坑 · 维护活跃度未知

- 严重度：medium
- 证据强度：source_linked
- 发现：未记录 last_activity_observed。
- 对用户的影响：新项目、停更项目和活跃项目会被混在一起，推荐信任度下降。
- 证据：evidence.maintainer_signals | https://github.com/sdebruyn/fabric-dw-mcp-cli | last_activity_observed missing

- 严重度：medium
- 证据强度：source_linked
- 发现：no_demo
- 证据：downstream_validation.risk_items | https://github.com/sdebruyn/fabric-dw-mcp-cli | no_demo; severity=medium

## 27. 安全/权限坑 · 存在评分风险

- 严重度：medium
- 证据强度：source_linked
- 发现：no_demo
- 对用户的影响：风险会影响是否适合普通用户安装。
- 证据：risks.scoring_risks | https://github.com/sdebruyn/fabric-dw-mcp-cli | no_demo; severity=medium

## 28. 安全/权限坑 · 来源证据：Track: measure execute_sql overuse after the MCP instructions block (needs telemetry)

- 严重度：medium
- 证据强度：source_linked
- 发现：GitHub 社区证据显示该项目存在一个安全/权限相关的待验证问题：Track: measure execute_sql overuse after the MCP instructions block (needs telemetry)
- 对用户的影响：可能阻塞安装或首次运行。
- 证据：community_evidence:github | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/985 | 来源讨论提到 python 相关条件，需在安装/试用前复核。

## 29. 安全/权限坑 · 来源证据：feat(mcp): add server instructions and steer execute_sql toward dedicated tools

- 严重度：medium
- 证据强度：source_linked
- 发现：GitHub 社区证据显示该项目存在一个安全/权限相关的待验证问题：feat(mcp): add server instructions and steer execute_sql toward dedicated tools
- 对用户的影响：可能影响授权、密钥配置或安全边界。
- 证据：community_evidence:github | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/984 | 来源类型 github_issue 暴露的待验证使用条件。

## 30. 安全/权限坑 · 来源证据：feat(mcp): name the remaining tool domains in the server instructions

- 严重度：medium
- 证据强度：source_linked
- 发现：GitHub 社区证据显示该项目存在一个安全/权限相关的待验证问题：feat(mcp): name the remaining tool domains in the server instructions
- 对用户的影响：可能影响授权、密钥配置或安全边界。
- 证据：community_evidence:github | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/992 | 来源讨论提到 python 相关条件，需在安装/试用前复核。

## 31. 安全/权限坑 · 来源证据：fix(ci): replace uv sync --frozen with --locked in remaining workflows

- 严重度：medium
- 证据强度：source_linked
- 发现：GitHub 社区证据显示该项目存在一个安全/权限相关的待验证问题：fix(ci): replace uv sync --frozen with --locked in remaining workflows
- 对用户的影响：可能增加新用户试用和生产接入成本。
- 证据：community_evidence:github | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/990 | 来源讨论提到 docker 相关条件，需在安装/试用前复核。

## 32. 安全/权限坑 · 来源证据：fix(cli): leading optional ITEM positional swallows the first required argument

- 严重度：medium
- 证据强度：source_linked
- 发现：GitHub 社区证据显示该项目存在一个安全/权限相关的待验证问题：fix(cli): leading optional ITEM positional swallows the first required argument
- 对用户的影响：可能影响升级、迁移或版本选择。
- 证据：community_evidence:github | https://github.com/sdebruyn/fabric-dw-mcp-cli/issues/981 | 来源类型 github_issue 暴露的待验证使用条件。

## 33. 维护坑 · issue/PR 响应质量未知

- 严重度：low
- 证据强度：source_linked
- 发现：issue_or_pr_quality=unknown。
- 对用户的影响：用户无法判断遇到问题后是否有人维护。
- 证据：evidence.maintainer_signals | https://github.com/sdebruyn/fabric-dw-mcp-cli | issue_or_pr_quality=unknown

## 34. 维护坑 · 发布节奏不明确

- 严重度：low
- 证据强度：source_linked
- 发现：release_recency=unknown。
- 对用户的影响：安装命令和文档可能落后于代码，用户踩坑概率升高。
- 证据：evidence.maintainer_signals | https://github.com/sdebruyn/fabric-dw-mcp-cli | release_recency=unknown