Chat with Your Data Using AI in Natural Language

Introduction

In an effort to simplify even more data accessibility, we put in place a special feature that allows non-tech professionals to quickly get insights from their data sources.

Stop waiting for data analysts, stop writing SQL queries, ask questions about your data in natural language and get instant answers—powered by AI. No technical skills needed.

What is Text-to-SQL?

Text-to-SQL (also called natural language to SQL) lets you ask database questions in plain English instead of writing SQL code. Simply type "How many orders were placed last month?" and AI generates and executes the query automatically.

TransformZ brings this to your MySQL and PostgreSQL databases, no separate tools, no duplicate setup required.

What You'll Get

• ✅ Ask questions in plain English (or French!)
• ✅ AI converts to SQL queries automatically
• ✅ Get instant answers with real data
• ✅ No SQL knowledge required

What You Need

1. A TransformZ account - Sign up here.
2. A connected database: Guide to connect a database to TransformZ.
3. Questions about your data - That's it!

Steps to Chat with your Data using AI

Step 1: Connect Your Database to TransformZ

Already connected? Skip to Step 2.

New user? Follow this quick guide: How to Connect Your Database to TransformZ (5 minutes).

Step 2: Open the AI Chat Interface

1. Log in to your TransformZ dashboard
2. Click Data Sources in the left sidebar
3. Select your connected database
4. Scroll to the "OData API" section
5. Click the "Chat with Data" button

The AI Chat interface opens in a modal window.

Step 3: Start Asking Questions

You'll see the chat interface with:

• Your OData Service URL (for reference).
• Example questions to get you started.
• A text input to type your questions.

How it works:

1. Type your question in natural language
2. Our AI converts it to an SQL query
3. TransformZ executes the query on your database
4. You get instant results

Important: Our AI never has access to your actual data. It only:

• Understands your database structure (table/column names)
• Generates the proper SQL query, Text-to-SQL.
• Then, TransformZ executes it securely.

Your data stays in your database, always.

Example Questions to Try

Basic queries:

• Show all records from the users table
• How many orders were placed last month?
• List the top 10 customers by total spending

Filtered queries:

• Show users who registered in 2024
• Find orders greater than $1000
• List products with less than 10 units in stock

Analytics:

• What is the average order value?
• Count the number of active users
• Sum total revenue by month

Just type naturally—the AI understands context!

Note: AI can make mistakes or be limited, but we keep improving it.

What You Can Do

With the AI Data Chat feature, you can:

• Explore data quickly without writing SQL
• Answer business questions in seconds
• Share insights with your team instantly
• Work independently without waiting for IT

Security & Privacy

Your data is protected:

• AI never sees your data - Only database structure, not content.
• HTTPS encryption - All queries encrypted in transit.
• Your credentials - The AI integration uses your existing data source security.
• Audit logs - The audit logs mechanism tracks all queries on your data.

Quick Troubleshooting

"I can't question my database"
→ Ensure your database is connected (status shows "Connected")

"The AI doesn't understand my question"
→ Try rephrasing with specific table names, or check example questions

"I got an error message"
→ Verify the table/column names exist in your database

"Results seem incomplete"
→ Ask for "top 50" or "limit 100" to manage large datasets

---

Need help?

• 📧 Email: info@automathing.ca
• 🌐 Website: transformz.ca
• 💼 LinkedIn: Follow Orléando Dassi

---

Related Articles:

• How to Connect Your Database to TransformZ
• The 5 Pillars of Data Accessibility
• How to Open Your Database in Excel Using TransformZ