Domain Rating by Ahrefs17
Description
DB Pilot is a desktop database tool for Mac, with a graphical interface, an SQL editor with smart autocomplete, and notebooks that mix SQL and Python. It connects to PostgreSQL, MySQL, SQLite, DuckDB, CockroachDB and chDB, which the site describes as local ClickHouse, and says more databases are coming. The notebook is a block-based interface, similar to Jupyter, that runs on your machine. You can combine SQL queries, Python code, inputs and interactive tables and charts, and query results and Pandas or Polars dataframes are available across blocks. Notebooks also support Jinja templating, environment variables and secrets, and interactive dashboards with input fields, date filters, charts and tables. The table explorer lets you edit database records as easily as a spreadsheet. The AI assistant can write and refine SQL from plain English, explain queries, debug errors with a fix-with-AI action, and convert between code and SQL, with inline AI and @-mentions for help without leaving your work. The site says the AI works with GPT, Claude and Gemini models and with custom models from any provider you configure. The app is currently for Mac, with Linux and Windows support coming later, and all app data is stored locally.…
Pricing
- Free$0 forever
- One-time purchase$79
Highlights
- SQL editor with autocomplete and table editing
- SQL and Python notebooks with dashboards
- PostgreSQL, MySQL, SQLite, DuckDB and more
- AI assistant with your own API keys
Ratings & Reviews
No ratings yet
Be the first to rate DB Pilot.
People also visit
DB Pilot FAQ
What is DB Pilot?
A database tool with a graphical interface, an SQL editor, SQL and Python notebooks, and an AI assistant.
Which databases does it connect to?
PostgreSQL, CockroachDB, MySQL, SQLite, chDB and DuckDB, according to the site.
Which operating systems are supported?
Mac with both M chip and Intel. The site says Linux and Windows support is coming soon. The Mac build needs macOS 15 or later on Apple Silicon.
Can I try the AI assistant before I buy?
Yes, for 20 messages, using your own API keys for the AI providers.
Where is my data stored?
The site says all app data is stored locally on your computer.
How much does it cost?
The free plan is $0 forever and covers local databases and the SQL editor. The one-time purchase is $79 and unlocks all AI features and premium features, with one year of updates.
What are the best DB Pilot alternatives?
Popular alternatives to DB Pilot include data-peek, ZQLZ and DB Pro. See all DB Pilot alternatives


