Skip to content

LouisRiverstone/query-script-maker

Repository files navigation

SQL Script Maker

SQL Script Maker Logo

Overview

SQL Script Maker is a powerful and user-friendly tool designed to help you create, manage, and execute SQL scripts effortlessly. It provides functionality to read Excel files (.xlsx), bind variables, write SQL queries in an intuitive editor, save your favorite queries in a local SQLite database, and test your queries against a MySQL database.

Whether you're a beginner or an experienced developer, this software simplifies your SQL query-building process, allowing you to focus more on solving problems than worrying about syntax.


Features

1. Read Excel (.xlsx) Files

  • Import Excel files directly into the application.
  • Automatically parse the data into SQL-friendly formats.
  • Extract relevant data from your spreadsheets for use in SQL queries.

2. Bind Variables for Queries

  • Easily bind variables to SQL queries.
  • Save time and reduce errors by using dynamic variables for repeated queries.
  • Supports both static and user-defined variables.

3. SQL Editor

  • An integrated SQL editor that provides syntax highlighting and basic code completion.
  • Includes error detection to help debug your queries.
  • Option to execute queries directly against a MySQL database.

4. Local SQLite Database for Favorite Queries

  • Save your frequently-used SQL queries locally in a built-in SQLite database.
  • Quickly access and reuse saved queries to streamline your workflow.
  • Organize your favorite queries into custom categories for easy retrieval.

5. Test Queries Against MySQL Database

  • Connect to your MySQL database and test SQL queries in real-time.
  • Direct execution of queries with results shown in the app.
  • Easily configure connection settings and manage database profile.

Installation

  1. Download the installer for your operating system from the release in repository.
  2. Run into your favorite OS.

System Requirements

  • Operating System: Windows 10 / macOS 10.13+ / Linux
  • RAM: 512 MB minimum (1 GB recommended)
  • Disk Space: 50 MB free space for installation
  • Database: MySQL 5.7+ (for testing queries)

License

SQL Script Maker is available under the MIT license. You can use the software for personal or commercial purposes as outlined in the full license documentation.


Enjoy crafting your SQL queries with ease!

About

A query script tool written in GO to automatize queries using a .xlsx

Resources

License

Stars

Watchers

Forks

Packages

 
 
 

Contributors