A bash-like shell for accessing database servers
Switch branches/tags
Nothing to show
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.


aurum is a bash-like shell for interacting with database servers. It's still very much in an alpha state of development and is mostly infrastructure at this point with very few useful commands. The eventual goal is for it to provide a concise alternative to SQL for common database tasks.


It's possible that aurum will work with versions preceding those listed below, but they are the ones I've tested it with. I'll consider patches to allow it to function on older versions within reason.


The aurum executable will look for configuration file at ~/.aurum. Here are the sections and settings that are currently supported.

prompt = aurum> 

name = protocol://username:password@host/database

The prompt setting is similar in concept to the $PSO variable of bash, but currenty only supports string literals.

Each line in the [dsn] section provides a DSN for a particular server and database with a shorthand name for later reference.


For now, clone the repo and execute ./bin/aurum with no arguments. Eventually, this will support specifying a DSN name to automatically connect to it. This will place you in the "root" from which you can list available DSNs and their subentities using the ls command and eventually you'll be able to navigate between them using the cd command.


Commands exist as classes in lib/aurum/commands that extend from aurum.commands.Command and implement any of its do_* methods, which represent particular contexts in which the command can be invoked such as when no DSN is active or when a specific DSN, database, table, or column is active.

A do_all method is also supported, which is executed if it exists when none of the other do_* methods declared by Command are overridden. This is useful when the command operation does not vary based on the context.

Note: These do_* methods are processed like those of any Cmd subclass. Specifically, if they return a True value, the shell will terminate. The base Command class and exit.Exit Command subclass are good examples of this behavior being used.


Why the name "aurum?"

This was partly influenced by the use of SQLAlchemy for the project. One of the original goals of the craft of alchemy was to transmute base metals into noble metals like gold or, in Latin, "aurum," the word from which the chemical element takes its symbol Au. Another influence was my eventual hope for this project, that it become as useful as its name implies.