Dataflare

About

Dataflare is a database manager for Mac that lets you connect to 27+ popular databases, including PostgreSQL, MySQL, SQLite, BigQuery, DuckDB, Redis, and more, through one unified interface. You can save multiple connections and switch between them easily, browse tables, and view the structure and relationships of your schema in one place.

For writing and running queries, Dataflare includes a SQL query editor with syntax highlighting, auto-complete, and real-time saving, as well as a SQL preview that lets you review statements before running them. A read-only mode helps you view data more safely, and AI-powered features can generate SQL, explain complex code, and offer suggestions. You can also filter, sort, insert, update, and delete data, visualize data through charts, quickly search for databases, tables, and queries, and generate hundreds of thousands of rows of random data for testing.

Dataflare is available free with up to 2 connections, or as a one-time purchase: a Standard license at $49 USD for one device, or an Extended license at $89 USD for two devices. Paid licenses include all features and future updates with no subscription, and come with a 7-day money-back guarantee.