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

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, DuckDB, ClickHouse, 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	go-sql-driver/mysql
	PostgreSQL	jackc/pgx
	SQL Server	microsoft/go-mssqldb
	SQLite	mattn/go-sqlite3
	DuckDB	duckdb/duckdb-go
	ClickHouse	ClickHouse/clickhouse-go
	Oracle	sijms/go-ora
	MongoDB	bytebase/gomongo, mongodb/mongo-go-driver
	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