Free Windows Tool

SQL Query Tool

A lightweight desktop app for querying SQL Server databases — no SSMS required.

Download SQL Query Tool

Free · Windows 10 / 11 · Windows Server 2016 or higher · SQL Server 2012 or later · No installation required · Portable

What It Does

The Alliance PCG SQL Query Tool is a free Windows desktop application for running SQL queries against any SQL Server database — without needing SQL Server Management Studio (SSMS) installed. It was built specifically for law firms running Time Matters, Practice Master, and other SQL Server-based practice management software, giving staff and consultants a fast, focused tool for database work.

Who is this for? IT consultants, system administrators, and power users who need to query a SQL Server database quickly — without the overhead of a full SSMS installation. It is not intended for end users without SQL knowledge.

Features

Server Discovery

Automatically finds SQL Server instances on your network by scanning the Windows registry, running sqlcmd, and checking ODBC DSNs. No manual server entry needed.

Connection Profiles

Save named connection profiles for each server and database you work with. Switch between clients in seconds without re-entering credentials.

Object Browser

Browse databases, schemas, tables, and views in a collapsible tree. Double-click any table to run a SELECT TOP 100. Right-click for SELECT COUNT(*), DDL script, and INSERT template.

SQL Editor

Full SQL editor with syntax highlighting — keywords, data types, functions, strings, numbers, and comments each colored distinctly. Tab inserts 4 spaces. Find and Replace built in.

Multi-Tab Results

Each query opens in its own result tab. Run up to 10 queries and keep results side by side. Click any column header to sort. Double-click any row to see all field values.

★ Save Queries

Save any query by name and reload it instantly from your saved library. Build a personal collection of your most-used queries — reports, lookups, and diagnostics — and run them in one click without retyping.

Query History

Every query you run is automatically saved with its timestamp, row count, elapsed time, server, and database. Reload any past query in one click.

Export Results

Export any result set to CSV or Excel with a single click. Excel exports include a styled header row and auto-sized columns.

Windows Auth & SQL Login

Supports both Windows Authentication and SQL Server login. Saved profiles store your preferred auth method per server.

Screenshots

SQL Query Tool main window showing connection bar and object browser
Main Window — Connection bar, object browser, SQL editor, and results pane in a single layout.
SQL editor with syntax highlighting showing colored keywords, comments and strings
Syntax Highlighting — Keywords, functions, strings, comments, and data types each colored distinctly.
Saved Queries panel showing organized query library with groups and individual queries
Saved Queries — Organize queries into named groups. Load any saved query into the editor in one click.

Click any screenshot to view full size.

Keyboard Shortcuts

F5 / Ctrl+Enter
Run the current query
Ctrl+F
Open Find bar
Ctrl+H
Open Find & Replace bar
Ctrl+S
Save current query to your saved library
Tab
Insert 4 spaces

System Requirements

RequirementDetail
Operating SystemWindows 10 or Windows 11 (64-bit) · Windows Server 2016 or higher
SQL Server DriverODBC Driver 17 for SQL Server (free from Microsoft)
SQL ServerSQL Server 2012 or later — any edition including Express
Network AccessTCP/IP access to the SQL Server instance on port 1433
PermissionsSQL Server login or Windows account with at minimum db_datareader on the target database
InstallationNone — single .exe file, runs directly
InternetNot required
Don't have ODBC Driver 17? Download it free from Microsoft at learn.microsoft.com. It installs in under two minutes and requires no restart.
Windows SmartScreen notice: When you first run the exe, Windows may display a blue "Windows protected your PC" warning. This is expected — the tool is not yet commercially code-signed. To run it: click More info in the warning dialog, then click Run anyway. Alternatively, right-click the exe, select Properties, and check Unblock at the bottom before running.

Ready to get started?

Download the tool, double-click the .exe, and connect to your first database in under a minute.