A beautiful database GUI. Enhanced by AI.

DB Pilot AI

AI assistant for your SQL needs

With DB Pilot AI, you can chat with your personal AI assistant powered by GPT-3.5 right inside your database GUI client.

Write SQL queries.
Simply describe the desired outcome of a query in English, and let DB Pilot AI write SQL for you. It figures out which tables to use, how to join them, and which columns to select.
Convert code to SQL and vice versa.
Easily convert between SQL and code for various ORM libraries. No more doing this by hand!
Explain queries.
Have a complex SQL query that's hard to understand? Ask DB Pilot AI to explain it to you!
App screenshot

Supported Databases

PostgreSQL CockroachDB MySQL SQLite DuckDB

DB Pilot supports PostgreSQL, CockroachDB, MySQL, SQLite, DuckDB - and more coming soon.

Integrated local database

Local hub to connect all your data

DB Pilot comes with an integrated, in-process ClickHouse instance. It acts as a local hub between your databases, and other data outside of them.

It allows you to easily run SQL queries on a variety of file formats, or store query results from any database locally for later reference.

Combine the two, and you get a straightforward way to connect data from your databases with any other data you may have.

Query local and remote files.
Easily query any CSV, JSON, and Parquet files with SQL - be it files on your machine, on S3, or available over HTTP.
Store query results locally.
Persist the results of any query in the integrated database. An easy way to keep query results from your production DB for later reference, without polluting the production DB.
App screenshot


See the best features in action

Spreadsheet-like editor

Insert, update, or delete rows in your database - as easy as using a spreadsheet!
Spreadsheet-like editor


Filter for specific rows without writing any SQL.

Let AI write your SQL queries

With DB Pilot AI, you can chat with your personal AI powered assistant right inside your database client. The assistant helps you write SQL queries, explain queries, convert SQL to code, and code to SQL.

Translate between code and SQL

DB Pilot AI converts your code to SQL, and vice versa - so you don't have to do it by hand. It supports libraries like Prisma, Ruby on Rails (Active Record), SQLAlchemy, and many more!

Join all your data

Using the integrated ClickHouse database, you can join data from CSV, JSON, Parquet files & more with data in any of your connected databases.

Write as CSV, JSON, or Parquet

Write the result of any query to a CSV, JSON, or Parquet file. Also a convenient way to convert a file to another format!

Query remote files

Simply specify a http URL or a S3-compatible path to data in a supported format, and query it right away. No need to download it manually.

Save query results to the integrated Database

Save query results of any connected database to the integrated ClickHouse instance, and keep them around for later reference.


What we'll ship next

Smart code completion
Context-aware autocomplete that knows about your database schema.
Additional database support
We are continuously adding support for more databases.
Query and chat history
Refer back to SQL queries you've run and chats you've had with your AI assistant.
Windows and Linux apps
Soon you'll be able to use DB Pilot on Windows and Linux.

Want product news and updates?

Sign up for our newsletter.

We care about your data. Read our privacy policy.


Simple no-tricks pricing

Get started for free today.
And once you're ready to enhance your SQL workflow, upgrade to Plus.


The essentials of a modern database GUI.


Download for free
  • A modern GUI database client
  • Supports PostgreSQL, CockroachDB, MySQL, SQLite
  • Acts as a local hub to connect all your data


Most popular

Power-up your workflow with a SQL AI assistant.

$7 /month
Annual billing (Save 30%)
  • Everything from the free tier
  • Your personal SQL AI assistant
  • 5-day free trial, no credit card required

Frequently asked questions

How does DB Pilot AI help me?

DB Pilot AI can help you write SQL queries - simply give it instructions in English, then let it do its magic. It can also explain queries, and convert between code and SQL, saving you valuable time.

Can I try the AI assistant for free?

Yes! You can try the AI assistant during the 5-day free trial of the Plus plan.

How do I activate my free trial for the Plus plan?

Your free trial will automatically be activated once you sign into your account in the DB Pilot app for the first time.

Which operating systems are supported?

DB Pilot can be used on Mac, with support for Windows and Linux coming soon.

Which databases are supported?

You can connect PostgreSQL, CockroachDB, and MySQL databases. We'll be continuously adding support for more databases. The next one coming is SQLite.

Can the AI assistant read my data?

No, the AI assistant cannot read your data. It knows which tables and columns exist in your database, so that it can assist you better. But it doesn't have access to any actual data stored in your database.


Get started for free. Download now!

Minimum MacOS 12.6 required.