New release

SoftTree SQL Assistant 14.0 +AI
for Oracle, SQL Server, Azure SQL, Hive, SparkSQL, Cassandra, DB2, Sybase, PostgreSQL, Redshift, Teradata, Netezza, Greenplum, MS Access, SQLite, MariaDB, MySQL, Snowflake, and MongoDB

 
The ultimate platform for database development (and administration)

SQL Assistant equips database developers and DBAs with the tools they need to speed up the database development process, improve code quality and accuracy. SQL Assistant will boost your database development productivity by 300% and more. You can check here real results shared by SQL Assistant users. The outstanding productivity has been achieved through the use of best in the industry SQL Intellisense and code automation features. The integrated AI further enhances user experience by providing intelligent database design suggestions, query generation and troubleshooting, making it easier for developers to write efficient and error-free SQL code. On top of that there are graphical database modeling and design tools for all supported database systems, performance monitoring, data analytics and reporting, ETL and data automation, visual database documenter, advanced schema cloning, multi-database code deployment, data obfuscation and sanitation, database benchmarking and unit testing, we got it all. Download the free trial and check it for yourself. We think you will like what you see, and we will be happy to see you joining many other users relying on SQL Assistant platform.

SQL Assistant supports all major relational databases. Out of the box it supports Oracle, Microsoft SQL Server, Azure SQL, IBM DB2, MariaDB, MySQL, PostgreSQL, Amazon Redshift, IBM Netezza, Teradata, Pivotal Greenplum, MongoDB, SQLite, SAP (Sybase) ASE and SQL Anywhere. Other major features include full-featured source control interface supporting Git, Subversion, Perforce, and Microsoft Team Foundation Server code repositories. Graphical database management; graphical database modeling and advanced dependencies analysis, code and data generation, ETL, database unit testing, and many others. Many users have stated they don't know how they can code and manage their databases without the SQL Assistant.

SQL IDE   Professional database development IDE  - Professional database development and management IDE supporting all major relational database systems.

Targets   Addons for many SQL and non-SQL development tools  - SQL Assistant integrates with many widely used database editors and database management and development environments including native tools that come with your database systems. It can also be used to database enable many universal code editors and used as a database development plugin.

SQL Assistant accelerates SQL development with context-aware code completion, schema browsing, real-time syntax validation, and many productivity tools across major database dialects. Highly customizable and extensible, it works well with both small and large database systems.

Key Features and Benefits

  • Supports 15 major database systems and their SQL dialects.
  • Triples database developer productivity.
  • Enhanced with integrated AI.
  • Improves code quality and accuracy.
  • Provides unmatched intelligent SQL code intellisense features; provides the most advanced SQL Intellisense available today with support for all types of DML and DDL statements, tables, joins, sub-queries, window functions and expressions, CTE expressions, with deep insights for temporary tables, indexes and constraints, advanced support for procedural objects and parameters, and much more.
  • Provides schema management tools supporting advanced database refactoring, For example, it enables converting regular tables to partitioned tables and back, literally with a click of a mouse, adding, dropping, changing, and reordering columns, all that while preserving the original table data.
  • Provides interactive SQL reference and SQL code assistance systems.
  • Provides advanced SQL code formatters and beautifiers; SQL syntax validation, code structure views for fast code navigation, and more...
  • Provides integrated database source code control interface.
  • Provides integrated real-time code syntax and spell checkers.
  • Provides integrated real-time code performance analyzer.
  • Provides multi-server code execution, scheduling, multi-server code and data search and replace.
  • Provides user extendable comparison engine for schema, database, jobs, and data comparison.
  • Provides integrated data import and export tools supporting multiple types of data sources, data formats, and database-to-database data transfers.
  • Provides integrated code and data generators, unit testing, and load testing framework.
  • Provides visual database modeling tools.
  • Integrates with many SQL and non-SQL editors.
  • Provides full featured professional multi-database development environment.
  • Can be easily installed without interrupting existing processes, and used immediately.

