dbkangaroo/kangaroo

Kangaroo is an AI-powered SQL client and admin tool for popular databases (MariaDB / MySQL / Oracle / PostgreSQL / Redis / SQLite / SQL Server / ...) on Windows / MacOS / Linux, support table design, query, model, sync, export/import etc, focus on comfortable, fun and developer friendly.

What it solves

Kangaroo simplifies database administration and management by providing a unified, AI-powered interface for multiple popular database systems, reducing the need for separate tools for different database types.

How it works

It functions as a cross-platform SQL client (Windows, MacOS, Linux) that connects to various databases to provide a suite of management tools. It integrates AI capabilities to assist with database tasks and includes a visual builder for SQL queries, a schema designer, and tools for data synchronization and import/export.

Who it’s for

It is designed for developers and database administrators who need a user-friendly, multi-database management tool with AI assistance.

Highlights

  • Broad Database Support: Compatible with MariaDB, MongoDB, MySQL, Oracle, PostgreSQL, Redis, SQLite, and SQL Server.
  • AI Integration: Built-in AI support to assist with database operations.
  • Comprehensive Toolset: Includes table design, querying, modeling, synchronization, and import/export capabilities.
  • Developer-Friendly Features: Offers code intellisense (autocomplete) and a visual SQL builder.

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
    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
    sjjian/openhare

    An AI-powered, cross-platform desktop SQL client that supports multiple databases and provides AI assistance for writing and optimizing queries.

  • Project
    clidey/whodb

    A lightweight, self-hosted database workspace for exploring, editing, and querying data with optional AI-powered natural language interfaces.

  • 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.