BIC-QA (Business Intelligence & Knowledge Query Assistant) is an intelligent Q&A system specifically designed for enterprise-level database knowledge management. As a next-generation database knowledge retrieval solution, BIC-QA is committed to providing efficient and accurate knowledge query services for database administrators, developers, and operations engineers.
BIC-QA is a comprehensive database knowledge Q&A platform that supports all mainstream database systems, with deep optimization specifically for domestic database ecosystems. The system integrates rich database knowledge bases covering SQL syntax, performance optimization, troubleshooting, best practices, and comprehensive content, providing users with instant professional database technical support.
- International Mainstream Databases: Oracle, MySQL, PostgreSQL, SQL Server, MongoDB, Redis, etc.
- Domestic Database Priority Support: DM Database (DM), KingBase, OceanBase, GoldenDB, Huawei GaussDB, Tencent TDSQL, etc.
- Cloud-Native Databases: Alibaba Cloud PolarDB, Tencent Cloud TDSQL-C, Huawei Cloud GaussDB, etc.
- Intelligent Semantic Understanding: Based on advanced NLP technology for accurate user query intent understanding
- Knowledge Graph Construction: Builds complete database knowledge association networks for contextually relevant answers
- Real-time Knowledge Updates: Continuously updates database version features and best practices
- Multi-dimensional Retrieval: Supports precise retrieval by database type, problem type, technical domain, and other dimensions
- 🚀 Quick Start
- ⚙️ Configuration Guide
- 🎯 Usage Instructions
- 🔧 Advanced Features
- 🛠️ Troubleshooting
- 📱 System Requirements
- 🔒 Privacy & Security
- 📞 Technical Support
- Download extension files to local machine
- Open browser extension management page
- Enable developer mode
- Click "Load unpacked extension"
- Select extension folder
- Open extension settings page
- Fill in username, company name, and email address
- Click Save button
- Check email for API Key
⚠️ Important Reminder: Do not modify the default URL arbitrarily to avoid affecting plugin operation. If already modified, please reset settings to restore default values.
- Enter knowledge base service configuration page
- Fill in the API Key from email into corresponding fields
- Click Save to complete configuration
- Open Settings → Models & Service Providers
- Add service providers (such as
ollama
,deepseek
, etc.) - Fill in corresponding API Address and API Key (if required)
Local Ollama Configuration Example:
API Address: http://localhost:11434/v1
- Click Test to connect, system automatically discovers available models
- Check desired models, click Batch Management to save
💡 Tip: Homepage dropdown menu displays Model Name (Service Provider) format to avoid confusion with same-name models.
For service providers that don't support auto-discovery:
- Click Add Model
- Fill in model name, token limit, temperature, and other parameters
- Click Save to complete configuration
- Select configured Model (Service Provider) on homepage
- Choose target knowledge base from Knowledge Base dropdown menu
- Input question, click Send or press Enter
- Enjoy intelligent Q&A experience!
💡 Usage Tip: When knowledge base is enabled, system automatically loads latest configuration and prioritizes knowledge base services.
BIC-QA supports custom prompts and retrieval parameters with three preset modes:
Mode | Temperature | Similarity | Use Case |
---|---|---|---|
Creative Mode | High | Medium | Requires creative responses |
Precise Mode | Low | High | Requires accuracy priority |
Custom Mode | Adjustable | Adjustable | Fully customizable needs |
Configurable Parameters:
- Prompt: System instruction template
- Temperature: Controls response randomness
- Similarity: Knowledge base retrieval threshold
- TopN: Number of retrieval results
⚠️ Parameter Impact: Higher temperature increases creativity, similarity/TopN affects knowledge base retrieval scope and quantity.
Possible Causes:
- File corruption during extraction
- Browser didn't select the innermost folder when choosing plugin
Solutions:
- Selected folder should contain manifest.json as shown below:
Possible Causes:
- Incorrect model service address
- Network connection issues
- Invalid API Key
- Local model permissions not granted
Solutions:
# Check service address
curl http://localhost:11434/v1/models
# Verify network connection
ping your-api-endpoint.com
# Configure local environment variables
Set system variable OLLAMA_ORIGINS to *
Possible Causes:
- Ollama service not started
- Incorrect API address format
- Model not properly deployed
Solutions:
# Start Ollama service
ollama serve
# Check model list
ollama list
Possible Causes:
- Incorrect knowledge base service URL
- Expired or invalid API Key
- Network permission restrictions
Solutions:
- Check knowledge base service status
- Re-obtain API Key
- Verify network access permissions
-
Reload Extension
- Open extension management page
- Click reload button
-
Clear Cache
- Clear browser cache and cookies
- Restart browser
-
Check Console
- Press F12 to open developer tools
- View Console error messages
-
Verify Configuration
- Check configuration file format
- Confirm all required fields
- Chrome 88+
- Edge 88+
- Other Chromium-based browsers
- Support HTTPS/HTTP requests
- Stable network connection
- Firewall allows extension access
- Local Storage: Conversation history stored locally
- Encrypted Transmission: All network requests use HTTPS
- Permission Control: Minimized permission requirements
- Local Models: Support complete local deployment
- API Keys: Secure storage and transmission
- Access Control: Configurable network access permissions
- No collection of personal sensitive information
- No data sharing with third parties
- Support data export and deletion
- Community: Join BIC-QA discussion group
- Feedback: Submit issue feedback
- Support Email: support@dbaiops.com
- DBAIOps Community:
- v1.0.6: Support for adding large model service providers, fixed known issues
- v1.0.5: Performance optimization, fixed known issues
- v1.0.4: Added knowledge base functionality
- v1.0.3: Support for local Ollama models
BIC-QA Intelligent Q&A Assistant - Making knowledge retrieval smarter, making Q&A more efficient
Version: v1.0.6 | Update Date: August 2025