Pre-configured targets:

  • SoftTree SQL Editor IDE - professional database development environment for all supported database systems (installed with SQL Assistant)
  • SQL Server Management Studio 2008 to 2022 (a.k.a. 19.x), 20.x, 21.x, 22.x
  • SQL Server Management Studio Express
  • SQL Query Analyzer
  • SQL Server Enterprise Manager
  • Visual Studio for Database Professionals (DataDude)
  • Visual Studio .NET to 2026
  • Visual Studio C# Express, VB Express, C++ Express, Web Developer Express
  • Eclipse
  • IBM Data Studio
  • DBeaver
  • Delphi
  • DB Tools for Oracle
  • PL/SQL Developer
  • Oracle SQL*Plus
  • Toad for Oracle
  • Toad for MySQL
  • Toad for DB2
  • Toad for SQL Server
  • PowerBuilder
  • PostgreSQL pgAdmin III
  • Navicat
  • MySQL Workbench
  • HeidiSQL
  • Microsoft Access
  • UltraEdit
  • Notepad++
  • Notepad
  • ...Imagine your SQL editor here...

 

See What's New 14.x page for details on new features added in recent SQL Assistant releases.

Support Forum  - SQL Assistant Support Forum. This forum contains messages from people using SQL Assistant. Browse or search to find answers for your questions and join the discussion!

 

Other Information
Last stable version:
v14.0.90
Release Date: February 21, 2026
Setup file sqlassist_setup.exe SHA256 hash: 9acdec05d2999afb192f9af84fa11116f5898ba6e71798151a7688943213f97e

Technical specifications:

Disk space - 821 MB (for full installation), CPU - x86 or x64
OS - Windows
Supported database systems:
  • Oracle 10.x - 26.x
  • Microsoft SQL Server 2008 - 2025 (all editions)
  • Azure SQL Database 11.x - 12.x (formerly SQL Azure)
  • Azure SQL Data Warehouse (formerly Azure Synapse Analytics)
  • Snowflake 6.x - 10.x
  • PostgreSQL 8.4 - 18.x
  • Apache Hive 2.x - 3.x
  • Apache Cassandra 3.x - 4.x
  • Apache SparkSQL 2.3 - 3.x
  • DataStax Enterprise 6.x
  • DB2 UDB for LUW 7.x - 12.x
  • DB2 UDB for iSeries 5.x - 7.x
  • MySQL 5.x - 9.x
  • MariaDB 5.x - 11.x
  • SAP Sybase Adaptive Server Enterprise 12.x - 16.x
  • SAP Sybase SQL Anywhere 9.x - 17.x (formerly Adaptive Server Anywhere)
  • Amazon Redshift 1.x
  • Microsoft Access 2003 to Office 365 (11.x - 16.x)
  • Teradata 14.x - 17.x
  • IBM Netezza 7.x
  • Pivotal Greenplum 4.3.x - 7.x
  • SQLite 2.x - 3.x
  • MongoDB via Connector for BI 2.x
Database connections via Oracle native client (OCI), MySQL connector (libMySQL), MariaDB connector (libMariaDB), PostgreSQL native client (LibPQ), SMO, ODBC, ADO.NET, MongoDB Connector for BI, Wire drivers
SQL Assistant API is available
If you are software developer or integrator, you might be interested in using SQL Assistant as an embedded add-on for your product. Read more...
Download now Download v14.0 SQL Assistant v14.0 (226 MB) - full-featured version

PDF

On-line documentation v14.0 (23 MB, 700 pages)
See what's new in 14.x
Compare SQL Assistant editions Professional vs. Standard
Download v13.5 Looking for previous version 13.5?
Screenshots of popular development tools using SQL Assistant...   Screenshots for all major features can be found in the on-line documentation (see link above)
SQL Assistant's menu