DEV Community 👩‍💻👨‍💻

Cover image for awesome cli that you didn't know, replacement of dbeaver
Andres 🐍 in 🇨🇦
Andres 🐍 in 🇨🇦

Posted on

awesome cli that you didn't know, replacement of dbeaver

Always I'm looking to replace my desktop apps with a terminal application. Now take time to search some sql clients to connect the most famous databases: mysql , postgresql and sqlite.

If you are tired about use the dbeaver, well I will showup 3 tools can be a replacement of database explorer.

The history

It's very interesting the history of this 3 tools:

Earlier this year I wrote pgcli to scratch my own itch. I realized that most of the work that went into that project was not specific to Postgres database. I received a few requests from MySQL users requesting a MySQL equivalent of pgcli. I kept procrastinating for a few months and finally decided to launch a kickstarter campaign to fund the development time. That's this project came into existence. But if you'd like to know why I bothered to write a auto-completing repl with syntax highlighting, here's the reason:
I'm a huge fan of CLIs. Especially REPLs. When I first encountered BPython, I fell in love with it. BPython is a Python REPL that has auto-completion, syntax-highlighting and displays the docstring of functions as you type. Once you get used to that level of pampering, all other REPLs start to look like Dumb Terminals.
When I started using psql for interacting with my Postgres database, I yearned for a BPython equivalent for psql.
One fine day I got a twitter DM from Jonathan Slenders asking me if I'd be interested in trying a new Python library that he's working on called Python-Prompt-Toolkit. This library provided a way to write CLIs without having to deal with ncurses and had the requisite tools for doing auto-completion and syntax-highlighting. So I jumped at the opportunity to try it out. After I got myself familiarized, I started writing pgcli to scratch my own itch.
So this app exists because Jonathan was kind enough to request my feedback.

Feature:

AutoCompletation

AutoCompletation
AutoCompletation2

highlight

highlight

Install

pip install mycli pgcli litecli

mycli

MyCLI is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.

pgcli

Pgcli is a command line interface for Postgres with auto-completion and syntax highlighting.

litecli

A command line interface for SQLite with auto-completion and syntax highlighting.

OK! now it's time to drop your dbeaver and look more hacker in the terminal

Top comments (0)

🌚 Friends don't let friends browse without dark mode.

Good news! You can update to dark mode in your DEV settings.