Click image to enlarge
Microsoft SQL Query Analyzer example
(click image to enlarge)

Screenshots of other popular development tools

Click image to enlarge
Oracle SQL*Plus example (click image to enlarge)

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

 

Version 7.0 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 10 major database systems: Oracle, SQL Server, DB2 UDB, DB2 for iSeries, Sybase ASE, Sybase SQL Anywhere, Postgre SQL, Amazon Redshift, MySQL, Microsoft Access, and their SQL dialects
  • 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
  • SQL Query Analyzer
  • Eclipse
  • Visual Studio NET/2005/2008/2010/2013/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: 22 MB
Memory - 256 MB
CPU - Pentium or compatible
OS - 2000/XP/2003/Vista/2008/7/8
Supported database systems:

  • Oracle 8i, 9i, 10g, 11g, 12c
  • Microsoft SQL Server 2000, 2005, 2008, 2012, 2014
  • Windows SQL Azure 11
  • DB2 UDB 7.x, 8.x, 9.x, 10.x
  • DB2 for iSeries 5.x, 6.x, 7.x, 8.x, 9.x
  • PostgreSQL 8.x, 9.x
  • MySQL 5.x
  • SAP Sybase ASE 12,.x 15.x
  • SAP Sybase ASA (SQL Anywhere) 9x - 14.x
  • Amazon Redshift
  • Microsoft Access 2003, 2007,2010

Database connections via OCI, SMO, ADO.NET, MySQL Connector, and ODBC

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: 7.0.158
    Release date: July 31, 2014
  • 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.