Internal Smart Assistant
An internal AI assistant that analyzes data and answers users' questions in natural language, transforms questions into safe SQL queries, and presents results as metrics, tables, and charts.
Turning questions into usable insights
The assistant lets users explore data and ask questions naturally, then converts them into safe queries and presents clear answers that support analysis and decision-making.
Assistant capabilities
Natural-language Questions
Ask direct questions about data without writing database queries.
Natural Language to SQL
Translate questions into SQL queries suited to the available data structure.
Safe Queries
Apply controls that protect data and restrict execution to allowed queries.
Intelligent Answers
Generate clear responses grounded in the returned data.
Metrics and Figures
Surface key values and indicators in a quick, direct format.
Analytical Tables
Organize detailed results in readable tables.
Charts and Reports
Present results through charts and reports that clarify trends.
Local Models
Run a local language model through Ollama for privacy and control.
Project technologies
Artificial Intelligence
Ollama / Local LLM
Natural Language to SQL (NL2SQL)
FastAPI
React + TypeScript
SQL Server
Data Analytics
Charts & Reports
Local AI connected to enterprise data
The solution combines Ollama and a local language model with FastAPI and SQL Server to turn user questions into safe queries, then presents the results through a React and TypeScript interface with clear visual analytics.
Open Internal Smart Assistant
Launch the assistant and start querying data in natural language.