Trusted by 1,000+ engineers, analysts & business owners

The AI-Native Database Tool

Database GUI, SQL editor & SQL + Python notebooks.

Powerful SQL Editor with smart autocomplete
SQL + Python Notebooks for Data Exploration & Dashboards
Edit database records as easy as updating a spreadsheet
AI Assistant with the latest models including GPT-4.1, Claude 3.7, Gemini 2.5 Pro, Grok 3

Free updates

No credit card required

Download for Mac (M chip)

Get access to AI Features

Mac arm64, min. MacOS 13

AI-powered SQL assistance

"I have tried MANY natural language to SQL solutions and nothing comes close to DB Pilot"

"The notebooks are SUPER cool"

"DB Pilot's implementation of the AI Assistant is fantastic"

"This is exactly the kind of thing I've been looking for"

Supported Databases

PostgreSQL

MySQL

SQLite

DuckDB

CockroachDB

More databases coming soon

New Feature

Notebooks

Mix and match SQL, Python, inputs and interactive tables & charts to build dashboards and iteratively explore data.

Explore and Transform Data with SQL & Python

Combine SQL queries, Python code, and interactive tables & charts in one block-based interface similar to Jupyter Notebooks, running locally on your machine.

Iteratively Query & Transform Data

Seamlessly combine SQL and Python to load, transform, and join data from multiple databases, files, and external APIs.
Mix SQL and Python

Go back and forth between SQL and Python: Access SQL query results in Python blocks, and Pandas & Polars dataframes in SQL blocks.
Access Data Across Blocks

Query results and Python dataframes are automatically accessible in subsequent blocks.
AI Integration

Speed up your data analysis using the AI chat and inline AI assistant in SQL, Python, table & chart blocks.

Learn more

Interactive Dashboards

Build interactive dashboards with input fields, date filters, charts, and tables.

Jinja Templating

Use Jinja to parameterize your notebook blocks.

Environment Variables

Configure variables and secrets for your notebooks.

AI-Powered

AI Assistant

Our AI assistant makes database work faster and easier than ever before.

AI Chat

Get instant help with your database queries, code generation, and data exploration. Describe what you need, and let the AI assist you.

Generate and refine SQL queries with natural language.
Get explanations for complex code or database concepts.
Preview and apply AI-suggested changes seamlessly.

Latest AI Models

Use the latest AI models from OpenAI, Anthropic, Google, and xAI.

Create & edit charts with AI

Generate insightful visualizations and charts with AI assistance in your notebooks.

Manage Context

Choose which databases, tables, notebooks, etc. to include in the AI context.

Custom AI Rules

Tailor AI behavior with your own instructions to match your specific needs and SQL style preferences.

Inline AI Assistant

Get AI help directly in your SQL editor, table viewer, and Python blocks.

Fix Errors with AI

Easily fix SQL and Python errors with AI suggestions.

Core Features

And many more features...

Table Viewer & Editor

View database tables, insert, update, and delete records - as easy as working with a spreadsheet.

SQL Editor with Smart Autocomplete

Get context-aware suggestions of tables, columns, keywords, and functions.

Export Data in Multiple Formats

Export your data to a file or copy to clipboard as CSV, JSON, NDJSON, or Markdown

SQL Formatter

Keep your SQL code clean and consistent with automatic formatting

Chart Builder

Build charts without code. Easily compare data across time periods.

Query History

View a list of all your previous queries and quickly re-run them

Favorites

Save your most used SQL queries for quick access

Pricing

Choose the Right Plan for You

Flexible options to fit your needs.

Subscription

The fastest way to get started

$20 /month

Unlock all premium features
Use AI features at no extra cost
Always use the latest app version
Access to all new features
Priority support

Subscribe now

Cancel anytime. No long-term commitment.

One-time Purchase

Pay once and own it

$79 paid once

Unlock all premium features
Bring your own API keys to use AI features
Includes updates for 1 year
No recurring payments
Priority support

Buy license

One-time payment. Yours to keep.

Try Before You Buy

Download DB Pilot for free. Upgrade to a paid plan or add your own AI provider API keys to unlock AI features.

Download Free

FAQ

Frequently Asked Questions

Find answers to common questions about DB Pilot.

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, debug errors with "Fix with AI", and convert between code and SQL, saving you valuable time. With inline AI and @-mentions, you can get help without leaving your workflow.

Can I try the AI assistant before I buy?

Yes, you can try the AI assistant for 20 messages before you buy. You'll need to provide your own API keys for the AI providers (OpenAI, Anthropic, Google AI, etc.). See the documentation for more details.

Which operating systems are supported?

DB Pilot can be used on Mac (both M chip and Intel), 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. We're continuously adding support for more databases.

How is my data used and stored?

All app data is stored locally on your computer.
Connection credentials are stored locally on your computer, with passwords and other sensitive information being stored securely in your device's keychain.
All database connectivity happens directly between your computer and the database server.
We don't store any of your database data on our servers.

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.

What are notebooks and how do they help?

Notebooks allow you to mix and match SQL, Python, text, and interactive tables & charts to explore data and build dashboards. They're perfect for iterative data exploration, combining data from multiple sources, and creating reproducible analyses.

What's the difference between subscription and one-time purchase?

The subscription ($20/month) includes all premium features and AI costs are covered. The one-time purchase ($79) gives you access to all premium features in app versions released within 1 year of purchase. To use AI features with the one-time purchase plan, you need to provide your own API key for the AI providers (OpenAI, Anthropic, Google AI, etc.).