I've been developing pgcli for a few months now.
It is now finally live http://pgcli.com.
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.
The design inspiration for the tool comes from my favorite python interpreter bpython.