Db-tool is a database java-based CLI application that allows you to manage your database. It can list all available tables in a database and is able to search through it like grep!
The use of so called Profiles will make your life easier when managing a lot of different databases. Configure once and use it through out the tool.
- Create a profile for different databases with
create-profile - List all available profiles
list-profiles - List all available tables in a database
list-tables - Use grep to search through a table
grep- Search through a database with a specific column pattern (with * as wildcards)
grep -cp - Search through a database with a specific column regex pattern
grep -cr - Search through a table with a specific column pattern (with * as wildcards)
grep -cp - Search through a table with a specific column regex pattern
grep -cr - Search through table content with a specific value pattern (with * as wildcards)
grep -vp - Search through table content with a specific value compare
grep -vc - Limit the number of rows in the result with
grep -lr - Limit the maximal length of text when the table is printed with
grep -lt - Most important You can use as many as you like of the above commands
- Use AND operator when using multiple
-vcwithgrep --vc-use-and - Verbose logging with
--please-tell-me-everything
- Search through a database with a specific column pattern (with * as wildcards)
Please refer to our How To Install Wiki Page
Please refer to our How To Use
In case you encounter any problems, feel free to contact us via email or open an issue on GitHub.
- Depending on which shell you use, the used color codes may not work (currently not working on Windows Command Prompt). This leads to weird characters in the output.
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change. Please make sure to update tests accordingly.