| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Community Apps Dependencies | Show |
| Lines of code | 5797 |
| Technical Name |
odoo_nova_ai_plugin_db_analyzer |
| License | OPL-1 |
| Website | https://odoo.orionyx.dev |
| Versions | 17.0 18.0 19.0 |
Database Analyzer
Smart DBA Plugin for AI-Powered Database Diagnostics
Detect orphan records, analyze referential integrity, run safe SQL diagnostics, and get performance insights — all through natural language conversations.
OdooNovaAi Ecosystem
This plugin requires the AI Assistant (base) module to work.
If you haven't purchased the base module yet, it will be automatically added to your cart when you buy this plugin.
DB Analyzer
This module
$119Deep Database Intelligence
Ask your database questions in natural language
Integrity Analysis
Detect orphan records, broken references, and data inconsistencies across your PostgreSQL database.
Performance Insights
Analyze table sizes, index usage, query patterns, and get AI-powered optimization recommendations.
Safe by Design
Read-only mode by default. Write operations require explicit activation and user authorization.
AI-Powered Database Health Check
Referential integrity analysis
Orphan record detection
Data corruption pattern identification
Table and index size statistics
Mini BI-style reports on system data
Safe SQL Queries via AI Chat
Direct SQL queries for diagnostics
Query performance analysis
AI-generated optimization suggestions
Index usage and bloat detection
Results formatted in readable tables
Read-Only First, Write Only When Needed
Read-only analysis by default
Write mode requires explicit activation
User-level authorization control
Guided data repair with confirmation
Central control from Settings panel
Plugin Tools
Advanced database capabilities added by this plugin
| Tool | Description |
|---|---|
db_analyze_integrity |
Check referential integrity and detect orphan records |
db_execute_query |
Run safe SQL queries for diagnostics and reporting |
db_table_stats |
Get table sizes, row counts, and index statistics |
db_performance_check |
Analyze query performance and suggest optimizations |
db_repair_guided |
Guided data repair with user confirmation (write mode) |
Real-World Use Cases
Ask in natural language, get database answers
"Are there orphan invoice lines?"
AI runs integrity check and reports broken references with record IDs.
"Which tables are the largest?"
Returns sorted table sizes with index usage and bloat indicators.
"Show me slow queries this week"
Analyzes pg_stat_statements and highlights optimization opportunities.
"Clean up orphan attachments"
Guided repair with preview and confirmation before any data change.
Technical Specifications
Requirements
Depends on: odoo_nova_ai_assistant
Odoo: 19.0
Editions: Community & Enterprise
License: OPL-1
Safety
Default mode: Read-only analysis
Write mode: Requires explicit activation
Database: PostgreSQL native
Repair: Guided with confirmation
Need Help?
We provide professional support for all our modules.
support@orionyx.dev odoo.orionyx.dev
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module