Welcome to the JiveDB user guide. JiveDB (also written JDB) is a desktop application for browsing, querying, and editing PostgreSQL, MySQL, MariaDB, SQLite, and Redis databases — all from one window.
This guide is organized into 14 chapters. Each chapter is its own file, focused on one part of the app, with step-by-step instructions and screenshots. Read them in order if you are new to JiveDB, or jump straight to the chapter you need.
Introduction to JiveDB
How JiveDB's main window is laid out, its toolbar icons, and the About dialog.
02Connections
How to create, secure (TLS/SSL, SSH tunnel), and organize database connections in JiveDB.
03Navigation and search
How to browse the sidebar tree, filter and search objects, and use every right-click menu in JiveDB.
04Query editor
How to write and run SQL in the JiveDB query editor, with autocomplete, formatting, and result filtering.
05Query history and favorites
How to browse query history and star statements as favorites in JiveDB.
06AI Assistant
How to use the JiveDB AI Assistant to ask about your schema, generate SQL, and query your data.
07Data grid
How to find, format, export, select, page, and edit table data in the JiveDB data grid.
08ERD diagram
How to read the JiveDB ERD diagram, group tables into zones, and add virtual relations.
09Schema explorer
How to use the read-only schema explorer to inspect a schema's tables, views, indexes, and procedures.
10Table structure
How to edit a table's columns, indexes, foreign keys, and triggers with JiveDB's table structure designer.
11Redis
How to browse Redis keys, filter by type, and view values with JiveDB's Redis browser.
12Appearance and language
How to switch light/dark mode, accent colors, fonts, and the display language in JiveDB.
13Settings, shortcuts, and the command palette
The full Settings dialog, keyboard shortcuts, AI provider setup, command palette, and App Logs.
14Updates
How JiveDB checks for, downloads, and safely installs new versions.
- Every chapter links back here (Up: Guide Index) and to its neighbors (Previous / Next), so you can read the whole guide in sequence.
- Each chapter starts with its own Contents list, linking to every section inside it.
- Screenshots are stored in
images/and are referenced by each chapter as they are needed.