Skip to content
yash-sainiPublic

About

NeatXQL Studio is a private, offline desktop utility for formatting JSON, XML, and sanitizing legacy SQL queries. It uses structural AST parsing to automatically extract parameters and generate ready-to-execute scripts without ever sending your sensitive data to the cloud.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

19 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 

Repository files navigation

neatsql NeatXQL Studio

.NET WPF Architecture

NeatXQL Studio is a blazing-fast, 100% offline desktop utility built for enterprise developers.

When working in secure environments, pasting proprietary database queries, sensitive JSON payloads, or private configuration files into random online formatters is a massive security risk. NeatXQL solves this by providing a premium, native Windows toolkit that never sends your data to the cloud.

Features

1. SQL Sanitizer (with AST Parsing)

Stop manually writing DECLARE statements to test legacy inline queries. The SQL Sanitizer uses Microsoft's official ScriptDom engine to parse raw text into an Abstract Syntax Tree (AST). It automatically formats the query, extracts all @parameters, guesses their SQL data types (e.g., DATETIME, BIT, INT), and generates an SSMS-ready executable script.

SQL_Sanitizer.mp4

SQL Sanitizer Demo

2. JSON Blacksmith

Instantly format, validate, or minify massive JSON payloads. Built on System.Text.Json and AvalonEdit, it can handle enormous API responses without freezing the UI thread.

JSON.mp4

JSON Blacksmith Demo

3. XML Blacksmith

Easily format and minify complex XML configuration files or SOAP responses with instant syntax highlighting and validation.

XML_Sanitizer.mp4

XML Blacksmith Demo

Architecture & Tech Stack

This project was built with a strict focus on modern Windows desktop development practices:

  • Framework: .NET 8 (LTS)
  • UI/UX: WPF-UI to implement the Windows 11 Fluent design system (Mica backdrops, modern typography, rounded corners).
  • Pattern: Strict MVVM (Model-View-ViewModel) using the CommunityToolkit.Mvvm source generators to eliminate boilerplate INotifyPropertyChanged code.
  • Text Engine: AvalonEdit for high-performance syntax highlighting, line numbering, and large-file handling.
  • SQL Parsing Engine: Microsoft.SqlServer.TransactSql.ScriptDom for true structural code analysis rather than fragile Regex matching.

Getting Started

Prerequisites

  • Visual Studio 2022 (Version 17.8 or later)
  • .NET 8.0 SDK

Installation

  1. Clone the repository:
    git clone [https://github.com/yourusername/NeatXQL.git](https://github.com/yourusername/NeatXQL.git)
    
  2. Open NeatXQL.sln in Visual Studio.
  3. Restore NuGet packages.
  4. Set NeatXQL as the startup project and press F5 to run.

Author

Yash Saini

License

This project is licensed under the Apache License 2.0 - see the LICENSE file for details.

About

NeatXQL Studio is a private, offline desktop utility for formatting JSON, XML, and sanitizing legacy SQL queries. It uses structural AST parsing to automatically extract parameters and generate ready-to-execute scripts without ever sending your sensitive data to the cloud.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages