Authors:
deepsky8

SQL Code Assistant

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

Vendor: Serhiy Kulyk

Email:

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

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 (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.
Latest changes:
  • Completion wizards for TABLE/PROCEDURE/FUNCTION/PACKAGE
  • [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.
Version 1.6.1.133
Downloads: 75593
Rating:
Participated in rating: 8
Version Compatible builds Date
1.6.1.133 133.100 — 133.* 01.08.2014 Download
1.6.1.135 134.100 — 135.* 01.08.2014 Download
1.6.1.129 120.1 — 129.1999 01.08.2014 Download
1.3.0.11 111.1 — 117.* 22.06.2012 Download
1.2.2.10 98 — 107.* 03.04.2012 Download
0.8.1.8 85.9500 — 85.* 15.10.2009 Download
10 updates are hidden show all updates
Screenshot #3386
Screenshot #3927
Screenshot #3130
Screenshot #14054
Screenshot #3056
Screenshot #3376
Screenshot #14098
Screenshot #3057
Screenshot #3387
Screenshot #3375
Screenshot #12955
Screenshot #3055