DBPilot

•
97
•

Deliver self-hosted performance diagnostics for SQL Server, MySQL, and PostgreSQL, covering trends, AAS insight, Top SQL, plan-change tracking, blocking, and deadlock analysis.

DBPilot is a self-hosted database autonomous diagnostics platform that continuously samples your database instances to streamline day-to-day DBA workflows. It provides a single web console for performance trends, Average Active Sessions (AAS) load decomposition, Top SQL analysis, query plan change tracking, missing index advice, index usage, fragmentation, blocking, deadlock analysis, and slow query logs. Designed for very low overhead on monitored instances, DBPilot also comes AI-ready with a built-in read-only MCP Server, exposing 11 diagnostic tools for integration with AI agents.

主な機能

01Monitors SQL Server (2008–2022), MySQL (8.0+), and PostgreSQL (13+) with low overhead (<1% CPU).
02Offers comprehensive performance trends, AAS insight, Top SQL, query plan change tracking, and missing index advice.
03Provides detailed blocking and deadlock analysis, including real-time trees and historical events.
04Single-process deployment with support for SQL Server, MySQL, PostgreSQL, or SQLite as the metadata store.
05Built-in read-only MCP Server exposes 11 diagnostic tools to AI agents for automated insights.
0634 GitHub stars

ユースケース

01Organizations requiring a self-hosted, low-overhead solution for managing database health and identifying performance bottlenecks.
02Integrating AI agents for automated database diagnostics and querying performance data using the built-in MCP Server.
03Database administrators seeking comprehensive performance monitoring and diagnostics across mixed SQL Server, MySQL, and PostgreSQL environments.