Changelog

Fixed DuckDB Decimal Processing

We fixed a bug in our processing logic for DuckDB DECIMAL values.

---

Charts

You can now visualize query results using charts:

---

Reimplemented DuckDB Client & Update To DuckDB 0.10.1

• We reimplemented the DuckDB client from the ground up to support all DuckDB types.
• We also updated DuckDB to version 0.10.1.

---

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.

---

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.

---

Save Queries As Favorites

You can now save SQL queries as favorites:

---

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.

---

Improvements to AI Assistant and Autocomplete

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

And, we’ve made autocomplete better.

---

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.

---

New Welcome Screen & Bug Fixes

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

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.

---

Configurable SSL Options

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

---

Autocomplete

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

---

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.

---

AI Assistant Handles Thousands of Entities

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

---

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.

---

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

---

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.

---

Docs!

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

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

---

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

---

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.

---

Save Query Results as CSV

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

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

---

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.

---

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:

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:

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.

---

Better Session Handling

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

---

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.

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

---

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.

---

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.

---

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!

---

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.

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)

---

Reworked PostgreSQL Integration

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

---

Filters

This release of DB Pilot adds table filters.

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

---

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

---

Table Viewer

---

First Release 🚀

See the announcement on Twitter / X.