A little but functional script that lets you search on every database of a MySQL server for an input string.
Project description
DBSeeker
Description:
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.
Usage:
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.
Dependencies:
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.
Contributors
As always, thanks to our amazing contributors!
Installation:
Inside the project folder, create a new virtual environment, then simply run
pip install -r requirements.txt
Or you can simply run
pip install dbseeker
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file dbseeker-0.7a0.tar.gz
.
File metadata
- Download URL: dbseeker-0.7a0.tar.gz
- Upload date:
- Size: 4.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.9.18
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | f145506e3430f5533c166487719aa2bf24bb0d2247c45bc5c16c8787387b1a8d |
|
MD5 | aeacfd07110dd88398a593dae96aa64b |
|
BLAKE2b-256 | 9c22b49292821d35a1003835c169236c7647d70f3a71d2a9c26b33a15f899de7 |
File details
Details for the file dbseeker-0.7a0-py3-none-any.whl
.
File metadata
- Download URL: dbseeker-0.7a0-py3-none-any.whl
- Upload date:
- Size: 4.9 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.9.18
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | baa66e3d5199c33c2d11272a82db9c8e3daa9f652aba3035fc0967c9febb14ee |
|
MD5 | 47490c2c6458ec21951d0ca5dd37b013 |
|
BLAKE2b-256 | 2a2890025e74bfa3070d8613c452db13cadfcd7c43feb8b7e997ae81901c9700 |