gonavi

GoNavi is a cross-platform database client built with Wails (Go) and React, designed as a lightweight alternative to Electron-based database GUIs. It offers a native desktop experience with installers around 20–26 MB, supporting a wide range of data sources including relational databases (MySQL, PostgreSQL, Oracle, SQL Server), cache systems (Redis), vector databases (Chroma, Qdrant, Milvus), message queues (Kafka, RabbitMQ, RocketMQ, MQTT), search engines (Elasticsearch, Sphinx), time-series databases (TDengine, IoTDB), and various domestic Chinese databases (OceanBase, Dameng, Kingbase, etc.). Key features include a virtualized DataGrid for handling large result sets, in-place cell editing, batch CRUD operations, transaction support, and export to CSV, XLSX, JSON, or Markdown. The Monaco editor provides context-aware SQL completion. AI integration supports OpenAI, Gemini, Claude, and custom OpenAI-compatible APIs, with the ability to attach live table schemas as context for generating, explaining, optimizing, and reviewing SQL. An MCP (Model Context Protocol) server allows coding agents like Claude Code, Codex, and others to access schema tools without exposing raw credentials. GoNavi includes SSH tunneling, proxy support, connection JSON import/export, and a driver manager for optional data source agents. It provides SQL execution logs, an audit center with redaction and retention, and an experimental web server mode for remote access. Deployment options include Docker, Kubernetes, Helm, and Podman. A standalone CLI is available for headless operations like querying, exporting, and batch execution. The project is Apache 2.0 licensed and actively developed, with releases for Windows, macOS, and Linux. It is sponsored by APISmart and HuaLongAI, which provide AI model API services.