DB Pilot is an AI-native database tool, officially positioned as a combination of a database GUI, SQL editor, and SQL + Python notebook.
Main capabilities:
- Powerful SQL editor with intelligent autocompletion (context-aware suggestions for tables, columns, keywords, and functions).
- SQL + Python notebook: a Jupyter Notebook-like block-based interface for locally mixing SQL queries, Python code, interactive tables, and charts for data exploration and dashboard building.
- View, insert, update, and delete database records as conveniently as updating a spreadsheet.
- AI assistant: supports the latest models, covering GPT, Claude, and Gemini; custom AI models from any provider can also be used.
AI features:
- Generate and optimize SQL queries using natural language.
- Get explanations of complex code or database concepts.
- Preview and seamlessly apply AI-suggested changes.
- Use the latest AI models from OpenAI, Anthropic, Google, and xAI.
- Use AI in notebooks to generate insightful visualizations and charts.
- Choose which databases, tables, notebooks, etc. to include in the AI context.
- Customize AI behavior through custom instructions to match specific needs and SQL style preferences.
- Get AI help directly in the SQL editor, table viewer, and Python blocks, and easily fix SQL and Python errors with AI suggestions.
Data exploration and transformation:
- Seamlessly combine SQL and Python to load, transform, and join data from multiple databases, files, and external APIs.
- Switch back and forth between SQL and Python: access SQL query results in Python blocks, and use Pandas and Polars data frames in SQL blocks.
- Query results and Python data frames are automatically accessible in subsequent blocks.
- Build interactive dashboards using input fields, date filters, charts, and tables.
- Parameterize notebook blocks using Jinja, and configure variables and secrets for notebooks.
Other features:
- Export data to files or copy it to the clipboard in CSV, JSON, NDJSON, and Markdown formats.
- Keep SQL code clean and consistent through automatic formatting.
- No codeBuild charts and easily compare data across different time periods.
- View a list of all historical queries and quickly rerun them; save the most frequently used SQL queries for quick access.
How to use:
- Download DB Pilot to get started for free. You can browse and query local databases, use the SQL editor and table browser, and try AI features a limited number of times without a credit card.
- A one-time purchase unlocks all premium features, and you can use your own API key to unlock all AI features, including 1 year of updates and priority support.
- You can also first download it for free and add your own AI provider API key to try AI features, or purchase a one-time license to unlock premium features.
Data and privacy:
- All application data is stored on the local computer.
- Connection credentials are stored locally, and passwords and other sensitive information are securely stored in the device keychain.
- All database connections are made directly between the computer and the database server.
- The official statement is that no database data is stored on servers.
Use cases:
- Data analysis work involving data exploration, transformation, and dashboard building using SQL and Python.
- Database operations that require AI assistance for writing and optimizing SQL, explaining code, fixing errors, and generating charts.
Supported platforms and databases:
- The official page lists supported databases and notes that more databases are coming soon; the specific list of supported operating systems and databases is not yet provided.
