AI Database Graphical User Interface
How does the DB Pilot AI assistant help with database tasks?
DB Pilot's AI assistant enhances database work by helping you write SQL queries through English instructions, explaining queries, debugging SQL and Python errors with AI suggestions, and generating insightful visualizations and charts. It leverages the latest AI models, including GPT-5 and Claude 4.5, to provide context-aware assistance directly within your workflow.
Can I try the AI assistant features before committing to a purchase?
Yes, you can try the AI assistant for free for 20 messages. You'll need to provide your own API keys for the AI providers, such as OpenAI or Google AI, to access these features. Detailed instructions are available in the documentation.
What are the pricing options for DB Pilot?
DB Pilot offers two pricing models:
- Subscription: $20 per month, including all premium features and AI features at no extra cost.
- One-time Purchase: $79, which includes all premium features and updates for one year. AI features require your own API key under this plan.
Which operating systems is DB Pilot compatible with?
DB Pilot is currently available for Mac, supporting both M chip and Intel architectures. Support for Linux and Windows is forthcoming.
How does DB Pilot manage and secure my data?
All app data and connection credentials are stored locally on your computer. Sensitive information is securely saved in your device's keychain, ensuring that database data is not stored on DB Pilot's servers. Database connectivity is managed directly between your computer and the database server.
What are Notebooks in DB Pilot, and how do they benefit me?
Notebooks in DB Pilot allow you to integrate SQL and Python, along with text and interactive tables & charts, to perform data exploration and build dashboards. They provide a flexible, block-based interface similar to Jupyter Notebooks, facilitating iterative data exploration and transformation across multiple sources.
What databases are supported by DB Pilot?
DB Pilot supports PostgreSQL, CockroachDB, MySQL, SQLite, and DuckDB, and more databases are being added regularly. It enables cross-database querying and transformation, allowing you to join tables and manipulate data across various platforms.
Can the AI assistant access my database data?
No, the AI assistant cannot read or access your database data. It only uses the structural information, like tables and columns, to provide relevant assistance without requiring access to actual data.
What is the difference between the subscription and one-time purchase plans?
The subscription includes full access to all premium features and built-in AI functionalities at $20/month. The one-time purchase, priced at $79, includes updates for one year and requires your own API keys for AI use. Both plans offer priority support.
How does the SQL Editor in DB Pilot improve query writing?
DB Pilot's SQL Editor features smart autocomplete, providing context-aware suggestions for tables, columns, keywords, and functions, making your query writing process faster and more efficient. It also includes a SQL Formatter to keep your code clean and consistent.
Does DB Pilot offer a way to manage and view database tables easily?
Yes, DB Pilot includes a table viewer and editor that allows you to view database tables and perform tasks such as inserting, updating, and deleting records, very much like working with a spreadsheet for ease of use.
How can I visualize data in DB Pilot?
With DB Pilot, you can build charts without coding, using the Chart Builder feature. It enables data visualization for effective data analysis and allows you to create interactive dashboards with input fields, date filters, charts, and tables.
What export formats does DB Pilot support for data?
DB Pilot allows you to export data to various formats, including CSV, JSON, NDJSON, or Markdown. You can export to a file or copy to the clipboard for easy data sharing and usage.
