LOBac SQL is a lightweight MySQL database manager developed by a group of students from Málaga's University, forked from Apollo SQL.
This CLI program written in Python allows you to connect to remote database to query and relate data with predesigned queries (modify custom/queries.sql
and custom/db_data_.py
), show whole tables, and insert data into them.
git clone https://github.com/LOBac/LOBac-SQL.git
The usage is pretty simple, just launch the main.py
file:
python main.py
It works with a CLI (command-line interface), so you just need a command line to work with it.
In the first start, you will need to setup in settings the following connection parameters:
host
port
database
username
password
The settings persist in memory in the config.ini
file, which will be created automatically on first start.
Here are some examples from the interface (main menu, settings, and a query) running on Windows Powershell 5.1:
The program also allows to perform customized queries from the menu:
The program uses external open-source packages (license included in every package in extra/
):