Frontend and backend stack to enable interactive natural language-style querying over SQL databases.

It's as if you literally had an Analyst in a Box.

AnalystBoxFrontend

The one search box to rule them all.

AnalystBoxFrontend is an autocompleting, tokenized bolding, keyword highlighting, extremely configurable, fast search-box. It's a React component designed for high versatility, speed, and seamless integration with a wide variety of projects.

AnalystBoxBackend

Understand data one and all.

AnalystBoxBackend is a data analyst that enables database queries in natural language - your language - allowing data to be understood by anyone. It's a python package designed for high versatility and seamless integration with a wide variety of projects.

Together - the Analyst in a Box

Example Queries:

• Show me everything
• What was the max car_speed
• What is the average stock_price
• How many values of employee_id are null
• Show me wind_speed and energy_generated
• Show me all dates when the temperature was low
• What songs were playing when the car_speed was high
• ...

Demos

These work on our local machines, hopefully, they'll work on your machine too... Try them out!

• DarkSky - see the frontend in action
• Dataset of Annotated Car Trajectories (DACT) - see what the frontend and backend can do together