Authors:
deepsky8
BSD

SQL Code Assistant

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

Vendor: Serhiy Kulyk

Email:

Website: https://github.com/deeps...SQL-Code-Assistant-/wiki

License: license url

Description:

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 (parrt@cs.usfca.edu, parrt@antlr.org).

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.

The latest changes:
  • Support completion for ALTER TABLE statement
  • [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

Version 1.5.11.129

I appreciate comments, suggestions or bug reports, thanks in advance.
Downloads: 50244
Rating:
Participated in rating: 6
Version Since Build Until Build File/URL Size (Kb) Date Details
1.5.11.129. 120.1. 129.1999. Download 13178.07 2014-04-13 22:50:21 details
1.5.11.133. 133.100. 133.*. Download 13181.88 2014-04-13 22:43:17 details
1.5.11.135. 134.100. 135.*. Download 13181.81 2014-04-13 22:42:19 details
1.3.0.11. 111.1. 117.*. Download 11198.52 2012-06-22 09:44:31 details
1.2.2.10. 98. 107.*. Download 11126.08 2012-04-03 22:43:09 details
0.8.1.8. 85.9500. 85.*. Download 6384.09 2009-10-15 13:35:14 details
. .
11 updates are hidden show all updates
Screenshot #3130
Screenshot #3376
Screenshot #3927
Screenshot #3375
Screenshot #3055
Screenshot #14054
Screenshot #3057
Screenshot #3056
Screenshot #3386
Screenshot #12955
Screenshot #14098
Screenshot #3387

Recent change notes:

  • 1.5.11.129
      - [NEW] Support completion for ALTER TABLE statement
      - [NEW] Support error logging clause
      - [FIX] Fixes in completion
  • 1.5.9.129
      - [NEW] More support on completion: SELECT JOIN, etc
      - [NEW] Parsing RESULT_CACHE construction
      - [FIX] "member" can be a name of table/view
  • 1.5.6.12
      - [NEW] Refactoring of completion (implemented base cases for now)
  • 1.4.9.12
      - [NEW] Highlight errors in string literal
      - [FIX] SQL files were not indexed on changes in Settings
      - [FIX] NPE in Structure View in case of invalid file
      - [FIX] Validation fixes
  • 1.4.8.12
      - [NEW] Public Key authentication for SSH tunnel
      - [FIX] StringIndexOutOfBoundsException issue
      - [FIX] DB Connection Editor dialog
  • 1.4.7.12
      - [FIX] GoToDBObject does not show objects with the same names
      - [FIX] Indexing of SQL files
      - [FIX] Data export to CSV format
      - [KNOWN ISSUE] Case-sensitive table names, column names and so on are not supported for now
  • 1.4.6.12
      - [NEW] Added support for "Enter within comments"
      - [FIX] SQL and PL/SQL file indexing
      - [FIX] Some change in syntax highlighter to support Darcula color scheme
      - [FIX] Data export to CSV format
      - [FIX] Parser and formatter for REVOKE and GRANT statements
      - [KNOWN ISSUE] Case-sensitive table names, column names and so on are not supported for now
  • 1.4.5.12
      - [NEW] Add support for RENAME TABLE statement, parsing, execution, code completion, etc
      - [FIX] Enhanced support for GRANT statement
      - [FIX] Performance improvement in the parser
      - [FIX] Code formatter changed case of names in double quotes
      - [KNOWN ISSUE] Case-sensitive table names, column names and so on are not supported for now
  • 1.4.4.12
      - [NEW] Initial support for Materialized Views (parsing and highlighting)
      - [FIX] Some fixes in the parser
      - [FIX] Syntax highlighting is broken on empty file
      - [FIX] Enable parser to support DB links for %TYPE and %ROWTYPE
      - [FIX] Bring back lost icons for buttons in Connection Settings dialog
      - [KNOWN ISSUE] Case-sensitive table names, column names and so on are not supported for now
  • 1.4.2.12
      - [KNOWN ISSUE] Case-sensitive table names, column names and so on are not supported for now
      - [NEW] Access to remote database via SSH (port forwarding)
      - [FIX] Refresh session button does not work
      - [FIX] Errored syntax failes syntax highlighting
      - [FIX] Slash failes parsing
  • 1.4.1.12
      - [NEW] TNSNAMES.ORA files can be used to establish connection to a database
  • 1.4.0.12
      - [NEW] Show Explain plan for SQL statement
      - [NEW] Support ALETR INDEX statement
      - [FIX] Hangs up on cancelation of running SQL
  • 1.3.1.12
      - [FIX] Some fixes in the parser
  • 1.3.0.11
      - [NEW] Added configuration of Colors & Fonts
      - [NEW] Autompletion of ":=", "||", SQL cursor attributes (PL/SQL), etc
      - [NEW] Support of the quoting mechanizm in PL/SQL appeared in 10g
  • 1.2.2.11
      - [FIX] Allow hyphen character in DB host name, example: 'host-101.com'
      - [FIX] DatabaseBrowser is not properly updated on ALTER TABLE request
  • 1.2.1.11
      - [FIX] Handling changes of File Type extensions
      - [FIX] Find Usages for names in double quotes
      - [FIX] Parsing
  • 1.2.0.11
      - [NEW] Code formatter added

Comments:

1234>
deepsky8
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.
.
Anonymous
2014-03-20 18:26:50
I've downloaded the latest version (1.5.9.135) 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 com.intellij.ide.plugins.cl.PluginClassLoader.b(PluginClassLoader.java:130) at com.intellij.ide.plugins.cl.PluginClassLoader.a(PluginClassLoader.java:77) at com.intellij.ide.plugins.cl.PluginClassLoader.loadClass(PluginClassLoader.java:66) ...
.
Anonymous
Rated:
2014-03-18 15:42:37
Invaluable for working with PL/SQL
.
deepsky8
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
.
rbellamy
2013-12-07 01:11:49
Just wondering about an ETA for release 13?
.
deepsky8
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
.
Anonymous
2013-06-18 11:57:10
The color schema still look not good under darcula. Please try to improve it. Thanks
.
deepsky8
2013-06-17 09:04:34
Hi hopeng, the latest supported versions are 12.1.4 and IDEA 13 EAP
.
hopeng
2013-06-12 06:36:43
Hi deepsky8, what's the latest Intellij version supported by this plugin? Thanks!
.
deepsky8
2013-06-08 18:01:55
Hello hopeng, 11.1.5 release is not supported.
.
hopeng
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\sql_assistant.zip” and install it manually. But after restart, it shows that the plugin is not compatible. Any idea?
.
roy_roy
Rated:
2012-04-13 20:52:51
Hello,

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!
.
deepsky8
2012-04-03 10:33:19
Hi Kun_Yue,
You are absolutely right, the host name was not accepting hyphen character ("-"). Now i have fixed it, going to upload plugin with the fix today or tomorrow.

Good catch, thank you!
.
Kun_Yue
2012-04-03 01:40:25
just tried the latest update.

use the same host name:
rac03-100-scan.isg.mycompany.com

got validation error: "Host parameter contains not permissible charaacters"

it seems that it's not happy with "-" now
.
Kun_Yue
2012-02-23 02:19:40


Hi deepsky8,

I made one more try...
I checked our Oracle version is 11.2.0.1.0
Therefore I copied ojdbc6-11.2.0.1.0.jar from my local Maven repository, which is used by IntelliJ "Data Sources" tool-window, and replaced ".IntelliJIdea11\config\plugins\sql_assistant\lib\ojdbc5.jar"


The same error pops up:
Could not establish connection: Listener refused the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching protocol stack

thanks,
Kun
.
1234>