The primary objective of this project is to empower individuals with little to no knowledge of SQL queries to easily and swiftly extract necessary information from databases. Our user-friendly interface allows the creation of complex SQL queries through simple selections, aiming to democratize access to data analysis. This approach effectively removes the barrier of technical knowledge in extracting valuable insights from databases.

• Python 3.11
• Typescript
• FastAPI
• Poetry
• Alembic
• Apache ECharts
• Next Auth
• Redux

git clone https://github.com/ebubekir/sql-generate-app

cd sql-generate-app/

cd backend/

poetry shell && poetry install

sudo docker compose up db

python main.py

yarn install

yarn dev

Firstly, you need to register to log into the application.

Add your data source in data sources page.

Add your connection details

When it's ok. Give it a name and save.

Select your table.

Also if you want, you can join your tables with ADD JOIN button.

Select columns.

You can add conditions with conditions panel.

Then go create a Query!

You can choose a different char types like pie, bar, line.