I’ve been developing pgcli for a few months now. 

It is now finally live http://pgcli.com

It all started when Jonathan Slenders sent me a link to his side-project called python-prompt-toolkit

I started playing around with it to write some toy programs. Then I wrote a tutorial for how to get started with prompt_toolkit https://github.com/jonathanslenders/python-prompt-toolkit/tree/master/examples/tutorial

Finally I started writing something more substantial to scratch my own itch. I was dealing with Postgres databases a lot at that time. The default postgres client ‘psql’ is a great tool, but it lacked auto-completion as I type and it was quite bland (no syntax highlighting). So I decided to take this as my opportunity to write an alternate. 

Thus the creatively named project ‘pgcli’ was born.

Details about pgcli.com:

It is built using pelican a static site generator written in Python. 

It is hosted by Github pages. 

The content is written using RestructuredText.

Inspiration:

The design inspiration for the tool comes from my favorite python interpreter bpython.