Skip to content

ProperlyExplained/query-database

Repository files navigation

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%"'

Install

npm install -g query-database

About

Find where in the database some data is stored

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published