InsTranSQL is a lightweight yet powerful SQL query tool that enables users to manipulate large datasets using SQL queries without the complexity of full-scale database management systems. Designed for data analysts, business users, and professionals handling structured datasets, it bridges the gap between spreadsheets and full SQL platforms.

Primary Advantage: Handles large datasets that spreadsheets cannot manage while remaining simpler than full SQL platforms.

Key Features

• Data Handling & Importing
  • Supports large datasets beyond spreadsheet limitations.
  • Load multiple CSV/TXT files simultaneously for cross-file querying.
  • Automatic table name generation based on file names.
  • Displays raw data in an interactive, paginated table.
  • Basic data integrity checks.
• SQL Query Execution
  • SQLite-based execution for fast and efficient query processing.
  • Supports standard SQL operations, including SELECT, JOIN, WHERE, GROUP BY, HAVING, ORDER BY.
  • Row Limit input box acts as a data preview.
  • SQL Query Presets to store and quickly insert frequently used queries.
• Query Results & Output
  • Displays query results in an interactive, paginated table.
  • Export query results as CSV for further use.
  • Clipboard copy function for quick retrieval of generated table names.
  • Pagination controls for large datasets.
• Session Management
  • Save and restore sessions, including file paths, queries, pagination states, and results.
  • Delete and manage saved sessions.
• UI & Usability Enhancements
  • Dark-themed interface for reduced eye strain.
  • Buttons for common SQL operations.
  • Hotkeys and interface-based actions for inserting table names, headers, and cell data.
  • Loading indicators for processing status.
  • Reset function to clear all inputs and start fresh.

Try InsTranSQL (Demo Version)

📥 Download InsTranSQL Demo

Demo Version Includes:

• Supports querying up to 2 datasets
• Allows saving up to 2 sessions
• Stores up to 2 query presets
• Data integrity check enabled
• Export to CSV not included in the demo version

Built With (Tech Stack)

• Python (Pandas, SQLite, Tkinter)
• SQLite (for executing SQL queries)
• Tkinter (for GUI)
• JSON (for session storage)

Screenshots