Directory of Tools Resources

Home > Computers > Programming > Languages > Java > Databases and Persistence > Tools

Open source database tools for administering and/or executing SQL on a database.

Resources in This Category

• Aqua Data Studio

  http://www.aquafold.com/
  An SQL editor and development tool that allows developers to create, edit, and execute SQL scripts, as well as browse database structures. [Commercial]

• Cache Monitor

  http://www.cachemonitor.de/
  An SQL development tool only for InterSystems database Cache that allows explore and manage database objects as well as execute own ad-hoc queries.

• DB Solo

  http://www.dbsolo.com/
  A database development and management tool for developers and admins. DB Solo allows you to explore and manage database objects as well as execute ad-hoc queries. It runs on Windows, Solaris and Linux and supports Oracle, MySQL, Sybase and MS SQL Server. [Shareware]

• db2db

  http://db2db.sourceforge.net/
  An application to transfer tables and data among heterogeneous relational databases. Written in Java and using JDBC, it is fully database-independent. It should work for any RDBMS with a suitable JDBC driver. [Open Source, GPL]

• Fredy's Admintool for SQL

  http://www.trash.net/~ffischer/admin/index.html
  GUI admin tool for JDBC databases. Allows querying (guided or plain SQL), meta-querying, Java code generation. [Open Source, GPL]

• instantOLAP

  http://www.instantolap.com/
  A powerful lightweight reporting and virtual OLAP tool, completely web-based and written in the Java programming language. [Commercial]

• iSQL-VIewer

  http://isql.sourceforge.net/
  An SQL browser tool that works with any JDBC 2.0 or higher driver. [Open Source, MPL]

• JasperAssistant

  http://www.jasperassistant.com/
  A visual report designer tool for JasperReports, a popular open-source reporting engine. It is built on top of the Eclipse's plug-in architecture and its main goal is to help create JasperReports report definition files through a simple graphical interface. [Shareware]

• Java Reporting Tools

  http://www.javareports.info/
  A short review of known Java reporting tools.

• JFaceDbc

  http://sourceforge.net/projects/jfacedbc/
  A JDBC client application written in Java that allow to view the structure of a JDBC compliant database, issuing SQL commands. The GUI is based on JFace and SWT libraries from the Eclipse Project. JFaceDbc can run as a stand-alone application or as an Eclipse plugin. [Open source, LGPL]

• JReport

  http://www.jinfonet.com/
  A pure Java report writer, creates sophisticated reports, graphs, RTF texts, crosstabs, sub-reports, and drill-down. Access data from JDBC, ODBC or another source with an API. The WYSIWYG designer, server and viewer are also available in Beans. [Commercial]

• Melati

  http://melati.org/
  A generic Web-based database administration system, a rapid templating mechanism, using "templets" (sub-templates) provides an easy mechanism for rendering persistent objects as interface elements. It is fully integrated with Java persistence layer over any JDBC compliant DB.

• myTextReport

  http://sourceforge.net/projects/mytextreport/
  Creates flexible reports from mySQL databases in any ASCII-based format, like HTML, RTF, TEX, Postscript, VRML... whatever. Just edit a template-file and insert special-coded, even relational SQL-statements. [Open Source, GPL]

• NLBean

  http://www.markwatson.com/opensource/#nlbean
  "Natural language" interface to databases. Allows simple human language queries, rather than requiring the user to use SQL or fill in forms. [Open Source, Artistic License]

• QueryForm Database Utility

  http://qform.sourceforge.net/
  A powerful GUI front end for relational databases. It creates forms on-the-fly through which tables can be queried or updated. [Open source, GPL]

• ReportMill

  http://reportmill.com/
  A Java developer tool for dynamically generating reports and web pages from Java applications in formats such as PDF, HTML, Flash, Excel.

• ReportWeaver

  http://www.qint.de/
  An object oriented report writer/generator for applications written in Java. [Commercial]

• RReport Visual Builder

  http://www.java4less.com/print_java_e.htm
  Reporting tool for java. It can preview , print and export reports to PDF and DHTML. It can retrieve data from databases using JDBC.

• SQL Developer

  http://sqldeveloper.solyp.com/
  A SQL administration and development frontend with a graphical user interface. It is written completely in Java and runs on virtual machines supporting Java 1.3 or higher.

• SQL2JAVA

  http://sql2java.sourceforge.net/
  Introspects database schema and generates all the needed java code to access it. No XML, no manual mapping, no complex architecture, no hand coded queries. [Open source, LGPL]

• SQLClient

  http://www.trustice.com/java/sqlclient/
  A simple SQL client with profiles of host/user/db combinations. It allows multiple JDBC drivers, browsing databases, as well as query and update. [Open Source, GPL]

• SQuirreL SQL Client

  http://www.squirrelsql.org/
  Java GUI program that allows viewing the structure of a JDBC compliant database, browse the data in tables, and issue SQL commands. [Open Source, LGPL]

• SWTJasperViewer

  http://www.jasperassistant.com/jasperviewer.html
  A JasperReports viewer component for SWT/JFace based applications and Eclipse plug-ins. [Open source, LGPL]

Related Categories

• Home > Computers > Programming > Languages > Java > Development Tools
• Home > Computers > Programming > Languages > Java > Applications

 

Home > Computers > Programming > Languages > Java > Databases and Persistence > Tools

 

---

 

Thanks to DMOZ, which built a great web directory for nearly two decades and freely shared it with the web. About us