自托管数据库自主诊断平台。

DBPilot 持续采样你的实例，并在一个网页控制台中提供日常 DBA 工作流程：性能趋势和洞察（AAS 负载分解）、顶级 SQL、查询计划变更跟踪、缺失索引建议、索引使用与碎片、阻塞分析、死锁分析以及慢查询日志。

简体中文

目录

• 亮点
• 截图
• 快速入门
• 密码和主密钥
• 配置
• 从源头构建
• 建筑学
• 特色
• 发动机支撑矩阵
• AI诊断（MCP服务器）
• 监控实例的开销
• 通过NuGet嵌入
• 常见问题解答
• 许可证

精彩片段

• 单进程部署 — 一个 .NET 进程（8.0+）+ 一个元数据数据库，模式启动时自动创建（SQL Server / MySQL / PostgreSQL / SQLite）。
• 监控三个引擎 — SQL Server 2008–2022，MySQL 8.0+，PostgreSQL 13+。监控引擎和元数据存储引擎是独立的轴：任意组合皆可。
• ** 不要将宿主项目命名为 dbpilot 或 DBPilot.* ——它会与 NuGet 包发生冲突，导致恢复失败（NU1108）。

2. 将Program.cs替换为：

3. 用（SQLite风格）替换appsettings.json：

DBPilot

Self-hosted database autonomous diagnostics platform.

DBPilot continuously samples your instances and serves the day-to-day DBA workflow in one web console: performance trends and insight (AAS load decomposition), Top SQL, query plan change tracking, missing-index advice, index usage & fragmentation, blocking analysis, deadlock analysis, and slow query logs.

简体中文

Contents

• Highlights
• Screenshots
• Quick start
• Password and master key
• Configuration
• Building from source
• Architecture
• Features
• Engine support matrix
• AI diagnostics (MCP Server)
• Overhead on monitored instances
• Embedding via NuGet
• FAQ
• License

Highlights

• Single-process deployment — one .NET process (8.0+) + one metadata DB, schema auto-created on startup (SQL Server / MySQL / PostgreSQL / SQLite).
• Monitors three engines — SQL Server 2008–2022, MySQL 8.0+, PostgreSQL 13+. Monitoring and metadata-store engines are independent axes: any combination works.
• <1% CPU overhead — collectors read only in-memory metadata views (DMVs / pg_stat_* / performance_schema); business tables are never scanned.
• AI-ready — built-in read-only MCP Server exposes 11 diagnostic tools to AI agents (Claude Code, Codex CLI). Just ask: “did any SQL slow down in the last hour?”
• Capability-driven UI — features without an equivalent data source hide or degrade per engine (PostgreSQL gets deadlock trends instead of event details); APIs answer with actionable messages.

Screenshots