pgcli/mycli - command line wrappers for postgresql and mysql Source

September 19, 2018 Markdown source

1---
2title: 'pgcli/mycli - command line wrappers for postgresql and mysql'
3date: '2018-09-19'
4published_at: '2018-09-19T18:45:00.002+10:00'
5tags: ['mysql', 'open source', 'postresql', 'python']
6author: 'Gavin Jackson'
7excerpt: 'pip install pgcli mycli These are replacements for the standard mysql and postgresql command line clients. This is appealing because it provides a (somewhat) consistent end user experience to these da...'
8updated_at: '2018-09-19T18:45:46.672+10:00'
9legacy_url: 'http://www.gavinj.net/2018/09/pgclimycli-command-line-wrappers-for.html'
10---
11
12##  pip install pgcli mycli
13
14These are replacements for the standard mysql and postgresql command line clients. This is appealing because it provides a (somewhat) consistent end user experience to these databases and provides some seriously handy features; including:
15
161. Command line completion
17
182. History (with search)
19
203. Integrates with your favourite command line editor \e
21
224. Named queries (favorites) - these can be configured to take parameters! I have lots of little SQL snippets I keep in a text file, this makes it much easier!
23
245. Allows you to easily define the output format using the \T special command (write to file by using the \o special command).
25
266. Use the "watch" command to easily set up a query that auto refreshes
27
28Output formats:
29double sql-update-1 orgtbl grid latex rst csv latex_booktabs mediawiki textile plain pipe html ascii fancy_grid psql sql-insert sql-update-2 vertical tsv jira simple moinmoin sql-update github
30
31Written in python too!!
32
33[https://www.mycli.net/](https://www.mycli.net/)
34[https://www.pgcli.com/](https://www.pgcli.com/)
35
36Great pycon presentation by the developer (Amjith Ramanujam): [https://www.youtube.com/watch?v=hJhZhLg3obk&feature;=player_embedded](https://www.youtube.com/watch?v=hJhZhLg3obk&feature=player_embedded)
37
38
39

---
title: 'pgcli/mycli - command line wrappers for postgresql and mysql'
date: '2018-09-19'
published_at: '2018-09-19T18:45:00.002+10:00'
tags: ['mysql', 'open source', 'postresql', 'python']
author: 'Gavin Jackson'
excerpt: 'pip install pgcli mycli These are replacements for the standard mysql and postgresql command line clients. This is appealing because it provides a (somewhat) consistent end user experience to these da...'
updated_at: '2018-09-19T18:45:46.672+10:00'
legacy_url: 'http://www.gavinj.net/2018/09/pgclimycli-command-line-wrappers-for.html'
---

##  pip install pgcli mycli

These are replacements for the standard mysql and postgresql command line clients. This is appealing because it provides a (somewhat) consistent end user experience to these databases and provides some seriously handy features; including:

1. Command line completion

2. History (with search)

3. Integrates with your favourite command line editor \e

4. Named queries (favorites) - these can be configured to take parameters! I have lots of little SQL snippets I keep in a text file, this makes it much easier!

5. Allows you to easily define the output format using the \T special command (write to file by using the \o special command).

6. Use the "watch" command to easily set up a query that auto refreshes

Output formats:
double sql-update-1 orgtbl grid latex rst csv latex_booktabs mediawiki textile plain pipe html ascii fancy_grid psql sql-insert sql-update-2 vertical tsv jira simple moinmoin sql-update github

Written in python too!!

[https://www.mycli.net/](https://www.mycli.net/)
[https://www.pgcli.com/](https://www.pgcli.com/)

Great pycon presentation by the developer (Amjith Ramanujam): [https://www.youtube.com/watch?v=hJhZhLg3obk&feature;=player_embedded](https://www.youtube.com/watch?v=hJhZhLg3obk&feature=player_embedded)