Mini SQL Query

"Mini SQL Query from by Paul Kohler is a minimalist SQL query tool for multiple providers (MSSQL, Oracle, OLEDB, MS Access, SQLite etc). The goal of the Mini SQL Query tool is to allow a developer or trouble-shooter to quickly diagnose issues or make changes to a database using a tool with a small footprint, is portable, fast, flexible and easy to use."

Features

Mini SQL Query is now hosted as an open source project on GitHub, see https://github.com/paulkohler/minisqlquery

Mini SQL Query is "deliberately minimalist". Software too often becomes bloated and less usable while trying to satisfy the 99% of what every user wants. Mini SQL Query aims to satisfy the most common tasks what the average user seeks to achieve, in doing so it keeps the size and complexity of the application to a minimum.

The application was developed almost entirely using Microsoft's Visual Studio C# Express IDE.

Some Core features:

• Supports multiple databases (MSSQL, MSSQL CE, MS Access, SQLite, Oracle, OLEDB etc)
• Integrated text templating system for generating SQL, code or data scripts
• Syntax highlighting (with printing support)
• Load and save SQL script files
• Generic batch support (using the 'GO' keyword but for any DB including SQLite, MSAccess etc)
• Quick View table data
• Basic query generation
• Extensible programming model

System Requirements

• Microsoft Windows (Windows 7, Vista, XP, Server 2003 etc)
• Microsoft .NET Framework 4 (or higher, earlier releases worked on version 2 of the framework but the requirement has become distant)

Product Website

The product "home" of Mini SQL Query is https://github.com/paulkohler/minisqlquery (previously hosted on CodePlex).

License

The project is run under the GLPLv3 license. See the "License-MiniSqlQuery.txt" file for the details.

Thank You's

Mini SQL Query relies on several other 'free/open source' products to pull together a simple but useful SQL working environment. In no particular order, thank you...

• Thanks to Kent Carlsle for his contributions (kdcarlisle@gmail.com)
• Mark James, for the Silk icon set (http://www.famfamfam.com/)
• ic#code for the SharpDevelopSharpDevelop project where I get the ICSharpCode.TextEditor from that removes the need for using an plain old textbox (http://www.icsharpcode.net/OpenSource/SD/
• Weifen Luo for his extremely easy to use WinForms docking suite (http://sourceforge.net/projects/dockpanelsuite/)
• To the Castle Project (http://www.castleproject.org/) for the NVelocity text template engine port.
• To the Ninject (http://www.ninject.org/) for the dependency injection container.

Extensibility

Mini SQL Query uses a very simple and open plugin architecture to make extending the tool very straight forward. Make use of the project plugin template (MiniSqlQuery.PlugIn.ProjectTemplate.zip) to get started.