All Your Data in One App
DB Pilot is a Database GUI client and SQL editor for PostgreSQL, MySQL, SQLite, DuckDB & more.
Minimum MacOS 12.6 required.
Supported Databases
;'%3e%3cdefs%3e%3cclipPath%20id='__lottie_element_4'%3e%3crect%20width='300'%20height='300'%20x='0'%20y='0'%3e%3c/rect%3e%3c/clipPath%3e%3c/defs%3e%3cg%20clip-path='url(%23__lottie_element_4)'%3e%3cg%20transform='matrix(1,0,0,1,0,0)'%20opacity='1'%20style='display:%20block;'%3e%3cg%20opacity='1'%20transform='matrix(1,0,0,1,150,150)'%3e%3cpath%20fill='rgb(0,0,0)'%20fill-opacity='1'%20d='%20M0,148%20C0,148%200,148%200,148%20C-81.85299682617188,148%20-148,81.85399627685547%20-148,0%20C-148,-81.85399627685547%20-81.85299682617188,-148%200,-148%20C81.85399627685547,-148%20148,-81.85399627685547%20148,0%20C148,81.85399627685547%2081.85399627685547,148%200,148z'%3e%3c/path%3e%3c/g%3e%3c/g%3e%3cg%20transform='matrix(1,0,0,1,0,0)'%20opacity='1'%20style='display:%20block;'%3e%3cg%20opacity='1'%20transform='matrix(1,0,0,1,119.19100189208984,150)'%3e%3cpath%20fill='rgb(255,240,0)'%20fill-opacity='1'%20d='%20M-61.31399917602539,0%20C-61.31399917602539,33.827999114990234%20-33.827999114990234,61.31399917602539%200,61.31399917602539%20C33.82899856567383,61.31399917602539%2061.31399917602539,33.827999114990234%2061.31399917602539,0%20C61.31399917602539,-33.827999114990234%2033.82899856567383,-61.31399917602539%200,-61.31399917602539%20C-33.827999114990234,-61.31399917602539%20-61.31399917602539,-33.827999114990234%20-61.31399917602539,0z'%3e%3c/path%3e%3c/g%3e%3c/g%3e%3cg%20transform='matrix(1,0,0,1,0,0)'%20opacity='1'%20style='display:%20block;'%3e%3cg%20opacity='1'%20transform='matrix(1,0,0,1,225.66099548339844,149.8489990234375)'%3e%3cpath%20fill='rgb(255,240,0)'%20fill-opacity='1'%20d='%20M3.4739999771118164,-21.898000717163086%20C3.4739999771118164,-21.898000717163086%20-25.52199935913086,-21.898000717163086%20-25.52199935913086,-21.898000717163086%20C-25.52199935913086,-21.898000717163086%20-25.52199935913086,21.898000717163086%20-25.52199935913086,21.898000717163086%20C-25.52199935913086,21.898000717163086%203.4739999771118164,21.898000717163086%203.4739999771118164,21.898000717163086%20C15.555999755859375,21.898000717163086%2025.523000717163086,11.930000305175781%2025.523000717163086,-0.1509999930858612%20C25.523000717163086,-12.232999801635742%2015.555999755859375,-21.898000717163086%203.4739999771118164,-21.898000717163086z'%3e%3c/path%3e%3c/g%3e%3c/g%3e%3c/g%3e%3c/svg%3e){kind=small}
DB Pilot supports PostgreSQL, CockroachDB, MySQL, SQLite, DuckDB - and more coming soon.
Features
SQL AI Assistant
Powered by GPT-4o and GPT-4o mini.
- Write, debug, and understand SQL queries.
- The AI assistant makes this easy as never before.
- Works with 10k+ tables.
- Even if your database is huge, the AI assistant will handle it.
Smart Autocomplete
Get context-aware suggestions of tables, columns, keywords, functions & more.
Edit & Search
Insert, update, or delete rows in your database - as easy as using a spreadsheet.
Use Filters to search for specific data without writing SQL.
Roadmap
What we'll ship next
- Schema Editor
- Update your database schema without writing any SQL - create tables, add columns & more.
- Additional database support
- We are continuously adding support for more databases.
- Windows and Linux apps
- Soon you'll be able to use DB Pilot on Linux and Windows.
Pricing
Choose the right plan for you
Subscription
- Unlock all premium features
- Use AI assistant at no extra cost
- Always use the latest app version
One-time purchase
- Unlock all premium features
- Use AI assistant with your own OpenAI API key
- Includes updates for 1 year
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.
- Which operating systems are supported?
DB Pilot can be used on Mac, with support for Linux and Windows coming soon.
- Which databases are supported?
You can connect PostgreSQL, CockroachDB, MySQL, SQLite, chDB (local ClickHouse), and DuckDB databases.
- 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.