Get Started with DBTalker + Magento 2
Talk to your store database using natural language. No coding. Just answers.
Step-by-Step Setup Guide
Register for Free on DBTalker
Start by creating your free account on DBTalker:
- Go to DBTalker and create an account
- You'll be enrolled in the Free Plan
- Free Plan requires a Gemini API key (bring your own)
- Add Gemini API key under Billing → API Key Section
Generate Your Gemini API Key
For the free plan, you'll need to provide your own Gemini API key:
- Go to Google AI Studio
- Login with your Google account
- Click "Create API Key" and Copy that Generated Key
- Paste into your DBTalker account
- Add Gemini API key under Billing → API Key Section
Add a Platform (Magento 2)
Connect your Magento 2 store to DBTalker:
- Go to DBTalker Dashboard → Platforms → Add New
- Select Magento 2 as your platform type
- Enter your store name and URL
- Click "Add Platform" to generate your integration key
- Copy the generated API key - you'll need it for the Magento module
Install Magento 2 Module
Download and install the DBTalker Magento 2 module:
- Download the module ZIP file from the link above
- Extract the contents to your Magento installation's
app/code/directory - The module should be in
app/code/DBTalker/Connector/ - Run the following commands from your Magento root directory:
# Enable the module
bin/magento module:enable DBTalker_Connector
# Run setup upgrade
bin/magento setup:upgrade
# Compile code (production mode)
bin/magento setup:di:compile
# Deploy static content (production mode)
bin/magento setup:static-content:deploy
# Clear cache
bin/magento cache:clean
bin/magento cache:flushConfigure Magento Module
Configure the module in your Magento admin panel under:
Stores → Configuration → DBTalker
⚙️ General Settings
- Enabled – Turn the module ON/OFF
- API Key – Paste your DBTalker API Key
- Sync Database Schema – Click button to sync tables/columns securely
- Last Sync – Shows last successful schema sync
💬 Chat Widget Settings
- Enable Chat Widget – Show/hide chatbot in store
- Position – Choose widget position on screen
- Header & Theme Colors – Customize widget look
- Store Logo URL – (optional) Add your logo to chat widget
- Greeting Message (Frontend/Admin) – Custom welcome text for users
Why Configure Chat Widget?
- Increase Customer Interaction – Immediate access to support boosts customer satisfaction and conversion rates.
- Boost Sales – Real-time answers to product inquiries reduce hesitation and drive sales.
- Enhance User Experience – Personalize the chat experience with your logo and branding, making it more seamless and trustworthy.
- Improve Support Efficiency – Provide instant responses and handle more queries simultaneously without additional staff.
🔒 Security Settings
- Allowed Tables – Restrict chatbot to specific tables
- Excluded Tables – Explicitly block sensitive tables
- Max Query Execution Time – Prevents long-running queries (e.g., 30s)
After syncing:
- ✓ DBTalker fetches your DB schema (tables, columns) securely
- ✓ No raw DB credentials are stored
- ✓ Your actual data never leaves your server
Use the Admin Chatbot
Start asking questions about your store data:
- Go to Magento Admin → DBTalker Chatbot tab
- Ask questions like:
For each question, you'll get:
- Answer in plain English
- SQL Query used (for transparency)
Use the Frontend Chatbot
Visitors and customers can also interact with the chatbot on your storefront:
- Guest Users: Can ask general store-related questions (limited).
- Logged-in Customers: Can ask questions about their own account, orders, and activity.
Example Queries:
Depending on the user type, chatbot provides:
- Plain English answers (e.g., order status, offers, account insights)
- Secure data access for logged-in customers
Example Questions You Can Ask DBTalker
Natural Language
What are the top 5 products this month?
Response
Lists top 5 products with sales figures and comparison to previous period
SQL Query
SELECT ... FROM products ... ORDER BY sales DESC LIMIT 5
Natural Language
What was the revenue yesterday?
Response
₹18,234 with comparison to previous day and breakdown by payment method
SQL Query
SELECT SUM(grand_total) FROM sales_order WHERE created_at ...
Natural Language
How many orders came from Gujarat?
Response
24 orders totaling ₹45,678 from Gujarat in the last 30 days
SQL Query
SELECT COUNT(*) FROM sales_order WHERE region='Gujarat'
Frequently Asked Questions
Do I need to give you DB access?
No, only the database schema (table and column names) is synced via the module. Your actual data stays on your server and is never sent to DBTalker.
Is my data secure?
Yes, we don't store raw credentials or access your database directly. All queries are executed on your Magento server through our secure module.
What if I don't have a Gemini API key?
Free plan users need to provide their own Gemini API key. Alternatively, you can upgrade to a paid plan which includes API access without needing your own key.
Can I use this with other platforms?
Yes, support for WordPress and Shopify is coming soon. Magento 2 is currently fully supported with a native integration.
Start your free setup today
Get started with DBTalker in minutes and transform how you interact with your Magento store data.