SQL Dump File Navigator is a Python tool designed to parse SQL dump files, providing a simple navigable interface for viewing and searching table data without any other dependencies than a standard Python 3 install. It supports both a curses-based interface for terminal navigation and a fallback non-curses navigation mode. This tool is for when you're in a pinch and need to quickly check the content of an SQL dump, most likely on a remote terminal connection, with no other tools available. This version specifically requires a particular MySQL dump format; check the example_dump.sql file for an example.
- Parse standard MySQL dump files to extract table schemas and data
- Navigate through tables and rows using a terminal-based interface
- Search rows across all columns
- Supports both curses-based and non-curses navigation
- Horizontal paging for tables with many columns (curses mode)
- Python 3.x
curseslibrary (usually included with Python on Unix-based systems)
-
Clone the repository:
git clone https://github.com/kirkbowe/sql-dump-file-navigator.git cd sql-dump-file-navigator -
Ensure you have Python 3 installed. You can check your Python version with:
python3 --version
-
Prepare your SQL dump file and place it in the project directory (e.g.,
example_dump.sql). Refer toexample_dump.sqlfor the correct dump format. -
Run the script with the path to your SQL dump file:
python3 sql-navigator.py example_dump.sql
-
Use the following commands to navigate:
[n]Next Page[p]Previous Page[l]Left Columns[r]Right Columns[s]Select Another Table[/]Search Rows[c]Clear Search[q]Quit
filepath: Path to the SQL dump file--verbose: Enable verbose output for debugging--nocurses: Disable curses navigation
Example:
python3 sql-navigator.py example_dump.sql --verbose --nocursesThis project is licensed under the terms of the GPL v3.0 License.