Repolode
Submit
sjjian

sjjian/openhare

AI-powered cross-platform desktop SQL client built with Flutter, supporting MySQL, PostgreSQL, SQL Server, SQLite and more.

Open-source alternative to:NavicatDBeaver

View on GitHubWebsite
Stars
815
Forks
52
Open issues
14
Last commit
18 days ago

What is it?

openhare is a desktop SQL client aimed at everyday development, data analysis and DBA work. It runs on Windows, macOS and Linux and is built with Flutter, so it uses a native desktop UI rather than a WebView or bundled browser engine.

The client connects to MySQL, PostgreSQL, SQL Server, SQLite, DuckDB, ClickHouse, Oracle, MongoDB and Redis. Database drivers are implemented in Go under pkg/db_driver/go_impl and called from the Dart client through FFI. MongoDB syntax is intended to be mongosh-compatible, with actual coverage defined by the underlying gomongo driver.

Built-in AI can help write, optimize and explain SQL. High-risk statements are flagged and require user confirmation before they run. The project is licensed under Apache-2.0.

Key features

  • 01Native desktop UI built with Flutter, without a WebView or bundled browser engine.
  • 02Built-in AI assistance for writing, optimizing and understanding SQL.
  • 03High-risk statements are flagged and require confirmation before execution.
  • 04Connects to MySQL, PostgreSQL, SQL Server, SQLite, DuckDB, ClickHouse, Oracle, MongoDB and Redis.
  • 05Runs on Windows, macOS and Linux.

Use cases

  • Querying and managing several different databases from one desktop tool.
  • Writing and tuning SQL with AI help during day-to-day development.
  • Routine DBA work on SQL Server, Oracle or MySQL instances.
  • Exploring local analytical data in SQLite or DuckDB files.

Quick start

  1. 1

    Install and update the app by following the install guide in the project's discussions

Things to know

  • The README links to an external discussion for installation, with no install command given.
  • The README does not document how to build from source.

Topics

#sql#database-client#desktop-app#flutter#nl2sql#mysql#postgresql#sql-server#ai#desktop

FAQ

What is openhare?
AI-powered cross-platform desktop SQL client built with Flutter, supporting MySQL, PostgreSQL, SQL Server, SQLite and more. openhare is a desktop SQL client aimed at everyday development, data analysis and DBA work. It runs on Windows, macOS and Linux and is built with Flutter, so it uses a native desktop UI rather than a WebView or bundled browser engine.
Is openhare free to use? What license does it have?
openhare is open source under the Apache-2.0 license. Check the license terms before using it in commercial products.
Is openhare still maintained?
Actively maintained. The last commit to openhare was on Oct 2, 2026.
What can I use openhare for?
Querying and managing several different databases from one desktop tool. Writing and tuning SQL with AI help during day-to-day development. Routine DBA work on SQL Server, Oracle or MySQL instances. Exploring local analytical data in SQLite or DuckDB files.
How do I install openhare?
Install and update the app by following the install guide in the project's discussions
Where can I get openhare?
The source code and installation instructions are on GitHub: https://github.com/sjjian/openhare

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects