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!
Supported Databases
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.
Features
See the best features in action
Spreadsheet-like editor
- Insert, update, or delete rows in your database - as easy as using a spreadsheet!
Filters
- 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.
Roadmap
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.
Pricing
Simple no-tricks pricing
Get started for free today.
And once you're ready to enhance your SQL workflow,
upgrade to Plus.
Hobby
The essentials of a modern database GUI.
Free
Download for free- A modern GUI database client
- Supports PostgreSQL, CockroachDB, MySQL, SQLite
- Acts as a local hub to connect all your data
Plus
Most popular
Power-up your workflow with a SQL AI assistant.
- 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.
Download
Get started for free. Download now!
Minimum MacOS 12.6 required.