DataPup

DataPup is an open source desktop database client with built in AI query assistance. It gives developers a single cross platform application for connecting to databases, writing and running queries, and getting help from an AI assistant that drafts and explains SQL, all inside an interface its maintainers designed to be clean and accessible. The tool is aimed at developers and data engineers who work directly with analytical and transactional databases and want a lighter alternative to heavyweight database IDEs. ClickHouse has full support with optimized query execution, and PostgreSQL is fully supported. MySQL, with MariaDB compatibility, and SQLite are listed as coming soon. The application is built on Electron with a Radix UI interface and Vite bundling, and its AI assistance is powered by LangChain. It runs on macOS, Windows and Linux, and developers can build it from source with Node.js 18 or later using npm, yarn or pnpm. DataPup is free. It is released under the MIT license, which allows commercial and private use, and there is no paid edition or hosted service. Any cost comes from the AI model provider a user connects for query assistance. The project is community maintained on GitHub, where contributions are welcomed through a contributing guide and questions are handled through issues. Buyers who need MySQL or SQLite today should confirm the current release, since the README still lists both as upcoming.