Changelog

See what's new in DB Pilot.

Improvement

Bug Fix

We fixed a bug where the app would wrongly show ‘Error fetching next rows.’ in case a query didn’t return any results.


Feature

Sortable Results & Additional Filters

  • You can now sort by columns in the table viewer and in query results.
  • We’ve also added additional filter options for the table viewer.
  • And we’ve made a few improvements to autocomplete.

Feature

Save Queries As Favorites

You can now save SQL queries as favorites:

Add to favorites
Improvement

One-time Purchase

We added an additional billing option: You can now make a one-time purchase to get access to premium features and the AI Assistant with your own OpenAI API key.


Improvement

Improvements to AI Assistant and Autocomplete

You can now edit previous messages of a chat with the AI assistant and regenerate responses.

Edit AI message

And, we’ve made autocomplete better.


Improvement

Various Bug Fixes & Improvements; Create Additional chDB Connections

In this release, we’ve fixed various small bugs and made improvements to the UI.

Additionally, chDB is now available as a regular connection like any other database type. Meaning, you can now create additional chDB instances. This also replaces the concept of the Analytics Workspace.


Improvement

New Welcome Screen & Bug Fixes

We added a new welcome screen that’s shown when you start the app:

Welcome screen screenshot

And we fixed two bugs that sneaked their way into the previous two releases:

  • A UI issue is fixed that made it not possible to add new SQLite or DuckDB connections.
  • Queries for attached files in the integrated ClickHouse instance are now build correctly again.

Improvement

Configurable SSL Options

You can now configure the SSL mode and provide custom SSL certificates when creating PostgreSQL and MySQL connections.

SSL options screenshot
Feature

Autocomplete

You’ll now get autocomplete suggestions in the SQL editor.

Autocomplete screenshot
Feature

Import Data From 250+ Sources

We’ve built an intergration for Airbyte source connectors, meaning you can now easily import data from 250+ sources.

This feature launches in Beta today. It is available in the integrated ClickHouse connection.

Syncs screenshot
Improvement

AI Assistant Handles Thousands of Entities

The AI assistant now works, even if you add thousands of tables and views to its context.

AI assistant screenshot
Improvement

Support for Multiple Catalogs in DuckDB

DuckDB sessions with multiple catalogs are now supported.

This means you can ATTACH other DuckDB databases, and its entities will now be displayed properly.


Improvement

DuckDB 0.9.2 & Bug Fixes

DuckDB in DB Pilot is updated to version 0.9.2 (previously was 0.9.1).

Also, a couple of bugs have been fixed:

  • Timezones now work in DuckDB connections, e.g. select now() won’t fail anymore
  • DuckDB queries including the BLOB data type won’t fail anymore

Improvement

chDB 1.0.1 / ClickHouse 23.10

The Analytics Workspace is now powered by chDB version 1.0.1, which is based on ClickHouse 23.10. The previous version was based on ClickHouse 23.6.

There’s many improvements coming from ClickHouse releases 23.7, 23.8, 23.9, and 23.10. A few highlights are faster file reads, better compression, and type inference for JSON.


News

Docs!

We’ve added documentation pages: https://www.dbpilot.io/docs/introduction

Docs screenshot

We’ve also added many more articles to our SQL Guides: https://www.dbpilot.io/sql-guides


Feature

GPT-4

You can now use GPT-4 with the AI assistant. Available on the new Pro plan. Subscribe here.

We’ve also added AI response streaming.

GPT-4 screenshot
Improvement

GPT-3.5 16K

DB Pilot’s AI assistant now uses OpenAI’s latest GPT-3.5 Turbo model, providing a context window of 16,385 tokens - 4x higher than before.


Improvement

App Crashes Fixed, DuckDB 0.9.1 & Support for All Official DuckDB Extensions

This release comes with two important bug fixes:

  • The app no longer crashes after certain types of SQL errors in the analytics workspace.
  • The app no longer crashes when connecting to a DuckDB database or saving query results as CSV. This bug affected Intel based Macs only.

Additionally, DuckDB is updated to version 0.9.1. DuckDB doesn’t yet support reading database files created with older versions of DuckDB, so you’ll have to migrate your existing DuckDB databases. Please follow these steps:

  • Download DuckDB version 0.7.1 and unzip it. This is the DuckDB version DB Pilot came with until now.
  • In a terminal, use the just downloaded version of DuckDB to access your database. E.g. ~/Downloads/duckdb /path/to/my/database.db
  • Run EXPORT DATABASE '/path/to/some/directory/';, then exit (press CTRL C two times).
  • Create a new DuckDB connection in DB Pilot. In the “Database” field, enter a path to a file that doesn’t exist yet to create a new empty database.
  • Run IMPORT DATABASE '/path/to/some/directory/'; in the newly created database to import your data.
  • Press CMD R to reload the entities of the database in DB Pilot.

