Authors:
stist
xylo
opensource software

SQL Query Plugin

Products: IntelliJ IDEA

Vendor: KiwiSoft

Email:

Website: http://java.sstiller.de/sql/index.html

SourceCode: SQL_Query_Plugin_228.zip

License: license url

Bugtracker page

Description:

A tool for executing SQL statements through a JDBC connection.

Features:

  • Syntax highlighting
  • Executing multiple statements at once
  • Highlighting of primary and foreign keys
  • Editing of results
  • Support for easier configuration of common JDBC driver
  • Support of different column formats (including custom formats)
  • Browser for database structure
  • Statement templates for often used statements
  • Support for Java BLOB's
  • Export into XML, HTML, CSV and Excel
  • Data Load

Downloads: 154623
Rating:
Participated in rating: 27
Version Since Build Until Build File/URL Size (Kb) Date Details
2.2. 40.3436. . Download 1730.71 2006-11-18 19:56:38 details
1.4.6. 40.1100. . Download 2005-11-05 16:20:54 details
1.4.1. . . Download 1095.23 2004-10-01 21:09:55 details
. .
9 updates are hidden show all updates
Screenshot #2

Recent change notes:

Bugs
  • [SQLQ-13] - Plugin not working on Mac
  • [SQLQ-15] - Editing of date columns doesn't work
Cosmetics
  • [SQLQ-4] - Output messages are sometimes in the wrong order
New Features
  • [SQLQ-1] - Import of data files
  • [SQLQ-6] - Add support for Microsoft SQLServer 2005 Driver
  • [SQLQ-16] - Allow relative dates for table date editors.
  • [SQLQ-17] - Add viewer for image BLOB's

Comments:

123>
xylo
2014-02-11 19:44:35
The plugin throws an exception when I try to add a JDBC driver in the latest IDEA EAP release. I wanted to report this bug, but unfortunately the bug tracker is not available anymore (404).
.
cliff76
Rated:
2014-02-03 03:44:36
Great plugin! I have a fix to get it working on the latest Idea CE 13. The latest version throws errors when you try to add/define a custom JDBC driver.
.
david_beutel
Rated:
2013-12-13 05:14:15
still the best for exploring dbs in IntelliJ 13
.
Anonymous
Rated:
2013-09-25 21:27:43
Would be nice to see some options to change the syntax highlighting manually. Otherwise works flawlessly
.
hamidrjafari
Rated:
2011-03-02 15:31:33
A very good plugin. Possible to add autocomplete to SQL keywords?
.
hamidrjafari
2011-02-23 16:15:26
Hi,

I am beginning to use the plugin. I am new to database design also. I need the conection string to look like:
jdbc:oracle:thin:@HOST:1521/SID
but the plugin here I see produces:
jdbc:oracle:thin:@HOST:1521:SID

Where should I change a setting or what might be the problem?

Aside I think it should score high. An early user I am.
.
Anonymous
Rated:
2010-08-19 20:10:33
Great plug-in!!. Seemed to work for a couple of DB's I entered. However, recently after adding some more DB's I get the error "The DialogWrapper" can only be used on event dispatch thread. Is anyone else seeing this?
.
Anonymous
Rated:
2008-11-11 03:19:47
It's working on 7.0.4 bug is problematic in different ways. Would be nice to fix. Would have rated it a positive "4" if all those were fixed. Meanwhile I started looking for alternatives in standalone / open source.

1. The Home/End buttons are going to begining/end of text instead of line (as mentioned before)

2. A long running query could hang the IDE and not only the plugin. (*)

3. Sometimes undo does not work. Don't have an exact scenario.

Squirrel is my alternative first attempt, works so far, not the cleanest usability but just ok.
SQL queries should really be an integral part of the IDE - IntelliJ team - pick this up and either write sql support from scratch or integrate Squirel or whatever is the best open source out there. Don't leave it to the mercy of a plugin developer - not good for the effectiveness of the tool nor your business. You should probably aim at making SQL queries a "5" rating for every intellij user - same as the overall IDE usually is.

(*) I do use a very heavy project with > 20k classes and lots of jsps/jars, overall installable after jsp pre-compilation + classes + jars is ~200MB; Not sure how much of the overall heaviness of the project is in play here.
.
Anonymous
2008-11-05 13:44:44
Just installed it with IntelliJ 7.0.4. DB Connection works, but when I expand 'Procedures' on a database, it hangs IntelliJ.

Reverting to dbHelper...
.
Anonymous
Rated:
2008-05-19 12:09:54
Nice work.
.
Anonymous
Rated:
2007-12-13 07:18:41
I love this plugin, but can not use it with Idea 7.0.1&2, as Home and End buttons do not work properly: pressing Home moves the cursor to the end of text, rather than line. It is so irritating, if you use “run selected” mode! I believe, this happens to all the plugin windows, though. Staying with version 6 :(
.
suedkm
Rated:
2007-12-06 13:21:36
.
Anonymous
Rated:
2007-07-27 22:12:46
I love it.
.
mjparme
Rated:
2007-05-23 21:02:04
I use DBVisualizer so this plugin isn't that useful. I suppose it is a good solution if you don't want to use DbVisualizer.
.
chrisbartley
Rated:
2007-05-11 23:54:06
.
123>