← Back to Discover

DataPup

A free, open source desktop database client with AI-powered query assistance that currently supports ClickHouse and PostgreSQL.

Data analysis

What it does

DataPup is an open source database client for working with your databases from a desktop app. It includes AI-powered query assistance, and the project describes it as cross-platform and free under the MIT license. ClickHouse and PostgreSQL are listed as currently supported. MySQL, including MariaDB, and SQLite are listed as coming soon. The app is built with Electron, uses Radix UI for its interface, and its AI assistance is built on LangChain. The README shows how to install dependencies with npm, run the app in development mode, build it and create a distributable. The repository topics tag the app for Mac, Windows and Linux.

Capabilities

  • AI-powered query assistance
  • Supports ClickHouse and PostgreSQL today
  • MySQL, MariaDB and SQLite listed as coming soon
  • Cross-platform desktop app built with Electron
  • Free and MIT licensed

When to use it

  • You work with ClickHouse or PostgreSQL and want AI help writing queries
  • You want a free database client whose source you can read, build and modify yourself