Skip to content
View BIC-QA's full-sized avatar

Block or report BIC-QA

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 250 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
BIC-QA/README.md

BIC-QA Intelligent Q&A Assistant

🌐 Language Selection / 语言选择

中文版 English Version

📖 Product Introduction

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.

🎯 Core Positioning

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.

🗄️ Database 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.

🚀 Technical Advantages

  • 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
BIC-QA Logo

A powerful browser extension providing intelligent Q&A and knowledge base retrieval services

Chrome Web Store Edge Add-ons Version License

🚀 Download Now

Download

Version: v1.0.6 | Size: ~15MB | Updated: August 2025

📋 Table of Contents

🚀 Quick Start

📦 Install Extension

  1. Download extension files to local machine
  2. Open browser extension management page
  3. Enable developer mode
  4. Click "Load unpacked extension"
  5. Select extension folder

⚡ Four-Step Configuration

Step 1: User Registration

User Registration Interface

  1. Open extension settings page
  2. Fill in username, company name, and email address
  3. Click Save button
  4. 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.

Step 2: Knowledge Base Service Configuration

Knowledge Base Configuration

  1. Enter knowledge base service configuration page
  2. Fill in the API Key from email into corresponding fields
  3. Click Save to complete configuration

Step 3: AI Model Configuration

3.1 Configure Service Provider Interface

Model Service Provider Configuration

  1. Open SettingsModels & Service Providers
  2. Add service providers (such as ollama, deepseek, etc.)
  3. Fill in corresponding API Address and API Key (if required)

Local Ollama Configuration Example:

API Address: http://localhost:11434/v1
  1. Click Test to connect, system automatically discovers available models
  2. Check desired models, click Batch Management to save

Model Management Interface

💡 Tip: Homepage dropdown menu displays Model Name (Service Provider) format to avoid confusion with same-name models.

3.2 Manual Model Configuration

Model Configuration Interface

For service providers that don't support auto-discovery:

  1. Click Add Model
  2. Fill in model name, token limit, temperature, and other parameters
  3. Click Save to complete configuration

Model Parameter Settings

Step 4: Start Using

  1. Select configured Model (Service Provider) on homepage
  2. Choose target knowledge base from Knowledge Base dropdown menu
  3. Input question, click Send or press Enter
  4. Enjoy intelligent Q&A experience!

💡 Usage Tip: When knowledge base is enabled, system automatically loads latest configuration and prioritizes knowledge base services.

⚙️ Configuration Guide

🔧 Parameter Rule Settings

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.

🛠️ Troubleshooting

❗ Common Issues

1. Extension Import Failure

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:

Import File Hierarchy

2. Request Failure

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 *

3. Model Loading Failure

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

4. Knowledge Base Connection Failure

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

🔍 Debug Steps

  1. Reload Extension

    • Open extension management page
    • Click reload button
  2. Clear Cache

    • Clear browser cache and cookies
    • Restart browser
  3. Check Console

    • Press F12 to open developer tools
    • View Console error messages
  4. Verify Configuration

    • Check configuration file format
    • Confirm all required fields

📱 System Requirements

🌐 Browser Support

  • Chrome 88+
  • Edge 88+
  • Other Chromium-based browsers

🌍 Network Requirements

  • Support HTTPS/HTTP requests
  • Stable network connection
  • Firewall allows extension access

🔒 Privacy & Security

🛡️ Data Protection

  • Local Storage: Conversation history stored locally
  • Encrypted Transmission: All network requests use HTTPS
  • Permission Control: Minimized permission requirements

🔐 Security Features

  • Local Models: Support complete local deployment
  • API Keys: Secure storage and transmission
  • Access Control: Configurable network access permissions

📋 Privacy Policy

  • No collection of personal sensitive information
  • No data sharing with third parties
  • Support data export and deletion

📞 Technical Support

🆘 Get Help

  • Community: Join BIC-QA discussion group

  • Feedback: Submit issue feedback

📧 Contact Information

- **GitHub**: [Submit Issue](https://github.com/BIC-QA/BIC-QA/issues)

🔄 Update Log

  • 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

⭐ Give us a star | 📖 Documentation | 🐛 Report Issues

Pinned Loading

  1. awesome-python-cn awesome-python-cn Public

    Forked from tingtinglu/awesome-python-cn

    Python资源大全中文版,内容包括:Web框架、网络爬虫、网络内容提取、模板引擎、数据库、数据可视化、图片处理、文本处理、自然语言处理、机器学习、日志、代码分析等

  2. CrazyMonitor CrazyMonitor Public

    Forked from triaquae/CrazyMonitor

    用python写的分布式监控软件

    JavaScript

  3. logzero logzero Public

    Forked from qiangleizang/logzero

    Robust and effective logging for Python 2 and 3.

    Python

  4. MxOnline MxOnline Public

    Forked from derek-zhang123/MxOnline

    在线教育平台

    Python

  5. python-tail python-tail Public

    Forked from kasun/python-tail

    Unix tail follow implementation in python

    Python

  6. Yearning Yearning Public

    Forked from cookieY/Yearning

    Mysql web端sql审核平台

    Vue