query-database

Execute a query that runs in all columns of all tables and return the tables, columns and rows.

Like Ctrl+Shift+F in some code editors, but with a database.

Examples

Find all tables containing "Michael" in any row in any column and list for each table the colums and for each column the rows containing "Michael."

query-database -D sakila -w '`x` like "%Michael%"'

Same thing but using another name to reference the column

query-database -D sakila -c 'column' -w '`column` like "%Michael%"'

npm install -g query-database