SQL Code Assistant

Products: IntelliJ IDEA, RubyMine, WebStorm, PhpStorm, PyCharm, AppCode, Android Studio, 0xDBE

Vendor: Serhiy Kulyk



License: license url


SQL Code Assistant provides extended editing capability for SQL and PL/SQL code of the Oracle database.
With the SQL Code Assistant you are able to browse the objects, edit and execute SQL statements, navigate over the code, search for usages in the database schema or scripts on the File System.

The plugin uses lexer and parser generated by ANTLR tool, thanks to Terence Parr (,

Feature list:
  • Configurable syntax and error highlighting
  • Static code analysis
  • Context aware code completion
  • Viewing the structure of SQL and PL/SQL code
  • SQL and PL/SQL code formatting (experimental) (Ctrl-Alt-L)
  • Code Navigation
  • Quick object lookup (Ctrl-Shift-O)
  • Explain Plan (Ctrl-Shift-P)
  • Find Usages tables, views, columns, function, procedures, etc
  • Run SQL statement or PL/SQL block against active connection (Ctrl-Shift-M)
  • Database Schema Browsing
  • Set up database connection with plain JDBC URL or TNS Names, also SSH tunnel supported
  • Code Folding and bracket matching support
  • Code commenting

NOTE: Put SQL and PL/SQL files under some of source roots to have them indexed by the plugin.
Latest changes:
  • [KNOWN ISSUE] Case-sensitive table names, column names, etc are not supported for now
  • [KNOWN ISSUE] Initial indexing of numerous SQL files (1k and more) may take time

I appreciate comments, suggestions or bug reports, thanks in advance.
Downloads: 73765
Participated in rating: 8
Version Since Build Until Build File/URL Size (Kb) Date Details 133.100. 133.*. Download 13253.53 2014-08-01 13:02:08 details 134.100. 135.*. Download 13253.91 2014-08-01 13:01:14 details 120.1. 129.1999. Download 13249.5 2014-08-01 13:00:14 details 111.1. 117.*. Download 11198.52 2012-06-22 09:44:31 details 98. 107.*. Download 11126.08 2012-04-03 22:43:09 details 85.9500. 85.*. Download 6384.09 2009-10-15 13:35:14 details
. .
10 updates are hidden show all updates
Screenshot #14098
Screenshot #3056
Screenshot #3055
Screenshot #3927
Screenshot #3057
Screenshot #3386
Screenshot #3376
Screenshot #3130
Screenshot #3387
Screenshot #14054
Screenshot #12955
Screenshot #3375


2015-02-28 00:57:19
Is this plugin available for Intellij 14?
2014-11-12 20:28:44
I had the same error. However I was able to fix it by setting the IDEA_JDK_64 according to this:
2014-04-25 10:27:47
Hello! Please pay attention to the error connecting to database "Password contains not permissible characters". My password contains such characters: "!^#[*%[,'{ I ask to make changes in order to introduce them.
2014-03-21 09:36:49
Hello! It sounds like you run IDEA with Java6 on Mac OS X. To run plug-in you need Java7 or above.
2014-03-20 18:26:50
I've downloaded the latest version ( of the plugin but after restarting the application I keep getting error messages and I cannot figure out how to load the plugin. Is the latest version compatible with Intellij IDEA v13.1? Please, help. Plugin 'SQL' failed to initialize and will be disabled. Please restart IntelliJ IDEA. com.intellij.diagnostic.PluginException: com/deepsky/lang/common/PlSqlSupportLoader : Unsupported major.minor version 51.0 [Plugin: SQL] at at at ...
2014-03-18 15:42:37
Invaluable for working with PL/SQL
2013-12-08 11:53:02
Hello rbellamy, Jetbrain's guys are changing API often and drastically, it is a challenge to chase after them :) But anyway I am going to release the plugin for 13 version ASAP. I will appreciate if you could provide comments on the plugin or report bugs. Thanks, Serhiy
2013-12-07 01:11:49
Just wondering about an ETA for release 13?
2013-06-18 20:55:52
Hi Anonymous, I will appreciate if you could provide screenshots to understand what's wrong with dark themes. Thanks, Serhiy
2013-06-18 11:57:10
The color schema still look not good under darcula. Please try to improve it. Thanks
2013-06-17 09:04:34
Hi hopeng, the latest supported versions are 12.1.4 and IDEA 13 EAP
2013-06-12 06:36:43
Hi deepsky8, what's the latest Intellij version supported by this plugin? Thanks!
2013-06-08 18:01:55
Hello hopeng, 11.1.5 release is not supported.
2013-06-07 10:40:36
Hi, Does the SQL code assistant support intellilJ 11.1.5? It shows up in the “Browse plugin” list, I clicked it but intellij only downloads the plugin not installing it. So I find the downloaded zip in “.IntelliJIdea\system\plugins\” and install it manually. But after restart, it shows that the plugin is not compatible. Any idea?
2012-04-13 20:52:51

Can you try making the plugin dark-theme friendly like the popular Vibrant Ink for RubyMine. Maybe use cyan instead of blue. Or maybe just use the them colors for reserved words, comments, etc.

Otherwise great plugin. Thank you!