日本語

Overview

• GUI Tool to browse data, issue SQL commands on DB.
• Supported DB: Oracle, PostgreSQL, MySQL, Cassandra, SQLite, SQLServer. Going to add more JDBC compliant DB in the future.
• Multi Platform: Windows, Linux, MacOS.
• Multi Language: English, French, Spanish, Chinese, Japanse.
• Free and Open-Source.

Download

https://sourceforge.net/projects/miludbviewer/files/?source=navbar

Install & Run

1. Download "Open JDK22 + Open JavaFX22" or later.
   Open JDK 22 Download from jdk.java.net
   Open JavaFX 22 Donwload from gluonhq.com/

2-1. Windows (1-1) Open JDK 22 Install.
for me, C:\Program Files\Java\jdk-22
(1-2) Open JavaFX 22 Install
for me, C:\Program Files\Java\javafx-sdk-22
(1-3) Add jdk/bin to PATH for me, C:\Program Files\Java\jdk-22\bin
(1-4) Add javafx/lib to PATH_TO_FX
for me, C:\Program Files\Java\javafx-sdk-22\lib
Run HelloWorld using JavaFX
(2-1) run "MiluDBViewer_Setup*.*.*.exe"
(2-2) run "your path\MiluDBViewer.exe"

2-2. Linux (1-1) Open JDK 22 Install.
for me, /opt/java/jdk-22
(1-2) Open JavaFX 22 Install
for me, /opt/java/javafx-sdk-22
(1-3) Add jdk/bin to PATH for me, /opt/java/jdk-22/bin
(1-4) Add javafx/lib to PATH_TO_FX
for me, /opt/java/javafx-sdk-22/lib
Run HelloWorld using JavaFX
(3-1) extract MiluDBViewer*.*.*.tar.gz by a file archiver to <>
(3-2) $ cd your path (3-3) $ ./MiluDBViewer***.sh

Checked DB(MiluDBViewer0.4.0_jdk22)

(1) Cassandra 4.1.4 (2) MySQL 8.0.36 (3) Oracle Database 23c Free (4) PostgreSQL 14.11 (5) SQLite 3.45.1 (6) Microsoft SQLServer 2017 (7) MongoDB 3.6.5

Checked DB(MiluDBViewer0.3.9_jdk21)

(1) Cassandra 3.9.0 (2) MySQL 5.7.20/8.0.11 (3) Oracle 12c Release2/11g Release2 (4) PostgreSQL 10.4/10.1 (5) SQLite 3.23.1 (6) Microsoft SQLServer 2017 (7) MongoDB 3.6.5

Features

Copy data vertically

This is the feature that I want and use the most. Enable to check data transition by your app. Especially for tables having many columns.

1. Copy data vertically

2. Paste it to a spreadsheet app like Excel, Open Office, Google spreadsheet.

Run Script

1. All SQL Results on "Result" Tab.

2. Each SQL Result on "Script#" Tab.

3. Execute selected SQL.

Completion

1. List popup for competion after "."

Schema Browse

1. Browse schema objects. Table and View => definition. Procedure => Source.

Supported Objects

x	Table	View	Materialized View	Function	Aggregate	Procedure	Package	Type	Trigger	Sequence
Cassandra	〇	×	〇	〇	〇	×	×	〇	×	×
MongoDB	〇	×	×	×	×	×	×	×	×	×
MySQL	〇	〇	×	〇	×	〇	×	〇	×
Oracle	〇	〇	〇	〇	×	〇	〇	〇	〇	〇
PostgreSQL	〇	〇	〇	〇	×	×	×	〇	〇	〇
SQLite	〇	〇	×	×	×	×	×	×	×	×
SQLServer	〇	〇	×	〇	×	〇	×	〇	〇	〇

ER Diagram

1. Draw ER diagram through traversing foreign keys.

Configuration to connect to DB

• Cassandra
• MongoDB
• MySQL
• Oracle
• PostgreSQL
• SQLite
• SQLServer

---

GitHub Flavored Markdown.