The combination of pandas ipython and psycopg2 work wonders for pulling data from db and manipulating/plotting, although I don't know in more detail of what the client's use cases are.
I am seeking suggestions for business intelligence and data mining tools compatible with postgresql. A new manager at a client's shop is leaning toward the MS offerings. I would like to be able to speak to the issue.