sqlshell 0.1.4

A powerful SQL shell with GUI interface for data analysis

SQL Shell

A GUI application that provides a SQL REPL interface for querying DuckDB databases and Excel files.

Features

• SQL query interface with syntax highlighting
• Support for querying local DuckDB database (pool.db)
• Import and query Excel files (.xlsx, .xls) and CSV files
• Results displayed in a clear, tabular format
• Keyboard shortcuts (Ctrl+Enter to execute queries)

Installation

1. Make sure you have Python 3.8 or newer installed
2. Install the required dependencies:

   pip install -r requirements.txt
   

Usage

1. Run the application:

   python sqls.py
   

2. The application will automatically connect to a local DuckDB database named 'pool.db'

3. To query Excel files:

   • Click the "Browse Excel" button
   • Select your Excel file
   • The file will be loaded as a table named 'imported_data'
   • Query the data using SQL commands (e.g., SELECT * FROM imported_data)

4. Enter SQL queries in the top text area

   • Press Ctrl+Enter or click "Execute" to run the query
   • Results will be displayed in the bottom panel

Example Queries

select * from sample_sales_data cd inner join product_catalog pc on pc.productid = cd.productid limit 3

you can also do multiple statements, i.e:

create or replace temporary view test_v as 
select * from sample_sales_data cd
inner join product_catalog pc on pc.productid = cd.productid;

select distinct productid from test_v ;