Mini SQL Query

"Mini SQL Query from PK Software 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 CodePlex, see http://www.codeplex.com/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 3.5 (or higher, earlier releases worked on version 2 pf the framework but the requirement has become distant)

Product Website

The product "home" of Mini SQL Query is http://pksoftware.net/MiniSqlQuery/ while the source code is hosted at CodePlex, see http://minisqlquery.codeplex.com/.

License

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

Thank You's

Mini SQL Query is written by Paul Kohler. See my website at: http://pksoftware.net/ Email me at: paul@pksoftware.net

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 dependency injection container (Micro Kernel) and the NVelocity text template engine port.

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.