✨ Features ⚙️ How it works 🗄️ Data Sources Open Dashboard →
✨ AI-Powered ERP Analytics

Smart ERP Connector

Ask your data
anything.

Smart ERP connects directly to your SQL database. Type a question in plain English — get live charts, tables, and plain-language insights in seconds.

AMSR

Live database · Real-time SQL · Zero setup

Live database connected
Smart ERP · AI Query
Top 10 products by sales this month
₹4.2LTop Product
10Results
0.8sQuery Time
📊 42 views available
40+
Database Views
<1s
Query Response Time
100%
SQL Server Native
0
Manual SQL Required
✦ Features

Everything your team needs
in one place

From natural language queries to live data exploration — Smart ERP puts your entire database at your fingertips.

AI Query Engine

Type questions in plain English. The AI generates optimized T-SQL, runs it live against your database, and explains the results in natural language.

GPT-4o Auto-retry Self-healing
📊

Live Data Explorer

Browse all your database views and tables with filters, sorting, date ranges, and branch/category segmentation. Export to Excel in one click.

40+ views Excel export Deep filters
📈

Smart Charts

Bar, line, and pie charts auto-generated from query results. Click any bar to drill down. Export charts as PNG for reports and presentations.

ECharts Drill-down PNG export
🔄

Google Sheets Sync

Sync any dataset directly to Google Sheets on demand. Schedule automatic exports or trigger them manually from the dashboard.

Google API Scheduled On-demand
🔒

Role-Based Access

Manager, viewer, and admin roles with per-feature permissions. Google SSO login ensures only authorized users can access sensitive data.

Google SSO RBAC Per-feature
🌙

Dark Mode + Mobile Ready

Fully responsive across all screen sizes — phone, tablet, desktop. Persistent dark/light theme with system preference detection.

Dark mode Responsive Touch-ready
⚙️ How It Works

From question to insight
in 4 steps

No SQL knowledge needed. Smart ERP handles the complexity so your team can focus on decisions.

1

Type your question

Ask anything in plain English — "Show me top 10 products this month" or "Which branches had zero sales last week?"

2

AI builds the SQL

GPT-4o generates optimized T-SQL using your live schema. A semantic guard validates the query before execution.

3

Live results

The query runs directly against your SQL Server database in real time. Zero data copying, zero stale caches.

4

Charts + Insights

Results appear as interactive charts and tables with a plain-English summary. Export to Excel or Google Sheets.

🗄️ Data Sources

All your ERP data,
connected and ready

Smart ERP reads from your existing Microsoft SQL Server views — no data migration or ETL required.

💰

Sales Data

Invoices, transactions, revenue

📦

Stock & Inventory

Quantity, reorder levels, movement

🛒

Purchase Reports

Vendors, PO amounts, GRN data

👥

Customers

Details, lifetime value, segments

🏪

Branches

Multi-branch performance tracking

🧑‍💼

Salesperson

Revenue rankings, targets

📊

Power BI Views

VW_MB_POWERBI_* analytics views

🗂️

Item Masters

Products, categories, articles

Ready to ask your data
anything?

Your dashboard is live and connected. Open it to start exploring your business data with AI.