What is Udb App

UDB is a next-generation cross-platform database management tool built on Electron.js, designed to support various databases and enhance database intelligence through AI capabilities.

Use cases

Use cases include automating SQL query generation, managing multiple databases from a single interface, and leveraging AI to enhance database design and management efficiency.

How to use

To use UDB, clone the repository, install dependencies, start the application, and connect to your database. Utilize the AI assistant for generating table structures and writing SQL queries.

Key features

Key features include multi-database support, AI-powered assistance for SQL generation, a modern user interface, and cross-platform compatibility across Windows, macOS, and Linux.

Where to use

UDB can be used in various fields such as software development, data analysis, and database management, making it suitable for developers, data scientists, and database administrators.

UDB - Unified Database Management Tool

UDB, an open-source, multi-agent based modern database management tool.

Introduction

UDB is a powerful database management tool built on Electron.js, Shadcn, and AI technologies. It supports multiple database types and offers unique features such as table structure generation and SQL writing based on large - language models.

Features

• [x] Multi - Database Support: Connect and manage various databases, including but not limited to MySQL, PostgreSQL, SQLite, etc.
• [x] AI - Powered Assistance: Leverage the capabilities of large - language models to generate table structures and write SQL queries effortlessly.
• [x] Modern UI: Utilize Shadcn to provide a beautiful and intuitive user interface.
• [x] Cross - Platform: Thanks to Electron.js, UDB runs on Windows, macOS, and Linux.

Supported Databases

UDB supports the following databases:

Screenshots

• UDB - AI Create Table
  
• UDB - Setting
  

Installation

1. Clone the repository:

 git clone https://github.com/udb-org/udb-app.git

2. Navigate to the project directory:

cd udb - app

3. Install dependencies:

npm install

Usage

1. Start the application:

npm start

2. Connect to your database by providing the necessary credentials.
3. Use the AI assistant to generate table structures or write SQL queries.

Configuration

You can configure the application by modifying the forge.config.ts and vite.*.config.* files.

Contributing

If you’d like to contribute to UDB, please follow these steps:

1. Fork the repository.
2. Create a new branch (git checkout -b feature/your - feature).
3. Commit your changes (git commit -m 'Add some feature').
4. Push to the branch (git push origin feature/your - feature).
5. Open a pull request.

Documentation

English

• README

中文

• 自述

Frequently Asked Questions

Troubleshooting: GitHub Connection Timeout for udb-java Download

If you encounter a timeout issue when trying to download udb-java from GitHub, here are some possible solutions:

• Check your network connection: Ensure that your internet connection is stable and not blocked by a firewall or proxy.
• Try a different network: If possible, switch to a different Wi - Fi network or use your mobile data.
• Use a mirror repository: If available, try downloading udb-java from a mirror repository.
• Retry at a different time: Sometimes, GitHub may experience high traffic, causing connection issues. Try again later.
  Alternatively, you can manually download the latest version of udb-java from the download address: https://github.com/udb-org/udb-java/releases, place it in the .udb/server/jar directory under your user directory, name it udb-java.jar,eg:/Users/YourName/.udb/server/jar/udb-java.jar, and then restart the application.

Troubleshooting: JDK Download Failure

If you encounter issues downloading the JDK, you can manually download it from the following links based on your operating system:

• Windows: openjdk-21.0.2_windows-x64_bin.zip
• Mac/AArch64: openjdk-21.0.2_macos-aarch64_bin.tar.gz
• Mac/x64: openjdk-21.0.2_macos-x64_bin.tar.gz
• Linux/AArch64: openjdk-21.0.2_linux-aarch64_bin.tar.gz
• Linux/x64: openjdk-21.0.2_linux-x64_bin.tar.gz
  After downloading the appropriate JDK package, follow these steps:

1. Extract the JDK:
   • For ZIP files (Windows): Right - click on the downloaded ZIP file and select “Extract All”.
   • For TAR.GZ files (Mac/Linux): Open a terminal, navigate to the directory where the file is downloaded, and run the command tar -xzf <filename.tar.gz>.
2. Move the extracted JDK: Move the extracted JDK directory to the .udb/server/java directory under your user directory. For example, on a Mac, it might be /Users/YourName/.udb/server/java/jdk-21.0.2.jdk.
3. Restart the Application: After completing the above steps, restart the UDB application for the changes to take effect.

License

This project is licensed under the LICENSE file.

Contact

If you have any questions or suggestions, feel free to contact us at your