Need help with sqlectron-term?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

sqlectron
502 Stars 45 Forks MIT License 111 Commits 12 Opened issues

Description

A simple and lightweight SQL client terminal-based interface with cross database and platform support

Services available

!
?

Need anything else?

Contributors list


A simple and lightweight SQL client with cross database and platform support.

demo

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

  • [x] highlight box based on focus
  • [x] create shortcuts component with ability to add and remove shortcuts on focus / blur
  • [x] show shortcuts based on focused box
  • [x] execute query
  • [x] show results
  • [x] set query and execute on table selection
  • [x] try to enhance shortcut control to work directly on screen
  • [x] list databases
  • [x] improve db connect action (work similar to fetchTablesIfNeeded)
  • [x] improve style handling
  • [x] improve servers handling (work similar to fetchTablesIfNeeded)
  • [x] improve server add / edit screen (similar to database container)
  • [ ] improve error handling of add / edit server screen
  • [ ] show selected table name in status bar

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.