Skip to content

README.md

Latest commit

 

History

History
76 lines (54 loc) · 2.87 KB

README.md

File metadata and controls

76 lines (54 loc) · 2.87 KB

DBQnA Application

Experience a revolutionary way to interact with your database using our DBQnA app! Harnessing the power of OPEA microservices, our application seamlessly translates natural language queries into SQL and delivers real-time database results, all designed to optimize workflows and enhance productivity for modern enterprises.

Table of contents

  1. Architecture
  2. Deployment Options

Architecture

The flow chart below shows the information flow between different microservices for this example.

flowchart LR
    %% Colors %%
    classDef blue fill:#ADD8E6,stroke:#ADD8E6,stroke-width:2px,fill-opacity:0.7
    classDef orange fill:#FBAA60,stroke:#ADD8E6,stroke-width:2px,fill-opacity:0.7
    classDef orchid fill:#DA70D6,stroke:#1E90FF,stroke-width:2px,fill-opacity:0.7
    classDef invisible fill:transparent,stroke:transparent;
    style Text2SQL-MegaService stroke:#000000

    %% Subgraphs %%
    subgraph Text2SQL-MegaService["Text-to-SQL MegaService "]
        direction LR
        LLM([LLM MicroService]):::invisible
    end
    subgraph UserInterface[" User Interface "]
        direction LR
        a([User Input Query]):::orchid
        UI([UI server<br>]):::orchid
    end

    LLM_gen{{LLM Service <br>}}
    POSTGRES_DB{{POSGRES DATABASE <br>}}
    GW([Text-to-SQL GateWay<br>]):::orange


    %% Questions interaction
    direction LR
    a[User Input Query] --> UI
    UI --> GW
    GW <==> Text2SQL-MegaService


    %% Text-to-SQL service flow
    direction TB
    LLM <-.-> POSTGRES_DB
    direction LR
    LLM <-.-> LLM_gen
Loading

The key feature of DBQnA app is that it converts a user's natural language query into an SQL query and automatically executes the generated SQL query on the database to return the relevant results. Basically ask questions to database, receive corresponding SQL query and real-time query execution output, all without needing any SQL knowledge.

Deployment Options

The table below lists the available deployment options and their implementation details for different hardware platforms.

Platform Deployment Method Link
Intel Xeon Docker compose Deployment on Xeon
AMD ROCm Docker compose Deployment on AMD Rocm

Validated Configurations

Deploy Method LLM Engine LLM Model Hardware
Docker Compose TGI mistralai/Mistral-7B-Instruct-v0.3 Intel Xeon
Docker Compose TGI mistralai/Mistral-7B-Instruct-v0.3 AMD ROCm