another database interface tool built with Java. Adit is meant to be a lightweight tool for querying a database. Some of the current features include: Connect to any database with a JDBC driver, Save query results to a delimited file, Save and restore SQL statements to disk
The goal of this project is to develop a relational database with infinite tables as functions. The database model is an extension to Codd's relational model.
Apache Derby is a full-featured, open source relational database management system (RDBMS) that is based on Java and SQL. Read more
The Apache Jackrabbit is an open source content repository for the Java platform. It is a fully conforming and featured implementation of the Content Repository for Java Technology API
a database designed from the ground up to store XML data or what is more commonly referred to as a native XML database
Aqua Data Studio
a SQL editor and developer tool that allows developers to easily create, edit, and execute SQL scripts, as well as browse database structures. Aqua Data Studio provides an integrated database environment with a single consistent inferface to all major relational databases. This allows the DBA or developer to tackle multiple tasks simultaneously from one application
Archive4J is an archive engine for large document collections written in Java, i.e. a set of algorithmic tools and implementations that make it possible to build a direct index of a document collection. In particular, for each document some basic data can be recovered, such as the length of the document in words, the list of distinct terms appearing in the document, and the number of occurrences of each term in the document (the count). Goals include a very high compression rate and very fast random access. To obtain this result, Archive4J combines techniques typical of search engines with succinct data structures.
Ashpool XML Database
Ashpool XML Database is a lightweight XML Database written in Java. It's goal is to use standard SQL92 syntax to query, add, update, and delete XML documents via a JDBC driver. The XML documents must hold to a table like structure. The reason for the table structure restriction is that SQL was designed to query table data not hierarchical data.
Avalon SQL Editor
Avalon SQL Editor is a powerful database/SQL editor with code completion, syntax coloring, word casing, and many more features.
Axamol SQL Library
executes SQL statements stored in external library files from Java code, with named parameters. Separating SQL and Java code increases readability, eases maintenance, and allows separate testing and documentation
a lightweight, scalable, modular and complete relational database system in Java, including full SQL and JDBC compliance, in-process and client/server operation and fully in-memory or persistent data
BaseX is a native XML database system and efficient XQuery/XQuery full-text processor. It features compact storage structures and a visual frontend, facilitating interactive access to very large XML instances.
a Java-based application used to access databases through JDBC. It features a Swing-based GUI and includes capabilities useful to developers when testing SQL statements against a database. It also produces timing information, which is valuable during tuning exercises
bddshell is a command line program for deductive database-based analysis. Its primary focus is software vulnerability detection. It acts as a front-end to a number of other programs, such as bddbddb and joeq.
for managing BibTeX (.bib) databases. Bibkeeper is intended to have a user-friendly graphical interface, and runs on all platforms for which the Java Virtual Machine is available
BoneCP is a fast Java database connection pool (JDBC pool) similar to C3P0 and DBCP but with a strong emphasis on performance.
Breeze XML Binder
(commercial) a complete Java/XML data binding solution available. Whether you start with XML Schema, XML DTD, a relational database table view, or just a simple XML document ... you can quickly create production quality Java classes that encapsulate all of the marshalling, validation, and manipulation of your XML
Bufonidae is a database query tool inspired by TOAD and implemented as a Java application. It should work with all databases that support JDBC.
Caché Monitor is an SQL development tool designed for InterSystems database Caché. It supports developers with features like an advanced SQL Query Editor with Caché-SQL Syntax highlighting, SQL Code completion, SQL History buffer for executed SQL commands, SQL Code formatting, an graphical SQL execution plan, SQL abbreviations and many more.
CegoAdm is a front end for administration of the Cego database system. It supports all required administrative operations.
cegojdbc implements the JDBC driver for the Cego database system. a Java 1.5 runtime environment is required.
a database cluster middleware that allows any Java application (standalone application, servlet or EJB container, ...) to transparently access a cluster of databases through JDBC
CMDBuild is an open source web application designed to model and manage a custom database of assets and design related workflow processes. The purpose of this software is to enable operators to have full control of the assets, knowing their composition, location, functional relations and the changes over time. Read more
(commercial) optimized for EJB and Java, solves the Object to Relational impedance mismatch. It virtually eliminates the need to hand-code database access for EJB and Java Applications
ComtorDAO is a Data Access Object system. Its uses reflexion to map objects to tables. It implements insert, delete, update, and find actions.
Craftsman Spy is an open source and free framework for JDBC logging. It is a JDBC driver implementation. This logger logs all SQL connection and processings with execution spent time, all the stored procedures with arguments, all the batch processings and the result sets.
(commercial) Daffodil DB is a SQL-99 specification compliant, capable, reliable, scalable, high-performance, embeddable, lightweight java-based relational database engine. Daffodil DB supports almost all constructs of SQL 99.
Daffodil Replicator is a data replication tool that allows bi-directional data replication between heterogeneous databases supporting JDBC drivers. Its flexible publish-and-subscribe model supports both snapshot and merge replication.
Data Storm is a database browser that can be embedded in Java code. It is intended to be used within tests to allow you to inspect why database dependent tests are failing. It uses SWT for speed and native look and feel.
DataBase Java Console
a console program that allows people to query a database with predefined SQL queries
DatabaseToUML reverse engineers a database schema from an existing relational JDBC database.
benerator is a framework for creating realistic and valid high-volume test data, used for testing (unit/integration/load) and showcase setup. Metadata constraints are imported from systems and/or configuration files. Data can imported from and exported to files and systems, anonymized, or generated from scratch. Domain packages provide reusable generators for creating domain-specific data such as names and addresses, internationalizable in language and region. benerator is strongly customizable with plugins and configuration options.
Databrid is a database browsing, retrieval, and manipulation tool for Oracle and MySQL Databases. Functionality includes SQL autocompletion, syntax and word highlighting, auto case adjustment, schema browsing, and the ability to save or update data in CSV files.
DataVision is an Open Source reporting tool similar to Crystal Reports. Reports can be designed using a drag-and-drop GUI. They may be run, viewed, and printed from the application or exported as HTML, XML, PDF, LaTeX2e, DocBook, or tab- or comma-delimited text files. The output files produced by LaTeX2e and DocBook can in turn be used to produce PDF, text, HTML, PostScript, and more. Read more
DBBrowser is a program which can be used to view the structure of databases as well as to run queries against them. The program is written to work with as many RDBMS systems as possible, using the JDBC API. Currently, the program supports connections to PostgreSQL, MySQL, Microsoft SQL Server 2000, and Oracle RDBMS systems.
DB Copy Plugin
DB Copy Plugin is a plugin for the SQuirreL SQL Client (1.2beta6 and 2.0 RC1+) that allows copying database objects (schema def and data) from one session window to another. The sessions can be disparate database vendors (Oracle -> MySQL, for instance).
(commercial) A powerful database development and management tool for developers and DBAs. It has an intuitive user interface that allows you to explore and manage your database objects as well as execute ad-hoc queries. It supports Oracle, MySQL, Sybase, and MS SQL Server. In addition to viewing objects such as schemas, tables, indexes, views, tablespaces, users, roles, sessions, and stored procedures, you can view, edit, print, and export data from tables or the results of queries. You can also graphically view foreign key relationships.
DB Visual ARCHITECT for NetBeans
DB Visual Architect for NetBeans (DBVA-NB) is a full-featured Object Relational Mapping (ORM) plugin for NetBeans that provides the industry's best round-trip code engineering support with Java. The tool acts as a bridge between the object model, data model, and relational model by automating the mapping between relational rows in a database and object models which can be manipulated by a Java program.
a database shell. You can centralize your connections and queries ordered by projects in one place. You can perform queries and view results in a table
DB2-JMIN is a general-purpose database administration client, inspired by phpMyAdmin. It was originally designed for DB2, but now also supports MySQL, PostgreSQL, Firebird, Derby, and Oracle. It can be used as a Web application or a desktop application. It runs on Tomcat 5.5 or Swing with JDK 1.5. It features schema browsing, table browsing, table structure, and an SQL query editor.
db2dot reverse engineers an existing database and produces an ER diagram in dot format. The dot file can be fed through graphviz's dot to produce a pretty ER diagram.
database for objects: an open source object database for Java and .NET. It is a fast, lean and easy to use database for native Java and .NET objects. It is free software available under the GPL but also under an optional commercial license. It can persist any native object with a single line of code, minimizing persistence hassle and allowing you to experience the gains of true object-orientation
(commercial) provides convenient administration of your Oracle database through any web browser from home, office or from remote location. DBAConnect can be used for convenient access from home, when traveling on business, and even from another desk in the same building
dbdeploy is a Database Change Management tool. It helps developers and DBAs change their database in a simple, controlled, flexible and
dbDir is a database directory software. It is a directory for databases.
DBeauty is a relationship-oriented database browser. It provides an insight into both the data and the interrelation of the rows and allows users to navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
DBeaver is a universal database manager and SQL Client. It supports MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, Derby, and any database that has a JDBC driver.
a utility for browsing Digital Bibliographic Libraries. It is currently used for browsing the whole of the DBLP Library offline
a DataBase Manager Java User Interface; an attempt to clone DBMGUI, the database manager for SAPDB
DBMonster is a tool which helps database application developers with tuning the structure of the database, tuning the usage of indexes, and testing the application performance under heavy database load. dbMonster generates as much random test data as you wish and puts it into SQL database. It provides a very pluggable interface and is trivial to use.
dbsql2xml is a Java tool (class) for transformation (export, convert) relational database into hierarchical XML. It requires JRE 5.0, JDBC and SQL DBMS. "dbsql2xml" uses XML document for mapping database tables and columns into elements of tree XML.
a simple JAVA application to access ORACLE and MySQL Databases. It's possible to enter and execute SQL-Statements. After executing the statements the results are listed in a formated grid. There is a command history for up to 100 commands
DBTree is a cross-platform (both database and operating system) general purpose database query tool. Some of the primary features of DBTree are a tabbed interface which allows you multi-database connectivity and multiple Workbooks per connection. A Workbook is the main query interface and is optimized for productivity and ease of use. DBTree also features automatic session saving and loading upon startup.
a cross platform database visualization tool relying 100% on the JDBC, Java Database Connectivity API's. DbVisualizer enables simultaneous connections to menu different databases through JDBC drivers available from a variety of vendors
DbWrench is a multi-vendor, multi-platform database design and synchronization software. Features include a syntax highlighting SQL query editor, support for many of today's most popular databases, a graphic entity relation diagram (ERD) designer, and the ability to forward and reverse engineer databases
a tool to help you create any text files that take their content from a relation database structure.
The primary usage consists to generate Java source code that contains CRUD operations
Drizzle-JDBC is a JDBC driver for drizzle, a microkernel DBMS for high performance scale-out applications.
Druid is a GUI tool for database build and management. Users can add/change/delete DB objects (tables, fields, etc). Druid generates for you: SQL scripts, docs in XHTML, PDF, DocBook, etc; code in C, C++ & Java Beans even for JDO and support Castor & OJB.
a simple XML file database API in Java to manage a xml db file system without DB complexity (no server or client, stores only Strings). This API creates both the access DAO sources files and the DB filesystem. Handle auto-increments and PKs
Duke is a fast and flexible record linkage engine. It does not use the traditional blocking (sort by key) approach, but instead relies on Lucene.
(commercial) a universal and fully dynamic GUI for relational databases. 100% pure Java, based on JDBC - runs on all platforms
Easysoft ODBC-JDBC Gateway
(commercial) The Easysoft ODBC-JDBC Gateway allows ODBC applications to be used with JDBC databases. It is a fully functional ODBC 3.5 driver that allows you to access any JDBC data source from any ODBC-compatible application. All leading Java databases are supported, including JDataStore, Cloudscape, PointBase, FirstSQL, McKoi, and HSQL. It is compatible with unixODBC, the Linux and Unix driver manager.
Embedded JSON Database engine (EJDB) aims to be a fast MongoDB-like library which can be embedded into C/C++ and NodeJS applications under terms of LGPL license.
Elvyx is a tool designed to monitor and profile the jdbc activity on java projects. This jdbc profiler has a server with a built-in db and a client to improve the experience.
(commercial) Emeraldj is a Object / Relational DAO generator for Java Applications. It allows developers to map relational database tables to XML and have the DAO pattern based SQL and Java source generated. One of the main features of Emeraldjb, is the ability to use native SQL commands and functions in the XML file definition.
Epictetus is a manager for JDBC-compliant databases.
ExtenDB Parallel Server Standard Edition
(commercial) The ExtenDB Parallel Server is a clustered database solution for data warehousing and business intelligence. It leverages the PostgreSQL database running on PC-based commodity hardware, and intelligently coordinates work between them. This allows for the scaling out of databases to handle large data volumes quickly.
Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. Read more
(commercial) imports database schema definitions from SQL scripts or from live databases via JDBC, and then generates a complete data-access tier based on the Data Access Object (DAO) design pattern
Flat File Reporting
Flat File Reporting allows you to use fixed width files as a data source in IReport designer and Jasper Reports.
FormatCheck is an application that screens flat files (fixed and variable width) for violations in the format of the data. The input files may contain one record type or a mixture of record formats, such as a file containing header and detail records. It uses a set of XML files that define the file formats that can be evaluated. Each XML file defines the acceptable record layout(s) for one input format. The application supports a record-related XML schema definition.
Geomajas Hibernate layer
Geomajas Hibernate layer is a plug-in that allows direct access to Hibernate mapped database tables in the Geomajas mapping framework.
Gzz is an implementation of Ted Nelson's zzstructure.
a JDBC driver implementation that provides light-weight, transparent clustering capability to groups of homogeneous JDBC-accessed databases
hamsterdb-java is a Java wrapper for the hamsterdb embedded database library.
a SQL shell written in Java that works for any database that has JDBC support. It provides commandline history, commandline completion, and can handle multiple connects to different databases at once
hsqldb is a relational database engine written in Java, with a JDBC driver, supporting a subset of ANSI-92 SQL. It offers a small (about 100k), fast database engine which offers both in memory and disk based tables. This product includes Hypersonic SQL. Read more
Hydrate is a Java tool that provides for fast efficient and error-free transformation of data between three different representations: relational databases, objects in an object-oriented programming language and extended markup language (XML).
a Java database engine with standard SQL and JDBC interface. Very compact. It can be used in applets, applications, as a server
i-net Crystal-Clear is a full reporting package. It consists of a report engine and a designer for generating the report templates. i-net DesignerXML comes free of charge with i-net Crystal-Clear, thus making it an extremely cost effective solution. This is also true for OEM partners who wish to integrate i-net Crystal-Clear into their solution.
i-net KONNEKTER is a new type of JDBC driver. It allows you to develop an applet or server application that supports different DBMS.
i-net MERLIA is a J2EE 1.3 certified JDBC driver for the MS SQL database server. It implements the latest JDBC API levels 3.0 and 4.0. It supports SSL security.
i-net ORANXO is a J2EE 1.3 certified Type 4 JDBC driver for the Oracle database server. It implements the latest JDBC API level 3.0.
a well-featured JDBC independant database app. It allows you seamless access to PostgreSQL, MySQL, Oracle, etc. in the same application
Itzam/Java is a pure Java reimplementation of the Itzam embedded database engine, and it is 100% interoperable with files created by Itzam/Core.
JAConfig implements an eventually consistent distributed key/value database for managing a JASocket cluster. Also included are Quarum for tracking when a quorum of hosts is present, Ranker for determining which nodes are least loaded, ClusterManager for starting up other servers and Kingmaker?which decides which node is to run ClusterManager. JAConfig is lock-free, actor-based and has no single point of failure.
Java SQL Admin Tool
a Java-based Admin-Tool for SQl-Databases via JDBC. Works fine with JDK 1.3
Java Ultra-Lite Persistence
an independant Object-Relational framework. Inheritance, Many classes per table, Many tables per class, Optimistic concurrency, simple mappings, etc. Less then 50KB. Swing GUI to generate classes and mappings
a simple, yet powerful tool for creating an object to relational mapping layer. In simple usages, jaxor allows developers to painlessly insert, update, and delete rows from tables
JayBird is a JCA/JDBC driver suite for connecting to Firebird database servers. It was based on Borland's InterClient JDBC driver and uses the new JCA standard, which specifies an architecture in which an application server can cooperate with a driver so that the application server manages transactions, security, and resource pooling, and the driver supplies only the connection functionality. It also supports JDBC.
JDatabaseImport is a tool capable of transferring data between databases. One can easily migrate data between servers by writing a simple XML configuration file.
an open source initiative to implement a database
administration tool in Java
provides a front end for SQL commands. It uses JDBC drivers to connect to a RDBMS. Future plans include storing a history of commands, syntax highlighting, and customizable ui
provides a consistent mechanism of importing data from files into a JDBC compliant database. Currently, each database vendor has their own utility or command that must be learned. Additionally, there are some limitations and caveats about the data format
JdbcTool is a collection of command line utilities for making your life easier when working with Java JDBC databases. Included is jdbctool, an interactive command line tool for executing SQL statements, jdbcdump, which dumps the contents of a database as SQL statements into a file, like mysqldump, and jdbcload, which executes SQL statements from a file (the opposite of jdbcdump).
jDBSync provides ANT tasks with which you will be able to find differences between two databases while offline and prepare SQL to update any of them.
a plugin for Eclipse. It allows you to view the structure and the content of any JDBC compliant database, issuing SQL commands, etc
jguigen generates screens to do CRUD (create, review, update, delete) from tables in a database. It supports any major database using JDBC. It generates fully internationalized and accessible screens that allow users to search tables, edit, run reports, and calculate summary stats.
provides SQL capabilities for querying, ordering and grouping of collections of Java objects. It allows a SQL statement to be applied to the collection of objects and the matching set returned, ordered and grouped
a package that allows Round Robin Database (RRD) generated by the Multi Router Traffic Grapher (MRTG) to be read from Java programs
jSlovo is a fast database engine with a GUI that was designed for free dictionaries. It can create a file-based database from a text file and then be used to search it for particular words. It can scan any large number of file-based databases and the size of the databases is not limited. HTML tags can be used in the text files and for cross-references.
jspMyAdmin is a clone of the very popular phpMyAdmin, but written in JSP. It provides MySQL database administration over the Web.
JSqsh is a Java reimplementation of a console based (i.e. non-graphical) database query tool called sqsh. Jsqsh combines the ability to run SQL queries against any database with a JDBC driver along with much of the functionality of a Unix shell, such as piping the results of queries out to external programs (grep, more, etc.), expanding variables, redirecting output to files, command line editing, tab-completion of object names, and more.
a JDBC 2.0 type 4 driver for the Microsoft SQL Server series (6.5, 7.x and 2000)
a Java application which converts XML documents into a variety of other data-types useful for database administration
LucidDB is an open-source Relational Database Management System (RDBMS) purpose-built entirely for data warehousing and business intelligence. It is based on architectural cornerstones such as column-store, bitmap indexing, hash join/aggregation, and page-level multiversioning. Read more
LuSql is a command line Java application for the construction of a Lucene index from an arbitrary SQL query of a JDBC-accessible SQL database. It allows a user to control a number of parameters, including the SQL query to use, individual indexing/storage/term-vector nature of fields, analyzer, stop word list, and other tuning parameters. In its default mode, it uses threading to take advantage of multiple cores. LuSql can handle complex queries, allows for additional per record sub-queries, and has a plug-in architecture for arbitrary Lucene document manipulation.
an Open Source MultiValue Database Management System. MultiValue based database systems have been around since the 1960s, and are known for their speed and RAD capabilities. MaVerick includes a DataBasic compiler and native filesystem, as well as drivers to interface with other database systems. Even runs on the Sharp Zaurus SL-5500 using the Jeode VM
Mckoi SQL Database
an open source relational database management system written in Java. It supports a useful subset of ANSI SQL-92. The software can be run as either a multi-client, multi-threaded database server or as a stand alone embedded database engine
mongo4ben is a plugin to access mongoDB with Benerator. It supports data import from and export of generated data to a mongoDB instance and modification of existing database data.
MonjaDB is a MongoDB GUI client tool for rapid application development. The application aims to provide a thoroughly straightforward way of updating MongoDB documents. Read more
MQSSave is a simple Java program that saves messages read from an MQSeries queue to a file.
Mr. Persister is a POJO persistence API for Java. The main focus of Mr. Persister is to handle all the trivial JDBC work, and leave the non-trivial parts up to you. It uses plain SQL as the query language, it can auto-map objects to the database, and it can generate SQL for a lot of trivial tasks by itself (such as insert, update, and delete). Mr. Persister also has support for easy batch updates of collections of objects, connection and transaction handling, and many other features.
MyJgui is a light-weight graphical user interface for MySQL databases. It aims to be easy to use for new users as well as experts.
MyJSQLView provides an easy to use Java based user interface frontend for viewing, adding, editing, or deleting entries in a MySQL database. All tables and fields are available for access in the selected database.
MySQA is a useful program to analyze log files created by MySQL slow queries or queries that don't use indexes.
MySQL2JSP is an easy to use, quick & template driven JSP code generator that creates a full set of JSPs /servlets as well as JavaBeans from MySQL database using JDBC. Using the generated JSPs, developers can perform any operation on any database record.
MySQLGraphic is an open-source Java application that provides a graphical interface for a MySQL database
Neo4j is a graph database, a fully transactional database that stores data structured as graphs.
NewSQL is a new database access language. It is easier to learn than SQL, elegant, consistent, and well defined. It is not a extension or subset of SQL, and not a Object database language. It is based on top of the cross database library LDBC.
NW.ORM is a simple wrapper for accessing databases using hibernate in Java. It makes working with multiple databases easy.
(commercial) a powerful yet compact Object Database (ODBMS), compliant with the Java Data Objects (JDO) standard developed by Sun. ObjectDB for Java/JDO is designed to handle efficiently databases of various sizes, ranged from a few KBs to hundreds of GBs
a real-time hierarchical distributed object orientated database interface
Octopus Java/XML ETL tool
Octopus Java/XML ETL tool is a simple Java-based Extraction, Transformation, and Loading (ETL) tool. It may connect to any JDBC data sources and perform transformations defined in an XML file.
OGSA-DAI is a product that allows data resources, such as file collections, relational or XML databases, to be accessed, integrated and federated across the Internet.
a free version of Daffodil DB, a commercial RDBMS. It is transparent to the end user and does not require a Database Administrator
Orabbix was made to monitor Oracle instances with Zabbix. It acquires data from every Oracle instance you want to monitor, and then Zabbix server produces graphs and collects data.
OrientDB is a NoSQL DBMS which can store up to 200,000 records in 5 seconds on common hardware. Even with a document-based database, the relationships are managed as in graph databases, with direct connections among records. Read more
ozone is a fully featured, object-oriented database management system completely implemented in Java and distributed under an open source license.
an open source framework for applications that intercept and optionally modify database statements. P6Spy includes P6Log, an application that intercepts and logs the database statements of any application that uses JDBC
pBeans Java Persistence Layer
an open source Java based persistence layer meant to be a straight forward way to automatically map Java objects (JavaBeans) into relational database tables
PGJDBC-NG is an implementation of JDBC aimed at supporting the advanced features of JDBC and Postgres.
a lightweight SQL querying tool written in Java. Connects to any JDBC compliant database and will run on any OS with a Java VM. Features: keyword highlighting, result formatting, statement history, multi-window, multiple databases connects at one time
PolePosition is a benchmark test suite to compare database engines and object-relational mapping technology.
provides a means of pooling Java objects, with particular extensions for pooling JDBC database connections and caching SQL queries to multiple databases
PostgreSQL JDBC drivers
the Official PostgreSQL JDBC drivers
The Power*Architect is a Java-based data modeling tool geared specifically for data darehouse and data mart design. It allows the designer to open multiple concurrent source database connections, create and explore profiles of the source data, drag and drop source schemas, tables, and columns into the data modeling playpen, and forward engineer the resultant target database and its associated ETL template.
a Java SQL Driver that provides a connection pool wrapper around another Driver of your choice. Very simple to migrate existing code. Fully configurable. Fast, mature and robust. Transparently adds connection pooling to your existing JDBC driver
Quantum Database Utility
a simple database access plugin for Eclipse. It currently supports Postgres, MySQL, Adabas-D, DB2, and Oracle. It allows a user to easily view a lists of tables, views, or sequences
Querydsl (pronounced: query diesel) is a framework that enables the construction of statically typed SQL-like queries. Instead of writing queries as inline strings or externalizing them into XML files, they can be constructed via a fluentDSL/API like Querydsl.
provides a powerful GUI front end for JDBC-enabled databases. It creates forms on-the-fly through which you can query tables and browse the results with just a few keystrokes or mouse clicks. It also lets you insert, update and delete table rows without typing any SQL statements
QuickTable is a complete JTable alternative Javabean. It has all the features which are missing in JTable and it is built on top of JTable, so you don't have to learn any new API.
a Java-coded desktop ORDBMS featured by Zigzag language - more expressive than SQL and XSLT. The some peculiarities of database: dynamic structure, data integrity control, many-valued data, multi-level classification, class inheritance, and manipulation with multitudes of the classes or relations
SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships. The browsing through relationships can occur though HTML links and/or though the graphical representation of the relationships. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints.
a platform-independent text shell to access relational databases that support jdbc. You can perform basic sql features such as insert, update, delete, select as well as create, drop tables stored procedures, etc. (similar to sql+)
SDE for Oracle JDeveloper
(commercial) SDE for JDeveloper is a UML modelling plugin which is tightly integrated with Oracle JDeveloper. It lets you draw all types of UML 2 diagrams includes use case, class, sequence, activity, and component diagrams, reverse engineer source code (Java, C++, XML, XML Schema, CORBA IDL, etc.) to UML diagrams, and generate Java source from UML diagrams. It supports the latest UML 2.0 diagrams and notations and features Microsoft Visio integration, team collaboration, EJB development support, HTML/PDF report generation, Rational Rose project importer, and an XMI importer.
Sequoia is a transparent middleware solution for offering clustering, load balancing and failover services for any database. Sequoia is the continuation of the C-JDBC project?. The database is distributed and replicated among several nodes and Sequoia balances the queries among these nodes. Sequoia handles node failures and provides support for checkpointing and hot recovery.
Simple Data Upload
SDU (Simple Data Upload) allows to transfer data between MySQL databases. It is a front-end of mysqldump and the mysql client program. It facilitates the migration of tables between databases.
SimpleDBM is a relational database manager. Its planned features include support for transactions, write ahead log, multiple isolation levels, B-tree indexes, entry level SQL-92, and system catalogs. It is distinguished by its modular design, in which each module is usable on its own. The two main subsystems of the backend are the data manager (responsible for transactions, locking, tuple management, and index management) and the SQL manager (responsible for parsing SQL statements, producing optimum execution plans, and executing SQL statements).
SmallSQL is a pure Java DBMS, a relational database for Java desktop applications. It has a JDBC 3.0 interface and offers many ANSI SQL 92 and ANSI SQL 99 features. SmallSQL should be compatible with other popular databases such as MS Access, MS SQL Server, Oracle or DB2.
SPT Object Database
SPT Object Database is a pure Java Object Database developed around the Prevayler transactional object persistence framework. SPT Object Database attempts to address some of the most glaring deficiencies in Prevayler while making full use of its great features.
SPT Relational Database Web Tool
The SPT Relational Database Web Tool (RWT) is a simple application that can help developers connect to databases configured as a DataSource in the application server or directly through JDBC. The RWT application attempts to replicate basic features found in the popular Aqua Data Studio application. Per user settings (saved connection parameters, saved queries), single and batch query processing, a history browser, multiple query browsers, a tree view of database metadata, and other features are supported.
SQL Construction Kit
SQL Construction Kit aims to provide a simple builder/factory pattern based approach to generating DML SQL for all popular RDBMS systems. Included builders are SelectBuilder, InsertBuilder, UpdateBuilder, and DeleteBuilder. It is much lighter weight than any of the ORM tools available, and is 100% Java. It is a complete re-factoring of code that has been in production use since 2001 (updated to use features of Java 6). Also included is a Facade patterned Database object that wraps a Datasource object. This provides an execution framework for the results of the Builder objects, which includes simplified transaction and batch management as well as the ability to transparently handle SQL exceptions in a default manner. The Database object also provides a simple object-oriented approach via wrappers around the database metadata.
a cross database SQL administration and development frontend with a graphical user interface completely written in Java
SQL ORM focuses on mediating database interaction rather than shielding the user from it. It takes the best parts from iBatis, Toplink, Spring JDBC, etc. and consists of four independent modules that can be used in isolation, in combination with each other, or in combination with other frameworks - even ORM frameworks!
a lightweight java/swing tool for sending queries and perform direct data edit on tables
SQleonardo is a powerful and easy-to-use GUI that lets you query databases. No SQL knowledge is required.
gives you the opportunity to build your SQL-statements visually as known from MS-Access. Parsing statements and visualizing them also is supported. Additionally the statements can be sent to a specified database and returned results viewed. Use the JDBC-driver you like
SQLiteJDBC is a JDBC driver for SQLite which is written as a Java JNI layer over the SQLite 3.3.x API. It supports the most commonly used features of JDBC that can be efficiently implemented on top of SQLite.
SQLJet is an independent pure Java implementation of a popular SQLite database management system. SQLJet is a software library that provides API that enables Java application to read and modify SQLite databases.
SQLLine is a console based utility for connecting to relational databases and executing SQL commands. It is similiar to other command-line database access utilities like sqlplus for Oracle, mysql for MySQL, and isql for Sybase/SQL Server.
a SQL Client (Java) that is very configurable, completes table and column names upon tabbing. Completes other words and abbrevs (vi-style). Powerful auto-linking across tables. Powerful auto-joining across tables
(commercial) a graphical user interface tool to convert SQL queries from one dialect to another. DB Administrators and developers working with multiple databases can just type a query in one SQL dialect and view the equivalent query in different databases dialects. It supports Oracle, MS-SQL Server, DB2, Informix, Sybase, MySQL, PostgreSQL and ANSI-SQL SQL dialects
a database explorer available as a plugin for the IntilliJ IDEA IDE
Squirrel SQL Client
a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.
StelsCSV is a JDBC driver that allows to perform SQL queries and other JDBC operations on text files (CSV, tab-separated, fixed length etc). Using this driver, you can easily create a simple database consisting of plain text files. Also, the driver can be used for writing data importing programs and migration tools.
StelsDBF is a DBF JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on DBF files (dBase III/ IV/ V, xBase, FoxPro).
StelsEngine is a multifunctional Java SQL engine for storing and processing tabular data in the software applications. Using StelsEngine, you can make processing data in your software application considerably easier and quicker. StelsEngine is as easy to use as possible since it implements the JDBC API standard.
Features: it is JDBC Type 4 driver, supports most keywords of ANSI SQL 92, supports integer, floating point, string, date/time and java object data types, supports aggregate, converting, string and user-defined SQL functions, supports data loading from a DBMS, platform independent.
StelsXML is a JDBC type 4 driver that allows you to perform SQL queries and other JDBC operations on XML files. It allows you to easily access data contained in XML documents using the standard SQL syntax and XPath expressions. The driver is completely platform-independent. It supports most keywords of ANSI SQL'92, XPath expressions for defining tables and columns, inner and outer table joins, aggregate, numeric, string, conversion, and user-defined SQL functions.
StreamCruncher is a multi-threaded program that provides an extension to the SQL language with event processing constructs. It supports sliding windows, time-based windows, partitions, and aggregates. It also provides a feature similar to materialized views. Joins and sub-queries are also supported to allow event co-relation. A database is used underneath to do the heavy lifting.
ThinkUI SQL Client
ThinkUI SQL Client is a graphical program that allows Java developers to browse a database structure, edit data in the tables, issue SQL queries, and generate code (e.g. Java Bean, DAO, SQL queries, JSP files, etc.) based on customizable Velocity templates.
TiTLi is a Google-like search tool for relational databases. It builds on top of Apache Lucene to provide an API and a GWT-based UI for searching multiple databases from various vendors simultaneously. It is very fast due to indexing, and the database is queried only when a record is chosen.
Ujorm is an easy-to-use, quick ORM solution for Java with a small footprint. Some of its features are type safe parameters in queries, relation mapping by Java code rather through proxy objects or entity states, and a memory overloading protection cache.
UMongo is a GUI app that can browse and administer a MongoDB cluster. It is available for Linux, Windows and Mac OSX. Read more
Universal Database Viewer
Universal Database Viewer is a utility for database browsing. It provides a simple interface for viewing any data you like.
a database abstraction layer for Jakarta Velocity: Velosurf is meant for ease of use, genericity and efficiency
Vibur DBCP is a concurrent, fast and fully-featured JDBC connection pool based on Java dynamic proxies. It supports a fairness parameter, statement caching, SQL queries logging, and many other features.
ViennaSQL is a GUI SQL client written in 100% Java. ViennaSQL can communicate with any database that has a JDBC driver.
reduces JDBC code in application, it makes code more readable and safe, SQL procedures and queries are mapped to JAVA methods using custom javadoc tags and dynamic code generation at runtime. It needs no custom build tools or external files
a database utility that goes through all of the columns in one or more tables in one or more database schemas generating a report on those columns that contain "high bits" in character data. A high bit is a byte that has the 8th bit set, and this generally indicates the presence of characters in a non-ascii encoding such as UTF-8 or ISO-8859-1. The application scans data in columns of type CHAR, VARCHAR, and CLOB
Wikitty is a key/value storage and search system. A Java object or a relational table is frozen when writing code or creating a database.
xlsjdbc is a JDBC-compliant driver which allows you to read Excel files with Java.
XSet is a performance oriented main memory XML database and query engine. XSet is meant to be a low level application component that enables applications to have high speed access to stored metadata in the form of XML documents.