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

Oracle SQL*Plus example
Click image to enlarge
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 3.5 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 4 major database systems: Oracle, SQL Server, DB2 and MySQL 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
  • SQL Query Analyzer
  • Eclipse
  • Visual Studio NET/2005/DataDude/
  • DB Tools for Oracle
  • Toad
  • PL/SQL Developer
  • MySQL Query Browser
  • SQL*Plus
  • UltraEdit
  • Notepad
  • ...Imagine your SQL editor here...

Top of page

Other information

Technical specifications:

Disk space: 5.4 MB
Memory - 128 MB
CPU - Pentium or compatible
OS - 2000/XP/2003/Vista
Supported database systems:

  • Oracle 8i, 9i, 10g, 11g
  • Microsoft SQL Server 2000, 2005, 2008
  • DB2 UDB 7, 8, 9
  • MySQL 5, 5.1
  • Sybase ASE 12, 15
  • Sybase ASA 7, 8, 9, 10
  • Microsoft Access 2003, 2007

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: 3.5.26
    Release date: June 19, 2008
  • 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 3.0 has received 5-star rating from SQL Server Worldwide User's Group. See the complete review here here.

    Click image to read the review