#!/usr/bin/env python3 # -*- coding: utf-8 -*- """ 更新英文问答数据库 - 基于新业务：Enterprise Private AI Agent Development 完整录入27条英文问答 """ import sqlite3 def update_english_qa(): """更新英文问答数据库为新的业务内容""" conn = sqlite3.connect('/root/老业务网站8.30/ai_agent_qa.db') cursor = conn.cursor() # 确保表结构存在 cursor.execute(''' CREATE TABLE IF NOT EXISTS qa_pairs ( id INTEGER PRIMARY KEY AUTOINCREMENT, question TEXT NOT NULL, answer TEXT NOT NULL, category TEXT NOT NULL, keywords TEXT, language TEXT DEFAULT 'en', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ''') # 创建索引 cursor.execute('CREATE INDEX IF NOT EXISTS idx_category ON qa_pairs(category)') cursor.execute('CREATE INDEX IF NOT EXISTS idx_language ON qa_pairs(language)') cursor.execute('CREATE INDEX IF NOT EXISTS idx_keywords ON qa_pairs(keywords)') conn.commit() print("Database table structure created") # 清空现有英文数据 cursor.execute("DELETE FROM qa_pairs WHERE language='en'") print("Cleared old English Q&A data") # English Q&A data - 27 items english_qa_data = [ # 1. Company Introduction (3 items) { "question": "What does your company do?", "answer": "We focus on enterprise private AI agent development, transforming enterprise productivity with AI. We provide three core products: Sales/Customer Service Copilot, Business Data Analysis Agent, and Content Generation & Auto-Publish Agent, helping enterprises improve business efficiency from customer communication to business decisions, from content creation to performance analysis.", "category": "Company Introduction", "keywords": "company,business,AI agent,development,productivity" }, { "question": "What are your advantages?", "answer": "Our core advantages include: 1) Technical team with over 15 years of enterprise management and AI application development experience; 2) All services are personalized and matched according to the enterprise's own business needs; 3) From development to follow-up services, we accompany customers throughout the entire cycle, providing worry-free service.", "category": "Company Introduction", "keywords": "advantage,technical team,customization,service,experience" }, { "question": "Who are your target customers?", "answer": "Our target customers are enterprises that need to improve sales efficiency, optimize business decisions, and enhance content marketing capabilities through AI agents, especially those hoping to achieve business automation, improve decision-making science, and enhance brand influence.", "category": "Company Introduction", "keywords": "target,customers,enterprise,AI agent,sales,decision,content marketing" }, # 2. Core Products (4 items) { "question": "What are the specific features of Sales/Customer Service Copilot?", "answer": "Sales/Customer Service Copilot is an intelligent sales and customer service assistant with main functions including: 1) Intelligent sales assistant, real-time support for sales teams to follow up with customers and close deals; 2) 24/7 online customer service, automatically identify customer intent and provide precise responses; 3) Multi-turn conversation management, understand context, provide personalized service recommendations; 4) Customer needs analysis, automatic handoff to human service, improve conversion efficiency. Applicable to online sales consultation, customer service ticket processing, customer relationship maintenance, pre-sales and post-sales support scenarios.", "category": "Core Products", "keywords": "sales,customer service,Copilot,intelligent,24/7,conversion" }, { "question": "What can Business Data Analysis Agent do?", "answer": "Business Data Analysis Agent is an intelligent business data analysis and decision support system with main functions including: 1) Multi-source data integration, automatically collect and clean business data; 2) Intelligent data analysis, identify trends, anomalies and business insights; 3) Visual dashboard, real-time monitoring of core business indicators; 4) Predictive analysis, help enterprises make strategic decisions in advance. Applicable to sales data analysis, customer behavior insights, inventory management optimization, financial forecasting analysis, operational efficiency improvement scenarios.", "category": "Core Products", "keywords": "business,analysis,Agent,data,decision,visualization,prediction" }, { "question": "What are the features of Content Generation & Auto-Publish Agent?", "answer": "Content Generation & Auto-Publish Agent is an AI content creation and marketing automation system with main functions including: 1) AI content creation, automatically generate high-quality copywriting, articles and marketing materials; 2) Multi-platform synchronous publishing, one-click distribution to websites, social media and email; 3) SEO optimization configuration, automatically optimize keywords and metadata; 4) Content schedule management, automatically publish on schedule, maintain brand activity. Applicable to blog article creation, social media operations, product promotional materials, SEO content marketing, brand content planning scenarios.", "category": "Core Products", "keywords": "content,generation,Agent,AI,SEO,publish,marketing automation" }, { "question": "How do AI agents enhance enterprise productivity?", "answer": "AI agents serve as the second productive force of enterprises, improving efficiency in the following ways: 1) Sales agent: Automatically follow up with customers, generate sales scripts and daily reports, allowing sales teams to focus on high-value customers; 2) Business analysis agent: Monitor business indicators in real-time, generate analysis reports and early warnings, enabling rapid management decisions; 3) Content generation agent: Automatically produce high-quality content and publish across multiple channels, allowing content teams to focus on core topic planning. Through AI automation, enterprises can achieve 24-hour uninterrupted service and decision support.", "category": "Core Products", "keywords": "AI agent,productivity,sales,business analysis,content generation,automation" }, # 3. Success Cases (6 items) { "question": "Do you have success cases of e-commerce sales agents?", "answer": "Yes. A large e-commerce platform handling tens of thousands of customer inquiries daily achieved significant results after deploying sales and customer service agents: Customer response time reduced by 80%, manual customer service workload reduced by 60%, customer satisfaction increased to 95%, and conversion rate improved by 35%. Core value lies in 24/7 intelligent customer service, automatic generation of customer follow-up daily reports, and real-time updates of intelligent script library, allowing sales teams to focus on high-value customers.", "category": "Success Cases", "keywords": "e-commerce,sales agent,customer service,conversion rate,case study" }, { "question": "What are the results of real estate business analysis agents?", "answer": "A nationwide real estate company achieved the following after applying business analysis agents: Real-time monitoring of 500+ project indicators, automatic daily generation of business reports and early warning reports, management decision response speed improved by 70%, risk early detection rate improved by 85%. Core value is automated data analysis replacing manual statistics, intelligent early warning of abnormal indicators, real-time monitoring of core KPIs, enabling management to grasp business status at the first time.", "category": "Success Cases", "keywords": "real estate,business analysis,Agent,monitoring,early warning,decision" }, { "question": "What are the results of news media content generation agent case studies?", "answer": "A professional financial media outlet achieved the following after applying content generation agents: Automatically produces 50+ high-quality financial articles daily, content automatically published to 8 platforms including websites, APP, WeChat official account, content production increased by 300%, user activity increased by 150%. Core value is AI automatically writing news, in-depth analysis, and industry reports, multi-platform synchronous publishing, maintaining brand activity, allowing content teams to focus on core topic planning.", "category": "Success Cases", "keywords": "news media,content generation,Agent,articles,platforms,activity" }, { "question": "How about automotive dealer sales agent case studies?", "answer": "A chain automotive dealer achieved the following after applying sales agents: Unified management of customer follow-up across 15 stores, automatic generation of daily sales reports and customer analysis, sales conversion rate improved by 42%, customer follow-up timeliness increased by 90%. Core value is intelligent customer follow-up system, automatic generation of sales scripts and follow-up reports, standardized sales process, making frontline sales more professional and efficient.", "category": "Success Cases", "keywords": "automotive,dealer,sales agent,conversion rate,follow-up,stores" }, { "question": "What are the results of manufacturing business analysis agent cases?", "answer": "A large manufacturing enterprise achieved the following after applying business analysis agents: Real-time collection of data from ERP, MES and other systems, daily generation of comprehensive business analysis reports and anomaly warnings, management decision speed improved by 65%, inventory turnover efficiency improved by 30%. Core value is multi-source data automatic integration, intelligent analysis of business trends and abnormal indicators, visual dashboard real-time monitoring, making business decisions more data-driven and scientific.", "category": "Success Cases", "keywords": "manufacturing,business analysis,Agent,ERP,MES,decision" }, { "question": "How about tech company content marketing agent cases?", "answer": "A SaaS tech company achieved the following after applying content generation agents: Automatically produces 30 technical articles and product copy weekly, synchronously publishes to 10 channels including official website, technical communities, social platforms, SEO ranking improved by 250%, official website traffic increased by 180%. Core value is AI automatically writing product introductions, technical tutorials, customer cases and other marketing content, SEO optimization of keyword layout, multi-platform synchronous publishing, maintaining continuous brand voice.", "category": "Success Cases", "keywords": "tech company,content marketing,Agent,SaaS,SEO,traffic" }, # 4. Technical Implementation (5 items) { "question": "What is the technical architecture of AI agents?", "answer": "We adopt advanced AI technical architecture: 1) Natural language processing technology to understand user intent and provide precise responses; 2) Machine learning algorithms to continuously optimize agent performance; 3) Knowledge graph construction to integrate enterprise knowledge base; 4) Multi-modal AI capabilities, supporting text, voice and other interaction methods; 5) Private deployment to ensure data security.", "category": "Technical Implementation", "keywords": "AI agent,technical architecture,NLP,machine learning,knowledge graph,private" }, { "question": "How do agents understand enterprise business?", "answer": "We enable agents to understand enterprise business through: 1) In-depth business research to understand enterprise business processes and pain points; 2) Knowledge base construction to organize enterprise products, services, cases and other knowledge; 3) Model fine-tuning to customize AI models based on enterprise data; 4) Continuous learning to continuously optimize based on actual usage; 5) Manual review to ensure content accuracy and professionalism.", "category": "Technical Implementation", "keywords": "agent,business understanding,knowledge base,fine-tuning,learning" }, { "question": "How do you ensure AI agent data security?", "answer": "We adopt multi-layered security protection measures: 1) Private deployment with all data running on enterprise internal servers; 2) HTTPS encrypted transmission to protect data transmission security; 3) Access control to strictly control data access permissions; 4) Data desensitization to protect sensitive information; 5) Regular security audits to detect and fix security vulnerabilities in time.", "category": "Technical Implementation", "keywords": "AI agent,data security,private,encryption,permissions,audit" }, { "question": "How do AI agents integrate with existing systems?", "answer": "We provide flexible integration solutions: 1) API interface integration through RESTful API to connect with existing systems; 2) Database integration to directly access enterprise databases for data; 3) Third-party system integration supporting CRM, ERP, ticketing systems, etc.; 4) Webhook callbacks to achieve real-time data synchronization; 5) Customized development to develop dedicated interfaces according to specific needs.", "category": "Technical Implementation", "keywords": "AI agent,system integration,API,database,CRM,ERP" }, { "question": "What are the deployment options for agents?", "answer": "We support multiple deployment methods: 1) Private deployment on enterprise self-built servers; 2) Cloud deployment using public or private clouds; 3) Hybrid deployment with some functions deployed locally and some running in the cloud; 4) Containerized deployment using Docker and other container technologies; 5) Edge deployment running lightweight agents on edge devices.", "category": "Technical Implementation", "keywords": "agent,deployment,private,cloud,containerized,edge" }, # 5. Service Quality (4 items) { "question": "How long does project implementation take?", "answer": "Project implementation period depends on project complexity: 1) Basic agent deployment: 2-3 weeks; 2) Customized development: 4-8 weeks; 3) Complex business scenarios: 8-12 weeks. We will develop detailed project plans and schedules according to specific needs.", "category": "Service Quality", "keywords": "project,period,deployment,development,plan" }, { "question": "What are your service prices?", "answer": "Our service prices are customized according to project scale and needs, providing flexible pricing plans: 1) Charging by number of agents; 2) Charging by functional modules; 3) Charging by API call count; 4) Annual/monthly service packages. Please contact us through the website form for specific prices, we will provide detailed quotation plans according to your specific needs.", "category": "Service Quality", "keywords": "service,price,charge,package,quotation" }, { "question": "Do you provide after-sales service?", "answer": "We provide comprehensive after-sales service including: 1) Technical maintenance with 7×24 hour technical support; 2) Content updates to regularly update knowledge base and AI models; 3) Function upgrades to continuously optimize and add new features; 4) Training services providing user training and technical training; 5) Problem resolution to quickly respond to and resolve usage issues.", "category": "Service Quality", "keywords": "after-sales,service,maintenance,update,upgrade,training" }, { "question": "Do you provide training and documentation?", "answer": "Yes, we provide comprehensive training and support: 1) User training to help users get started quickly; 2) Technical training to deeply explain system principles and maintenance methods; 3) Detailed documentation including user manuals, technical documents, API documents; 4) Video tutorials recording operation videos for easy learning; 5) Online support providing online customer service and technical support.", "category": "Service Quality", "keywords": "training,documentation,manual,video,online support" }, # 6. Application Scenarios (3 items) { "question": "Which industries are suitable for using sales agents?", "answer": "Sales agents are suitable for the following industries: 1) E-commerce retail to handle large volumes of customer inquiries; 2) Automotive dealers to uniformly manage customer follow-up; 3) Real estate sales to assist sales teams in closing deals; 4) Finance and insurance to provide professional consulting services; 5) Education and training to answer course inquiries.", "category": "Application Scenarios", "keywords": "sales agent,industries,e-commerce,automotive,real estate,finance" }, { "question": "Which industries are suitable for using business analysis agents?", "answer": "Business analysis agents are suitable for the following industries: 1) Manufacturing enterprises to monitor production, inventory, cost and other indicators; 2) Retail chains to analyze sales data and customer behavior; 3) Real estate development to monitor project progress and payment collection; 4) Catering services to analyze revenue and customer preferences; 5) Logistics and transportation to optimize operational efficiency.", "category": "Application Scenarios", "keywords": "business analysis,industries,manufacturing,retail,real estate,catering" }, { "question": "Which industries are suitable for using content generation agents?", "answer": "Content generation agents are suitable for the following industries: 1) Media and publishing to quickly produce high-quality content; 2) Tech companies to continuously output technical articles; 3) Brand enterprises to maintain brand content dissemination; 4) E-commerce platforms to generate product introductions and marketing copy; 5) Education and training to create course content.", "category": "Application Scenarios", "keywords": "content generation,industries,media,tech, brand,e-commerce" }, # 7. Contact Information (1 item) { "question": "How can I contact you?", "answer": "You can contact us through the following methods: 1) Website contact form to fill in consultation forms; 2) Phone: +86 13720083062; 3) Email: qikaka625@gmail.com; 4) Social media: LINE @lw625, Telegram @sq625, WhatsApp +66 889691368; 5) AI chat window on the right side of the website for 24-hour online consultation.", "category": "Contact Information", "keywords": "contact,phone,email,social,consultation" }, # 8. Multi-language Support (1 item) { "question": "Which language versions are supported?", "answer": "We support all languages that large models can translate. Currently, the website provides four common language versions: Chinese, English, Thai, and Vietnamese, and can automatically redirect to the corresponding version based on user's browser language. For other languages, AI agents can perform real-time translation to provide localized service experience for customers in different regions.", "category": "Multi-language Support", "keywords": "language,multi-language,translation,AI agent,localized" } ] # Insert data for qa in english_qa_data: cursor.execute(''' INSERT INTO qa_pairs (question, answer, category, keywords, language) VALUES (?, ?, ?, ?, 'en') ''', (qa['question'], qa['answer'], qa['category'], qa['keywords'])) conn.commit() print(f"Successfully inserted {len(english_qa_data)} English Q&A items") # Verify data cursor.execute("SELECT COUNT(*) FROM qa_pairs WHERE language='en'") count = cursor.fetchone()[0] print(f"Database contains {count} English Q&A items") conn.close() print("Update completed!") if __name__ == '__main__': update_english_qa()