sqlectron The Sqlectron Team
winget install --id=sqlectron.sqlectron-gui -e A simple and lightweight SQL client with cross database and platform support.
Sqlectron is a lightweight SQL client designed to provide a terminal-based interface for efficient database management across multiple platforms and databases.
Key Features:
- Cross-database support for connecting to various systems like PostgreSQL, MySQL, SQLite, and more.
- Terminal-based interface for a distraction-free environment ideal for command-line users.
- Real-time query execution for quick and reliable results.
- Cross-platform compatibility, supporting Windows, macOS, and Linux without requiring a GUI.
Audience & Benefit:
Ideal for software developers, database administrators, and backend engineers who need a simple yet powerful tool to manage databases across different platforms. Sqlectron streamlines workflow by offering a lightweight, terminal-based solution for efficient SQL operations. It can be installed via winget.
README
A simple and lightweight SQL client with cross database and platform support.
Current supported databases
- PostgreSQL
- MySQL
Do you want to support another SQL database? Please send a pull request to sqlectron-core.
Install
npm install -g sqlectron-term
GUI
SQLECTRON has also a GUI interface called sqlectron-gui.
Configuration
See the available configuration here.
Development
Running the application:
npm install
npm run dev
Routes
- /server/list
- /server/add
- /server/:id/edit
- /server/:id/remove
- /server/:id/database/:database
- /server/:id/database/:database/databases
Features
- manage servers
- list databases
- list tables
- execute query
TODO
- highlight box based on focus
- create shortcuts component with ability to add and remove shortcuts on focus / blur
- show shortcuts based on focused box
- execute query
- show results
- set query and execute on table selection
- try to enhance shortcut control to work directly on screen
- list databases
- improve db connect action (work similar to fetchTablesIfNeeded)
- improve style handling
- improve servers handling (work similar to fetchTablesIfNeeded)
- improve server add / edit screen (similar to database container)
- improve error handling of add / edit server screen
- show selected table name in status bar