Help & Documentation

Complete guide to using DB Chat AI

📚 Overview

DB Chat AI is an intelligent assistant for WordPress/WooCommerce stores. It analyzes your store data using AI and provides insights, answers questions, and helps you make data-driven decisions.

🤖 Natural Language

Ask questions in plain English and get intelligent responses

📊 Real-time Analytics

Visual dashboards with charts and insights

🔧 Direct Tools

Access database tools without AI assistance

👥 Multi-user

Role-based access for users and admins

💬 Chat Interface

Location: /chat

Natural Language Queries

Ask questions about your store data in plain English:

"What are my top 10 selling products this month?"
"Show me revenue trends for the last 90 days"
"Which customers spent the most last year?"
"Are there any products that haven't sold?"

Three-Stage Processing

  1. 1
    Plan Creation: AI analyzes your question and creates a step-by-step plan
  2. 2
    Execution: Executes database queries using appropriate tools
  3. 3
    Response: Generates comprehensive answer with insights

Key Features

  • ✓Plan Approval Mode: Review and approve AI plans before execution
  • ✓Auto Execute Mode: AI executes plans automatically
  • ✓questions: Pre-configured questions for one-click access
  • ✓Response Actions: Copy, provide feedback (👍👎), export data, view SQL
  • ✓Model Selection: Choose between different AI models
  • ✓Chat History: All conversations saved and searchable

📊 Analytics Dashboard

Location: /analytics

Visual analytics and insights about your WooCommerce store.

💰 Revenue Analytics

  • • Daily, weekly, monthly trends
  • • Revenue by category
  • • Revenue by coupon
  • • Time period comparisons

📦 Order Analytics

  • • Order count trends
  • • Status breakdown
  • • Average order value
  • • Distribution by time

🛍️ Product Analytics

  • • Top-selling products
  • • Performance over time
  • • Variants analysis
  • • Inventory alerts

👥 Customer Analytics

  • • Top customers by spend
  • • Acquisition trends
  • • Lifetime value
  • • Repeat purchase rate

Interactive Features

  • →Zoom and pan on charts
  • →Filter by custom date ranges
  • →Export charts as images
  • →Responsive design for mobile

🔧 Tools Tester

Location: /app/tools

Direct access to database tools without AI assistance.

Available Tools

🛍️ Products Tools

Search products, get variants, find product IDs

📦 Orders Tools

Query order statuses, date ranges, order counts

🏷️ Coupons Tools

Coupon revenue analysis, usage trends, all coupons

🔧 Utils Tools

Database inspection, fuzzy matching, table information

✨ Test All Tools (New!)

One-click comprehensive testing of all tools:

  • ✓Validates all tool methods work correctly
  • ✓Shows pass/fail status for each tool and example
  • ✓Reports total tools, examples, and success rates
  • ✓Detects empty results with warnings
  • ✓Click on data counts to view actual response data

⚙️ Settings

Location: /settings

Configuration Options

🔌 API Connection

  • • Configure WordPress site URL
  • • Set WooCommerce API credentials
  • • Test connection before saving
  • • Secure encrypted storage

🤖 Model Preferences

  • • Select default AI model
  • • Configure temperature & tokens
  • • Cost optimization options

🏪 Store Profile

  • • Automatic store info fetching
  • • Store name & business type
  • • AI context enhancement
  • • Manual override available

👥 Admin Features

Available to administrators only

User Management

Location: /app/admin/users

  • •Create, edit, and delete user accounts
  • •Assign roles (admin/user) and permissions
  • •"Connect As" feature: View app as another user for debugging
  • •Bulk operations and user export

AI Instructions

Location: /app/admin/instructions

  • •Define AI personality and behavior
  • •Set response guidelines and formats
  • •Use templates and version control

questions

Location: /app/admin/quick-questions

  • •Add, edit, delete question buttons
  • •Reorder with drag-and-drop
  • •Track usage analytics

💡 Tips & Best Practices

For Users

1Use questions for common queries to save time
2Enable Auto-Execute if you trust the AI's plans
3Provide Feedback (👍👎) to improve AI responses
4Try Different Models for different types of questions
5Use Tools Tester when you need precise control

For Admins

1Customize questions based on user needs
2Review AI Instructions periodically
3Monitor User Activity for optimization
4Test New Features in Tools Tester first
5Keep Store Profile Updated for better AI context
6Use "Connect As" to debug user issues

⌨️ Keyboard Shortcuts

Send messageCtrl/Cmd + Enter
Focus searchCtrl/Cmd + K
Close modalEsc
Navigate history↑ / ↓

🆘 Common Issues

"No tools available" error

  • • Check API connection in Settings
  • • Verify WooCommerce API credentials
  • • Test connection with "Test Connection" button

"Empty response" from AI

  • • Check if database has data for the query
  • • Try a different time period
  • • Use Tools Tester to verify tool functionality

Slow responses

  • • Try a faster AI model
  • • Simplify complex queries
  • • Check cache settings