SQLife is a modern, cross-platform database management tool built with JavaFX. It supports multiple RDBMS (Oracle, PostgreSQL, MySQL, SQL Server, etc.) and middleware (Redis, MongoDB, Kafka, RabbitMQ), with a focus on providing a rich user experience for database administrators, developers, and data analysts.
## Supported Platforms
* Windows 10+ (x86-64)
* Linux (x86-64, ARM64): Debian, Ubuntu, Fedora, CentOS — Dpkg and RPM packages available
* MacOS 10.14+ (x86-64, ARM64 - Apple Silicon)
## Supported
* Oracle (9i+, best support for 19c+)
* PostgreSQL (9.6+, recommended 14+)
* MySQL (5.5+; 8.0+ recommended; 5.5 supported with plugin)
* MariaDB (10.0+)
* Microsoft SQL Server (2012+)
* SQLite (3.x)
* H2 Database (Memory, File and Server mode)
* IBM DB2
* Apache Derby
* HyperSQL (File and Server mode)
* DuckDB (Memory and File mode)
* ClickHouse
* Databricks
* Snowflake
* Redis
* MongoDB
* Kafka
* RabbitMQ
## Features
* Comprehensive Connection Properties for Oracle, PostgreSQL, MySQL, and other databases with keep-alive support.
* Object Management (tables, views, procedures, functions, triggers, indexes, sequences, synonyms, packages, materialized views, partitions, extensions, etc.)
* Multiple Connections and Tabs Support
* Partition/Sub-Partition Table Management (add, remove, rename, alter partition columns)
* Intelligent Auto-Completion with code navigation and bracket matching
* SQL Syntax Highlighting, Formatting, and Error Highlighting
* Data Export (SQL, CSV, TSV, JSON, XML, Excel, HTML, Markdown, PNG) with parallel export and zip packaging
* Data Import (Excel, CSV, TSV) with column mapping, function conversion, parallel processing, and Lob support
* Data Viewing and Inline Editing with multi-cell selection and clipboard support (Copy as Insert SQL/In SQL/TSV/CSV/JSON/XML)
* SQL History Tracking with Date/Pagination Search and auto-cleanup
* Oracle Scheduler Jobs Management (Jobs, Schedules, Programs, Windows, Chains)
* Oracle DBMS_OUTPUT capture and display
* Dark Mode Support (companion stylesheet overrides)
* Sharing Results via Local Network and Internet
* Plugin Management
* MCP (Model Context Protocol) support
* LLM Agent (OpenAI, DeepSeek, Ollama) with function-call safety checks
* Schema Comparison across different database types
* Database Locks Monitor
* SQL Executor with multi-threaded execution, batch commit, Lob/Blob support
* Object Browser with search and filter
* File Workspace with Git integration (file history, diff, commit)
* Task View with lifecycle controls (cancel, restart, reveal, open-log)
* Workspace State Recovery after crash (tab title, selection, scroll position, file path)
* SSH Tunnel support via external tunnel configuration
* Proxy Support (HTTP, SOCKS4, SOCKS5)
* Outline View for SQL script navigation
* Key Mapping customization with export/import
* Connection Backup/Restore with encrypted password storage
* i18n: 13 languages supported