Last but not least, you can now install and load all official (i.e. signed) DuckDB extensions, e.g. INSTALL iceberg; LOAD iceberg. Previously, only extensions that came bundled with DB Pilot could be used. As extensions can now be installed and loaded as needed, DB Pilot doesn’t bundle any extensions anymore, leading to a smaller app size by default.


Feature

Save Query Results as CSV

You can now export results of a SQL query to a CSV file:

Export to CSV screenshot

Additionally, this release fixes two bugs affecting older versions of MacOS:

  • It used to be impossible to submit messages to the AI assistant
  • In certain cases the minimize/maximize window buttons did not work

Feature

Release 1.0.0 🎉 - External Sources, Query History & More

This is DB Pilot’s biggest update yet, packed with many new features and improvements.

In short, you can now:

  • Attach external sources to the embedded ClickHouse database
  • Select which tables the AI assistant should know about
  • See your past SQL queries
  • Resize all sub-windows
  • Use even more keyboard shortcuts

Easily connect all your data sources, then query them as if they were one single database: Simply attach external sources like other databases, local files, or files on S3, GCS, or other object storages.

Release 1.0.0 app screenshot
Feature

Embedded ClickHouse and Standalone DuckDB Support

Starting with this release, the embedded analytics database is powered by an in-process ClickHouse instance, replacing DuckDB.

This provides faster queries in certain cases, and overall even wider ranging support of data formats. For example, you can now easily join data from a PostgreSQL database with data from a local file on your machine:

Join PostgreSQL and local file data

Using ClickHouse in this way is possible thanks to the amazing open-source project chDB.

Furthermore, this release adds support for custom DuckDB database connections:

New DuckDB connection

The supported DuckDB version is 0.7.1. Available DuckDB extensions are: httpfs, json, parquet, and sqlite_scanner.

Note: To access data from the previous, DuckDB-powered, embedded database, create a new DuckDB connection in the DB Pilot app using file path /Users/YOUR_USER_NAME/Library/Application Support/io.dbpilot/user.db.


Improvement

Better Session Handling

We improved session handling, so that you will stay signed in inside the app for longer.


Feature

Sign in by Email and AI Assistant for SQLite

We’ve added a new sign-in method! In addition to signing in with Google, you can now also sign in by email.

sign-in-methods-screenshot.png

Besides that, we made the AI assistant available for SQLite. So go ahead, and chat with your SQLite instances :)


Improvement

Introducing a Free Tier

You can now use a basic version of DB Pilot completely for free! All currently supported databases work with the free tier. Perfect for when you’re just getting started.

Once you’re ready to enhance your SQL workflow, subscribe to the Plus plan and get access to exclusive features like the DB Pilot AI assistant.

Billing screenshot
Feature

SQLite and CockroachDB Support

You can now connect to SQLite databases in DB Pilot. We’ve also made it easier to connect to CockroachDB instances.

billing-screenshot.png


Feature

MySQL Support

We’ve added support for MySQL in DB Pilot.

Go give it a try and use the GPT AI assistant to chat with your MySQL databases!


Feature

Spreadsheet-like Editor and Keyboard Shortcuts

You can now edit your database rows in DB Pilot 🎉

The spreadsheet-like editor allows you to easily insert new rows, and update or delete existing ones.

You can preview everything before committing any changes, and you can check exactly what SQL will be executed by DB Pilot.

spreadsheet-like-editor.png

Besides that, we added keyboard shortcuts for the most important actions, with more coming soon:

  • Switch to previous tab: ⌘⇧[
  • Switch to next tab: ⌘⇧]
  • Run query: ⌘↵
  • Refresh: ⌘R
  • Commit changes: ⌘S
  • Delete row: ⌫ (needs commit afterwards, so you don’t accidentally delete something)

Improvement

Reworked PostgreSQL Integration

We’ve reworked DB Pilot’s PostgreSQL integration from the ground up. All column types are now supported!


Feature

Filters

This release of DB Pilot adds table filters.

You can now view and filter your tables without having to write any SQL!

Table filters screenshot
Feature

PostgreSQL Support, Save Results, and More

A big new release with many new things 🚀

  • PostgreSQL support
  • Save query results as a table in DB Pilot
  • Added a schema selector to the table list sidebar
  • The UI now handles long column values better

Feature

Table Viewer


Feature

First Release 🚀

See the announcement on Twitter / X.

Website screenshot

Get started with DB Pilot

DB Pilot is a Database GUI client and SQL editor for PostgreSQL, MySQL, SQLite, DuckDB & more.