history-db

I've been tempted to do something similar. The context information (e.g. environment, working directory) would be especially helpful, since that's what I'm currently missing. Have you tried https://github.com/umang1912/advanced-shell-history? That was where I planned to start. Here are a few other projects: https://github.com/thenewwazoo/bash-history-sqlite # simple shell script to store Bash history into SQLite3 database https://gist.github.com/pklaus/1e381be8592426568df9 # simple Python script to store Bash history into Pandas dataframe https://gist.github.com/pklaus/26925cfa1fc6b370e043 # simple Python script to store Bash history in SQLite3 database https://github.com/fredsmith/history-db # store Bash history in PHP/MySQL web server https://github.com/joshuacronemeyer/shellsink # store Bash/Zsh history in Python web server

$ history | wc -l 56201 I use a simple prompt_command hook to push my history (from all my machines) to a central MySQL database(https://github.com/fredsmith/history-db). Entries are de-duped and a tally is kept so I can do simple ad-hoc reporting: mysql> select * from history order by count DESC limit 10; +-------+---------------------+-----------+----------+-------+ | id | timestamp | command | hostname | count | +-------+---------------------+-----------+----------+-------+ | 1 | 2015-09-02 19:41:45 | ls | xicada | 34458 | | 89 | 2015-09-02 14:58:33 | cd .. | xicada | 4332 | | 519 | 2015-08-24 18:38:55 | ll | xicada | 3229 | | 9 | 2015-09-02 12:37:05 | cd | xicada | 2250 | | 82 | 2015-08-28 18:27:07 | add | xicada | 1887 | | 329 | 2015