Implemented ProjectData Analytics and AI

Dalil AI Text-to-SQL

Dalil is an intelligent platform that uses artificial intelligence to convert natural language questions into SQL queries, execute them against databases and present results directly and clearly, without requiring users to write SQL manually.

01

From question to result

The platform makes data accessible and enables users to query and analyze information in natural language. A user can ask a question such as: ‘How many employees are there?’, and the platform understands it, generates a query and presents the result.

02

How does Dalil work?

Implemented Project

Understand the Question

Understand the natural language question and identify the requested information.

Implemented Project

Identify Related Data

Identify the tables and data related to the question.

Implemented Project

Generate a SQL Query

Generate a SQL query suited to the question and data structure.

Implemented Project

Validate the Query

Validate the query before execution.

Implemented Project

Execute the Query

Execute the query against the database.

Implemented Project

Present the Result

Present the result directly and clearly to the user.

Implemented Project

Explain the Result

Provide an intelligent explanation to help the user understand the result.

Implemented Project

Suggest Related Questions

Suggest related questions to continue exploring the data.

03

Project technologies

Artificial Intelligence

LLM

Ollama

Text-to-SQL

RAG

Semantic Search

Vector Database

BAAI/bge-m3

FastAPI

Python

SQLite

React

Vite

Docker

04

AI for understanding questions and data

Dalil combines language models through Ollama with RAG, semantic search and a vector database using BAAI/bge-m3 to understand questions, identify related data and generate SQL. The platform uses FastAPI, Python and SQLite, with a React and Vite interface and Docker deployment.

Open Dalil

Launch the platform and start querying data in natural language.

Open the System