JiveDB 1.3.0

A client for all databases — PostgreSQL, MySQL, SQLite, and Redis in a lightweight native application.

New Features

• Multi-database connection: PostgreSQL, MySQL, SQLite, Redis; encrypted at-rest passwords (AES-256-GCM).
• Metadata tree: database, schema, table, view, routine, sequence, data type.
• Powerful data table: edit cells directly, add/delete rows, undo (⌘Z), filter & sort.
• Interactive WHERE / ORDER BY bar directly on the data tab (power user).
• Pagination, navigate to reference rows via foreign keys (FK navigation).
• Export data: CSV, JSON, clipboard, and Excel (.xlsx).
• SQL editor (CodeMirror): run commands, format, column suggestions, multiple statements.
• Query history and Command Palette (⌘K) for quick operation search.
• ERD diagram (view only) with DDL panel and export SVG image.
• Schema Info tab to view an overview of schema/table information.
• Redis operations: browse keys, view/edit values, run commands.
• Multi-provider AI: chat, generate SQL, dialect conversion, optimization/explanation, data dictionary.
• Provider editor & AI model list right in Settings.
• Light/dark interface + accent color; bilingual Vietnamese / English.
• Customizable shortcuts; App Logs table to monitor activity.
• Auto-check for new version when opening the app + notification on the title bar.