SQL Code Assistant
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 (firstname.lastname@example.org, email@example.com).
NOTE: Put SQL and PL/SQL files under some of source roots to have them indexed by the plugin.
HOW TO SETUP PUBLIC KEY AUTH FOR CONNECTION VIA SSH TUNNEL
For example you want to connect to the database on DB-ONE host which is not accessible directly from your host (SMITH). The standard way to resolve this issue is to use SSH tunnel via an intermediate or "jump" host which can access DB-ONE host. But you want to have database connection procedure to be as simple as possible without having to enter password on SSH authentication. To have this solved you have to use Public Key Authentication and below you can find an example how to generate Public/Private Key pair and setup Public Key Auth on the host jump.
#1. Create Public/Private Key pair
$ ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/home/user/.ssh/id_rsa):
Enter passphrase (empty to have no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/username/.ssh/id_rsa.
Your public key has been saved in /home/username/.ssh/id_rsa.pub.
The key fingerprint is:
#2. Create .ssh folder on jump server, if it already exists, skip this step
ssh b@jump mkdir -p .ssh
#3. Append username's new public key to b@jump:.ssh/authorized_keys
cat .ssh/id_rsa.pub | ssh b@jump 'cat >> .ssh/authorized_keys'
#4. Specify public key (/home/username/.ssh/id_rsa.pub) in the Connection Setting dialog to enable Public Key Authentication for connection with SSH tunnel.
See more details on setting up Public Key Auth here: http://www.linuxproblem.org/art_9.html
I appreciate comments, suggestions or bug reports, thanks in advance.
Full documentation URL: https://github.com/deepsky/SQL-Code-Assistant-/wiki
6 updates are hidden show all updates
Recent change notes: