Universal Database Management Tool
A powerful, modern database editor built with JavaFX that brings professional database management capabilities to your desktop.
Features • Supported Databases • Installation • Usage • Building
Connect to and manage multiple database systems simultaneously:
- MySQL - World's most popular open source database
- MariaDB - Enhanced MySQL fork with advanced features
- PostgreSQL - Advanced open source relational database
- SQL Server - Microsoft's enterprise database platform
- H2 - Fast, lightweight embedded database
- SQLite - Self-contained, serverless database engine
Connection Management
- Manage multiple database connections simultaneously
- Active concurrent connection monitoring
- Custom JDBC driver configuration
Query Execution
- Run multiple queries concurrently
- Advanced SQL editor with syntax highlighting
- Intelligent SQL code suggestions and autocomplete
- Save and organize SQL queries for reuse
Schema Management
- Browse and navigate databases, schemas, tables, and columns
- View detailed table and column properties
- Create, modify, and delete tables
- Create and drop databases/schemas
Data Manipulation
- Edit result sets directly in the grid
- Generate DDL scripts automatically
- Create INSERT scripts from data
- Export data in multiple formats:
- CSV
- JSON
- XML
Developer Experience
- Modern, intuitive JavaFX interface
- Syntax highlighting for SQL code
- Intelligent code completion
- Fast and responsive UI
- Cross-platform compatibility
| Database | Pre-installed Driver Version |
|---|---|
| MySQL | 9.5.0 |
| MariaDB | 3.5.6 |
| PostgreSQL | 42.7.8 |
| SQL Server | 13.2.1.jre11 |
| H2 | 2.4.240 |
| SQLite | 3.51.1.0 |
All JDBC drivers can be customized by the user to support different versions or configurations.
- Java 21 or higher
- Maven 3.6+ (for building from source)
Download the latest release from the Releases page.
java -jar queryexe-1.0.0.jar- Click the New Connection button
- Select your database type
- Enter connection details (host, port, database, credentials)
- Test the connection
- Save and connect
- Open a new query tab
- Write your SQL query with syntax highlighting and autocomplete
- Execute with
Ctrl+Enteror click the Run button - View results in the data grid
- Edit cells directly or export results
- Right-click on any table to access table operations
- Create Table: Define columns, types, and constraints
- Alter Table: Modify structure and properties
- Drop Table: Remove tables with confirmation
- View Properties: Inspect table metadata and statistics
- Execute a query to generate a result set
- Click Export
- Choose format (CSV, JSON, or XML)
- Select destination and export
git clone https://github.com/B077AS/query-exe
cd query-exe# Build with platform-specific JavaFX dependencies
mvn clean package -Ppackagemvn javafx:runThe compiled JAR will be available in the target/ directory.
- Java 21 - Modern LTS Java version
- JavaFX 22 - Rich desktop UI framework
- AtlantaFX - Modern JavaFX theme
- RichTextFX - Advanced text editing component
- JDBC Drivers - Native database connectivity
- Maven - Build and dependency management
- Lombok - Boilerplate reduction
- ER diagram generation
- Theme selection
- Query performance analysis
- Database backup and restore
Contributions are welcome! Please feel free to submit a Pull Request.
- Fork the repository
- Create your feature branch (
git checkout -b feature/AmazingFeature) - Commit your changes (
git commit -m 'Add some AmazingFeature') - Push to the branch (
git push origin feature/AmazingFeature) - Open a Pull Request
This project is licensed under the MIT License
- Built with JavaFX
- UI powered by AtlantaFX
- Icons from Ikonli
- SQL editing with RichTextFX
Made with Java
If you find QueryExe useful, consider giving it a ⭐!