Happy DBA: Top 10 open-source SQL clients allow you to easily manage databases

Source: Internet
Author: User
Tags sql client

The SQL client is an essential tool for every developer. They help developers easily Execute SQL queries in any database. They are also very important for solving any database-related problems.

1. Squirrel SQL client

Squirrel SQL client is currently the most popular open-source SQL client. It provides graphical JavaProgramThis allows you to view the structure of a JDBC-compatible database, View table data, SQL commands, and so on.

2. iSQL-Viewer

ISQL-Viewer is an open source JDBC compatible database 2.x client written in Java. It implements the cross-platform jdbc api function. It has everything through a single interface. The iSQL-Viewer browser is compatible with most database platforms, including PostgreSQL, MySQL, Oracle, and Informix. ISQL-Viewer provides multiple tools and functions to execute common database tasks.

3. liquibase

Liquibase is an open-source (lgpl) database that is used to track, manage, and change the application database. It is built on a simple premise: All Database changes are stored in a readable form and can be trackedSource codeControl check.

4. henplus

Henplus is an SQL shell written in Java. JDBC provides support for any database. Therefore, it is basically supported by any database. Why do we need this? Any database comes with some shells, but they all have missing features (and some shells, which cannot be used at all ). If you use these databases once (if you are a developer and when you do everything), you will feel how boring it is to switch between these tools.

5. quantumdb

Quantumdb is a simple but powerful database access plug-in based on the eclipse development platform. Quantumdb allows you to connect to a database linked to the JDBC driver, using standard audit modes: tables, views, and sequences to find columns, indexes, and foreign key information, ad hoc query publishing or other SQL statements in the database.

6. dbbrowser

Dbbrowser is an open-source cross-platform tool (GPL) that can be used to view the content of a database. It supports clobs and blobs. It is designed to support Oracle and MySQL. You never have to write SQL statements to view the SQL window, even the data provided by SQL. Supports ergraphs (entity relationships), xmltypes, and more DBMS plans to be included in future versions.

7. jackcess

Jackcess is a client written in Java only for reading and writing data to the MS Access database. This is not an application. No graphical user interface. This is a library that other developers intend to use to build Java applications.

8. SQL workbench-J

QL workbench-J is the front-end of an SQL database DBMS independet. It is available in batch processing mode and has powerful Export and Import capabilities. It also provides some extensions to SQL (supports variable replacement, and the local blob file name), and tries to process the SQL database in a unified manner. It can directly copy data in two batches and different server tables on the graphic user interface.

9. SQL Admin

SQL admin is a Java client. Applications connect to and query different databases through JDBC. The main idea is to build a multi-platform and multi-database thin client.

10. sqleonardo

sqleonardo is a powerful and easy-to-use database query tool ,. When you use sqleonardo to work, it means that you do not need to understand SQL, you only need to work in the graphic environment and data in this environment, this is for the database standard programming language .

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.