/KQL-Manager

KQL Local Manager, allows you to manage and organize KQL Queries in a central Database.

Primary LanguagePythonMIT LicenseMIT

KQL Query Manager

Introduction

The KQL Query Manager is a Python application that allows you to manage and organize your KQL (Kusto Query Language) queries in a central database. This tool provides a user-friendly interface for adding, editing, deleting, searching, and exporting your KQL queries, making it easier to manage your data exploration and analysis tasks.

Features

  • Query Management: Add, edit, and delete KQL queries with detailed information such as title, author, description, and tags.
  • Navigation Pane: View and select queries from a list in the navigation pane.
  • Query Details: Display the selected query's details, including the query text, which can be copied to the clipboard.
  • Search Functionality: Search for queries based on title, query text, or tags, with optional time range filtering.
  • Data Export: Export the query data to CSV or JSON formats.
  • Data Import: Import query data from CSV or JSON files.

Installation

  1. Clone the repository: git clone https://github.com/DrPwner/KQL-Manager.git
  2. Navigate to the project directory: cd kql-query-manager
  3. Run The Application: python KQL-DB-MANAGER.py

Menu Options

  • File:
  • Export: Export the query data to a CSV or JSON file.
  • Import: Import query data from a CSV or JSON file.
  • Exit: Close the application.
  • Edit:
  • Add: Create a new KQL query.
  • Edit: Modify an existing KQL query.
  • Delete: Remove a KQL query.
  • Search:
  • Search: Perform a search for KQL queries based on title, query text, or tags.

Screenshot

image

Contributing

If you find any issues or have suggestions for improvements, please feel free to open an issue or submit a pull request.

License

This project is licensed under the MIT License.