SQL Assistant

The ultimate tool for SQL developer productivity!

SQL Assistant equips database developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy. Depending on what you are coding, SQL Assistant could boost your SQL coding productivity by 100% or more. Some users have reported productivity gains by as much as 500%.

Screenshots

Version 12 is now available. Here is what's new in this version.

SQL Assistant easily integrates with many widely used database editors and database management and development environments including native tools that come with your database systems. It provides assistance with code typing, automatic word completion and database object and attributes browsing. It provides functions for quick entry of common SQL constructs and code snippets. It also provides integrated and fully interactive SQL code assistance system for instant help with SQL command syntax and options available in specific database versions.

SQL Assistant is fast and can be used with both very small and very large database systems. It is also very flexible and can be easily customized by users to match their coding habits.

Key Features and Benefits

Pre-configured targets:

Increases SQL developer productivity
Improves code quality and accuracy
Integrates with many SQL and non-SQL editors
Provides interactive SQL reference and SQL code assistance systems
Provides advanced SQL code intellisense features, including support for databases, objects, parameters, script variables, syntax elements and more...
Includes code formatters and beautifiers; SQL syntax validation, code structure views for fast code navigation, and more...
Supports 14 major database systems: Oracle, SQL Server, Azure SQL, DB2 UDB, DB2 for iSeries, Sybase ASE, Sybase SQL Anywhere, PostgreSQL, Amazon Redshift, MariaDB, MySQL, Teradata, SQLite, and Microsoft Access
Fast and has small disk and memory footprint
Can be easily installed without interrupting any existing processes and used immediately

SQL Server Management Studio 205/2008/2012/2014/2016/2017/18.x
SQL Query Analyzer
Eclipse
Visual Studio NET/2005/2008/2010/2013/2015/2017/2019/DataDude/Express
DB Tools for Oracle
Toad
PL/SQL Developer
MySQL Query Browser
MySQL Query Workbench
SQL*Plus
PowerBuilder
UltraEdit
Notepad
Notepad++
...Imagine your SQL editor here...

Other information

Technical specifications:

Disk space: 179 MB for full installation
OS - Windows
Supported database systems:

Oracle 8i, 9i, 10g, 11g, 12c, 18c, 19c, 21c
Microsoft SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2017, 2019
Windows SQL Azure 11.x, 12.x
Apache Hive 2.x, 3.x
Apache SparkSQL 2.2, 2.3, 2.4
DB2 UDB 7.x, 8.x, 9.x, 10.x, 11.x
DB2 for iSeries 5.x, 6.x, 7.x
PostgreSQL 8.x, 9.x, 10.x, 11.x, 12.x
MySQL 5.x and 8.x
MariaDB 5.x and 10.x
SAP Sybase ASE 12.x, 15.x, 16.x
SAP Sybase ASA (SQL Anywhere) 9.x - 17.x
Amazon Redshift
Teradata 14.x, 15.x, 16.x
IBM Netezza 7.x
Pivotal Greenplum 4.x, 5.x, 6.x
SQLite 3.x
Microsoft Access 2003 to Office 365 (11.x to 16.x)

Database connections via Oracle OCI, MySQL connector (libMySQL), MariaDB connector (libMariaDB), PostgreSQL LibPQ, SMO, ODBC, ADO.NET

Free Evaluation Download

NOTE: Fields marked in «green» are required. First Name*: Last Name*: Job Title*: Company*: City: Country*: Phone: E-mail*: A valid email address is required. The download link will be sent to the email address you provide.

Click on the Privacy Protected Seal to confirm how we protect your personal information.

Download
Last version: 12.0.181
Release date: October 31, 2021
User's Guide
Support Forum
SQL Assistant API is now available. If you are software developer or integrator, you might be interested in using SQL Assistant as an embedded add-on for your product.
SQL Assistant has received 5-star rating from SQL Server Worldwide User's Group. See the complete review here.
Check what database experts say about SQL Assistant.
Read here SQL Assistant review by senior Oracle DBA James Koopmann.