Skip to content

sjjian/openhare

Repository files navigation

logo

openhare is an AI-powered, cross-platform desktop SQL client with multi-database support, built for everyday development, data analysis, and DBA management workflows.

GitHub Repo stars License GitHub all releases GitHub release (latest by date) macOS Windows Linux

openhare product screenshot

English | 简体中文

Support

  1. How to Install and Update the Application

Key Features

  • Lightweight & Native: Download, install, and run in seconds — no WebView or bundled browser engine. Built with Flutter for a native desktop UI and a lean memory footprint.
  • AI-Powered Assistance: Write, optimize, and understand SQL with built-in AI — high-risk statements are flagged and require your confirmation before execution.
  • Multi-Database Support: Connect to MySQL, PostgreSQL, SQL Server, SQLite, Oracle, MongoDB, Redis, and more.
  • Cross-Platform: Native experience on Windows, macOS, and Linux.
  • Fully Open Source: Licensed under the Apache License 2.0 — transparent and community-driven.

Database

Database drivers are implemented in pkg/db_driver/go_impl and invoked from the Flutter client through Dart FFI.

Icon Database Go driver
MySQL MySQL go-sql-driver/mysql
PostgreSQL PostgreSQL jackc/pgx
SQL Server SQL Server microsoft/go-mssqldb
SQLite SQLite mattn/go-sqlite3
Oracle Oracle sijms/go-ora
MongoDB MongoDB bytebase/gomongo, mongodb/mongo-go-driver
Redis Redis redis/go-redis

Note: MongoDB syntax is intended to be mongosh-compatible; for what is actually supported, refer to gomongo.

Framework

  1. Application: Flutter
  2. State Management: Riverpod, GoRouter
  3. UI: SQL Editor, HugeIcons, Window Manager
  4. Storage: ObjectBox

Star History

Star History Chart