DbGate Free and Open Source Desktop App CookApps CookApps Marketplace

Overview

DbGate - (no)SQL database client DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import. DbGate is licensed under GPL-3.0 license and is free to use for any purpose. - Try it online - demo.dbgate.cloud - online demo application - Download application for Windows, Linux or Mac from dbgate.io - Looking for DbGate Community? Download from dbgate.io - Run web version as NPM package or as docker image - Use nodeJs scripting interface (API documentation)

DbGate is built on open-source principles to guarantee security, privacy, and full reproducibility. All sensitive data transformations run locally on your hardware with zero telemetry or unexpected cloud dependencies.

Key Technical Features & Capabilities

Browse table data with many filtering options, Excel-like filters, multi-value filters: High-performance integrated capability designed for native DbGate workflow.

Table data editing, with SQL change script preview: High-performance integrated capability designed for native DbGate workflow.

Edit table schema, indexes, primary and foreign keys: High-performance integrated capability designed for native DbGate workflow.

Compare and synchronize database structure: High-performance integrated capability designed for native DbGate workflow.

Light and dark theme, next themes available from DbGate Cloud: High-performance integrated capability designed for native DbGate workflow.

Huge support for work with related data - master/detail views, foreign key lookups, expanding columns from related tables in flat data view: Streamlined desktop functionality optimized for macOS and Windows.

Query designer - visual SQL query builder without writing SQL code. Complex conditions like WHERE NOT EXISTS.: Streamlined desktop functionality optimized for macOS and Windows.

Query perspectives – innovative nested table view over complex relational data, something like query designer on MongoDB databases: Streamlined desktop functionality optimized for macOS and Windows.

Architecture & Technology Stack

Primary Languages: TypeScript

Frameworks & UI Runtime: Electron / Node.js

Build Systems & Tooling: pnpm / npm

Supported Platforms: macOS 12.0+ (Apple Silicon M1-M4 & Intel x86_64), Windows 10/11 x64, Linux

System Requirements

Specification	Minimum Requirement	Recommended Specification
Operating System	macOS 12.0 Monterey / Windows 10 x64	macOS 14.0+ Sonoma / Windows 11 x64
Processor Architecture	Apple Silicon (M1+) or Intel Core i5 x64	Apple Silicon Unified Memory (M2/M3/M4)
Memory (RAM)	4 GB Unified RAM	8 GB+ High-Speed RAM
Storage Space	300 MB available local disk space	1 GB+ SSD storage
GPU Acceleration	Metal 2 / DirectX 12 compatible	Apple Neural Engine / Vulkan capable

Installation & Setup Guide

macOS Installation (Recommended)

Download the verified .dmg release installer directly from CookApps.

Open the disk image and drag DbGate.app into your /Applications folder.

Launch DbGate via Spotlight (Cmd + Space) or Launchpad.

Alternatively, install using Homebrew if available:

bash

brew install --cask dbgate

Windows Installation

Download the official installer package (.exe / .msi).

Run the executable and follow the setup wizard.

Launch DbGate from the Start Menu or desktop shortcut.

Building from Source (Development Setup)

bash

git clone https://github.com/sponsors/dbgate.git
cd dbgate
pnpm install || npm install
pnpm run build || npm run build

How to Use & Workflow

Application Launch & Workspace: Open DbGate to load the responsive native workspace.

Configuration & Preferences: Press Cmd + , (macOS) or Ctrl + , (Windows) to configure hardware acceleration, custom directories, and display themes.

Primary Operation: Drag-and-drop source files or input parameters directly into the central window.

Execution & Export: Initiate the processing pipeline and verify output files saved directly to your chosen local directory.

Troubleshooting & Common Issues

Problem: macOS Gatekeeper displays *"App is damaged and can't be opened"* or unnotarized developer notice.

Root Cause: macOS quarantine flag set on binaries downloaded outside the Mac App Store.

Resolution: Open Terminal and run:

bash

    xattr -cr /Applications/DbGate.app

Alternatively, navigate to System Settings > Privacy & Security and select Open Anyway.

Problem: High memory consumption during batch processing operations.

Root Cause: Large media buffers retaining uncompressed state.

Resolution: Adjust batch concurrency in settings or process assets in focused batches.

DbGate

Overview

Key Technical Features & Capabilities

Architecture & Technology Stack

System Requirements

Installation & Setup Guide

macOS Installation (Recommended)

Windows Installation

Building from Source (Development Setup)

How to Use & Workflow

Troubleshooting & Common Issues

How to Use & Getting Started

Ready to run DbGate?

More in system-utilities

Plonk

Kawa

WhatCable