Skip to content

ATR318/sql-ui

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

The SQL UI - A T R 🗂️

A sleek and simple SQL User Interface built fully in Python using CustomTkinter.
It’s designed for easy database creation, table management, and even data visualization, all wrapped in a modern, minimal design.

This was one of those "why not?" ideas that I decided to take my shot on.


🚀 Features

  • 🧑‍💻 User authentication system with bcrypt-hashed passwords
  • 📂 Create and manage SQL databases through the UI
  • 📊 Visualize data using graphs and charts powered by Matplotlib & NumPy
  • 🎨 Clean, dark-themed interface with vibrant highlights
  • 📁 Secure local storage for usernames and passwords
  • ⚡ Comes with a one-click installer for all dependencies

📝 Requirements

Here’s what the project uses :

  • pymysql
  • customtkinter
  • pillow
  • pywinstyles
  • matplotlib
  • numpy
  • pandas
  • bcrypt

📷 Screenshots

alt text

alt text

alt text

alt text


⚙️ Setup Guide (It’s Easy)

1. Install Python

Make sure you’ve got Python 3.x installed. You can grab it from:
https://www.python.org/downloads/


2. Clone This Repository:

git clone "https://github.com/ATR318/sql_ui.git"

3. Install Dependencies:

Simply double-click install_req.cmd (included in the repo).


4. Run It:

Just launch the app like this:

python main.py

🔒 Security Note

This project uses bcrypt for hashing passwords—no plain text storage here.
Of course, don’t push your real user data to GitHub. You can add sample users or reset the user files before sharing.


🗓️ Future Plans

  • ✅ AI-powered auto data analysis using Gemini AI (planned for later)
  • ✅ More fancy charts & reports
  • ✅ Cloud database support (maybe?)

🏷️ License

This project is licensed under the MIT License


🙋‍♂️ Author

Made by A T R
GitHub: https://github.com/ATR318


💬 Final Note

Honestly, this was just a fun project I built on for a school assignment (and was bragging a lot about it haha)
If you find it useful or feel like improving it, go ahead—fork it, tweak it, do whatever.
And yeah, thanks for checking it out!

About

A simple User Interface for SQL

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published