sjjian/openhare

AI-powered desktop SQL client. Cross-platform. Built with Flutter.

What it solves

Openhare is a cross-platform desktop SQL client designed to simplify database management, data analysis, and development workflows. It provides a lightweight, native experience without the overhead of browser engines, while integrating AI to help users write and optimize queries.

How it works

Built with Flutter for the user interface and Go for the database drivers (connected via Dart FFI), the application provides a native desktop experience on Windows, macOS, and Linux. It supports a wide range of databases including MySQL, PostgreSQL, SQL Server, SQLite, DuckDB, ClickHouse, Oracle, MongoDB, and Redis.

Who it’s for

Developers, data analysts, and database administrators (DBAs) who need a fast, native SQL client that supports multiple database types across different operating systems.

Highlights

  • AI-Powered Assistance: Built-in AI helps users write, optimize, and understand SQL, with safety flags for high-risk statements.
  • Multi-Database Support: Compatible with a broad array of SQL and NoSQL databases.
  • Native Performance: Developed with Flutter to ensure a lean memory footprint and fast installation.
  • Open Source: Licensed under the Apache License 2.0.

Related

  • Project
    wannabespace/conar

    Tamery.app is an open‑source Electron desktop tool that stores database connections securely and uses an LLM to generate or optimise SQL queries for PostgreSQL, MySQL, MSSQL and ClickHouse.

  • Project
    dbkangaroo/kangaroo

    Kangaroo is an AI-powered SQL client and database administration tool that provides a unified interface for managing multiple popular databases across Windows, MacOS, and Linux.

  • Project
    geek-fun/sqlkit

    An agentic, cross-platform SQL database GUI client that supports 70+ databases and uses AI to generate, optimize, and fix SQL queries from natural language.

  • Project
    OtterMind/Chat2DB

    An AI-powered database client and SQL workspace that allows developers and analysts to generate, explain, and optimize SQL using natural language.

  • Project
    TabularisDB/tabularis

    tabularis is an open‑source desktop SQL workspace (Windows/macOS/Linux) that supports built‑in databases and a plugin system for many more. It offers a full‑featured editor, notebooks, visual query builder, execution‑plan visualiser, and optional AI‑powered text‑to‑SQL/explanations via OpenAI, Anthropic, Ollama, etc. An embedded MCP server lets external AI agents read schemas and run queries directly from the app.