GoSQL is a terminal-based Minimalist PostgresSQL database management tool written in Go. It provides an intuitive interface for managing database connections and executing PostgresSQL queries.
- Database connection profile management
- SQL query execution
- Table data viewing and editing
- Schema browser
- Real-time data updates
- Secure password storage
- Make sure you have Go installed on your system
- Clone this repository:
git clone https://github.com/yourusername/GoSQL.git
- Navigate to the project directory:
cd GoSQL - Install dependencies:
go mod download
- Build the project:
go build
-
Run the application:
./GoSQL
-
Create a new database connection profile:
- Fill in the connection details (Profile Name, Host, Port, Username, Password, Database Name)
- Click "Connect" or press Enter to save the profile
-
Select a profile from the list to connect to the database
-
Use the query interface to execute SQL commands
Tab/Down Arrow: Move to next fieldShift + Tab/Up Arrow: Move to previous fieldCtrl + X: Jump to buttonsn: Create a new Profileu: Update a Profilep: Return Profile listEnter: Submit form
Ctrl + T: Focus on table treeCtrl + K: Focus on query inputCtrl + U: Focus on data tableCtrl + A: Execute current queryCtrl + D: Toggle database list visibilityCtrl + R: Reset changesCtrl + S: Submit data changesEscape: Close status modale: Edit selected cells: Save changes
Up/Down Arrow: Move between rowsLeft/Right Arrow: Move between columns1-9: Quick navigation (type number + direction)d: Move down specified number of rowsu: Move up specified number of rowsCtrl + X: Toggle node expansion in tree view