How fiyo/dbcheck works
RaccoonX is a cross-platform database inspection and operations platform. Its central user workflow is to manage a database instance, connect and collect data, run inspection and analysis, produce a report, and retain history for comparisons; the README also documents monitoring, SQL audit, AI/RAG, backup, scheduling, and other operational features. Core inspection relationships are supported by the engine’s source index; several additional feature links reflect README-level documentation, not inspected call sites. Some subsystems have unsampled implementations, so their internal wiring is not expanded.
Main entry points: app.py Web Application · inspection/engine.py Inspection Engine · instance_manager.py Instance Manager · disaster_recovery/engine.py Disaster Recovery
Components 24
Access and Instances
- Instance Manager
modules/pro/instance_manager.py - User Management
modules/user_management/services/auth_service.py
Inspection and Reports
- Inspection Engine
modules/inspection/engine.py - Findings Analysis
modules/inspection/analyzer.py - Config Baselines
modules/inspection/config_baseline.py - Slow Query Analysis
modules/inspection/slow_query.py - Index Health
modules/inspection/index_health.py - Inspection History
modules/inspection/dal.py - SQL Audit
modules/sqlaudit/service.py - Oracle AWR Analysis
modules/web/awr_parser.py
Operations
- Live Monitoring
modules/monitor/engine.py - Server Inspection
modules/server/inspect.py - Disaster Recovery
modules/disaster_recovery/engine.py - Scheduled Tasks
modules/web/scheduler.py - Notifications
modules/notify/__init__.py
AI and Knowledge
- AI Diagnostics
modules/intelligence/ai_helper.py - RAG Knowledge Base
modules/rag/manager.py - Document Knowledge
modules/doc_kb/service.py - AI Skills
modules/intelligence/skills.py
Interfaces and Extensions
- Web Application
modules/web/app.py - MCP Server
modules/mcp_server/server.py - Plugin System
modules/pluginkit/loader.py
Other components
- DBA / Engineer
- Database Systems
Connections 29
- DBA / Engineer → Web Application: uses
README.md - Web Application → Instance Manager: manages instances
- Instance Manager → Database Systems: connects to
- Web Application → Inspection Engine: starts inspection
- Inspection Engine → Database Systems: collects data
README.md - Inspection Engine → Findings Analysis: uses analysis
modules/inspection/engine.py - Inspection Engine → Config Baselines: checks baselines
modules/inspection/engine.py - Inspection Engine → Slow Query Analysis: analyzes queries
modules/inspection/engine.py - Inspection Engine → Index Health: checks indexes
modules/inspection/engine.py - Inspection Engine → Inspection History: records results
modules/inspection/engine.py - Inspection Engine → Web Application: generates reports
README.md - Web Application → Live Monitoring: opens monitoring
- Live Monitoring → Database Systems: collects metrics
README.md - Web Application → Server Inspection: starts server checks
- Web Application → SQL Audit: submits SQL audit
- SQL Audit → Instance Manager: resolves instance
modules/sqlaudit/routes.py - Web Application → Disaster Recovery: manages backup plans
- Disaster Recovery → Instance Manager: gets credentials
modules/disaster_recovery/engine.py - Scheduled Tasks → Disaster Recovery: runs plans
- Scheduled Tasks → Notifications: sends alerts
- Inspection Engine → AI Diagnostics: requests diagnosis
- AI Diagnostics → RAG Knowledge Base: retrieves knowledge
- Document Knowledge → RAG Knowledge Base: supplies documents
modules/doc_kb/service.py - DBA / Engineer → MCP Server: requests tools
README.md - MCP Server → AI Skills: dispatches skills
modules/mcp_server/server.py - AI Skills → Instance Manager: uses instances
modules/intelligence/skills.py - Web Application → Plugin System: loads extensions
- DBA / Engineer → Oracle AWR Analysis: uploads AWR report
README.md - Web Application → User Management: authenticates users