SQL Query Plugin

Compatible with  IntelliJ IDEA
18.11.2006
169 269

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

Download plugin

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
11.02.2014
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).
03.02.2014
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.
13.12.2013
still the best for exploring dbs in IntelliJ 13
Anonymous
25.09.2013
Would be nice to see some options to change the syntax highlighting manually. Otherwise works flawlessly
02.03.2011
A very good plugin. Possible to add autocomplete to SQL keywords?
23.02.2011
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
19.08.2010
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
11.11.2008
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
05.11.2008
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
19.05.2008
Nice work.
Anonymous
13.12.2007
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 :(
Anonymous
27.07.2007
I love it.
23.05.2007
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.
Anonymous
19.04.2007
It had a problem with version 6. Till then it was wonderful.
Anonymous
26.01.2007
很好的插件
Please  sign in  to leave a comment.