sqlshell 0.1.0

A powerful SQL shell with GUI interface for data analysis

SQLShell

A powerful SQL shell with GUI interface for data analysis. SQLShell provides an intuitive interface for working with various data formats (CSV, Excel, Parquet) using SQL queries powered by DuckDB.

Features

• Load and analyze data from CSV, Excel (.xlsx, .xls), and Parquet files
• Interactive GUI with syntax highlighting
• Real-time query results
• Table preview functionality
• Built-in test data generation
• Support for multiple concurrent table views

Installation

You can install SQLShell using pip:

pip install sqlshell

For development installation:

git clone https://github.com/yourusername/sqlshell.git
cd sqlshell
pip install -e .

Usage

After installation, you can start SQLShell from anywhere in your terminal by running:

sqls

This will open the GUI interface where you can:

1. Load data files using the "Load Files" button
2. Write SQL queries in the query editor
3. Execute queries using the "Execute" button or Ctrl+Enter
4. View results in the table view below
5. Load sample test data using the "Test" button

Requirements

• Python 3.8 or higher
• PyQt6
• DuckDB
• Pandas
• Other dependencies will be automatically installed

License

This project is licensed under the MIT License - see the LICENSE file for details.