Show HN: Dbjumper – a user-friendly interface for DB lookups
GitHub - yury-n/dbjumper: Navigate relational DBs with ease
dbjumper
Navigate relational DBs with ease.
Installation

Make sure you have git, node, and npm installed.
Clone this repository locally.
Cd into the root dir of the repository.
Run cp .env.example .env.
Fill .env file with your DB credentials.
Run npm install.
Run npm start.
Open http://localhost:3000/ in your browser.

Filtering
Tab/Enter to select a suggestion. If there's no suggestions, Enter submits the query, Tab creates a new query input.

Connections
(Cmd/Ctrl)+Click on a TD or TH. Tab/Enter to select a suggestion. If there's no suggestions, Enter creates a connection with a specified table as a new board item, Cmd/Ctrl+Enter -- connects it inside the same board item.

Creating connection from query
Syntax: "+joined_table(initial_table_key=joined_table_key)" or "+joined_table(key)", if they have the same name. This performs left join operation.

Table columns info
Syntax: "table#"
Alt+Click to hide a column.
Not implemented [yet]

Relational DBs other than MySQL
Filtering by operands other than '='
Inline joins using a column from a joined table
Pagination
Sorting

License
Licensed under MIT.
