query 0.1.4

Quick interactive exploration of SQL databases.

query is a simple module for quickly, interactively exploring a SQL database. Together with IPython, it supports quick tab-completion of table and column names, convenience methods for quickly looking at data (e.g., .head(), .tail()), and the ability to get a rich interactive database connection up in only 2 lines by setting a few required environmental variables.

Demo in 2 lines

Explore the included demo database:

from query import QueryDb
db = QueryDb(demo=True)

Real-world use case in 2 lines

Or set a few environmental variables (QUERY_DB_DRIVER, QUERY_DB_HOST, QUERY_DB_PORT, QUERY_DB_NAME, and QUERY_DB_PASS) and get started just as quickly:

from query import QueryDB  # capital 'B' is OK too :)
db = QueryDB()

Interactive example

Links

• Code and additional details on Github: