130

Is there any simple SQL editor in Eclipse? Or do I need to find a simple SQL editor plugin for Eclipse?

By simple I mean, the editor does NOT connect to any DB, does syntax highlighting and preferably formatting sql is a bonus.

chars
  • 343
  • 3
  • 10
nimcap
  • 10,062
  • 15
  • 61
  • 69
  • This is what you are looking for: http://www.gstaff.org/colorEditor/ – rtxndr Dec 24 '15 at 11:57
  • As the time of the creation of the question were the requests for a software not yet forbidden. The question should be set to a "historical significance only", and not closed. Thus, I voted to reopen. – peterh Apr 01 '16 at 10:47
  • Since 2019-03-14 there is standalone and very simple plugin available at eclipse marketplace: https://marketplace.eclipse.org/content/sql-editor - it's just for editing SQL files, syntax highlighting and contains an experimental sql formatter. So exactly what was asked for. – de-jcup Apr 07 '20 at 07:49

6 Answers6

144

for reference to add sql syntax highlighting / coloring to eclipse you can install Data tools platform extender sdk from "install new software", under Database Development

or enter site location directly http://download.eclipse.org/datatools/updates

Jessdevelop
  • 25
  • 4
Ben K
  • 1,456
  • 1
  • 10
  • 2
  • 1
    simple as it's needed :) – kuba Mar 30 '11 at 08:56
  • 2
    "Data tools platform extender sdk" contains a SQL Editor with Syntax Highlighting which works great for me. +1 Ben K – Jonas Söderström Sep 01 '11 at 08:53
  • Very good! I was also looking for some simple highlighting of SQL... and the SQL Explorer just didn't work was expected (buggy and heavy to load). This just made the trick I was looking for! Thanks a lot! – bruno.braga Dec 12 '11 at 03:28
  • 8
    By default (on Kepler, at least), this plug in opens SQL files using the SQL File Editor, which includes connection bloat. It does also include SQL Editor, which is the lightweight version, that you can easily set as the default editor. –  May 02 '14 at 18:40
  • update site: http://download.eclipse.org/datatools/updates/ – Eric Dec 10 '14 at 14:08
  • 1
    It seems to be garbage. It's not clear which dialect is supported, but I have a feeling that only the very basic is part of this plug-in (plus some irrelevent features which I can't use). Also it doesn't highlight trigger or PL/SQL related keywords. – Bartis Áron Sep 08 '17 at 11:14
  • Working link: https://marketplace.eclipse.org/content/sql-development-tools – KimchiMan Jun 23 '18 at 21:53
  • Please refer updated : http://www.eclipse.org/datatools/downloads.php (Oxygen : http://download.eclipse.org/datatools/1.14.1.201712071719/repository/) – gubs Nov 08 '18 at 11:52
  • 1
    @All - http://download.eclipse.org/datatools/updates - This link doesn't work at all now. – PAA Jul 04 '19 at 11:07
23

This Eclipse SQL Editor seems very lightweight. It only does syntax highlighting and provides an outline view. As of now the author is planning to eventually add code folding and completion, but those two features are still on the todo list.

Jacob van Lingen
  • 8,989
  • 7
  • 48
  • 78
sam2themax
  • 1,068
  • 3
  • 10
  • 14
  • I tried both others mentioned in answers here and both were bloated, slow, and worst of all, didn't work at all for me. This one is tiny, a breeze to install, and just works. Bravo. – Adam Tuttle Feb 22 '11 at 15:30
  • 1
    How do I install this plug-in? So far I have tried copying http://blog.debertshaeuser.com/uploads/com.debertshaeuser.sql.SQLEditorPlugin_1.0.0.jar to %eclipse%/dropins, %eclipse%/plugins, %eclipse%/dropins/plugins and %eclipse/dropins/SQLEditor/eclipse/plugins but SQLEditor does not show up in the list of installed plug-ins. I am using Eclipse Galileo version 20100218-1602 – Miserable Variable Mar 27 '11 at 06:09
  • If you too are unable to install the plugin then take a look at http://stackoverflow.com/questions/6223969/unable-to-install-eclipse-plugin-eclipse-sql-editor/6239567#6239567 – Miserable Variable Jun 06 '11 at 06:23
  • 2
    copy the .jar-file into the eclipse/plugin/ folder and after restarting eclipse, .sql-files are connected to this editor. (eclipse indigo) – sinini Jun 20 '12 at 11:56
  • If you're looking for auto-indentation and syntax highlighting in a light editor, this fits the bill perfectly. Many thanks for the recommendation. – KomodoDave Aug 20 '12 at 11:39
10

Use Toad eclipse-extension (community edition), you will get almost everything you want in an SQL editor. Search for 'toad' in eclipse market place. It has very good Oracle, MySQL and PostgreSQL support.

Take a look at Installation instructions and screenshots.

Alternatively, there is DBeaver (very good in my experience and support almost all DB's) which is built on eclipse platform and available as standalone and eclipse plugin.

sojin
  • 4,527
  • 2
  • 37
  • 40
7

The eclipse SQLExplorer plugin seems light enough, and comes with a basic SQL editor (but no "format" option):

alt text

The official DTP DataTool Project is much complete, but have also its own editor:

DTP Editor

VonC
  • 1,262,500
  • 529
  • 4,410
  • 5,250
  • SQLExplorer is the nicest SQL plugin I have found so far, and it's pretty lightweight. However, it only does syntax highlighting when you are connected to a DB. –  Jan 23 '15 at 09:55
4

QuantumDB is also a lightweight option that I really liked.

http://quantum.sourceforge.net/

Shantanu Kumar
  • 1,240
  • 1
  • 12
  • 14
3

Just found DBeaver : http://dbeaver.jkiss.org/

looks good, plenty of features, support mssql (which I need in the moment :) ... I'll give it a try ...

apocalypz
  • 1,180
  • 1
  • 8
  • 11
  • DBeaver is great for people wanting to have a full DB tool. But as a plugin it has some different behaviours to standard eclipse (e.g. its SQL editor does handle standard shortcuts like CTRL + SHIFT + UP different) . Also the toolbar is extreme changing when scope changes to sql parts - at least for myself it make much "noise". So I use DBeaver standalone and use `SQL Editor` plugin (see https://marketplace.eclipse.org/content/sql-editor ) inside eclipse for SQL files. It's lightweight and works fine. – de-jcup Nov 13 '19 at 09:37