Configuring Oracle SQL Developer for PostgreSQL

I see that some people wonder if Oracle SQL Developer can be used with PostgreSQL. I wrote a blog post to show how you can configure Oracle SQL Developer to connect Microsoft SQL Server and MySQL. You can use the same method to configure SQL Developer for PostgreSQL. First we need to download a compatible JDBC driver from PostgreSQL site. Latest version of SQL Developer uses JDK 1.7, so we can download the JDBC41 Postgresql Driver:


Then we open Oracle SQL Developer, open preferences, database section and third party JDBC driver.


Click “Add Entry” button, pick the JAR file you downloaded, click OK to make it enabled.


Now you can defined connections for PostgreSQL databases and connect them. You’ll see that only basic features work (such as running queries). I encountered problems even when browsing indexes but it’s better than nothing.

Please share
  • 6

AWS Big Data Specialist. Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g. Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress. Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community. Founding member, and vice president of Turkish Oracle User Group (TROUG). Presented at various international conferences including Oracle Open World.


  1. Merhaba Gökhan Bey,

    Gerçekten çok faydalı oldu, teşekkür ederim. postgreSQL ile güzel bir tool arayışındaydım. en azından bildiğimiz bir developer tool ile postgreSQL ile çalışmak çok güzel bir duygu

  2. mehmetsülün


    4.0.2  ve 4.0.3 sürünüyor  ben  açamadım  çok yavaş  sizdede  durum  aynımı acaba?

    • Murat

      Mehmet kardeş yabancı forumlarda da araştırdım benzer sorunlar yaşanmış. Çözüm olarak da Oracle SQL Developer 3.2 kullanın diyorlar. 3.2 çok iyi çalışıyor.

  3. Pingback: Configuring Oracle SQL Developer for PostgreSQL » DbRunas

  4. Manoj


    Do you know how to access Teradata using SQLDeveloper. I downloaded jar file and is still showing error?



    • Gokhan Atil

      Hi Manoj,

      I don’t have access to any Terradata box. If Terradata still provides a demo VM, I may try it. What kind of error do you get?

  5. amihay gonen (@agonen)

    Do you know if sqldeveloper can auto complete table names of fields for postgres data source ?

    • Gokhan Atil

      Amihay, as I know it can’t and as I heard, it will not be able to do it in near future 🙂

    • Gokhan Atil

      Yes, Oracle SQL Developer team is not planning to support PostgreSQL.

  6. Thiro

    Hi Gakhan,

    I have SQL Developer 3.2 installed and I have JAVA_HOME set to jdk 1.7

    I used postgresql-9.3-1103.jdbc41.jar, but  SQL developer didn’t populated the PostgreSQL tab to make the new connection.

    Could you please shed some light on the issue.

    Many thanks.





  7. Suhas

    Hello Gokhan

    Thanks for this post. Just wanted to add that for JDK 1.8, one would need to use the JDBC42 version of the Postgres JDBC driver.

  8. Marcelo Santana

    Hi Gakhan,

    I have SQL Developer 4.1 installed and postgresql-9.3-1103.jdbc3.jar, but SQL developer didn’t populated the PostgreSQL the label “Choose database”.

    Inform the remote address but what to do to load the databases?

    They are not listed.


    Thank’s for help


    Marcelo Santana

    • Marcelo Santana

      There is an alternative, performing the modification of the saved connection, through the connections.xml file.

      1 – Save the connection to PostgreSQL in SQL Developer to add connection information in connections.xml by filling in the fields;
      2 – open the connections.xml file (~/.sqldeveloper/system4. o.jdeveloper.db.connection.
      3 – find added entry and add the database in line
      Old: jdbc:postgresql://host123:5432/
      New: jdbc:postgresql://host123:5432/database
      4 – Close and open SQL Developer to load the information added to the connections.xml file.

  9. Raj Shivraman

    Thanks! That really helped me a lot in getting this done. Truly appreciate the helpful instructions.

  10. Livia

    Hi Gokhan,

    I have SQL Developer installed and postgresql-9.4.1208.jre7.jar, but SQL developer didn’t populated the PostgreSQL the label “Choose database”.

    Inform the remote address but what to do to load the databases?
    The database is PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-11), 64-bit
    They are not listed.

    Thank’s for help

    Livia Souza

  11. Ling

    Hi Gokhan,
    We have a PostgreSQL DB built on a cloud platform. And we need to replicate data (under one entire schema) from that PostgreSQL DB to our Oracle DB. What tool/method can be used for that connectivity?

    That is, we’d like to know how to connect a cloud DB to an Oracle DB.

    Thanks in advance for your help!

  12. Revathi

    I connect postgresql db through sql developer. Function,Procedure objects are not showing.

    • Gokhan Atil

      Hi Revathi, Oracle SQL Developer does not support all features of PostgreSQL and as I know there’s no plan to support PostgreSQL in future.

Leave Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.