A Tool for SQL Queries

Query Runner is a multi-database, multi-platform SQL query tool. Download and try out a developement release for free!

SQL is a simple and powerful language that enables the programmer to run complex queries against many relational database systems. Although most database systems include tools to run SQL queries, they typically provide only essential capabilities making common operations repetitive and cumbersome. Query Runner's functions are centered around the activity of writing SQL queries.

As a programmer who frequently writes complex queries to create reports and build applications, I often desire certain capabilities to assist my efforts. Query Runner is the cumulation of these wishes coupled with a few of my preferences like a native GUI.

Both this website and the Query Runner software are currently alpha quality. That is, they are functional and hopefully useful to you, but there are probably broken and missing functions. I've made the software available at this early stage because I think that broad feedback is important for design decisions. The idea is to trade free, useful software for feedback.

Features

  • Cross Platform. Runs on anything wxPython run on.
  • Currently supports Postgresql, Oracle, MSSQL, MySQL, SQLite and Firebird. Will support ODBC, Sybase, Informix, MaxDB and possibly JDBC.
  • Schema Auto Completion
  • Syntax Highlighting
  • Data Export
  • Memory Usage Feedback
  • Query history log and searching.
  • ... more to come

Why Query Runner?

With similar tools on the market, why choose Query Runner? What distinguishes Query Runner from other products?

  • Source Code Included and Modifiable - The source code is now and will always be included. You are free to inspect and modify your copies of the software as you see fit.
  • Future Proof - If having the source code weren't enough, the license for the non-development versions will revert to a BSD style license after some period of time (most likely 7 years), making it freely redistributable. Instead of becoming outdated, your software becomes ubiquitous.
  • Affordable - As other products have grown in features, so have their price tags. The target price range for Query Runner is $20-$30 USD, an hour or two's labor for most. A principal goal of development is to maintian an affordable price with every improvment and feature addition.
  • Task Focus - Query Runner does not and will not try to be everything to everyone. It follows the UNIX philosophy of "do one thing and do it well". Its purpose is to assist in writing and running SQL queries and additional features should serve that purpose.

Public Alpha Release Notes

Alpha means not highly polished, some things are broken and some things are missing. However, I would not have made a public release if it were not useful. I use it day to day for my query needs and it's more useful than any free alternative I know of. I plan to update and release frequently, so if you let me know about a bug or missing feature you're more likely to have your issue addressed promptly.

I'm making the source code available to view and modify. It's your copy. You can squash a bug or just change something to fit your liking. I only ask that you don't redistribute a modified version because I do plan to attempt a modest profit eventually. Though, even then I'll make the source available as I think it should be.

Proceed to the download page.

 
 

Valid XHTML 1.0 Strict