[an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] SQL Assistant - Productivity tools for database developers and DBAs
 

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 11 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...

Top of page

Other information

Technical specifications:

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

  • Oracle 8i, 9i, 10g, 11g, 12c, 18c, 19c
  • 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

Top of page

Free Evaluation Download

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














SQL Assistant

  • Download Download
    Last version: 11.5.362
    Release date: January 28, 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.

    Click image to read the review
     
  • Check what database experts say about SQL Assistant.
    Read here SQL Assistant review by senior Oracle DBA James Koopmann.