AI Database Analyzer - DBA Tools & PostgreSQL Diagnostics | NovaAi
by Orionyx https://odoo.orionyx.dev$ 200.38
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Community Apps Dependencies | Show |
| Lines of code | 9992 |
| Technical Name |
odoo_nova_ai_plugin_db_analyzer |
| License | OPL-1 |
| Website | https://odoo.orionyx.dev |
| Versions | 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Community Apps Dependencies | Show |
| Lines of code | 9992 |
| Technical Name |
odoo_nova_ai_plugin_db_analyzer |
| License | OPL-1 |
| Website | https://odoo.orionyx.dev |
| Versions | 19.0 |
OdooNovaAi — Complete AI Suite for Odoo 19
AI Assistant + Database Analysis + Smart Actions — All in one package
A professional AI assistant integrated directly into Odoo with chat, module analysis, database diagnostics, record creation/updates with audit trail, voice transcription, visual themes and file attachments.
Everything Included
One purchase, full AI power for your ERP
AI Assistant Chat
Floating bubble + fullscreen app. Conversation history per user, multi-model selector, 8+ built-in Odoo tools, voice transcription (Whisper) and file/image attachments.
Database Analysis Plugin
Intelligent DBA: integrity checks, orphan detection, performance diagnostics, table statistics, safe read-only queries, and controlled data repairs with dry-run preview.
Actions Plugin
AI can create and update Odoo records with full governance: user/model/field allowlists, quotas, mandatory confirmation, and a complete audit trail with automatic cleanup.
AI Assistant — Core Features
Floating bubble chat — available on every screen, always one click away.
Fullscreen chat app — dedicated view in the Odoo main menu.
8+ built-in tools — search records, read data, analyze modules, diagnose issues, describe models.
Voice transcription — Whisper API integration for audio input.
File attachments — upload images and files for context-aware analysis.
6 visual themes — Classic Gold, Sunset Pro, Ocean Breeze, Emerald Forest, Midnight Neon, Rose Minimal.
5 languages — English, Spanish, French, German, Portuguese.
Multi-provider — OpenRouter, OpenAI, Anthropic, DeepSeek, or any OpenAI-compatible endpoint.
Database Analysis — DBA Intelligence
9 specialized tools for deep PostgreSQL analysis
Integrity checks — detect broken foreign keys, orphan records and desynchronized sequences.
Performance diagnostics — slow queries, active locks, cache hit ratios, sequential scans.
Table statistics — sizes, bloat, unused indexes, largest tables.
Safe read-only queries — AI can execute SELECT statements with dangerous query blocking.
Controlled repairs — UPDATE/DELETE/INSERT with dry-run preview and role-based authorization.
VACUUM optimization — table maintenance directly from chat.
Actions Plugin — Governed AI Operations
Create and update records with full control and traceability
User allowlisting — restrict who can execute AI-driven operations.
Model & field restrictions — control exactly which models and fields AI can modify.
Hourly/daily quotas — limit operations per user to prevent abuse.
Mandatory confirmation — dry-run preview with token-based approval before execution.
Audit trail — complete log of create/write operations with before/after values.
Automatic cleanup — scheduled CRON removes old audit logs and expired tokens.
Quick Setup
Ready in minutes from Settings
1. Install
Install the base module.
Plugins install automatically as dependencies.
2. Configure
Go to Settings → AI Assistant.
Set your provider, API key, and model.
3. Use
Click the floating bubble or open
the fullscreen app. Start chatting.
Compatible LLM Providers
OpenRouter (recommended — access 200+ models) • OpenAI (GPT-4o, o1) • Anthropic (Claude Sonnet, Opus) • DeepSeek (DeepSeek Chat) • Custom (any OpenAI-compatible endpoint, including local LLMs)
Support & Updates
Includes installation/configuration guide and support for reproducible issues. Active development with continuous improvements to governance, observability, and AI capabilities.
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