A little but functional script that lets you search on every database of a MySQL server for an input string. It will print the results in a table format, indicating which table contains the search term, in which database, how many rows were found and the time it took to search.
Please note that this project is still in alpha stage, so you may encounter bugs and missing features.
DBSeeker uses argparse to parse command line arguments.
You can run python dbseeker.py -h to see this help message:
usage: dbseeker.py [-h] -a address -P port -u user [-p password] [-d database | -bl blacklist] -s search
-h, --help
To show this help message and exit
-a address, --address address
To Enter the host address
-P port, --port port
To Enter the port
-u user, --user user
To Enter the user
-p password, --password password
To Enter the password
-d database, --database database
To Enter databases you want to search in
-bl blacklist, --blacklist blacklist
To Enter databases you want to be excluded, separated by commas
-s search, --search search
To Enter the search term
Please note that -d and -bl are mutually exclusive;
Square brackets indicate optional arguments;
At the moment DBSeeker will accept a minimum of 3 characters for the search term, but it may be changed in the future;
If your search string does include whitespaces, please remember to use quotes.
Since 'argparse' and 'time' should be both included in your python environment you just need to install the following dependencies:
- mysql-connector-python
- tabulate
as referred in the requirements.txt file.
As always, thanks to our amazing contributors!
Inside the project folder, create a new virtual environment, then simply run
pip install -r requirements.txtOr you can simply run
pip install dbseeker