SQLife

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.

Unlike many SQL clients, SQLife is optimized for MacOS while also providing robust support for Windows and Linux. It enables users to connect to databases, execute queries, and manage data efficiently, all within a unified interface.

Supported Databases

Relational Databases

• 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

Middleware

• Redis
• MongoDB
• Kafka
• RabbitMQ

Features

• Comprehensive Connection Properties with keep-alive support
• Object Management (tables, views, procedures, functions, triggers, indexes, sequences, synonyms, packages, materialized views, partitions, extensions)
• Multiple Connections and Tabs Support
• Partition/Sub-Partition Table Management
• 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, and parallel processing
• Data Viewing and Inline Editing with multi-cell selection and clipboard support
• 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
• 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
• 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