DBCheck database inspection

Overview of core functions function description ˇData source management Unified management of all database instances, supporting grouping, batch inspection, CSV import and export Database inspection Covering 10 databases, 160+ enhanced rules, and automatically generating Word reports In-depth analysis of slow queries Associate execution plan, I/O mode, lock waiting and other dimensions, and AI-assisted root cause analysis lock diagnosis Blocking chain visualization, deadlock statistics, long transaction detection, including executable repair scripts 📊Index Health Analysis Detect missing indexes, redundant indexes, and long-term unused indexes ˇConfigure baseline checks Comparative analysis of current values and recommended values of key parameters in each library Historical trend analysis Multiple rounds of inspection data are aggregated to generate a trend line chart, and changes are compared before and after AI intelligent diagnosis Based on local Olama, automatic generation of optimization suggestions based on inspection indicators 💬AI dialogue inspection AI panel in the lower right corner of the Web UI, natural language initiates inspections 📡Real-time monitoring Slow query + real-time monitoring of active connections, visualization of heat maps ˇServer inspection Comprehensive inspection of CPU/memory/disk/network/process Share links Generate online sharing links with one click, and view reports without login Timing tasks Cron expressions are checked regularly and automatically notified by email/Webhook after completion RAG Knowledge Base Upload operation and maintenance documents, and automatically retrieve relevant knowledge during AI diagnosis 📊AWR report analysis Upload Oracle AWR HTML reports and automatically generate Word analysis reports 📝SQL Editor Built-in Web UI, syntax highlighting, result table, execution history ˇRemote terminal Based on SSH, multiple tabs, full-screen mode Database inspection Inspection coverage of each warehouse Inspection dimension MySQL PG Oracle SQL Server DM8 TiDB IvorySQL YashanDB KingbaseES GBase 8s Basic information (version/instance/library) ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ Sessions and Connections ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ Memory and Cache ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ tablespace - - ✅ ✅ ✅ - - ✅ - ✅ SGA/PGA Memory - - ✅ - ✅ - - ✅ - - Redo log - - ✅ - ✅ - ✅ - - - Archive and backup - - ✅ ✅ ✅ - - ✅ - - Key parameter configuration ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ invalid objects ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ User security audit ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ Top SQL /Slow Query ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ Master-slave replication/ Data Guard ✅ ✅ - - - ✅ ✅ - ✅ - RAC cluster - - ✅ - - - - - - - Lock and blockage detection ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ object statistics - - ✅ ✅ ✅ ✅ ✅ - ✅ ✅ partition table information - - ✅ ✅ ✅ ✅ ✅ - ✅ - Chunks/Disk Storage - - - - - - - - - ✅ Logical log/checkpoint - - - - - - - - - ✅ Word report structure (Oracle example) chapters content cover Database name, version, host information, inspector, timestamp Chapter 1 OS host information (CPU /memory/disk) Chapter 2 Basic database information Chapter 3 Tablespaces (including automatic expansion) Chapter 4 SGA / PGA Memory Analysis Chapter 5 Key parameter configuration Chapters 6 to 19 Undo / Redo /Archive/ DG / RAC / ASM /Sessions/Performance/Security, etc. Chapter 20 Risks and recommendations (including executable repair SQL) Chapter 21 AI diagnostic recommendations (Markdown automatically renders to Word) Chapter 22 report describes The report structure of each database type is slightly different, and inspection sections can be freely configured through the Web UI. Intelligent risk analysis Automatically detect potential risks of various databases. Each risk comes with executable repair SQL and supports one-click execution. Risk rule statistics database number of rules coverage dimension MySQL 35+ connection, memory, disk, slow query, lock, security, replication PostgreSQL 27+ connection, caching, performance, security, archive, dead tuples Oracle 20+ Tablespace, TEMP, Session, SGA, Redo, DG, ASM, Security SQL Server 15+ connection, session, wait, lock, deadlock, backup, memory DM8 16+ Tablespaces, memory pools, sessions, transactions, backup, security TiDB 18+ connection, memory, disk, slow query, lock, security, Placement IvorySQL 27+ Same as PostgreSQL YashanDB 15+ connection, memory, table space, lock, backup, security KingbaseES 19+ Connectivity, caching, performance, security, archiving, statistics GBase 8s 6+ connection, dbspace, logging, memory, password policy one-click repair Each risk card provides an "Execute Repair" button. Dangerous operations (DELETE/DROP/TRUNCATE) require secondary confirmation, and all operations are logged. AI intelligent diagnosis Based on local Ollama deployment, inspection data is completely offline and requires no networking. rear end description applicable scenarios ollama Pure local, zero cost, no data out of the machine Intranet environment, high security requirements openai Cloud API (OpenAI / DeepSeek), requires networking Environment that allows cloud APIs disabled Disable AI (default) No need for AI functions Quick Start: ollama pull qwen3:30b #Pull the diagnostic model (the larger the better the effect) ollama pull nomic-embed-text #Pull RAG embedded model (required for knowledge base functions) python web_ui.py #Configure on the AI Settings page after startup other functions SQL editor The Web UI has a built-in interactive SQL editor that supports all 10 databases, syntax highlighting, result tables, and error-friendly prompts. real-time monitoring Slow query + real-time monitoring of active connections, visualization of heat maps, automatic refresh (adjustable in 5 to 60 seconds), and support for CSV export. remote terminal SSH based, support password/key authentication, multi-tab management, full-screen mode. Server inspection Independent of database inspection, covering CPU /memory/disk/network/service/process, generate professional server inspection report. historical trend analysis Multiple rounds of inspection data are automatically aggregated, the Web UI trend analysis page displays a line chart + threshold line, and the comparison changes before and after are marked with colored arrows. Timing tasks and notifications Support Cron expressions, quick presets (daily/weekdays/weekly/monthly), automatic email (attached Word report) or Webhook (Enterprise WeChat/Nail/Custom JSON) notification after task completion. share links Generate online sharing links with one click, view reports without login, isolate permissions, automatically record visits, and delete them at any time. Configure Baseline Management The Web UI visually edits the recommended values, thresholds and compliance rules for key parameters of each library. Current support: MySQL: 22 parameters (buffer pool, number of connections, binlog, etc.) PostgreSQL: 21 parameters (shared_buffers, work_mem, WAL, etc.) Oracle: 12 parameters (SGA/PGA, processes, undo, etc.) SQL Server: 6 parameters (memory, parallelism, backup compression, etc.) DM8: 7 parameters (memory target, number of sessions, buffer pool, etc.) TiDB: 9 parameters (buffer pool, number of connections, concurrency, etc.) YashanDB: 8 parameters (buffer pool, connection, logging, etc.) KingbaseES: 7 parameters (connection, buffer, vacuum, etc.) GBase 8s: 9 parameters (MAXCONNECTIONS, SHMVIRTSIZE, BUFFERS, LOGSMAX, etc.) Inspection chapter management Configurable drivers, each database can independently add/delete/sort/start and stop inspection chapters, and Word reports can be dynamically generated. AWR report analysis Upload Oracle AWR HTML reports, automatically parse key performance indicators, generate structured Word analysis reports, and support AI-assisted diagnosis. RAG Knowledge Base Upload PDF / Word / Markdown / TXT documents to automatically quantify, and automatically retrieve relevant knowledge during AI diagnosis to generate more accurate suggestions. Multiple languages and themes Support Chinese (default) and English, CLI parameters and Web UI can be switched Support dark/light themes, automatic saving of preferences