Skip to main content

A little but functional script that lets you search on every database of a MySQL server for an input string.

Project description

DBSeeker

Built with Python3 PyPI version License Contributors

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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbseeker-0.7a0.tar.gz (4.6 kB view hashes)

Uploaded Source

Built Distribution

dbseeker-0.7a0-py3-none-any.whl (4.9 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page