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
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
- Application: Flutter
- State Management: Riverpod, GoRouter
- UI: SQL Editor, HugeIcons, Window Manager
- Storage: ObjectBox