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.
Please note, query requires pandas >= v0.14.
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()