| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 5685 |
| Technical Name |
chatbot_llm_integration |
| License | OPL-1 |
| Website | https://github.com/yoshin4g4 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 5685 |
| Technical Name |
chatbot_llm_integration |
| License | OPL-1 |
| Website | https://github.com/yoshin4g4 |
Chatbot LLM Integration
AI-Powered Assistant with Multi-LLM Support & Database Intelligence
Transform Your Odoo into an Intelligent AI Assistant
Integrate with leading LLM providers and enable natural language database queries. Built with LiteLLM and LangChain for enterprise-grade AI conversations.
Supported AI Providers
Choose from the world's leading AI providers or host your own models locally
OpenAI
GPT-4, GPT-4 Turbo, and GPT-3.5 models with function calling support.
Anthropic
Claude 3 Opus, Sonnet, and Haiku with advanced reasoning capabilities.
Gemini Pro and Gemini Pro Vision for text and multimodal understanding.
DeepSeek
DeepSeek Chat and DeepSeek Coder optimized for technical tasks.
Ollama
Local/self-hosted models: Llama, Mistral, CodeLlama for complete privacy.
Odoo AI
Native Odoo AI with custom ReAct Agent and advanced tool support.
Everything You Need for Enterprise AI
Floating Chat Widget
Always-accessible AI assistant integrated directly into Odoo. Chat from anywhere in the system with SSE streaming.
Multi-Provider Support
Unified API using LiteLLM for seamless switching. No vendor lock-in - choose the best model for each task.
Database Intelligence
Query external databases using natural language. PostgreSQL, MySQL, and SQL Server support.
Agent-Based Architecture
Configure multiple specialized AI agents with different system prompts and capabilities for various use cases.
Enterprise Security
Role-based access control, SQL injection prevention, multi-company support. Security-first architecture.
Conversation Management
Complete chat history tracking with token usage monitoring. Analyze costs and optimize AI usage.
See It In Action
Professional interface designed for enterprise workflows
Intuitive Menu Structure
LLM Provider Configuration
Easy setup for any LLM provider with API key management and model selection
Database Connection Setup
Connect to PostgreSQL, MySQL, or SQL Server for natural language queries
AI Agent Configuration
Create specialized agents with custom system prompts and database access
Floating Chat Widget
Beautiful chat interface with streaming responses and conversation history
6 Powerful Database Tools
Turn your AI into a data analyst with natural language SQL queries
query_database
Execute SELECT queries safely with automatic SQL injection prevention and result limits. Transform natural language into precise database queries.
get_table_schema
Explore table structures including columns, data types, primary keys, and indexes. Understand your database schema effortlessly.
get_table_sample
Preview sample rows from any table to understand data patterns and content before writing complex queries.
search_tables
Find tables by name pattern to quickly locate relevant data sources. Perfect for large databases with hundreds of tables.
get_relationships
Discover foreign key relationships between tables for comprehensive data analysis. Understand data dependencies automatically.
list_all_tables
Get complete database inventory with all available tables and views. Perfect starting point for data exploration.
Real-World Use Cases
Transform your operations with AI-powered assistance
Customer Support
Create an AI-powered support chatbot with access to your product database. Answer customer questions instantly with accurate product information.
Code Assistant
Help developers with code generation, debugging, and documentation. Use models like DeepSeek Coder or GPT-4 for technical assistance.
Business Intelligence
Transform natural language questions into SQL queries. Let non-technical users query databases and generate reports.
Documentation Q&A
Build a knowledge base assistant that answers questions about your internal documentation, policies, and procedures.
Built on Industry-Leading Technology
LiteLLM Powered
Standardized API calls to cloud and self-hosted providers. Switch providers without changing code. No vendor lock-in.
LangChain Integration
Custom ReAct Agent implementation with tool support. Advanced reasoning and iterative problem solving.
SSE Streaming
Server-Sent Events for real-time streaming responses. See AI responses appear as they're generated.
Enterprise-Grade Security
Role-Based Access Control
Granular permissions with User and Manager security groups. Control who can access which AI agents and features.
SQL Injection Prevention
Multi-layer protection: query validation, dangerous keyword blocking. Only READ-ONLY SELECT queries allowed.
Conversation Privacy
Users can only access their own conversations. Record rules ensure complete data isolation per user.
Multi-Company Support
Full support for multi-company environments. Each company can have its own AI agents and configurations.
Easy Installation
Get started in 5 simple steps
Install Python Dependencies
pip install litellm langchain langchain-core requests cryptography psycopg2-binary
Configure LLM Provider
Add your LLM provider with API key and endpoint in Chatbot LLM > Configuration > Providers
Create AI Agent
Create your first agent with custom system prompt in Chatbot LLM > Agents
Enable Database Access (Optional)
Create database connection and enable database access on your agent for SQL queries
Start Chatting!
Open the floating chat widget and start conversing with your AI assistant
Need Help or Have Questions?
Professional support and customization services available
ð§ Email: 1rw4n.5y4h1919@gmail.com
ð» GitHub: yoshin4g4
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