Database GUI - Professional JavaFX Query Tool

A production-ready, cross-platform database management application built with JavaFX 21, featuring a modern dark UI, real-time SQL syntax highlighting, async query execution, and support for MySQL and Microsoft SQL Server.

✨ Features

• 🎨 Modern Dark UI: Nord/Dracula-inspired theme with smooth transitions
• ✍️ SQL Editor: Real-time syntax highlighting with RichTextFX
• ⚡ Async Query Execution: Non-blocking queries with loading overlay
• 🗂️ Schema Browser: TreeView with tables and columns
• 📊 Dynamic Results: TableView with automatic column generation
• 🔌 Connection Pooling: HikariCP for optimal performance
• 🗄️ Multi-Database: MySQL and MSSQL support

🚀 Quick Start

Prerequisites

• Java 21 or higher
• Maven 3.8+
• MySQL or Microsoft SQL Server database

Build & Run

# Clone or navigate to the project directory
cd queryWorkerJava

# Build the project
mvn clean package

# Run the application
mvn javafx:run

📖 Usage

Connecting to a Database

1. Click Connect button or use File → Connect
2. Select database type (MySQL or MSSQL)
3. Enter connection details:
   • Host (e.g., localhost)
   • Port (default: 3306 for MySQL, 1433 for MSSQL)
   • Database name
   • Username and password
4. Click Connect

Executing Queries

1. Type your SQL query in the editor
2. Press Ctrl+Enter or click Execute
3. View results in the table below
4. Check execution time in the status bar

Schema Browser

• Expand the tree to view tables
• Click on a table to see its columns
• Use Refresh Schema to update the tree

🏗️ Architecture

Project Structure

queryWorkerJava/
├── src/main/java/
│   └── nl/
│       └── jorisros/
│           └── queryworker/
│               ├── MainApp.java                    # Application entry point
│               ├── config/                         # Dependency injection (Guice)
│               │   └── AppModule.java
│               ├── controller/
│               │   ├── MainController.java         # Primary UI logic
│               │   └── QueryPanelController.java   # Tab-specific logic
│               ├── model/
│               │   ├── ConnectionStore.java        # Connection persistence
│               │   └── DatabaseConnection.java     # Connection configuration
│               ├── service/
│               │   ├── ConnectionManager.java      # HikariCP pool management
│               │   ├── DatabaseService.java        # Async query execution
│               │   ├── ThemeManager.java           # Theme switching logic
│               │   └── git/                        # Git integration
│               ├── view/
│               │   ├── ErdView.java                # ER Diagram visualizer
│               │   └── SettingsDialog.java         # App settings
│               ├── component/
│               │   ├── SqlEditor.java              # RichTextFX editor wrapper
│               │   └── LoadingOverlay.java         # Progress indicator
│               └── database/                       # Database provider adapters
│                   ├── mysql/
│                   └── mssql/
├── src/main/resources/
│   ├── application.properties
│   └── nl/
│       └── jorisros/
│           └── queryworker/
│               ├── view/
│               │   ├── MainView.fxml               # Main layout
│               │   └── QueryPanel.fxml             # Tab layout
│               └── styles/
│                   ├── dark-mode.css               # Theme definitions
│                   └── erd-view.css                # ERD specific styles
└── pom.xml

Key Technologies

Technology	Purpose
JavaFX 21	Modern UI framework
RichTextFX	Advanced code editor with syntax highlighting
HikariCP	High-performance JDBC connection pooling
MySQL Connector/J	MySQL database driver
MSSQL JDBC Driver	Microsoft SQL Server driver

🎨 UI Components

SQL Editor

• Syntax Highlighting: Keywords, strings, comments, numbers
• Line Numbers: Built-in line numbering
• Keyboard Shortcuts: Ctrl+Enter to execute

Results Table

• Dynamic Columns: Auto-generated from ResultSetMetaData
• Virtualization: Efficient rendering for large datasets
• Row Count: Display total rows returned

Loading Overlay

• Fade Animations: Smooth show/hide transitions
• Progress Indicator: Visual feedback during query execution

⚙️ Configuration

HikariCP Settings

Edit src/main/resources/application.properties:

hikari.maximumPoolSize=10
hikari.minimumIdle=2
hikari.connectionTimeout=30000
hikari.idleTimeout=600000
hikari.maxLifetime=1800000

Database Connection

The application supports:

• MySQL: jdbc:mysql://host:port/database
• MSSQL: jdbc:sqlserver://host:port;databaseName=database

🔧 Development

Building from Source

# Compile only
mvn compile

# Run tests (if any)
mvn test

# Package as JAR
mvn package

# Clean build artifacts
mvn clean

Running with Custom JVM Options

mvn javafx:run -Djavafx.args="--enable-preview"

📝 Example Queries

-- Select all records
SELECT * FROM users LIMIT 100;

-- Join tables
SELECT o.id, c.name, o.total
FROM orders o
INNER JOIN customers c ON o.customer_id = c.id
WHERE o.status = 'completed';

-- Aggregate functions
SELECT 
    category,
    COUNT(*) as count,
    AVG(price) as avg_price
FROM products
GROUP BY category
ORDER BY count DESC;

🎯 Keyboard Shortcuts

Shortcut	Action
Ctrl+Enter	Execute query
Ctrl+Q	Quit application

🐛 Troubleshooting

Connection Issues

• Verify database is running
• Check firewall settings
• Ensure JDBC driver is compatible
• Validate credentials

Performance

• Adjust HikariCP pool size in application.properties
• Use LIMIT clause for large result sets
• Enable database query caching

📄 License

This project is provided as-is for educational and professional use.

🙏 Acknowledgments

• JavaFX - Modern Java UI framework
• RichTextFX - Rich text editing for JavaFX
• HikariCP - Lightning-fast connection pooling
• Nord Theme - Beautiful color palette inspiration