SQL Explorer (Excel to SQL via Flask)

SQL Explorer lets you upload an Excel workbook and run ad-hoc SQL queries against its sheets (loaded into an in-memory SQLite DB) using a Flask web UI.

Features

• Upload .xlsx / .xls files
• Converts sheets to SQLite tables (sheet names used as table names)
• Run arbitrary SQL queries and view results
• Inspect table schemas in the sidebar

Requirements

• Python 3.8+
• See requirements.txt for needed Python packages.

Quickstart

1. Create and (optionally) activate a virtual environment:

python -m venv .venv
# Windows
.venv\Scripts\activate
# macOS / Linux
source .venv/bin/activate

2. Install dependencies:

pip install -r requirements.txt

3. Run the app:

python wsgi.py

4. Open http://127.0.0.1:5000.

Notes

• For .xlsx files the app uses openpyxl via pandas. For older .xls files xlrd is used.
• Column names are normalized by trimming and replacing spaces with underscores.
• The app uses an in-memory SQLite database; nothing is written to disk.

Files added for GitHub

• requirements.txt — Python dependencies
• .gitignore — ignores virtual envs, caches and editor files
• LICENSE — MIT license
• CONTRIBUTING.md — contribution guidelines
• CODE_OF_CONDUCT.md — contribution conduct
• .github/workflows/python-app.yml — basic CI checks
• docs/USAGE.md — extended usage notes

License

This project is released under the MIT License — see LICENSE.