SQLite Shell is an interactive command-line shell that allows you to interact with SQLite databases. The shell supports custom commands, SQL queries, and exporting query results to Excel files.

• SQLite Mode: Execute SQL queries, list tables, databases, and columns, and perform CRUD operations.
• Custom Commands: Load and execute custom commands from an external JSON file.
• Export to Excel: Export query results to Excel files.

• Python 3.x
• openpyxl library

Install the required libraries using:

pip install -r requirements.txt

1. Clone the repository:

   git clone https://github.com/arpitnema07/sqlite_shell
   cd sqlite_shell

2. Install the required libraries:

   pip install -r requirements.txt

3. Run the shell:

   python shell.py

You can add custom commands by modifying the commands.json file. Each command should have a name and a corresponding SQL query or Python function to execute.

To export query results to an Excel file, use the export command followed by the query and the output file name.

This project is licensed under the MIT License.